ETL QA Analyst Job at qsourcegroupinc, San Mateo, CA

c3lOdm5xSUxWRjFWRGtVZlNQeE9KaE5XTVE9PQ==
  • qsourcegroupinc
  • San Mateo, CA

Job Description

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.

Job Tags

Similar Jobs

GreenState Credit Union

Licensed Insurance Representative Job at GreenState Credit Union

 ...POSITION SUMMARY: The Licensed Insurance Representative (LIR) works closely with the Senior Account Managers (SAM), Account Managers (AM), Licensed Insurance Agents (LIA) and Producers. The primary duties of the LIR include accurate, timely and professional service... 

The LiRo Group

Construction Superintendent Job at The LiRo Group

We have an immediate need for a Construction Superintendent in Rockland County, NY. Come join our team! We are looking to build services and capabilities through the growth of our key asset- our staff. Ranked among the nation's top A/E firms by Engineering News...

BayMark Health Services

Per Diem Dispensing Nurse - LPN/LVN Job at BayMark Health Services

 ...Description Per Diem (PRN) Dispensing Nurse LPN/LVN HCRC (Health Care Resource Centers) is looking for a detail oriented and empathetic Licensed Practical Nurse / Licensed Vocational Nurse to dispense prescribed medications as part of a treatment team in... 

Pool World

Entry Level Hot Tub Delivery Technician Job at Pool World

Pool World,is a family-owned, local company that has been around for over 45 years! Because of our commitment to doing things right for our customers and employees, Pool World has grown to become the largest pool and spa business in the Inland Northwest. We have 4 stores...

City National Bank

KYC Review Analyst- Ops Job at City National Bank

Overview: KYC REVIEW ANALYST- OPS WHAT IS THE OPPORTUNITY? Conduct Enhanced Due Diligence background investigations for commercial...  ..., risk management or related function and two years of BSA/AML experience ~2 years experience using Microsoft Office Skills...