DataHub - DataHub L3 (5.1-7 years)

Overview

Capco is seeking a Data Warehousing resource to join the Marketing Data Warehouse Tribe, designing, developing and optimizing data integration processes and data pipelines.

What you'll do

• 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 processing.
• 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 the 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.
• 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.
• Integrate in a French-Indian agile extended team.

What you'll need

• 5-7 years of experience 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, and writing complex SQL queries, including Teradata database.
• Strong hands-on experience in Python, including 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 or any other.
• Experienced user of ALM/QC, JIRA, Confluence, SharePoint.
• Excellent oral and written communication skills.
• Experience working in an Agile environment.
• Agile methodology exposure.
• Proactive mindset.
• Minimum 5-7 years of experience along with a Bachelor's Degree in IT, a computer-related field, or equivalent experience.

Nice to have

• Data visualization: exposure to tools such as PowerBI/Tableau.
• Knowledge of banking products.

Details

• Location: Mumbai / Thane (source location line: India - Bengaluru).
• Education level: Bachelor's degree or equivalent.