Description

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

This role is on-site.

Responsibilities

• Translate business and technical requirements into scalable data integration solutions for regulatory reporting.
• 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 via root cause analysis.
• Support the full development lifecycle including testing, UAT, deployment validation, and environment migrations.

Required Skills

• 5+ years of experience designing and developing ETL solutions.
• Proficiency in Informatica PowerCenter for enterprise data warehousing.
• Strong command of Oracle SQL and PL/SQL.
• Experience with Unix/Linux environments for ETL execution and scripting.
• Solid understanding of Data Warehousing concepts and Data Integration patterns.
• Ability to perform data validation, reconciliation, and quality checks.
• Experience with performance tuning and impact analysis for source system changes.

Preferred Skills

• Experience with data governance, data lineage, and audit/compliance requirements.
• Knowledge of data profiling tools and techniques.

Key Skills

Education

Bachelor's degree