Skip to content

DataHub - DataHub L3 (5.1-7 years)

CAPCOIndia - BengaluruOn-Site

Estimated salary, not published by the employer: Est. ₹11–16 LPA

Needs a free Superjobs account. You'll finish on CAPCO's Greenhouse page.

Skill score

Summary

This person designs, builds, and maintains data pipelines in IBM Datastage feeding an enterprise data warehouse, writes SQL and Python automation, and sets up GitLab CI/CD for the Marketing Data Warehouse team. It suits a data warehousing engineer with 5 to 7 years of hands-on ETL and Teradata experience who works well in an agile team.

Function
Strategy
Estimated salary
Est. ₹11–16 LPA
Estimated for a mid-level role, ~5 yrs experience, India. Not published by the employer.
Work mode and location
On-Site, India - Bengaluru
Experience
5–7 yrs

Job description

Overview

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.
  • The candidate will 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 BNP Paribas group.
  • We are looking for top-notch, energetic talent to keep up with the industry’s momentum and support the team efforts.

Roles and 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 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 consistency by defining validation rules, unit tests and automated data‑quality 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 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 incidents and 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 a team player and actively participate in squad ceremonies (stand‑ups, sprint planning, retrospectives).
  • Adhere to Group standards (coding conventions, security, data‑governance, CI/CD).
  • Promote a culture of continuous learning, sharing insights about data‑warehouse trends and emerging technologies.
  • Work closely with cross‑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.

Skills required

Top skills

  • IBM Datastage
  • Teradata SQL
  • Python
  • CI/CD

All skills (11)

  • Data warehousing
  • Dimensional modelling
  • GitLab
  • Jenkins
  • Ansible
  • Autosys
  • Agile
  • JIRA
  • PowerBI
  • Tableau
  • Banking products

Qualifications

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

Nice to have

  • Add‑On (Nice‑to‑have) Data Visualization – exposure to tools such as PowerBI/Tableau.
  • Minimum5-7years of experience along with Bachelor's Degree - in IT, Computer related field or equivalent experience.

Other Skills

• 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

Other details

Location: Mumbai / Thane

Company info

“Capco, a Wipro company, is a global technology and management consulting firm. With our presence across 32 cities across globe, we support 100+ clients across banking, financial and Energy sectors.

More jobs at CAPCO