Software Engineer in Test
VistalTech IncAbout the role
Job Description: The SDET is responsible for ensuring the qualityand 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.
Proficiency in ETL Testing and developing automation framework &testcases in at least 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, 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.
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.
Responsibilities
- Review requirements, specifications, and technical design documents to understand and provide feedback
- Develop and implement test strategies for complex initiatives
- Estimate, prioritize, plan and coordinate testing activities
- Create automation test framework and execute automation scripts
- Perform thorough regression testing when bugs are resolved
- Develop and apply testing processes for new and existing features
- Liaise with cross-functional teams to identify system requirements
- Track quality assurance metrics
Qualifications
- At least 8 years of IT experience
- Minimum 5 years of experience in ETL Testing and automation framework development
- Strong SQL skills and experience with big data using ETL tools
- Mandatory work experience with PySpark
- Experience in cloud environments like S3, Glue, EMR
- Familiarity with DBT or similar data transformation tools is a plus
- Excellent business communication skills
Skills mentioned
About VistalTech Inc
Vistal Tech is a leading provider of technology solutions and services specialized in Web Development, Mobile App Development, Cloud Platforms and Software Development. We also help companies address risks associated with their information systems by offering Data Quality and regulatory compliance solutions. We also provide a variety of enterprise workforce solutions like Contingent Workforce, Full-time / Permanent staffing, and Recruiting Process Outsourcing (RPO) services to diverse businesses.