ETL Developer at A R Systems Inc., Atlanta, GA

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

Job Title: ETL Developer

Job Location: Atlanta, GA

Job Visa: USC/GC/H4EAD/OPT/CPT - W2 Only

Job Description

• Design, develop, and maintain ETL solutions using Informatica PowerCenter to support enterprise data warehouse and regulatory reporting requirements.


• Analyze business and technical requirements and translate them into scalable data integration solutions.


• Perform data profiling, source system analysis, and business rule validation to support data integration initiatives.


• Optimize ETL workflows for performance, reliability, and scalability through tuning and best practices.


• Investigate and resolve production issues, ETL failures, data discrepancies, and performance bottlenecks through root cause analysis.


• Conduct data validation, reconciliation, and quality checks to ensure accuracy, completeness, and consistency of data.


• Perform impact analysis for source system changes, business rule modifications, and database enhancements.


• Assess upstream and downstream dependencies across ETL processes, databases, reports, and consuming applications.


• Support the full development lifecycle, including testing, UAT, deployment validation, monthly releases, and environment migrations.


• Collaborate with business analysts, data analysts, architects, and other stakeholders while maintaining technical documentation and supporting audit/compliance requirements.

Key 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