Morningstar Hiring For Senior Database and Database Developer:
Mandate Skills - SQL, ETL and Shell Scripting
Date - 28th Nov 2018
Location - Vashi
Morningstar's structured credit research and ratings subsidiary (MCR) is a Nationally Recognized Statistical Ratings Organization (NRSRO) that has earned a reputation for innovation and excellence in the structured finance market. This group aims to increase market transparency and provides the highest quality ratings through securities research, monitoring services, data, and technology solutions.
The Senior Database Developer will be a leader in a wide variety of responsibilities critical to the implementation of our next generation data platform. This person will be responsible for the design, construction, and, maintenance of warehousing processes, which includes ETL/ELT, ODS/Warehouse data modeling, metadata definitions and scripting. In this role the Senior Database Developer will design analytical SQL, data models, work very closely with our project managers/scrum masters, business analysts, architects, developers, and DBAs to ensure the requirements are well understood .
+ Design analytical SQL.
+ Optimize SQL queries and ETL processes.
+ Design tables, distributions, and organize and materialized views.
+ Develop user defined functions, aggregates, and table functions.
+ Translate user requirements and needs into database schema and table design.
+ Implement and support data calculation, collection, and harvesting.
+ Design and construct databases in both MySQL/Postgres, MongoDB and SQL Server.
+ Work closely with business analysts and data architects to support tactical and strategic objectives
+ A bachelor's degree in computer science or a related field.
+ Minimum of 5-8 years' experience of prior Analytical SQL experience.
+ Skills in database design with some data modeling skills, as well as proficiency with ANSI SQL-99.
+ Minimum of 3-5 years' experience with Java, C/C++, Python, and/or Shell Scripting.
+ Proven SQL skills in performance tuning and creating efficient stored procedures and functions.
+ Knowledge of SQL window functions as well as data visualization tools, and applications.
+ Experience working in the cloud (AWS and/or Azure)
+ Financial industry knowledge, especially in the Credit Rating area is looked on very favorably.