Sr. Informatica PowerCenter & Oracle Consultant

Profile:  Senior Consultant - Informatica Power Center/Oracle

Experience:

3-12 Years

Location:

Pune | Mumbai | Bangalore (On-site/Hybrid)
Work Mode:  On-site/Hybrid with rotational shifts & weekend support (as required)

Role Overview :
We are hiring an experienced Senior Consultant  for a globally recognized multinational organization. This is a high-impact, production-driven role supporting enterprise-scale data platforms. Ideal for hands-on ETL professionals who enjoy solving complex data challenges and owning critical systems.

Key Responsibilities:

Design, develop, enhance & optimize  Informatica Power Center ETL workflows, mappings & mapplets
Perform deep-dive debugging, log analysis & issue resolution  across ETL and Oracle DB layers
Analyze workflow performance and implement tuning improvements
Write, optimize & tune  complex Oracle SQL queries
Analyze & troubleshoot BI reports and underlying query logic
Support production activities , impact analysis & deployments
Ensure  code quality, documentation & best practices
Collaborate with cross-functional teams to deliver reliable data solutions
Required Skills & Expertise:

- Technical

Skills:

Strong hands-on experience in  Informatica Power Center
Advanced Oracle SQL development & performance tuning
Solid Data Warehousing concepts :
Fact/Dimension modeling, Star & Snowflake schemas, SCD
Experience troubleshooting reporting environments
Strong debugging & performance optimization skills
Professional

Skills:

Excellent analytical & problem-solving abilities
Ability to work independently with  end-to-end ownership
Strong communication & stakeholder management skills
Detail-oriented with strong documentation practices
Flexibility to support production-critical environments
Why Join?:
Work in a  globally established enterprise environment
Exposure to large-scale, business-critical data platforms
Long-term engagement  with strong growth potential