Job Description
Job Description
Overview
CTG is seeking to fill a Lead Data Integration/ETL opening for our client in San Antonio, TX.
Location: San Antonio, TX
Duration: 6 months
Duties:
-
Lead the design, development, and maintenance of scalable ETL/ELT solutions using IBM DataStage and dbt in Snowflake.
-
Translate business requirements into efficient data integration workflows and transformation logic.
-
Collaborate with cross-functional teams to define data models, data quality rules, and transformation standards.
-
Implement robust data validation, error handling, and logging mechanisms to ensure data integrity.
-
Optimize SQL queries and Snowflake performance for large-scale data processing.
-
Manage CI/CD pipelines for data integration and ensure version control practices are followed.
-
Support orchestration and scheduling of data workflows using Airflow or similar tools.
Skills:
-
Strong hands-on experience with IBM DataStage for data extraction, transformation, and loading.
-
Proficiency in dbt (data build tool) for modular, reusable transformation models in Snowflake.
-
Deep knowledge of Snowflake cloud data warehousing architecture and features.
-
Advanced SQL skills for complex data manipulation, profiling, and performance tuning.
-
Familiarity with orchestration tools such as Airflow or Control-M.
-
Experience with CI/CD pipelines and version control systems like Git.
-
Strong understanding of data quality, validation rules, and exception handling.
Experience:
-
7+ years of experience in ETL/ELT development with at least 2 years in a lead role.
-
Prior experience delivering data integration solutions in a cloud environment, preferably Snowflake.
-
Demonstrated success leading data integration projects and mentoring technical team members.
Education:
-
Bachelor’s degree in Computer Science, Information Systems, or a related field (or equivalent experience).
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. For additional information, please contact Nicole Shaw at Nicole.Shaw@ctg.com. Kindly forward this to any other interested parties. Thank you!