DataHub - DataHub L3 (5.1-7 years)

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 , strong SQL 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 . 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…