Data Engineer (DataStage / Snowflake)

• Design, develop, and maintain ETL/ELT processes using IBM DataStage and Snowflake.
• Build scalable, high-performance data pipelines supporting enterprise reporting and analytics.
• Develop and optimize SQL queries, stored procedures, and data transformation logic.
• Create and maintain Unix Shell scripts to automate data processing workflows.
• Schedule, monitor, and troubleshoot batch jobs using Control-M and Snowflake scheduling capabilities.
• Integrate data from multiple enterprise systems while ensuring data quality, consistency, and accuracy.
• Optimize performance across Snowflake, DB2, and Netezza databases.
• Troubleshoot production issues and implement long-term solutions for ETL and data integration processes.
• Collaborate with business analysts, architects, and development teams to deliver enterprise data solutions.
• Maintain technical documentation and support ongoing enhancements to the data platform.

• Strong hands-on experience with IBM DataStage ETL development.
• Experience developing solutions within Snowflake.
• Advanced SQL development and query optimization skills.
• Proficiency with Unix and Shell scripting.
• Experience with enterprise scheduling tools such as Control-M.
• Working knowledge of DB2 and Netezza databases.
• Strong understanding of data warehousing concepts and ETL best practices.
• Excellent analytical, troubleshooting, and problem-solving skills.
• Insurance industry experience is a plus.

Preferred Experience

• 5+ years of experience as a Data Engineer, ETL Developer, or related role.
• Experience designing and supporting enterprise data warehouse solutions.
• Proven ability to work with large-scale, mission-critical data environments.
• Experience with production support, performance tuning, and data pipeline optimization.

Education

• Bachelor's degree in Computer Science, Information Technology, Engineering, Information Systems, or a related field.
• Equivalent professional experience will be considered.

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 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 www.ctg.com . 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.