Ssis Ssrs Developer

Job Title: Developer SSIS C# SQL

Position Purpose: 

XGEN is an application used to control and transform data into the format expected by regulators. It contributes to the production of the Group financial reporting for banking and market authorities. 

The application is continuously evolving from both a technical and functional perspective in order to address frequent regulatory changes requested by supervisory and regulatory authorities. 

The candidate will join the ITG-ITTF-SDE team and will contribute to the implementation, maintenance and evolution of XGEN. The role will mainly involve analysis, technical design, SSIS development, SQL development, testing, documentation and production support. 

The candidate will work closely with French & Indian teams, business analysts, production teams and development teams in an international environment.

Responsibilities

• Analyze and interpret business and technical specifications received from business analysts or application leads. 
• Liaise with business analysts and development teams to ensure a clear understanding and correct implementation of requirements. 
• Design, develop and maintain SSIS packages used by XGEN. 
• Develop and maintain SQL components, including queries, scripts, stored procedures and data transformation logic. 
• Contribute to technical design and propose solutions adapted to business and regulatory needs. 
• Participate in testing phases, including technical tests, regression tests and support to user acceptance testing. 
• Analyze data and investigate discrepancies linked to regulatory reporting processes. 
• Analyze and correct incidents in collaboration with Production and Development teams. 
• Provide technical support during reporting closing periods, including on-call support when required. 
• Follow up technical operations on environments, including obsolescence management, security actions and environment stability. 
• Follow up and validate application deliveries. 
• Ensure high-quality developments in line with BNP Paribas standards, including DevOps tooling and coding best practices.  
• Contribute to application performance improvement and technical reliability. 

Technical & Behavioral Competencies

Mandatory

• Strong expertise in SSIS / Microsoft SQL Server Integration Services. 
• Strong expertise in SQL. 
• Strong knowledge of C# development. 
• Good knowledge of Shell scripting. 
• Good knowledge of GitLab / version control tools. 
• Ability to perform technical analysis, development, unit testing and technical documentation. 

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 ~15000 employees, to provide support and develop best-in-class solutions.