3Ci Solutions Team is seeking three skilled Data Engineers specializing in SQL Server and SSIS for a project with a regional banking Client. The project involves designing, developing, and maintaining data pipelines to move data between a SQL Server database hosted on Azure and a mainframe system. The engagement is initially for 12 months, with opportunities for some positions to transition to full-time roles after the contract phase.
This project entails designing, developing, and maintaining ETL processes using SQL Server Integration Services (SSIS) to extract data from Azure SQL Server database and load it into a mainframe system. Collaboration with cross-functional teams and optimization of ETL processes for performance and scalability are key aspects of the role.
Required Education and Experience
General Requirements
Availability to work in the Central Time Zone Strong proficiency in SQL and database concepts, with experience working with Azure SQL Server Excellent problem-solving skills and attention to detail Strong communication and collaboration skills US citizen or green cardPreferred Requirements
Familiarity with Azure and Azure Data Factory (ADF) Familiarity with mainframe systems and experience converting files to VSAM formatEssential Functions
Design, develop, and maintain ETL processes using SSIS Collaborate with cross-functional teams to develop efficient data transfer solutions Optimize ETL processes for performance and scalability Ensure data quality and integrity throughout the data pipeline Develop and maintain documentation for data processes Monitor and troubleshoot data pipelines Stay up-to-date with industry trends and best practices Perform other tasks as required