Senior ETL Consultant - Informatica Power Center

Description :

Key Responsibilities :

- Design, develop, and maintain ETL solutions using Informatica PowerCenter

- Understand end-to-end system landscapes, including upstream source systems and downstream target systems

- Interpret ETL technical specifications and implement scalable, optimized data pipelines

- Leverage Informatica transformations and features to deliver high-performance ETL solutions

- Work extensively with Oracle databases, including PL/SQL development

- Decode complex Oracle PL/SQL queries and rebuild or refactor functionality within ETL workflows

- Optimize SQL and ETL jobs for performance and reliability

- Develop and manage data integrations between Informatica and :

1. Oracle databases

2. SAP systems

3. Amazon Redshift

- Work in UNIX environments for scheduling, scripting, and job monitoring

- Build and manage API-based data integrations using Informatica

- Support enhancements and troubleshooting of existing data pipelines

- Collaborate with architects, business analysts, and downstream consumers

- Support testing, deployment, and production support activities

- Work in Agile delivery environments and track work using tools like Jira Align

Mandatory Skills & Qualifications :

Technical Skills :

- 5- 7 years of strong hands-on experience in Informatica PowerCenter (PWC)

- Solid understanding of enterprise data landscapes

- Strong experience with Oracle database and PL/SQL development

- Ability to interpret and implement ETL technical specifications

- Experience with UNIX environments

Desired / Good-to-Have Skills :

- Exposure to SAP connectivity with Informatica

- Experience integrating Amazon Redshift with Informatica

- Knowledge of API processing using Informatica

- Exposure to Jira Align or Agile project management tools

Soft Skills :

- Strong analytical and problem-solving abilities

- Attention to detail and commitment to data quality

- Good communication and collaboration skills

What We Offer :

- Opportunity to work on complex, enterprise-scale data integration projects

- Exposure to modern data platforms and integration patterns

- Collaborative and growth-focused work environment

- Competitive compensation and career advancement opportunities