Job Title

Profile: Senior Consultant - Informatica PowerCenter/OracleExperience: 10-14 YearsLocation: Bangalore | Mumbai | Pune (On-site)Work Mode: On-site 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 PowerCenter ETL workflows, mappings & mappletsPerform deep-dive debugging, log analysis & issue resolution across ETL and Oracle DB layersAnalyze workflow performance and implement tuning improvementsWrite, optimize & tune complex Oracle SQL queriesAnalyze & troubleshoot BI reports and underlying query logicSupport production activities, impact analysis & deploymentsEnsure code quality, documentation & best practicesCollaborate with cross-functional teams to deliver reliable data solutionsRequired Skills & Expertise:- Technical Skills:Strong hands-on experience in Informatica PowerCenterAdvanced Oracle SQL development & performance tuningSolid Data Warehousing concepts: Fact/Dimension modeling, Star & Snowflake schemas, SCDExperience troubleshooting reporting environmentsStrong debugging & performance optimization skillsProfessional Skills:Excellent analytical & problem-solving abilitiesAbility to work independently with end-to-end ownershipStrong communication & stakeholder management skillsDetail-oriented with strong documentation practicesFlexibility to support production-critical environmentsWhy Join?:Work in a globally established enterprise environmentExposure to large-scale, business-critical data platformsLong-term engagement with strong growth potential