Job Title: ETL QA Analyst
Location: San Mateo CA (Onsite)

Visa: USC, GC, AND H4 EAD



Must Have: AWS,S3, RDS, Snowflake , GitHub, Glue, and Amazon Aurora



Key Responsibilities:

• Design, develop, and execute detailed test plans, test cases, and test scripts for validating ETL processes and data pipelines.
• Verify the integration and functionality of AWS Glue, Amazon Aurora, and Snowflake Cloud in ETL workflows.
• Test data extraction, transformation, and loading (ETL) processes across AWS S3, Snowflake Cloud, and RDS for accuracy, completeness, and performance.
• Perform detailed data validation and reconciliation at various stages of ETL workflows to ensure high-quality data delivery.
• Collaborate with data engineers, developers, and business stakeholders to understand requirements and mitigate risks.
• Utilize Rally for agile project management, issue tracking, and documentation.
• Leverage GitHub for version control, collaboration, and test script management.
• Conduct regression testing and assist in the automation of test cases to improve efficiency.
• Adhere to data security and compliance standards throughout the testing lifecycle.

Required Skills:

• Strong understanding of ETL testing principles, methodologies, and best practices.
• Hands-on experience with AWS services, including S3, Glue, RDS, and Amazon Aurora.
• Proficiency in Snowflake Cloud, including expertise in SQL for querying and data validation.
• Familiarity with Rally for agile project tracking and management.
• Experience with GitHub for version control and collaboration.
• Advanced SQL skills, including writing and optimizing complex queries.
• Strong analytical and problem-solving skills with exceptional attention to detail.