Data Modeler 6-8 years

Position Description:

Founded in 1976 CGI is among the largest independent IT and business consulting services firms in the world. With 94000 consultants and professionals across the globe CGI delivers an end-to-end portfolio of capabilities from strategic IT and business consulting to systems integration managed IT and business process services and intellectual property solutions. CGI works with clients through a local relationship model complemented by a global delivery network that helps clients digitally transform their organizations and accelerate results. CGI Fiscal 2024 reported revenue is CA$14.68 billion and CGI shares are listed on the TSX (GIB.A) and the NYSE (GIB). Learn more at .
Job Title: Data Modeller
Position: Lead Analyst
Experience: 6-8 Years
Category: Software Development/ Engineering
Shift:General
Main location:PAN India
Position ID: J0326-1744
Employment Type: Full Time
Education Qualification: Bachelors degree in Computer Science or related field or higher with minimum 5 years of relevant experience.



The Data Modeler will work towards design and implementation of new data structures to support the project teams delivering on ETL Data warehouse design managing the enterprise data model the maintenance of the data and enterprise data integration approaches.

Technical Responsibilities


. Build and maintain out of standards data models to report disparate data sets in a reliable consistent and interpretable manner.
. Gather distil and harmonize data requirements and to design coherent Conceptual logical and physical data models and associated physical feed formats to support these data flows.
. Articulate business requirements and build source-to-target mappings having complex ETL transformation.
. Write complex SQL statements and profile source data to validate data transformations.
. Contribute to requirement analysis and database design - Transactional and Dimensional data modelling. Normalize/ De-normalize data structures introduce hierarchies and inheritance wherever required in existing/ new data models.
. Develop and implement data warehouse projects independently.
. Work with data consumers and data suppliers to understand detailed requirements and to propose standardized data models.
. Contribute to improving the Data Management data models.
. Be an influencer to present and facilitate discussions to understand business requirements and develop dimension data models based on these capabilities and industry best practices.


Requirements


. Extensive practical experience in Information Technology and software development projects of with at least 8 years of experience in designing Operational data store & data warehouse.
. Extensive experience in any of Data Modelling tools Erwin/ SAP power designer.
. Strong understanding of ETL and data warehouse concepts processes and best practices.
. Proficient in Data Modelling including conceptual logical and physical data modelling for both OLTP and OLAP.
. Ability to write complex SQL for data transformations and data profiling in source and target systems
. Basic understanding of SQL vs NoSQL databases.
. Possess a combination of solid business knowledge and technical expertise with strong communication skills. Demonstrate excellent analytical and logical thinking.
. Good verbal & written communication skills and Ability to work independently as well as in a team environment providing structure in ambiguous situation.


Good to have

. Understanding of Insurance Domain
. Basic understanding of AWS cloud
. Good understanding of Master Data Management Data Quality and Data Governance.
. Basic understanding of data visualization tools like SAS VA Tableau
. Good understanding of implementing & architecting data solutions using the informatica SQL server/Oracle

Skills:

• erwin Data Modeler
• ETL
• Data Analysis

What you can expect from us:

Together as owners lets turn meaningful insights into action.

Life at CGI is rooted in ownership teamwork respect and belonging. Here youll reach your full potential because

You are invited to be an owner from day 1 as we work together to bring our Dream to life. Thats why we call ourselves CGI Partners rather than employees. We benefit from our collective success and actively shape our companys strategy and direction.

Your work creates value. Youll develop innovative solutions and build relationships with teammates and clients while accessing global capabilities to scale your ideas embrace new opportunities and benefit from expansive industry and technology expertise.

Youll shape your career by joining a company built to grow and last. Youll be supported by leaders who care about your health and well-being and provide you with opportunities to deepen your skills and broaden your horizons.

Come join our teamone of the largest IT and business consulting services firms in the world.