ETL Developer

ETL Developer Position

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!