Technical Lead- MSBI Development

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.

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 specialised 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

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.

About Business line/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:

Technical Lead

Date:

Department:

CIB IT - IAM - Identity Access Management

Location:

Mumbai

Business Line / Function:

CIB IT Production

Reports to:

(Direct)

Grade:

(if applicable)

(Functional)

Number of Direct Reports:

N/A

Directorship / Registration:

NA

POSITION PURPOSE

We are looking for Microsoft Business Intelligence IT Professional having an experience more than 8 years and expertise in areas such as SSIS, SSRS & SSAS and SQL Server 2005/2012/2014/2017/2019/2022. 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 SAILPOINT 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 SailPoint application performance
Accountable for generation, reporting and improvements of various Production KPIs, SLs and dashboards for APS teams.
Accountable for improvements in service and presentations for all governances and steering committees
Accountable for maintenance and improvement of IT continuity plans (ICP)

CONTRIBUTING RESPONSIBILITIES

TECHNICAL & BEHAVIORAL COMPETENCIES

Have minimum of 8 years of strong experience in Microsoft Technology (Microsoft Business Intelligence) MSBI like SSIS, SSRS & SSAS and SQL Server 2005/2012/2014/2017/2019/2022
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 advantagePreferred to have

SPECIFIC QUALIFICATIONS (IF REQUIRED)

Graduate in any discipline or bachelor’s in information technology

Skills Referential

Behavioural Skills: (Please select up to 4 skills)

Ability to collaborate / Teamwork

Creativity & Innovation / Problem solving

Ability to deliver / Results driven

Communication skills - oral & written

Transversal Skills: (Please select up to 5 skills)

Ability to manage a project

Ability to set up relevant performance indicators

Ability to anticipate business / strategic evolution

Ability to develop and adapt a process

Analytical Ability

Education Level:

Bachelor Degree or equivalent

Experience Level

At least 5 years

Other/Specific Qualifications (if required)