Data Engineer; DataStage​/Snowflake

Data Engineer (Data Stage / Snowflake)

CTG is seeking an experienced Data Engineer to support enterprise data integration and analytics initiatives. This role is ideal for a hands-on data professional with strong expertise in IBM Data Stage, Snowflake, SQL, and Unix scripting who enjoys building scalable data pipelines and optimizing enterprise data platforms. Experience working in insurance environments is a plus.

Location:

San Antonio, TX Duration: 12 months

What You'll Do

• Design, develop, and maintain ETL/ELT processes using IBM Data Stage 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.

What We're Looking For

• Strong hands-on experience with IBM Data Stage 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.
• 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.