ETL Data Quality Tester

Diverse Lynx, LLC

  • NY
  • 3 days ago
  • Remote
  • $43 Per Hour
Want to know if you’re a fit?
Upload your resume and let our AI show you.

Skills

  • Access Controlunmatched
  • Bug Tracking/Defect Managementunmatched
  • Business Processesunmatched
  • Data Mappingunmatched
  • Data Qualityunmatched
  • Data Setsunmatched
  • Database Extract Transform and Load (ETL)unmatched
  • Functional Testingunmatched
  • Performance Analysisunmatched
  • Performance Testingunmatched
  • Problem Solving Skillsunmatched
  • Process Developmentunmatched
  • Python Programming/Scripting Languageunmatched
  • Query Analysisunmatched
  • Regression Testingunmatched
  • SQL (Structured Query Language)unmatched
  • Scripting (Scripting Languages)unmatched
  • Security Complianceunmatched
  • Snowflake Schemaunmatched
  • Stored Proceduresunmatched
  • Test Dataunmatched
  • Testingunmatched
  • Warehousingunmatched

Description

Role: ETL Data Quality Tester

Location: Remote

Duration: 6-12 months

Experience: 8+ Year

Rate: $43/hr/hr(C2C) or $42/hr(W2)

Role Descriptions:

  • Validate Source-to-Target Data Mapping Ensure data is accurately loaded from source systems into Snowflake tables according to business requirements.
  • Perform ETL/ELT Testing Verify data extraction| transformation| and loading processes to ensure correct data movement and transformation.
  • Execute Data Quality Testing- Validate completeness| accuracy| consistency| uniqueness| and integrity of data stored in Snowflake.
  • Develop and Run SQL Validation Queries Create complex SQL queries to compare source and target data| identify discrepancies| and verify business rules.
  • Test Snowflake Objects Validate databases| schemas| tables| views| materialized views| stages| streams| tasks| and stored procedures.
  • Perform Regression and Functional Testing Ensure new changes do not impact existing functionalities and validate end-to-end business processes.
  • Conduct Performance Testing Analyze query execution performance| warehouse utilization| and data load efficiency for large datasets.
  • Validate Security and Access Controls Test role-based access control (RBAC)| user permissions| data masking policies| and security compliance.
  • Automate Data Validation Processes Develop automation scripts using Python| or testing frameworks to improve testing efficiency and coverage.

Defect Tracking and Reporting Identify| document| track| and retest defects while collaborating with developers and data engineers to resolve issues

Diverse Lynx LLC is an Equal Employment Opportunity employer. All qualified applicants will receive due consideration for employment without any discrimination. All applicants will be evaluated solely on the basis of their ability, competence and their proven capability to perform the functions outlined in the corresponding role. We promote and support a diverse workforce across all levels in the company.

Numbers & Facts

LocationNY (
Remote
)

Similar Jobs