ETL Tech Lead: Enterprise Data with PowerCenter & Snowflake

Computer Task Group; Atlanta (GA); In loco; USD 120.000 - 150.000; Tempo pieno

Descrizione del lavoro

CTG is seeking an ETL Tech Lead for our enterprise data integration client. Location: Atlanta, GA / Charlotte, NC / Raleigh, NC; No Remote.

You will design, develop, and optimize ETL solutions using Informatica PowerCenter, DBT and Snowflake, support data warehouse initiatives, and collaborate with analysts, architects, and stakeholders to ensure data governance and reliable production operations. Bachelor’s degree preferred; excellent communication skills in English required.

Competenze

• Strong experience developing and supporting enterprise ETL and data integration solutions.
• Experience with Informatica PowerCenter, DBT, Snowflake, Oracle SQL/PLSQL, and data warehouse environments.
• Experience analyzing complex data flows, source systems, business rules, and upstream/downstream dependencies.
• Experience with data quality, reconciliation, performance tuning, production support, testing, releases, and environment migrations.

Mansioni

• Design, develop, enhance, and maintain enterprise ETL and data integration solutions using Informatica PowerCenter and DBT with Snowflake.
• Support enterprise data warehouse and regulatory reporting initiatives in complex environments.
• Analyze requirements and translate them into scalable data integration solutions.
• Perform data profiling, source system analysis, data validation, reconciliation, and quality checks.
• Optimize ETL workflows for performance, reliability, and scalability.
• Troubleshoot ETL failures, production issues, data discrepancies, and bottlenecks via root cause analysis.
• Perform impact analysis and assess upstream/downstream dependencies across systems and reports.
• Support testing, UAT, deployments, monthly releases, and environment migrations.
• Collaborate with business analysts, data analysts, architects, and stakeholders.
• Maintain documentation and support data governance, lineage, audit, and compliance.

Conoscenze

Informatica PowerCenter

DBT

Snowflake

Oracle SQL

ETL design

Data warehousing

Data profiling

Performance tuning

Unix/Linux

Impact analysis

Release management

Data governance

Root cause analysis

Formazione

Bachelor’s degree in Computer Science, Information Systems, Engineering, or related field

Strumenti

Informatica PowerCenter

DBT

Snowflake

Oracle SQL/PLSQL

Descrizione del lavoro

CTG is seeking an ETL Tech Lead for our enterprise data integration client. Location: Atlanta, GA / Charlotte, NC / Raleigh, NC; No Remote.

You will design, develop, and optimize ETL solutions using Informatica PowerCenter, DBT and Snowflake, support data warehouse initiatives, and collaborate with analysts, architects, and stakeholders to ensure data governance and reliable production operations. Bachelor’s degree preferred; excellent communication skills in English required.