Senior Software Engineer

About BNP Paribas Group:

BNP Paribas is a top-ranking bank in Europe with an international profile. It operates in 71 countries and has almost 199 000 employees. The Group ranks highly in its three core areas of activity: Domestic Markets and International Financial Services (whose retail banking networks and financial services are grouped together under Retail Banking & Services) and Corporate & Institutional Banking, centred on corporate and institutional clients. The Group helps all of its clients (retail, associations, businesses, SMEs, large corporates and institutional) to implement their projects by providing them with services in financing, investment, savings and protection. In its Corporate & Institutional Banking and International Financial Services activities, BNP Paribas enjoys leading positions in Europe, a strong presence in the Americas and has a solid and fast-growing network in the Asia/Pacific region.

About BNP Paribas India Solutions:

Established in 2005, BNP Paribas India Solutions is a wholly owned subsidiary of BNP Paribas SA, a leading bank in Europe 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 6000 employees, to provide support and develop best-in-class solutions.

About Businessline/Function :

The Identity Access Management (IAM) team ensures proper IT Security access control for application user accounts and is responsible for the controlled access management of employees to IT resources including application accounts, domain accounts, and account privileges. In addition the team provide people referential setup for regions.

Business line is CIB - CIB is Corporate and Institutional Banking

Job Title:

Senior Software Engineer

Date:

19/06/2023

Department:

CIB IT - IAM - Identity Access Management

Location:

Mumbai

Business Line / Function:

CIB ITO Production

Reports to:

(Direct)

Grade:

(if applicable)

(Functional)

Number of Direct Reports:

NA

Directorship / Registration:

NA

Position Purpose

We are looking for Microsoft Business Intelligence IT Professional having an experience more than 7 years and expertise in areas such as SSIS, SSRS & SSAS and SQL Server 2005/2012/2014/2017. The resource will play a key role as a Technical Architect in Access Management platform handling the complete back-end of IIQ repository. The candidate should have a solid working knowledge of various IT systems/technologies and enjoy working collaboratively across teams. This position requires constant interaction with technology operations and security compliance teams to understand management processes, which must be re-engineered to work with IAM processes

Responsibilities

Direct Responsibilities

• Should be responsible of creating ETL packages for loading data from HR database
• Should be responsible in maintaining/supporting/developing SSIS, SSRS & SSAS and SQL packages for the IIQ repository
• Provide technical leadership and Propose improvements related to the development activity (job performance)
• Problem resolution: Incidents analysis, steering of corrective action
• Strong hands on experience on Web and Application servers
• Needs to have experience in Performance engineering and improving Access Management SailPoint application performance

Contributing Responsibilities

Technical & Behavioral Competencies

• Have minimum of 5 years of strong experience in Microsoft Technology (Microsoft Business Intelligence) MSBI like SSIS, SSRS & SSAS and SQL Server 2005/2012/2014/2017
• In-depth Technical Knowledge on Microsoft Business Intelligence (MSBI) Tools like SQL Server 2005/2008/2012 Integration Services and Reporting Services
• Should have Knowledge on creating Package Configuration, Logging, and Error Handling for the SSIS Packages.
• Having knowledge in Implementation of Relational Database (OLTP) and Data warehousing systems (OLAP) and Data Marts.
• Experience in Deployment of ETL Packages in different environments and worked for preparing the deployment documentation for the DBA team.
• Experience in creating relationships between Dimensions and Measure groups. Involved in the design and development of the SSAS cubes and (Multidimensional) MDX queries.
• Experience in extracting the data using SSIS from OLTP to OLAP.
• Experience in Dimensional Data Modeling Star and Snow Flake Schemas.
• Experience in maintaining database, including updating statistics, re-indexing, structure modifications, and index analysis and restore Database backup.
• Experience in creating like Drill-Down, Drill-Through, Sub Reports, Parameterized reports and subscriptions in SSRS. Configuring the Report security in the Report configuration manager
• Should have at least 3 years of excellent hands on experience on SailPoint, in design and developing functionalities like Lifecycle Management, Multiplexed and Direct Reconciliation, Workflow Management & Compliance Management
• Knowledge on Power BI, SAP BO Reporting & Tableau will be an added advantage

Specific Qualifications (if required)

Skills Referential

Behavioural Skills: (Please select up to 4 skills)

Ability to collaborate / Teamwork

Decision Making

Communication skills - oral & written

Ability to synthetize / simplify

Transversal Skills: (Please select up to 5 skills)

Ability to understand, explain and support change

Ability to manage a project

Ability to develop others & improve their skills

Ability to inspire others & generate people's commitment

Ability to manage / facilitate a meeting, seminar, committee, training…

Education Level:

Bachelor Degree or equivalent

Experience Level

At least 5 years

Other/Specific Qualifications (if required)

               

NA