Role Summary: ETL Developer is responsible for supporting enterprise data integration, data warehouse, and regulatory reporting initiatives. The role involves designing, developing, enhancing, and maintaining ETL solutions, performing data analysis and validation, supporting application enhancements, and implementing new data integrations. The ideal candidate will have strong expertise in Informatica PowerCenter, Oracle SQL/PLSQL, data warehousing, and ETL development within complex enterprise environments.
Key Responsibilities:
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
Numbers & Facts
Location
Atlanta, GA
Skills
Acceptance Testingunmatched
Analysis Skillsunmatched
Best Practicesunmatched
Business Analysisunmatched
Change Managementunmatched
Data Analysisunmatched
Data Profilingunmatched
Data Qualityunmatched
Data Warehousingunmatched
Database Extract Transform and Load (ETL)unmatched
Enterprise Data Integrationunmatched
Informaticaunmatched
Linux Operating Systemunmatched
Oracle Databaseunmatched
Oracle PL-SQLunmatched
Performance Tuning/Optimizationunmatched
Problem Solving Skillsunmatched
Product Lifecycleunmatched
Reconciliationunmatched
Regulatory Complianceunmatched
Regulatory Reportsunmatched
Regulatory Requirementsunmatched
Release Management/Engineeringunmatched
Root Cause Analysisunmatched
Software Administrationunmatched
Systems Analysisunmatched
Technical Supportunmatched
Technical Writingunmatched
Testingunmatched
Unix Operating Systemsunmatched
🎯
Be found by employers
5,500+ employers search our resume database daily. Add yours to get found by recruiters looking for candidates like you.
Level up your application
Professional resume templates
Browse dozens of recruiter approved resume templates, layouts and formats. Choose your favorite and make it your own in minutes.