Profile:Senior Consultant - Informatica PowerCenter/Oracle Experience:10-14 Years Location:Bangalore | Mumbai | Pune (On-site) Work Mode:On-site 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 & optimizeInformatica 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 & tunecomplex Oracle SQL queries Analyze & troubleshoot BI reports and underlying query logic Support production activities , impact analysis & deployments Ensurecode quality, documentation & best practices Collaborate with cross-functional teams to deliver reliable data solutionsRequired Skills & Expertise:-Technical Skills: Strong hands-on experience inInformatica 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 skillsProfessional Skills: Excellent analytical & problem-solving abilities Ability to work independently withend-to-end ownership Strong communication & stakeholder management skills Detail-oriented with strong documentation practices Flexibility to support production-critical environmentsWhy Join?: Work in aglobally established enterprise environment Exposure to large-scale, business-critical data platforms Long-term engagementwith strong growth potential
Job Title
Senior Consultant - Informatica PowerCenter/Oracle Analytics