SDET II
Russell Investments22 hours ago
Mumbai, IndiaMid Level
Responsibilities
- Participate in analysis, design, planning, development validation, release readiness, deployment, and retrospectives across the Agile development process.
- Design, develop, and maintain automated testing frameworks for enterprise data platforms, data pipelines, APIs, backend services, and data-centric applications.
- Create and execute functional, regression, integration, system, and data validation tests for ETL/ELT workflows, source-to-target mappings, transformations, reconciliations, data quality rules, and business logic.
- Validate ingestion, transformation, storage, APIs, data services, reporting and analytics layers, user interfaces, metadata, and database objects.
- Analyze test results, investigate data defects and root causes, and collaborate with engineering teams to resolve application and data quality issues.
- Improve testing processes, automation frameworks, quality gates, test data management, and enterprise quality engineering practices.
- Prepare status reports and communicate testing progress, coverage, defects, risks, blockers, data quality concerns, release readiness, and quality trends.
- Maintain dashboards and test execution reports using JIRA, Zephyr/TestRail, CI/CD pipelines, or data quality platforms.
Requirements
- 4-7 years of experience in software testing, data testing, data validation, orchestration tools, and automation, including at least 2 years focused on enterprise data platforms, data warehouses or lakehouses, ETL/ELT pipelines, or data-centric applications.
- Strong programming and scripting skills in Python and SQL; C# or another object-oriented language is a plus.
- Hands-on experience with automated testing frameworks such as PyTest, Behave, Robot Framework, Playwright, Selenium, or similar tools.
- Experience testing APIs and services with Postman, RestAssured, Karate, or equivalent automation libraries.
- Experience with CI/CD and version control tools such as Jenkins, TeamCity, GitHub, Azure DevOps, or GitLab.
- Experience with test management and defect tracking tools such as JIRA, Zephyr, or TestRail.
- Advanced SQL skills and experience validating relational databases, data warehouses, cloud data platforms, or data lakes; Snowflake is preferred.
- Experience validating ETL/ELT pipelines, schema changes, data lineage, reconciliation, completeness, accuracy, timeliness, and referential integrity.
- Experience with enterprise data platforms, data engineering, data warehousing, financial services data, sales or marketing data, or analytics applications.
- Strong troubleshooting, analytical, communication, collaboration, organization, and stakeholder-management skills.
- Preferred experience with dbt tests, Fivetran, Soda, ADF, Airflow, Astronomer, Databricks, Snowflake, observability, transformation tools, or performance testing.
- Bachelor's degree in Computer Science, Information Technology, Data Engineering, Data Analytics, or a related field is preferred.
Benefits
- Mumbai, India location in the Goregaon East office.
- EMEA shift schedule from 1:30 pm to 10:30 pm IST.
- Opportunity to collaborate with global teams across multiple geographies and time zones.
- Collaborative and inclusive work environment with opportunities for continuous learning.
Tech Stack
Categories
About Russell Investments
Russell Investments is a global investment solutions and asset management firm that designs multi-asset portfolios, provides OCIO/fiduciary management, and offers consulting and implementation services for institutions, financial advisors, and individual investors. The company operates a fee-based model across managed assets and outsourced investment programs and oversees hundreds of billions in assets for clients worldwide. Founded in 1936 and headquartered in Seattle, it is owned by B Capital and maintains offices across the Americas, EMEA, and APAC.