Job Description
Job Description
Overview
CTG is seeking to fill an ETL Developer position for our client.
Location: Atlanta, GA; Charlotte, NC; or Raleigh, NC — No Remote
Duration: 12 months
Duties:
-
Design, develop, enhance, and maintain ETL solutions using Informatica PowerCenter, DBT, and Snowflake.
-
Support enterprise data warehousing, data integration, and regulatory reporting initiatives.
-
Translate business and technical requirements into scalable data integration solutions.
-
Perform data profiling, source-to-target mapping, data validation, reconciliation, and quality checks.
-
Optimize ETL workflows and troubleshoot production issues, data discrepancies, and performance bottlenecks.
-
Conduct root cause and impact analysis for source system changes, database enhancements, and business rule modifications.
-
Assess upstream and downstream dependencies across ETL processes, databases, reports, and applications.
-
Support testing, UAT, deployments, monthly releases, and environment migrations.
-
Collaborate with cross-functional teams and maintain technical documentation supporting data governance, lineage, audit, and compliance requirements.
Skills:
-
Informatica PowerCenter, DBT, and Snowflake
-
Oracle SQL/PLSQL and Unix/Linux
-
ETL Development, Data Integration, and Data Warehousing
-
Data Profiling, Validation, Reconciliation, and Quality Assurance
-
Performance Tuning, Root Cause Analysis, and Impact Analysis
-
Release Management, Data Governance, and Data Lineage
Experience:
-
Hands-on experience developing and supporting enterprise ETL, data integration, and data warehouse solutions using Informatica PowerCenter, DBT, Snowflake, and Oracle SQL/PLSQL.
-
Experience troubleshooting production issues, optimizing ETL performance, validating data quality, and managing upstream/downstream dependencies.
-
Experience supporting the full development lifecycle, including testing, UAT, deployments, release management, and production support in complex enterprise environments.
-
Strong analytical, problem-solving, documentation, and cross-functional communication skills.
Education:
Bachelor’s degree in Computer Science, Information Systems, Data Engineering, or a related field, or equivalent combination of education and 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. Kindly forward this to any other interested parties. Thank you!