DataHub L3 Professional

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 Bachelor's 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.