Principal Consultant

2 weeks ago


Noida, India Genpact Full time

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

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

Hands-on experience with physical, relational and dimensional data modeling, and even in No-SQL

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 Modelling, Process Flow Modelling, Data flow modelling and Knowledge of data modelling principles including conceptual and logical data models

Creating 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/GCP

Transformation to Consumption using various methods including API delivery

Experience with data warehouses and big data platforms

Strong hands-on experience with data modeling tools like Erwin.

Identify and understand business needs and create data models to fit those needs

Maintain data models, define data modeling and design standards

Evaluate any existing data systems

Develop best practices for standard naming conventions and data coding

Ensure consistency of data models

Evaluate data models and databases for variances and discrepancies

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

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

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



  • Noida, Uttar Pradesh, India Genpact Full time

    Job Title: Senior Principal ConsultantDescription: As a Senior Principal Consultant at Genpact, you will lead the P&C Applications Development team, overseeing up to 50+ people and handling responsibilities such as strategy, budgeting, growth requirements, technology architecture and design, project management, people management, and client...


  • Noida, India ION Full time

    The Role: This is an exciting opportunity to join ION as a Principal Technical Consultant. As a Principal Consultant, you will be responsible for project technical oversight and leadership, technical architecture and design, mentoring consultants, and leading and participating in internal initiatives to improve delivery. You will work with business...


  • Noida, India Oracle Full time

    Oracle GSC is hiring for Fusion HCM Technical Sr Consultant / Principal ConsultantsMinimum experience - 4 years with atleast 1 end to end fusion project implementation experienceJob locations- PAN India (Bangalore, Hyderabad, Chennai, Mumbai, Pune, Kolkata, Gandhinagar, Noida)Oracle Global Services Center (GSC) is a fast-growing cloud consulting team...


  • Noida, India Genpact Full time

    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 –...


  • Noida, India Genpact Full time

    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 –...


  • Noida, India Genpact Full time

    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 –...


  • Noida, India Genpact Full time

    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 –...


  • Noida, Uttar Pradesh, India Genpact Full time

    Job Title: Senior Principal ConsultantGenpact (NYSE: G) is a global professional services firm dedicated to delivering exceptional outcomes. Our team of experts, driven by a passion for innovation, works across 30+ countries to create lasting value for our clients.Key Responsibilities:- Collaborate with sales teams to comprehend client requirements and...


  • Noida, Uttar Pradesh, India Genpact Full time

    Genpact is a global professional services and solutions firm delivering outcomes that shape the future. Our team is driven by our innate curiosity, entrepreneurial agility, and desire to create lasting value for our clients. We serve and transform leading enterprises with our deep business and industry knowledge, digital operations services, and expertise in...


  • Noida, Uttar Pradesh, India Genpact Full time

    Job Opportunity:Genpact, a global professional services and solutions firm, invites applications for the role of Principal Consultant, Program Manager. As a key member of our team, you will be responsible for managing software development projects, ensuring they are completed on time, within budget, and to the required quality standards.Responsibilities:•...


  • Noida, India Genpact Full time

    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 –...


  • Noida, India Genpact Full time

    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 –...


  • Noida, Uttar Pradesh, India Genpact Full time

    About This OpportunityGenpact is a global professional services and solutions firm seeking an experienced Senior Principal Consultant – Senior Principal Architect to join our team. As a key member of our organization, you will be responsible for designing and implementing scalable, fault-tolerant data migration solutions that meet the needs of our diverse...


  • Noida, India Oracle Full time

    Oracle GSC is hiring for Oracle EPM FCCS Principal/Sr Principal Consultants with minimum 8 years experience.Job Locations - PAN India (Bangalore, Mumbai, Pune, Hyderabad, Chennai, Noida, Kolkata, Gandhinagar)Oracle Global Service Center (GSC) is a unit within oracle that establishes long-term relationships with many of Oracle's customers through...


  • Noida, India Genpact Full time

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


  • Noida, India Genpact Full time

    Inviting applications for the role of Principal Consultant-Software Development Engineer In Test As a QE Lead SDET, he/she will be responsible for leading the quality engineering efforts, developing and executing comprehensive test plans, and ensuring the robustness of our software products. He /She will work closely with the development team to design...


  • Noida, India GENPACT India Private Limited Full time

    Principal Consultant and Lead Consultant, Azure DatabricksWork model - HybridWe are looking to hire Data Engineers with expertise in Azure Databricks, Python, Pyspark, and SQL for our esteemed client across PAN India. The ideal candidates should have 4 to 11 years of experience.Genpact (NYSE: G) is a global professional services and solutions firm delivering...


  • noida, India Oracle Full time

    Oracle GSC is hiring for Fusion HCM Technical Sr Consultant / Principal Consultants Minimum experience - 4 years with atleast 1 end to end fusion project implementation experience Job locations- PAN India (Bangalore, Hyderabad, Chennai, Mumbai, Pune, Kolkata, Gandhinagar, Noida) Oracle Global Services Center (GSC) is a fast-growing cloud consulting team...


  • Noida, India Genpact Full time

    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 –...


  • Noida, India Genpact Full time

    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 –...