At least 8 years of IT experience; 5 years specifically in ETL testing.
Proficient in automated testing frameworks and scripting languages.
Strong SQL and big data handling skills using ETL tools.
Mandatory experience with PySpark and AWS services.
Testing experience in cloud environments, especially with S3, Glue, and EMR.
Familiarity with DBT or similar data transformation tools is advantageous.
Excellent communication skills for cross-functional interaction.
Responsibilities
Review and analyze requirements, specifications, and design documents.
Develop and implement test strategies for complex projects.
Estimate, prioritize, and coordinate testing activities effectively.
Create and maintain a robust automation test framework.
Design, develop, and execute automated testing scripts.
Identify, document, and track bugs systematically.
Perform regression testing upon bug resolution.
Benefits
Opportunities for professional development and skill enhancement.
Access to cutting-edge data tools and technologies.
Collaboration with experienced data engineers and developers.
Flexible work environments and potential remote work options.
Full Job Description
SDET Position Summary The SDET is responsible for ensuring the quality and reliability of ETL processes and data integration workflows. This role involves designing and implementing automated tests to validate data transformation and migration, as well as collaborating with data engineers and developers to identify and resolve data quality issues. The ideal candidate will leverage their expertise in ETL testing and data validation to enhance the overall data pipeline performance and integrity Minimum Qualification At least 8 years of IT experience with minimum 5 years of experience in below skills: Tech Skills Proficiency in ETL Testing and developing automation framework & testcases in atleast one scripting language Strong SQL skills, with experience in handling big data using ETL tool Mandatory work experience with PySpark Testing experience in cloud environment S3, SSS, Glue, EMR, Data Catalog, Crawler, SQS, ETL Jobs, Event Bridge Athena, Redshift Spectrum Databases AWS Commands for running the jobs, file process and movements Experience with Test Automation and DevOps practices in ETL and Cloud Systems. Experience with Test Automation and DevOps practices in ETL and Cloud Work experience in a Big Data ecosystem processing data in data lakehouse Familiarity with DBT or similar data transformation tools is a plus Experience providing testing oversight in Agile team Should have excellent business communication to interact with Business teams and cross-functional teams Responsibilities Review requirements, specifications, and technical design documents to understand and feedback Experience in developing and implementing test strategies for complex initiatives Estimate, prioritize, plan and coordinate testing activities Create automation test framework Design, develop and execute automation scripts Identify record document thoroughly and track bugs Strong problem-solving skills troubleshooting and root cause analysis skills Perform thorough regression testing when bugs are resolved Develop and apply testing processes for new and existing features to meet client needs Liaise with cross functional teams to identify system requirements Track quality assurance metrics like defect densities and open defect counts Stay up to date with new testing tools and test strategies requirements Support and guide junior team members
About Virtusa Corporation
Virtusa Corporation is a global provider of digital business strategy, digital engineering, and information technology (IT) services and solutions. The company helps its clients transform their businesses through innovative technology solutions that enable them to improve customer engagement, increase operational efficiency, and drive revenue growth. Virtusa Corporation was founded in 1996 and is headquartered in Southborough, Massachusetts. The company has over 20,000 employees and operates in over 30 countries around the world. Virtusa Corporation is committed to sustainability and has received numerous awards for its environmental and social responsibility initiatives.