Sr. QA Automation Engineer (Data)

Posted Yesterday
Be an Early Applicant
Navi Mumbai, Thane, Maharashtra
Hybrid
Mid level
Enterprise Web • Fintech • Financial Services
The Role
Lead the development of automated test frameworks for financial data pipelines, focusing on data validation and big data testing using PySpark and AWS. Collaborate with different teams to define test requirements and optimize processes, while ensuring data quality and consistency across systems.
Summary Generated by Built In

Responsibilities:

  • Test Automation & Framework: Lead the development of automated test framework for financial data pipelines using PySpark/Python and AWS services (e.g., Glue, Athena, EMR, Redshift) Should be able to write test cases based on product requirement, execute them and report issues
  • Data Validation: Automate data validation for financial data sets (like back test datasets, prices and returns data and other calculated metrics), ensuring data consistency and correctness across distributed systems
  • Big Data Testing: Use PySpark / Python to test large financial datasets, validating performance, accuracy, and scalability in AWS environments
  • Collaboration: Work with data analysts, portfolio managers, and quant researchers to define test requirements and ensure data quality in financial data sets like Back test universe, Risk Models and reports
  • Continuous Improvement: Optimize test processes, creating reports and frameworks for efficiency, integrating new tools and best practices for cloud-based systems


Requirements:
Education:

  • Bachelor's or MBA/Masters' degree in a quantitative, financial discipline, or engineering
  • 3+ years of hands-on experience in QA automation with a focus on data-driven financial solutions, preferably in AWS environment


Technical Expertise:
Automation Frameworks & Tools:

  • Strong knowledge of a testing framework for API, and data-driven test automation
  • Hands-on experience with integrating test automation into Code Pipeline or cloud-based CI/CD systems to ensure consistent and reliable testing


Data Analysis & Financial Modeling Knowledge:

  • Proficiency in SQL and MS Excel and ability to work with large financial datasets, performing data validation for downstream usage of financial calculations and reports.


Performance Testing & Optimization:

  • Experience in performance testing and load testing for large financial data applications, optimizing AWS-based systems for scalability and reliability


Skill that would be a plus:

  • Strong proficiency in Python, with extensive experience using PySpark to process large datasets and validate financial data across distributed systems
  • Strong expertise in AWS services including S3, Glue, EMR to design and automate testing for financial data systems in the cloud
  • Basic understanding of financial data analysis workflows and key financial metrics, including portfolio performance, risk management, and pricing models
  • Experience with AWS CDK, CloudFormation, or Terraform for infrastructure automation, ensuring test environments are reproducible and scalable


Personal Attributes:

  • Excellent ability with a strong track record of fostering collaboration across multiple teams
  • Exceptional problem-solving skills, with the ability to troubleshoot complex data issues and identify root causes in large-scale cloud-based systems
  • Strong communication skills, with the ability to present technical information clearly to both technical and non-technical stakeholders
  • Highly motivated, pro-active, and passionate about continuous learning, keeping abreast with emerging trends in cloud technologies, data analysis, and automation


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

Top Skills

Pyspark
Python

What the Team is Saying

Raaghavendar
Saurabh
Anna
Wendell
Jeff
Upasna
The Company
HQ: Chicago, IL
12,700 Employees
Hybrid Workplace
Year Founded: 1984

What We Do

At Morningstar, we believe in building great products in-house in a highly collaborative, agile environment where we focus on technical excellence, the user experience, and continuous improvement. Our technologists represent a range of skills and experience levels, but they all view their work as a craft and push technology’s boundaries.

Why Work With Us

Imagining big things is in our blood -- it's transformed us from a company with just a few employees in 1984 to a leading independent investment research company with a worldwide presence today. As of April 2020, we acquired Sustainalytics to drive long-term meaningful outcomes for investors in the ESG space. Join us on this exciting journey!

Gallery

Gallery
Gallery
Gallery
Gallery
Gallery
Gallery

Morningstar Offices

Hybrid Workspace

Employees engage in a combination of remote and on-site work.

Typical time on-site: 3 days a week
HQGlobal Headquarters
Santiago Province
LU
NSW
TH
Amsterdam, NL
Cape Town, ZA
Dubai, Dubai
Frankfurt am Main, DE
Frederiksberg, DK
London, GB
Madrid, ES
Mexico City, Mexico City
Milano, IT
Navi Mumbai, Maharashtra
New York, NY
Oakland, MD
Oslo, NO
Paris, FR
São Paulo, São Paulo
PitchBook US Headquarters
Stockholm, SE
Tokyo, JP
Toronto, ON
Toronto, Ontario
Zürich, CH
Learn more

Similar Jobs

Morningstar Logo Morningstar

Senior Data Quality Assurance Engineer

Enterprise Web • Fintech • Financial Services
Hybrid
Navi Mumbai, Thane, Maharashtra, IND
12700 Employees

Morningstar Logo Morningstar

Senior Software Engineer

Enterprise Web • Fintech • Financial Services
Hybrid
Navi Mumbai, Thane, Maharashtra, IND
12700 Employees

Morningstar Logo Morningstar

Quality Engineer (Future of Retirement)

Enterprise Web • Fintech • Financial Services
Hybrid
Navi Mumbai, Thane, Maharashtra, IND
12700 Employees

Morningstar Logo Morningstar

Lead Site Reliability Engineer

Enterprise Web • Fintech • Financial Services
Hybrid
Navi Mumbai, Thane, Maharashtra, IND
12700 Employees

Sign up now Access later

Create Free Account

Please log in or sign up to report this job.

Create Free Account