DataHub - DataHub L3 (5.1-7 years)

Capco
Bengaluru, Mumbai
Workplace: OnsiteFull timeFunction: Administration & Executive AssistanceExperience: 5-7 yearsEducation: bachelorsSkills: ["Communication","Analytical ability","Team player","Proactive mindset","Collaboration"]

Design, build, and optimize data integration and warehousing pipelines for the Marketing Data Warehouse. You will use IBM Datastage, Teradata SQL, and Python to ingest, transform, and expose data with strong dimensional modeling and data quality controls. The role includes automation via CI/CD (GitLab) and scripting, supporting production incidents, and partnering with data architects and business analysts to translate requirements into scalable, governed data solutions.

Loading

Loading job details...

Preparing the role view and application actions.

FursaFursa
Capco
Capco
20 hours ago

DataHub - DataHub L3 (5.1-7 years)

✓ Verified Job

Canonical indexed version, validated from employer's careers page.

Source: Company careers pageValidated by: Fursa AI
Last checked: 2 hours agoStatus: Live

Job Summary

Design, build, and optimize data integration and warehousing pipelines for the Marketing Data Warehouse. You will use IBM Datastage, Teradata SQL, and Python to ingest, transform, and expose data with strong dimensional modeling and data quality controls. The role includes automation via CI/CD (GitLab) and scripting, supporting production incidents, and partnering with data architects and business analysts to translate requirements into scalable, governed data solutions.
Location: Bengaluru, Mumbai
Workplace: Onsite
Employment Type: Full time
Job Function: Administration & Executive Assistance
Seniority: Mid level

Key Responsibilities

  • •Design, build, and maintain IBM Datastage data pipelines to ingest, transform, and expose data into the enterprise data warehouse.
  • •Implement data-warehousing concepts (dimensional modeling, slowly changing dimensions, star/snowflake schemas) to support analytics and BI consumption.
  • •Develop Python/Shell scripting to automate day-to-day tasks and required processing.
  • •Ensure data quality and consistency via validation rules, unit tests, and automated data-quality checks.
  • •Set up CI/CD pipelines in GitLab for testing, versioning, and deployment across dev/test/prod, and support production incidents with root-cause analysis.

Key Requirements

  • •5–7 years creating data-warehousing solutions using IBM Datastage.
  • •Strong hands-on ETL/data-warehousing concepts (dimensional modeling, slowly changing dimensions, star/snowflake schemas).
  • •Strong SQL skills, including writing complex queries and stored procedures/functions.
  • •Strong Python experience (OOP, reusable utilities, exception handling, debugging, clean code).
  • •Hands-on CI/CD and automation tools, including GitLab and at least one scheduling/ALM tool (e.g., Autosys, ALM/QC, JIRA, Confluence).
Experience:5-7 yearsData warehousingETLCI/CDBankingAgile
Education:Bachelor's
Skills:CommunicationAnalytical abilityTeam playerProactive mindsetCollaboration
Tech Stack:IBM DatastageSQLTeradataPythonShell scriptingCI/CDGitLabJenkinsAnsibleAutosysALM/QCJIRAConfluenceSharePointPowerBITableauDimensional modelingETL pipelinesData validationUnit tests

Company Brief

Capco
Global management and technology consultancy specializing in financial services. Capco advises banks, insurers, and capital markets firms on digital transformation, risk and compliance, technology implementation, and operational improvement, combining industry expertise with advisory and engineering capabilities.
Industry: Management Consulting
Company Size: Enterprise (1,001+ employees)
Growth: Established Company
Headquarters: London, United Kingdom
Founded: 1998
Glassdoor
Glassdoor: 3.7
WebsiteLinkedIn