W2 profiles Only
Location: Atlanta, GA (Onsite)
Position Overview
We are seeking an experienced ETL Developer to join our team in Atlanta, GA. The ideal candidate will be responsible for designing, developing, enhancing, and maintaining enterprise ETL solutions that support data integration, data warehousing, and regulatory reporting initiatives. This role requires strong expertise in Informatica PowerCenter, Oracle SQL/PLSQL, and enterprise data warehouse environments, along with the ability to troubleshoot complex data integration issues and optimize ETL performance.
Key Responsibilities
- Design, develop, and maintain scalable ETL workflows using Informatica PowerCenter to support enterprise data warehouse and regulatory reporting initiatives.
- Analyze business and technical requirements and translate them into efficient and scalable data integration solutions.
- Perform source system analysis, data profiling, and business rule validation to support ETL development and data integration projects.
- Develop and optimize ETL mappings, workflows, sessions, and reusable components following industry best practices.
- Tune ETL jobs and database queries to improve performance, reliability, scalability, and processing efficiency.
- Investigate and resolve production issues, ETL failures, data discrepancies, and performance bottlenecks through detailed root cause analysis.
- Conduct data validation, reconciliation, and quality assurance activities to ensure data accuracy, completeness, and consistency.
- Perform impact analysis for source system changes, database enhancements, and business rule modifications to minimize downstream risks.
- Assess upstream and downstream dependencies across ETL processes, databases, reporting applications, and consuming systems.
- Support the complete Software Development Life Cycle (SDLC), including development, testing, User Acceptance Testing (UAT), deployment validation, release management, and environment migrations.
- Collaborate with Business Analysts, Data Analysts, Data Architects, QA teams, and business stakeholders to deliver high-quality data integration solutions.
- Maintain technical documentation, ETL design specifications, data lineage, and support audit and compliance requirements.
Required Qualifications
- Strong experience developing enterprise ETL solutions using Informatica PowerCenter.
- Hands-on expertise with Oracle SQL and PL/SQL for data extraction, transformation, optimization, and database development.
- Solid experience with Unix/Linux scripting and command-line operations.
- Strong understanding of ETL architecture, data integration, and enterprise data warehouse concepts.
- Experience performing:
- Data profiling
- Data validation
- Data reconciliation
- Root cause analysis
- Performance tuning
- Ability to analyze complex business requirements and develop scalable ETL solutions.
- Experience supporting production environments, troubleshooting ETL failures, and implementing performance improvements.
- Knowledge of impact analysis, dependency management, and change management processes.
- Strong analytical, problem-solving, and troubleshooting skills.
- Excellent verbal and written communication skills with the ability to collaborate across cross-functional teams.
Preferred Qualifications
- Experience supporting enterprise data warehouse and regulatory reporting platforms.
- Familiarity with data governance, data lineage, and metadata management practices.
- Experience with release management, deployment processes, and production support.
- Knowledge of SDLC methodologies, Agile practices, and enterprise application development standards.
- Experience working in Banking or Financial Services environments is a plus.
Key Skills
- Informatica PowerCenter
- Oracle SQL & PL/SQL
- Unix/Linux
- ETL Design & Development
- Data Warehousing
- Data Integration
- Data Profiling
- Data Validation
- Data Reconciliation
- Performance Tuning
- Root Cause Analysis
- Impact Analysis
- Release & Change Management
- Data Governance
- Data Lineage
- Production Support
- SDLC
- Regulatory Reporting