ETL Developer - Informatica PowerCenter & Data Warehouse

Ellenco Estágios e Treinamentos; Atlanta (GA); On-site; USD 85,000 - 125,000; Full time

Job summary

Ellenco Estágios e Treinamentos in Atlanta, GA is seeking an ETL Developer with strong Informatica PowerCenter experience to design and maintain enterprise ETL solutions.

You will work with data analysts and architects to translate requirements, profile data, and ensure data quality for warehousing and regulatory reporting.

The role requires hands-on ETL design, data modeling, and collaboration across IT and business teams to meet deadlines and audit requirements.

Qualifications

• Experience with Informatica PowerCenter and data integration.
• Strong knowledge of Oracle SQL and PL/SQL.
• Familiarity with Unix/Linux environments.
• Proven ETL design and development capabilities.
• Experience with data warehousing and data integration projects.
• Ability to perform data profiling, validation, and reconciliation.
• Performance tuning of ETL workflows.
• Ability to assess impacts of source changes and releases.
• Understanding of data governance and data lineage.
• Experience with release and change management.

Responsibilities

• Design, develop, and maintain ETL solutions using Informatica PowerCenter.
• Translate business and technical requirements into scalable data integration.
• Profile data, analyze sources, and validate business rules.
• Tune ETL workflows for performance and reliability.
• Investigate production issues and resolve ETL failures.
• Perform data validation and quality checks.
• Analyze impacts of source changes and database enhancements.
• Map dependencies across ETL processes and reports.
• Support full development lifecycle, including testing and deployments.
• Collaborate with analysts, architects, and auditors, documenting work.

Skills

Informatica PowerCenter

Oracle SQL & PL/SQL

Unix/Linux

ETL Design & Development

Data Warehousing

Data Integration

Data Profiling & Validation

Performance Tuning

Data Reconciliation

Impact Analysis

Release & Change Management

Data Governance & Data Lineage

Job description

Ellenco Estágios e Treinamentos in Atlanta, GA is seeking an ETL Developer with strong Informatica PowerCenter experience to design and maintain enterprise ETL solutions.

You will work with data analysts and architects to translate requirements, profile data, and ensure data quality for warehousing and regulatory reporting.

The role requires hands-on ETL design, data modeling, and collaboration across IT and business teams to meet deadlines and audit requirements.