DataHub - DataHub L3 (5.1-7 years)

Capco; Bengaluru; On-site; INR 2,500,000 - 4,000,000; Full time

Job summary

Capco, a Wipro company, is a global technology and management consulting firm hiring aData Warehousing Engineer in Mumbai. You will design and optimize data pipelines, ensure data quality, and collaborate with cross‑functional teams to deliver scalable analytics solutions.

With 5–7 years of experience, you will implement data warehousing concepts, work with Oracle/ Teradata SQL, and contribute to governance and performance improvements while embracing an agile delivery approach.

Qualifications

• 5–7 years of experience in data warehousing with IBM Datastage.
• Strong SQL skills with Teradata database experience.
• Proficient in Python and CI/CD tooling (GitLab).
• Knowledge of data quality, governance and performance standards.
• Experience in Agile environments and cross‑functional teams.
• Bachelor’s degree in IT or computer science.

Responsibilities

• Design, build and maintain data pipelines in IBM Datastage to ingest, transform and expose data into the enterprise data warehouse.
• Apply dimensional modelling and star/snowflake schemas to support analytics and BI.
• Develop Python/Shell scripts to automate day‑to‑day tasks and processes.
• Ensure data quality with validation rules, tests and automated checks.
• Collaborate with data architects and business analysts to translate requirements into design and implementation.
• Document design specs, data dictionaries and runbooks; contribute to knowledge base.
• Set up CI/CD pipelines (GitLab) for testing, versioning and deployment across environments.
• Support production incidents; perform root‑cause analysis and preventive fixes.
• Promote coding standards and architecture reviews; mentor junior engineers.

Skills

IBM Datastage

SQL

Python

CI/CD

GitLab

Agile

ETL

Education

Bachelor's Degree in IT

Tools

JIRA

Confluence

SharePoint

Autosys

ALM/QC

Job description

About Us

“Capco, a Wipro company, is a global technology and management consulting firm. Awarded with

About Us

“Capco, a Wipro company, is a global technology and management consulting firm. Awarded with Consultancy of the year in the British Bank Award and has been ranked Top 100 Best Companies for Women in India 2022 by Avtar & Seramount. With our presence across 32 cities across globe, we support 100+ clients across banking, financial and Energy sectors. We are recognized for our deep transformation execution and delivery.

WHY JOIN CAPCO?

You will work on engaging projects with the largest international and local banks, insurance companies, payment service providers and other key players in the industry. The projects that will transform the financial services industry.

MAKE AN IMPACT

Innovative thinking, delivery excellence and thought leadership to help our clients transform their business. Together with our clients and industry partners, we deliver disruptive work that is changing energy and financial services.

#BEYOURSELFATWORK

Capco has a tolerant, open culture that values diversity, inclusivity, and creativity.

CAREER ADVANCEMENT

With no forced hierarchy at Capco, everyone has the opportunity to grow as we grow, taking their career into their own hands.

DIVERSITY & INCLUSION

We believe that diversity of people and perspective gives us a competitive advantage.

MAKE AN IMPACT

Position Purpose

• We are looking for a strong Data warehousing resource with 5 to 7 years of hands‑on experience in IBM Datastage, strongSQL programm ing skills in Teradata database, good hands‑on on python programming and CI/CD.
• Thecandidatewill be a member of the Marketing Data Warehouse Tribe, working on the design, development and optimization of data integration processes.
• The candidate should be able to independently design, build, debug, maintain, and enhance data pipelines while collaborating effectively with different stakeholders.
• The role focuses on translating business requirements into robust, scalable data pipelines, data‑modeling and self‑service analytics while ensuring data‑quality, governance and performance standards of the BNPParibas group.
• We are looking for top‑note, energetic talent to keep up with the industry’s momentum and support the team efforts.

Responsibilities

Direct Responsibilities

• Design, build and maintaindata pipelines inIBM Datastage to ingest, transform and expose data from source systems (Relational, flat files etc.) into the enterprise data warehouse.
• Implement data‑warehousing concepts(dimensional modelling, slowly‑changing 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 consistencyby defining validation rules, unit tests and automated data‑quality checks implementation.
• Collaborate with data architects and business analyststo translate functional requirements into technical specifications, functional designs and implementation plans.
• Document technical and functional artifacts(design specs, data dictionaries, operational run‑books) and contribute to knowledge‑base for the Data Tribe.
• Set up CI/CD pipelines(GitLab) to automate testing, versioning and deployment across environments (dev / test / prod).
• Support production incidentsand perform root‑cause 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 ateam playerand actively participate in squad ceremonies (stand‑ups, sprint planning, retrospectives).
• Adhere to Group standards(coding conventions, security, data‑governance, CI/CD).
• Promote a culture ofcontinuous learning, sharing insights about data‑warehouse trends and emerging technologies.
• Work closely withcross‑functional 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 data‑warehousing 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.
• Hands‑on 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.
• Add‑On (Nice‑to‑have) Data Visualization– exposure to tools such as PowerBI/Tableau.

Specific Qualifications

• Minimum5-7years of experience along with Bachelor's Degree - in IT, Computer related field or equivalent experience.

Skills Referential (Required knowledge, skills and abilities)

• Agile methodology exposure
• Knowledge of banking products is a nice to have
• Proactive mindset

Behavioral Skills

• Communication
  • Communication
  • Analytical Ability
  • Team Player

Education Level

Bachelor Degree or equivalent

Location

Mumbai / Thane