Job Title: ETL QA Analyst

Location: San Mateo CA (Onsite)

Visa: USC, GC, AND H4 EAD

Preferred: 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.

QSource Group Inc. jobs

QSource Group Inc. | ETL QA Analyst