Careers at Genpact


  • Facebook
  • Twitter
  • Linkedin
  • Email

Senior Principal Consultant - Data Modeler

With a startup spirit and 90,000+ curious and courageous minds, we have the expertise to go deep with the world’s biggest brands—and we have fun doing it. Now, we’re calling all you rule-breakers and risk-takers who see the world differently, and are bold enough to reinvent it. Come, transform with us.

Transformation happens here. Come, be a part of our exciting journey!

Be part of a team that is transforming BCG into a bionic company! We are in the early stages of building a multi domain Master Data Management solution that will ensure the uniformity, accuracy and accountability of enterprise-wide master data assets.

The Data Modeler will work as part of an Agile squad composed of internal and external developers, functional business partners, data stewards, software vendors and other service providers, the candidate will closely interact with colleagues in various Functional Groups, the Database Services (DBA) Group, external solution providing vendor to provide high quality data model that respond to and meet the business needs of the global BCG organization

Are you the one we are looking for?

Inviting applications for the role of Data Modeler


Understand and translate business needs into data models supporting long-term solutions.

• Reviewing modifications of existing systems for cross-compatibility.

• Be Custodian of Enterprise Data Model, support enhancement and promote its usage

• Help drive creation of logical and physical data models from EDM using best practices to ensure high data quality and reduced redundancy.

• Optimize and update Enterprise Data Model (EDM) to support new and existing projects.

• Maintain EDM and logical data models along with corresponding metadata.

• Work with the Application Development team to take references from EDM and help drive Application level Data model, build & capture data flows.

• Develop best practices for standard naming conventions and coding practices to ensure consistency of data models.

• Recommend opportunities for reuse of data models in new environments.

• Ability to perform reverse engineering of physical data models from databases and SQL scripts. (PL/SQL)

• Evaluate data models and physical databases for variances and discrepancies.

• Validate business data objects for accuracy and completeness.

• Analyze data-related system integration challenges and propose appropriate solutions.

• Examine new application design and recommend corrections if required.

• Must have ERwin experience


• Bachelor's degree or equivalent combination of education and experience.

• Bachelor's degree in information science, data management, computer science or related field preferred.

• Good IT experience with major focus on data related projects

• Good experience working as Application Data modeler/Enterprise Data Modeler

• Good experience as Enterprise Data Warehouse is a strong plus

• Strong interpersonal skills and ability to work cross-functionally

• Excellent communication and presentation skills.

• Advanced troubleshooting skills.

• Expertise in Oracle or MS SQLServer or MySQL database, as well as data modelling, both logical and physical; expertise with the Amazon AWS platform would be beneficial

• Expertise in data modelling software such as ERWin

• Extensive experience in multidimensional data modelling, such as star schemas, snowflakes, normalized and de-normalized models, handling “slow-changing” dimensions/attributes

• Exceptional ability to effectively communicate with technical and business colleagues and make complex ideas understood

• Experience working projects using Agile methodologies

• Experience in Operational Data Store and data integration processes/procedures

• Experience with Data Warehouse and BI systems; extensive experience for collecting business requirements from customers, and transform the requirements into DB data processes and data schem

Genpact is an Equal Opportunity Employer and considers applicants for all positions without regard to race, color, religion or belief, sex, age, national origin, citizenship status, marital status, military/veteran status, genetic information, sexual orientation, gender identity, physical or mental disability or any other characteristic protected by applicable laws. Genpact is committed to creating a dynamic work environment that values diversity and inclusion, respect and integrity, customer focus, and innovation. For more information, visit Follow us on Twitter, Facebook, LinkedIn, and YouTube.

Job: Senior Principal Consultant

Job ID: ITO046531

Primary Location: India - Bangalore

Education Level: Bachelor's / Graduation / Equivalent

Job Posting: Apr 28, 2022

Master Skills List: Corporate

Job Category: Full Time