Job Title: Datastage Developer
Department: ISPL ITG Payment services
About Business line/Function:
IT Payment Services department, the worldwide reference for payments in the BNP Paribas Group. We are working on the many applications used worldwide using various technologies and working in Agile methodology.
The Marketing Data Warehouse Fortis is a tribe within the IT Data Tribe is responsible for transforming complex marketing data into actionable insights by building robust Data pipelines and building modern, cloud‑native data solutions that power analytics & reporting initiatives across the IT Group.
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 programming 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 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.
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:
• Minimum 5-7 years of experience along with Bachelor's Degree - in IT, Computer related field or equivalent experience.
Skills Referential (Required knowledge, skills and abilities)
Other Skills:
- Agile methodology exposure
- Knowledge of banking products is a nice to have
- Proactive mindset
Behavioral Skills:
- Communication
- Analytical Ability
- Team Player
Education Level: Bachelor Degree or equivalent
Location: Mumbai / Thane
About BNP Paribas Group:
BNP Paribas is the European Union’s leading bank and key player in international banking. It operates in 65 countries and has nearly 185,000 employees, including more than 145,000 in Europe. The Group has key positions in its three main fields of activity: Commercial, Personal Banking & Services for the Group’s commercial & personal banking and several specialized businesses including BNP Paribas Personal Finance and Arval; Investment & Protection Services for savings, investment, and protection solutions; and Corporate & Institutional Banking, focused on corporate and institutional clients. Based on its strong diversified and integrated model, the Group helps all its clients (individuals, community associations, entrepreneurs, SMEs, corporates and institutional clients) to realize their projects through solutions spanning financing, investment, savings and protection insurance. In Europe, BNP Paribas has four domestic markets: Belgium, France, Italy, and Luxembourg. The Group is rolling out its integrated commercial & personal banking model across several Mediterranean countries, Turkey, and Eastern Europe. As a key player in international banking, the Group has leading platforms and business lines in Europe, a strong presence in the Americas as well as a solid and fast-growing business in Asia-Pacific. BNP Paribas has implemented a Corporate Social Responsibility approach in all its activities, enabling it to contribute to the construction of a sustainable future, while ensuring the Group's performance and stability.
About BNP Paribas India Solutions:
Established in 2005, BNP Paribas India Solutions is a wholly owned subsidiary of BNP Paribas SA, European Union’s leading bank with an international reach. With delivery centers located in Bengaluru, Chennai and Mumbai, we are a 24x7 global delivery center. India Solutions services three business lines: Corporate and Institutional Banking, Investment Solutions and Retail Banking for BNP Paribas across the Group. Driving innovation and growth, we are harnessing the potential of over 10000 employees, to provide support and develop best-in-class solutions.
Commitment to Diversity and Inclusion
At BNP Paribas, we passionately embrace diversity and are committed to fostering an inclusive workplace where all employees are valued, respected and can bring their authentic selves to work. We prohibit Discrimination and Harassment of any kind and our policies promote equal employment opportunity for all employees and applicants, irrespective of, but not limited to their gender, gender identity, sex, sexual orientation, ethnicity, race, colour, national origin, age, religion, social status, mental or physical disabilities, veteran status etc. As a global Bank, we truly believe that inclusion and diversity of our teams is key to our success in serving our clients and the communities we operate in. As a global Bank, we truly believe that inclusion and diversity of our teams is key to our success in serving our clients and the communities we operate in.