SQL, SSIS Developer

Earnmodes; Chennai; On-site; INR 900,000 - 1,500,000; Full time

Job summary

BNP Paribas India Solutions in Chennai is seeking an experienced SQL Server and SSIS Developer to design, develop, and maintain robust ETL processes for regulatory reporting. The role involves coordinating with multiple Finance teams and stakeholders to ensure data availability and quality.

You will work on ETL workflows using SSIS, manage SQL Server data with T-SQL, and create dashboards in Tableau while leveraging GitLab for version control.

Qualifications

• 8–10 years of relevant experience in ETL and data integration.
• Strong proficiency in SSIS and T-SQL for SQL Server data processing.
• Experience with Tableau dashboards and data visualization.
• Hands-on use of GitLab for version control and collaboration.
• Familiarity with SSMS or equivalent database administration tools.
• Bachelor's or Master's degree in a relevant field.

Responsibilities

• ETL Development: Design and implement complex data integration workflows for WIND application using SSIS.
• Modeling & Querying: Query Microsoft SQL Server databases using T-SQL.
• Data Visualization: Transform processed data into dashboards via Tableau for actionable insights.
• Version Control: Use GitLab for code management and collaboration.
• Maintenance & Optimization: Optimize data flows and SQL performance to ensure reliable regulatory reporting.

Skills

ETL development

SQL

Data visualization

Version control

SQL Server management

Education

Bachelor/Master's degree

Tools

SSIS

T-SQL

Tableau

GitLab

SSMS

Visual Studio

Job description

Job Description

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 Studiofor 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 Tableaufor Data Visualization.
• Experience with GitLabfor version control and code management.
• Proficiency in Microsoft SQL Server Management Studio (SSMS) or equivalent solutionsis 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 Studiofor 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 Tableaufor Data Visualization.
• Experience with GitLabfor version control and code management.
• Proficiency in Microsoft SQL Server Management Studio (SSMS) or equivalent solutionsis a major asset for database administration and exploration.

Behavioral Skills:

Behavior Skills

Education Level: Bachelor/Masters

8 to 10 years of Relevant work experience

Location: Chennai

About BNPParibas Group:

BNPParibas 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 BNPParibas 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, BNPParibas 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. BNPParibas 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 BNPParibas India Solutions:

Established in 2005, BNPParibas India Solutions is a wholly owned subsidiary of BNPParibas SA, European Union’s leading bank with an international reach. With delivery centers located in Bengaluru, Chennai and Mumbai, we are a 24×7 global delivery center. India Solutions services three business lines: Corporate and Institutional Banking, Investment Solutions and Retail Banking for BNPParibas 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 BNPParibas, 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.

Source: Company Career page