Consultant - Data Warehousing (MDM)- (482)

Bangalore · 4-6 years experience · Full-time · Hybrid · Posted Oct 15, 2026

At a glance

As a Consultant in a Data Warehousing project, you will undertake a range of technical, analytical, and collaborative tasks essential for effective data management.
You will play a pivotal role in ensuring that the organization can effectively leverage its data assets for informed decision-making.

Undertake primary ownership in driving self and team member's effort across all phases of a project lifecycle
Oversees and develops Data Warehouse projects to ensure methodological soundness; deliver quality client deliverables within expected timeframe
Assist in designing data models that reflect business needs and support analytical objectives
Partner with Project lead/ Program lead in delivering projects and assist in project management responsibility like - project plans, and risk mitigation
Develop and maintain comprehensive documentation for data warehouse architecture, ETL processes, and system configurations to ensure clarity and compliance
Participate in design reviews and code reviews to ensure adherence to quality standards and best practices in data warehousing
Foster collaboration with onshore and offshore team members to ensure seamless communication and effective task execution
Lead task planning and task distribution across team members and ensure timely completion with high quality and report accurate status to project lead
Mentor/coach the junior members in the team
Analyze problem statements and client requirements to design and implement complex solutions using Programing languages, ETL platform

4-6 years of hands-on experience in Master Data Management (MDM), within relevant consulting-industry experience
Strong understanding of core MDM concepts, including data stewardship, data governance, and data quality management
Proven experience in Customer Mastering (HCP/HCO) & address mastering and standardization using third party tools
Proficient in data profiling, applying data quality rules, data standardization, and reference data management
Familiarity with key pharma data sources such as IQVIA, MedPro, Symphony, etc.
Ability to translate both functional and non-functional business requirements into scalable, efficient MDM solutions
Proficiency in Python for scripting and data manipulation
Strong SQL skills for data extraction and analysis

Hands on experience with leading MDM platforms such as Reltio, Informatica MDM, etc. is a plus