Job Description

Genpact (NYSE: G) is a global professional services and solutions firm delivering outcomes that shape the future. Our 125,000+ people across 30+ countries are driven by our innate curiosity, entrepreneurial agility, and desire to create lasting value for clients. Powered by our purpose - the relentless pursuit of a world that works better for people - we serve and transform leading enterprises, including the Fortune Global 500, with our deep business and industry knowledge, digital operations services, and expertise in data, technology, and AI.Inviting applications for the role of Principal Consultant-Data Modeler!ResponsibilitiesUnderstanding 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 organizationHands-on experience with physical, relational and dimensional data modeling, and even in No-SQLExpert 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 applicationsBusiness Process Modelling, Process Flow Modelling, Data flow modelling and Knowledge of data modelling principles including conceptual and logical data modelsCreating ETL specification documents, & creating flowcharts, process workflows and data flow diagrams.Performed extensive data cleansing, data manipulations and date transforms and data auditing.Developed database objects like packages, tables, stored procedures, triggers that are used for meeting the business objectives.Hands on experience of working in the Cloud technologies - AWS/Azure/GCPTransformation to Consumption using various methods including API deliveryExperience with data warehouses and big data platformsStrong hands-on experience with data modeling tools like Erwin.Identify and understand business needs and create data models to fit those needsMaintain data models, define data modeling and design standardsEvaluate any existing data systemsDevelop best practices for standard naming conventions and data codingEnsure consistency of data modelsEvaluate data models and databases for variances and discrepanciesMinimum QualificationsSolid 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-Modelling, developing Database Schemas like Star schema and Snowflake schema used in relational, dimensional and multidimensional modelling .Extensive experience in Relational Data Modelling, Dimensional Data Modelling, Logical/Physical Design, ER Diagrams, Forward and Reverse Engineering, Publishing Erwin diagrams, analysing data sources and creating interface documents.Preferred qualificationsStrong 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 toolsExcellent 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 projectsStrong understanding of RDMS/ SQL concepts and experience in working with relational databases and able to design the data models and implement themGood understanding of CLOUD (Azure, AWS, GCP) data and analytics servicesCertification and Hands-on experience with Azure and/or AWS design and implementation is preferredDeveloped Data dictionary and maintained Metadata for each model.Coordinated with other developers in tuning long running SQL queries to enhance system performanceGenpact 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. Get to know us at and on , , , and .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.

Genpact