Senior ETL Consultant

Mployee.me; Pune District; On-site; INR 600,000 - 1,000,000; Full time

Job summary

Mployee.me in Pune, India, is seeking a QA Associate to evaluate systems and improve test processes across ETL and data validation efforts. You will work independently to support functional and automation testing for multiple systems, applications, and databases.

You will lead test planning, write test cases, and coordinate with US & India teams in Agile environments to ensure quality and reliability of Asset Management workflows and data migrations.

Qualifications

• Hands-on ETL testing across data warehouses and databases (data validation, reconciliation).
• SQL queries to validate data accuracy, integrity and business rules.
• Test Asset Management systems including portfolios, trading platforms, and regulatory reporting.
• Understand securities processing, NAV calculations and performance attribution.
• Design data validation techniques for source-to-target mapping.
• Plan and execute QA for data migrations and data warehouse implementations.
• Create detailed test plans, scenarios and cases for ETL and Asset Management workflows.
• Experience with Agile/Scrum in financial services environments.

Responsibilities

• Define test strategies for Automation, Regression and Smoke Testing.
• Manage and lead a test team.
• Understand and implement testing processes.
• Prepare automation test plans.
• Deploy and manage test frameworks.
• Identify and communicate risks during test planning and execution.
• Lead end-to-end testing tasks: scoping, estimation, planning, work allocation, resource management, test design & execution, defect management, progress tracking & status reporting.
• Plan and coordinate for timely availability of test data and environments.
• Collaborate with project teams across US & India.
• Ensure all test execution activities follow procedures.
• Be self-driven and organized; strong presentation and interpersonal skills.
• Customer-focused; action-oriented; teamwork; self development; creativity & innovation.
• Ability to handle multiple tasks and work both independently and in a team.
• Define and implement QA metrics framework.
• Identify and drive QA improvement opportunities.
• Willing to work shifts and provide QA support on weekends as required.

Skills

ETL testing

SQL testing

Asset Management

Data validation

Agile/Scrum

Test planning

Job description

QA Associate evaluates systems and develops test processes to improve the reliability and maintainability of products and applications. Working independently, this job supports the functional and automation testing of various systems, applications, and databases..

Required Skills

• Extensive hands-on experience in ETL testing, including data extraction, transformation, and load validation across multiple database platforms and data warehouses.
• Strong expertise in database testing using SQL queries to validate data accuracy, integrity, referential integrity, and business rule implementation.
• Proven experience testing Asset Management systems, including portfolio management, trading platforms, investment accounting, and regulatory reporting applications.
• Deep understanding of Asset Management business processes, including securities processing, position reconciliation, NAV calculations, and performance attribution.
• Hands-on experience with data validation techniques, including source-to-target mapping verification, data quality checks, and reconciliation testing.
• Proficient in designing and executing test strategies for data migration projects and data warehouse implementations.
• Experience creating detailed test plans, test scenarios, and test cases based on business requirements and data specifications for ETL processes and Asset Management workflows.
• Prior experience working in Agile/Scrum methodology within Asset Management and financial services environments.

Key Responsibilities and Duties

• Define the test strategies for Automation, Regression and Smoke Testing.
• Effectively manage and lead a test team.
• Understand and implement the testing processes.
• Prepare automation test plans.
• Deploy and manage test frameworks.
• Identify and communicate risks during test planning and execution phases.
• Own (Lead) the end-to-end testing tasks like scoping, estimation, planning, work allocation, resource management, test design & execution, defect management, progress tracking & status reporting, management reporting, UAT support, test closure etc.
• Plan & coordinate for timely availability of the test data & environments
• Proactively communicate and collaborate with project teams, test teams and support partners across US & India
• Ensure that all test execution activities are conducted for projects per procedure / requirements.
• Self-starter, highly organized; Works well with all functional levels in the organization; excellent presentation and interpersonal skills; high level of business management and facilitation skill; capability to resolve complex problems with minimum confusion, frustration, and inconveniences for all parties concerned.
• Customer focused; Action-Oriented; Building Team Spirit; Self Development; Creativity & Innovation; Problem Solving; Ethics & Values
• Ability to handle multiple tasks and to work independently as well as in a team setting.
• Define and implement the QA metrics framework.
• Identify & drive the improvement opportunities in the QA space.
• Should be willing to work in shifts and provide QA support on weekend as per the project requirements.

Additional Skills

• Understanding on Asset Management business domain.