🔔 FCM Loaded

Senior Consultant - Informatica PowerCenter/Oracle Analytics

Canopus Infosystems - A CMMI Level 3 Company

10 - 14 years

Bengaluru

Posted: 17/02/2026

Getting a referral is 5x more effective than applying directly

Job Description

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 & 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

Services you might be interested in

Improve Your Resume Today

Boost your chances with professional resume services!

Get expert-reviewed, ATS-optimized resumes tailored for your experience level. Start your journey now.