8+ years of IT experience, with 5+ years in ETL testing and automation.
Proficient in developing automation frameworks and test cases using at least one scripting language.
Strong SQL skills and experience with big data ETL tools like Informatica.
Mandatory experience with PySpark and cloud testing (AWS).
Familiarity with AWS services such as S3, Glue, EMR, and Data Catalog.
Experience in a Big Data ecosystem and data lakehouse processing.
Excellent communication skills for cross-functional collaboration.
Responsibilities
Review requirements and technical documents to provide feedback.
Develop and implement test strategies for complex projects.
Estimate, prioritize, and coordinate testing activities effectively.
Create and maintain automation test frameworks.
Design, develop, and execute automation scripts for testing.
Identify, document, and track bugs thoroughly.
Conduct regression testing to ensure bug fixes are effective.
Develop testing processes for new and existing features to meet client needs.
Benefits
Collaborative work environment with cross-functional teams.
Opportunity to work with cutting-edge ETL and cloud technologies.
Focus on professional development and skill enhancement.
Engagement in Agile methodologies for dynamic project management.
Full Job Description
SDET Position Summary: The SDET (Software Development Engineer in Test) 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 tools (e.g., Informatica). • Mandatory work experience with PySpark • Testing experience in cloud environment (AWS) • 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 (Data Build Tool) 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.
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.
