Software Engineer

Title - Software Engineer, Mumbai
Location: Vashi, Navi Mumbai
Company: Morningstar is a leading provider of independent investment research in North America, Europe, Australia, and Asia. We offer a wide variety of products and solutions that serve market participants of all kinds, including individual and institutional investors in public and private capital markets, financial advisors, asset managers, retirement plan providers and sponsors, and issuers of securities.
Morningstar India has been a Great Place to Work-certified company for the past eight consecutive years.
In this role, you will collaborate with Team Leader, Scrum Master, data analysts, and developers to build technology solutions for Morningstar platforms. You should have hands on experience on Core Java and Python. Also, you should have experience in component-based architecture and create scalable, flexible technical solutions. You would create new components, support existing systems, study their enterprise complexities and develop/implement better systems with modern software development practices. Developing good understanding of existing systems on other platforms and its database is a beginning step.
The Role: At Morningstar, helping investors is what brings us together and drives our work. Our Quality Assurance Organization is looking for Software Engineer who specializes in Data Engineering, Python, SQL and AWS to join our team, grow with us, introduce us to new ideas and develop products that empower our users. Every day, you will work with team members across disciplines and geographic locations, developing products for investors. You will interact daily with our product managers to understand our domain and create technical solutions that push us forward. We want to work with other engineers who bring knowledge and excitement about our opportunities. This position is based in our Mumbai office.
Responsibilities:

• Design, develop, and maintain scalable ETL pipelines for data extraction, transformation, and loading.
• Write efficient SQL queries and stored procedures to manage and manipulate large datasets in SQL Server.
• Implement data validation and integrity checks to ensure accuracy across all pipelines.
• Collaborate with business stakeholders and business analysts to deliver data solutions that support business goals.
• Work with Python to automate data workflows and integrate with third-party systems.
• Optimize data pipelines for performance, scalability, and cost-efficiency.
• Troubleshoot, debug, and resolve issues related to data processing.
• Leverage AWS services for cloud-based ETL processes (e.g., S3, Lambda, Glue) and storage solutions.
• Collaborate in an agile environment with product managers, data analysts, and engineering teams.

Must Have Skills: These are the most important skills, qualities, etc. that we'd like for this role.

• 3-5 years of experience in Data Engineering or related field.
• Proficiency in Python for building data pipelines and automation scripts.
• Strong experience with SQL Server including complex queries, stored procedures, and optimization techniques.
• Expertise in ETL processes and data modeling.
• Knowledge of version control and CI/CD pipelines for data projects.
• Good to have - Java, Spring and MongoDB

Qualifications:

• Bachelor's degree in computer science, Information Technology, or a related field.
• Strong analytical and problem-solving skills.
• Good communication and teamwork abilities.

EOE Statement: Morningstar is an equal opportunity employer
Morningstar's hybrid work environment gives you the opportunity to work remotely and collaborate in-person each week. We've found that we're at our best when we're purposely together on a regular basis, at least three days each week. A range of other benefits are also available to enhance flexibility as needs change. No matter where you are, you'll have tools and resources to engage meaningfully with your global colleagues.
I10_MstarIndiaPvtLtd Morningstar India Private Ltd. (Delhi) Legal Entity