Azure Data Integration Engineer

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, Dev Ops deployment activities, and collaboration with infrastructure, application, and business teams.

• 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 Dev Ops (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.

• 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 Dev Ops (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.

• Experience with Informatica Power Center 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.

• Azure Dev Ops
• 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, 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…