29918-DataHub L3 (5.1-7 years) MuM

Company Profile:
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 .

Responsibilities:
Direct Responsibilities

. Design build and maintain data pipelines in IBM Datastage to ingest transform and expose data from source systems (Relational flat files etc.) into the enterprise data warehouse.
. Implement datawarehousing concepts (dimensional modelling slowlychanging dimensions star/snowflake schemas) to support analytical reporting and BI consumption.
. Develop Python/Shell Scripting code to automate day to day tasks and perform required .
. Ensure data quality and consistency by defining validation rules unit tests and automated dataquality checks implementation.
. Collaborate with data architects and business analysts to translate functional requirements into technical specifications functional designs and implementation plans.
. Document technical and functional artifacts (design specs data dictionaries operational runbooks) and contribute to knowledgebase for the Data Tribe.
. Set up CI/CD pipelines (GitLab) to automate testing versioning and deployment across environments (dev / test / prod).
. Support production incidents and perform rootcause analysis apply fixes and preventive measures.
. Drive technical excellence by establishing coding standards performing architectural reviews and mentoring junior engineers to foster a high performing engineering culture.

Contributing Responsibilities

. Act as a team player and actively participate in squad ceremonies (standups sprint planning retrospectives).
. Adhere to Group standards (coding conventions security datagovernance CI/CD).
. Promote a culture of continuous learning sharing insights about datawarehouse trends and emerging technologies.
. Work closely with crossfunctional teams (Data Scientist BI Business Units) to understand data needs and deliver reliable solutions.
. Able to integrate in a French Indian agile extended team.


Technical & Behavioral Competencies

. Experience of 5 7 years in creating data warehousing solutions using IBM Datastage.
. Strong background in datawarehousing concepts ETL pipelines and performance tuning.
. Strong SQL programming hands on experience in creating procedures functions writing complex SQL queries.
. Programming Strong hands on experience in Python concepts such as OOPs reusable utilities exception handling debugging and clean code practices.
. Handson with GitLab Jenkins Ansible or similar tools to automate builds and deployments.
. Experience in Scheduling tool Autosys/any other.
. Experienced user of ALM/QC JIRA Confluence SharePoint.
. Excellent oral and writing communication skills.
. Experience in working in Agile environment.
. AddOn (Nicetohave) Data Visualization exposure to tools such as PowerBI/Tableau.

Specific Qualifications:
. Minimum 5 7 years of experience along with Bachelors Degree in IT Computer related field or equivalent experience.
Skills Referential(Required knowledge skills and abilities)
Other Skills:
Agile methodology exposure
Knowledge of banking products is a nice to have
Proactive mindset
Behavioral Skills:

. Communication
. Analytical Ability
. Team Player

Education Level:Bachelor Degree or equivalent
Location:Mumbai / Thane

Life at CGI:
It 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 team one of the largest IT and business consulting services firms in the world.

• Data Analysis
• Data Warehousing
• DB2 Warehouse
• GitLab
• ETL

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.

That same commitment to fairness extends to how we use technology. To support our recruitment team AI tools may be used to help assess applications though they never replace human judgement. All hiring decisions remain entirely in the hands of our recruitment professionals.

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