Data warehouse SQL Developer (SQL Server), Mumbai

Job Description:

Job Title: Deputy Manager - 1 Department: IT
Reports to: Sr. Manager – IT Experience: 6 to 8 years

Required Qualification: BE/B Tech/BSc (with PG
Dip Computers)/ BSc (IT) /BCA/ MCA

Preferred Qualification: BE/B Tech/BSc (with PG
Dip Computers)/ BSc (IT) / MCA

Skill, Knowledge & Trainings:

 Hands-on experience with SQL Server 2016 or higher
 Writing optimized T-SQL Queries
 Development of Reports in SSRS / Tableau
 MSBI Technology Stack
 Good Communication and Presentation skills

Core Competencies (Must have):

 SQL Server Development
 Strong T-SQL skills
 Report Development
 Querying Oracle 11g or higher

Additional Competencies (Nice to have):

 Exposure to post trade applications in Capital Markets/Treasury
 Should be able to work in a team as well as individually
 SSAS – Cube
 MDX
 Power BI

Job Purpose:

The successful candidate would join the IT Department of a critical Financial Market Infrastructure (FMI) organization which serves as a Qualified Central Counterparty (QCCP) for Government Securities, Money Market, FX and Derivatives transactions in the Indian financial markets.
The successful candidate would play a key role in the “Data Warehouse” which serves the needs of analytical data of all business segments.
The candidate should be able to design fact & dimension tables, create & deploy SSRS reports and SSIS catalogues, create and modify cube design. The successful candidate would be responsible for
application development using BI tools through all stages of the development life cycle while also working closely with all other project stakeholders.

Area of Operations Key Responsibility

Data Warehouse Member of data warehouse team developing the solution using SQL Server Scripts, Stored Procedures, Functions.

Any Other Requirement:

 Should be a good team player.
 Would be required to work with multiple projects / teams concurrently