Sr. Informatica PowerCenter & Oracle Consultant

Profile: Senior Consultant - Informatica PowerCenter/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 Consultantfor 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 PowerCenter ETL workflows, mappings & mapplets
• Perform deep-dive debugging, log analysis & issue resolutionacross 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 PowerCenter
• 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 engagementwith strong growth potential