SQL Developer Jobs in Pune - MSCI Inc.

SQL Developer

MSCI Inc.

0 to 3 Years

Not disclosed

Expired

Posted: 02 Jul 20

Job Description

About MSCI

For more than 40 years, MSCI’s research-based indexes and analytics have helped the world’s leading investors build and manage better portfolios. Clients rely on our offerings for deeper insights into the drivers of performance and risk in their portfolios, broad asset class coverage and innovative research. Our line of products and services includes indexes, analytical models, data, real estate benchmarks and ESG research. MSCI serves 98 of the top 100 largest money managers, according to the most recent P&I ranking.

For more information, visit us at .

Position Overview

SQL Developer in the HR Technology Team

Responsibilities

7+ years’ experience developing SQL based applications in a large development environment.
Deep expertise in SQL, Stored Procedures, Triggers, functions and SQL troubleshooting.
Developing complex SQL queries, views, procedures and triggers with a deep understanding of indexing for optimization.
Experience in SSIS, SSAS, SSRS and ability to develop, build and troubleshoot SSIS packages.
Experience in designing efficient database solutions for loading and transforming large volume of data.
Proficiency in optimization techniques & performance tuning, understanding benefits & disadvantages of normalization & denormalization.
Performance Tune database applications & schemas for performance & scalability ensuring security, and availability of databases.
Familiar with common database procedures such as upgrade, backup, recovery, migration, etc.
Maintain high standards of data quality and integrity.
Recommend and lead implementation for improvements to SQL Server configuration.
Build relationships with the enterprise DBA team and collaborate and partner with them to propose & implement changes for database optimization.
Partner with software development teams to provide technical insights into schema, queries & stored procedure design.
Understanding the Software Development Life Cycle (SDLC), specifically Scrum and Agile methodology.

Desired Experience And Qualifications

Collaborating with other team members and stakeholders to develop strong relationships and partnerships.
Strong analytical and problem-solving abilities.
Ability to work with minimal supervision or assistance to complete tasks.
Deep expertise in T-SQL, Stored Procedures, Triggers, functions & knowledge of SQL Developer tools is must.
Strong proficiency with SQL Server – SSIS, SSAS and SSRS. Power BI, DAX and M-Query knowledge is a definite plus.
Excellent knowledge of Business intelligence tools like Import/Export, SSAS, SSRS and Power BI.
Proficiency in optimization techniques & performance tuning, understanding benefits & disadvantages of normalization & denormalization.
Skilled in working with poorly documented source databases and understanding the source schema through examining the data itself.
Experience in designing database solutions and capable of troubleshooting common database issues.
Preparing documentations and specifications.

Due to the great number of applications we receive for each of our open vacancies, we are unable to respond on an individual basis.

To all recruitment agencies: MSCI does not accept unsolicited CVs/Resumes. Please do not forward CVs/Resumes to any MSCI employee, location or website. MSCI is not responsible for any fees related to unsolicited CVs/Resumes.