DM - Data Warehouse SQL Developer

Job Title: Deputy Manager 1
Department: Information TechnologyReports To: Sr. ManagerExperience: 6to 8 yearsPreferred Qualification:BE/B Tech/BSc (with PG Dip Computers)/ BSc (IT) / MCARequired Qualification: BE/B Tech/BSc (with PG Dip Computers)/ BSc (IT) /BCA/MCA

Skill, Knowledge & TrainingsHands-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 :SQL Server Development Strong T-SQL skills Report Development Querying Oracle 11g or higher

Functional CompetenciesExposure 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 Bl tools through all stages of the development life cycle while also working closely with all other project stakeholders.

Area Of OperationsData Warehouse

Key ResponsibilityMember 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