Location: Onsite Buffalo, Ny
Duration 6 months
Seeking an experienced Azure Data Integration Engineer. This role will be responsible for designing, developing, deploying, and supporting data integration solutions that enable critical business functions including loan origination, underwriting, and portfolio management.
The successful candidate will work across the full data lifecycle, supporting data movement between Salesforce, lending platforms, enterprise data stores, and cloud-based systems. This position requires hands-on development, production support, DevOps deployment activities, and collaboration with infrastructure, application, and business teams.
Responsibilities- Design, develop, and maintain enterprise data integration solutions supporting Commercial Lending business processes.
- Build, enhance, and support ETL/ELT pipelines that move data between Salesforce, loan origination systems, underwriting applications, and enterprise databases.
- Develop and maintain source-to-target mapping documentation and integration specifications.
- Support Salesforce data extraction, replication, archival, and migration processes using tools such as Copystorm and/or GRAX.
- Deploy enhancements and code releases through Azure DevOps (ADO) CI/CD pipelines.
- Collaborate with business analysts, lending technology teams, and infrastructure teams to define integration requirements and data transformation rules.
- Troubleshoot production issues impacting lending operations and critical business workflows.
- Support data quality validation, reconciliation, and exception management processes.
- Assist with data platform modernization and cloud migration initiatives.
- Participate in on-call production support as required.
- Ensure solutions adhere to security, compliance, and governance requirements within a regulated financial environment.
- Create and maintain technical documentation, operational procedures, and support materials.
Required Qualifications- 5-7 years of experience in Data Integration, ETL Development, Data Engineering, or related disciplines.
- Strong SQL development and database experience.
- Experience integrating data from Salesforce.
- Experience working with Azure DevOps (ADO) including source control, build management, release management, and deployment automation.
- Experience developing data mappings and transformation specifications.
- Understanding of cloud-based integration architectures.
- Experience supporting production environments and resolving integration-related incidents.
- Ability to work across both development and operational support functions.
Preferred Qualifications- Experience with Informatica PowerCenter and/or Informatica Intelligent Cloud Services (IICS).
- Experience with Copystorm and/or GRAX.
- Knowledge of Azure Data Factory and Azure-native integration services.
- Experience supporting enterprise cloud migration initiatives.
- Understanding of data governance, security, and regulatory compliance requirements.
Technical Skills- Azure DevOps
- SQL Server
- Salesforce
- Data Integration / ETL
- Azure Cloud Services
- Copystorm
- GRAX
- Informatica (Preferred)
- CI/CD Deployment Pipelines
- Production Support
- Data Mapping & Transformation
Excellent verbal and written English communication skills and the ability to interact professionally with a diverse group are required.
CTG does not accept unsolicited resumes from headhunters, recruitment agencies, or fee based recruitment services for this role.
To Apply:To be considered, please apply directly to this requisition using the link provided. Kindly forward this to any other interested parties. Thank you!
About CTGCTG, a Cegeka company, delivers IT and business solutions that enhance clients' digital agility, empowering them to seize new opportunities and overcome any challenge. Backed by more than 60 years' experience and a commitment to being a reliable, results-driven partner, we work shoulder to shoulder with clients to shape digital together. Our vision is to be an indispensable partner to our clients and the preferred career destination for digital and technology experts. With more than 9,000 team members in over 15 countries, we combine global expertise with local insight to deliver innovative solutions. We operate across the Americas, Europe, and India, working with over 3,000 clients in many of today's highest-growth industries.
Together, we shape what's next-working shoulder to shoulder to deliver impactful solutions for our clients and society. Our culture is built by the people who work at CTG, the values we hold, and the actions we take. It's a living, breathing thing that is renewed every day through the ways we engage with each other, our clients, and our communities. At CTG, you'll find a workplace where you are encouraged to grow, supported in your ambitions, and empowered to shape your own career journey. For more information, visit ;br>
CTG will consider for employment all qualified applicants including those with criminal histories in a manner consistent with the requirements of all applicable local, state, and federal laws.
CTG is an Equal Opportunity Employer. CTG will assure equal opportunity and consideration to all applicants and employees in recruitment, selection, placement, training, benefits, compensation, promotion, transfer, and release of individuals without regard to race, creed, religion, color, national origin, sex, sexual orientation, gender identity and gender expression, age, disability, marital or veteran status, citizenship status, or any other discriminatory factors as required by law. CTG is fully committed to promoting employment opportunities for members of protected classes.
Never miss an opportunity! Create an alert based on the job you applied for.