Data Stage Developer

Position Purpose

The Developer would be responsible for all the development on the MIRO Application, Support the application development and as well as testing.

The activity will mainly consist of development and maintenance.

Responsibilities

• ETL Development: Create, optimize, and maintain DataStage parallel jobs, sequences, and routines to move data from various sources to target data warehouses and data marts.
• Data Transformation: Implement complex business logic using transformer stages, lookups, joins, aggregations, and sorting mechanisms.
• Database & SQL Optimization: Write and optimize advanced SQL and PL/SQL queries to extract and manipulate data in relational databases like Oracle, DB2, or SQL Server.
• Scripting & Automation: Develop Unix/Linux shell scripts to automate job scheduling, file monitoring, and operational pipelines.
• Troubleshooting & Support: Monitor job execution, perform root cause analysis on failed data loads, and provide production support for data processing cycles. 
• Collaboration: Work with data architects, business analysts, and testers to translate business rules into source-to-target mappings and technical specifications. Work closely in a one team approach with all stakeholders during all phases of the SDLC, jointly providing high quality deliverables
• Testing: Participate in the testing phases (system, user acceptance, regression) as required while coordinating with BA, IT and QA teams
• AI: Use AI tools LLM, API’s etc

Technical expertise

• Primary / Mandatory –
• IBM Infosphere DataStage Designer, Director, and Administrator
• SQL and Unix shell scripting
• Oracle 19c

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.