Job Title: SQL Server and SSIS Developer
Department: FRS
About Business line/Function: FDS (Finance dedicated Solutions)
Position Purpose: As Developer in LRRS team, main responsibilities are related to the technical aspects of automation of the local regulatory reporting for the countries within the portfolio. Therefore, communication with the different stakeholders is expected for coordination purposes: several Finance teams (Branches, CIB, Group), the business analysts in LRRS team, the tools providers, the technical teams, to maintain and support LRRS applications. The primary mission will be to design, develop, and maintain robust ETL (Extract, Transform, Load) processes to ensure data availability, high data quality, and the seamless operation of the application.
Responsibilities
Direct Responsibilities
- ETL Development: Design and implement complex data integration workflows for the WIND application using Microsoft SQL Server Integration Services (SSIS).
- Modeling & Querying: Manipulate and query Microsoft SQL Server databases using Transact-SQL (T-SQL).
- Data Visualization: Collaborate to transform processed data into actionable business insights and dashboards via Tableau.
- Version Control: Ensure code integrity and facilitate team collaboration through GitLab.
- Maintenance & Optimization: Identify and resolve data flow anomalies and optimize SQL query performance to guarantee the reliability of regulatory reporting.
Contributing Responsibilities
Contribute to overall FRS and ISPL Vision goals as directed by Team and Department Management
Technical & Behavioral Competencies
Technical
(Mandatory Skills):
- Mandatory proficiency in Microsoft Visual Studio for SSIS package development.
- Expertise in Microsoft SSIS (SQL Server Integration Services).
- Advanced mastery of Transact-SQL (T-SQL) for managing and querying Microsoft SQL Server databases.
- Proficiency in Tableau for Data Visualization.
- Experience with GitLab for version control and code management.
- Proficiency in Microsoft SQL Server Management Studio (SSMS) or equivalent solutions is a major asset for database administration and exploration.
(Optional Skills):
· Autosys, Python, Unix
· Preferably Banking and Financial domain
Specific Qualifications:
Behavior Skills
- Rigor and attention to detail (essential to meet stringent regulatory reporting requirements).
- Strong analytical and complex problem-solving skills.
- Autonomy and highly organized.
- Team player with excellent communication skills to interact with business stakeholders.
Skills Referential (Required knowledge, skills and abilities)
Technical Skills:
- Mandatory proficiency in Microsoft Visual Studio for SSIS package development.
- Expertise in Microsoft SSIS (SQL Server Integration Services).
- Advanced mastery of Transact-SQL (T-SQL) for managing and querying Microsoft SQL Server databases.
- Proficiency in Tableau for Data Visualization.
- Experience with GitLab for version control and code management.
- Proficiency in Microsoft SQL Server Management Studio (SSMS) or equivalent solutions is a major asset for database administration and exploration.
Behavioral Skills:
Behavior Skills
- Rigor and attention to detail (essential to meet stringent regulatory reporting requirements).
- Strong analytical and complex problem-solving skills.
- Autonomy and highly organized.
- Team player with excellent communication skills to interact with business stakeholders.
Education Level: Bachelor/Masters
8 to 10 years of Relevant work experience
Location: Chennai
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, corporate 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.
