<p><p><b>Description : </b><br/><br/>Job Title : Deputy Manager - 1<br/><br/></p><p>Department : IT<br/><br/>Reports to : Sr. Manager IT<br/><br/></p><p>Experience : 6 to 8 years<br/><br/>Required Qualification : BE/B Tech/BSc (with PG Dip Computers)/ BSc (IT) /BCA/ MCA<br/><br/>Preferred Qualification : BE/B Tech/BSc (with PG Dip Computers)/ BSc (IT) / MCA<br/><br/><b>Skill, Knowledge & Trainings : </b><br/><br/>- Hands-on experience with SQL Server 2016 or higher<br/><br/></p><p>- Writing optimized T-SQL Queries<br/><br/></p><p>- Development of Reports in SSRS / Tableau<br/><br/></p><p>- MSBI Technology Stack<br/><br/></p><p>- Good Communication and Presentation skills<br/><br/><b>Core Competencies (Must have) : </b><br/><br/>- SQL Server Development<br/><br/></p><p>- Strong T-SQL skills<br/><br/></p><p>- Report Development<br/><br/></p><p>- Querying Oracle 11g or higher<br/><br/><b>Additional Competencies (Nice to have) : </b><br/><br/>- Exposure to post trade applications in Capital Markets/Treasury<br/><br/></p><p>- Should be able to work in a team as well as individually<br/><br/></p><p>- SSAS Cube<br/><br/></p><p>- MDX<br/><br/></p><p>- Power BI<br/><br/><b>Job Purpose : </b><br/><br/>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.<br/><br/>The successful candidate would play a key role in the Data Warehouse which serves the needs of analytical data of all business segments.<br/><br/>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.<br/><br/><b>Area of Operations Key Responsibility :</b><br/><br/>Data Warehouse Member of data warehouse team developing the solution using SQL Server Scripts, Stored Procedures, Functions.<br/><br/><b>Other Requirements : </b><br/><br/>- Should be a good team player.<br/><br/></p><p>- Would be required to work with multiple projects / teams concurrently</p><br/></p> (ref:hirist.tech)