Principal Consultant – Data Modeller

Ready to shape the future of work
At Genpact we dont just adapt to changewe drive it. AI and digital innovation are redefining industries and were leading the charge. Genpacts AI Gigafactory our industry-first accelerator is an example of how were scaling advanced technology solutions to help global enterprises work smarter grow faster and transform at scale. From large-scale models to agentic AI our breakthrough solutions tackle companies most complex challenges.
If you thrive in a fast-moving tech-driven environment love solving real-world problems and want to be part of a team thats shaping the future this is your moment.
Genpact (NYSE: G) is an advanced technology services and solutions company that delivers lasting value for leading enterprises globally. Through our deep business knowledge operational excellence and cutting-edge solutions we help companies across industries get ahead and stay ahead. Powered by curiosity courage and innovation our teams implement data technology and AI to create tomorrow today. Get to know us at and on LinkedIn X YouTube and Facebook.

Inviting applications for the role of Principal Consultant Data Modeller!

Role:
In this role you shall be responsible for working as a Data Modeler
Heres a more detailed breakdown of the typical responsibilities and required skills:
Responsibilities:
Understanding the business needs and gathering user requirements by conducting and participating in JAD sessions interacting with end-users and training them on the applications developed for the organization
Expert knowledge in SDLC (Software Development Life Cycle) and was involved in all phases in projects.
Design Development and implementation of the enterprise-wide architecture for structured and unstructured data providing architecture and consulting services to Business Intelligence initiatives and data driven business applications
Business Process Modeling Process Flow Modeling Data flow modeling
creating ETL specification documents & creating flowcharts process work flows and data flow diagrams.
Performed extensive data cleansing data manipulations and date transforms and data auditing.
Developed database objects like PL/SQL packages tables stored procedures triggers that are used for meeting the business objectives.
Hands on experience of working in the Cloud technologies AWS/Azure/GCP
End to end data and analytics solutions design experience using cloud technologies- AWS S3 Spark EMR Data bricks MPP databases Redshift/Snowflake right from Ingestion to Transformation to Consumption using various methods including API delivery

Qualifications we seek in you!
Minimum Qualifications
Solid experience in Information Technology as Data Analyst and Data Modeler with advanced analytical and problem solving skills.
Good experience in snowflake.
Solid experience in RDBMS(Like teradata oracle etc)
Extensive experience with OLTP/OLAP System and E - R modeling developing Database Schemas like Star schema and Snowflake schema used in relational dimensional and multidimensional modeling .
Extensive experience in Relational Data Modeling Dimensional Data Modeling Logical/Physical Design ER Diagrams Forward and Reverse Engineering Publishing Erwin diagrams analyzing datasources and creating interface documents.

Preferred Qualifications/ Skills:
Data Modeler
Strong and Excellent experience in Data Analysis Data Migration Data Validation Data Cleansing Data Verification identifying data mismatch Data Import and Data Export through the use of multiple ETL tools such as Pentaho Talend and Informatica PowerCenter and Informatica BDE
Excellent experience on Teradata SQL queries Teradata Indexes Utilities such as Mload Tpump Fast load and FastExport.
Have experience in Dimensional Modeling using Star and Snowflake schema methodologies of Data Warehouse and Integration projects
Strong understanding of RDMS/ SQL concepts and experience in working with relational databases and able to design the data models and implement them
Good understanding of CLOUD (Azure AWS GCP) data and analytics services
Certification and Hands-on experience with Azure and/or AWS design and implementation is preferred
Developed Data dictionary and maintained Metadata for each model.
Coordinated with other developers in tuning long running SQL queries to enhance system performance
Why join Genpact
Be a transformation leader Work at the cutting edge of AI automation and digital innovation
Make an impact Drive change for global enterprises and solve business challenges that matter
Accelerate your career Get hands-on experience mentorship and continuous learning opportunities
Work with the best Join 140000 bold thinkers and problem-solvers who push boundaries every day
Thrive in a values-driven culture Our courage curiosity and incisiveness - built on a foundation of integrity and inclusion - allow your ideas to fuel progress
Come join the tech shapers and growth makers at Genpact and take your career in the only direction that matters: Up.
Lets build tomorrow together.

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 respect and integrity customer focus and innovation.
Furthermore please do note that Genpact does not charge fees to process job applications and applicants are not required to pay to participate in our hiring process in any other way. Examples of such scams include purchasing a starter kit paying to apply or purchasing equipment or training