Likeremote

Subscribe to the latest remote jobs:

  • Likeremote jobs on https://LinkedIn.com/
  • Likeremote jobs on https://telegram.org/
  • Likeremote jobs on Reddit.com
DL

ETL Testing

Diverse Lynx India
  • ๐Ÿ‡ฎ๐Ÿ‡ณ India
  • On-site
  • Senior
  • 1 day ago
  • ETL
  • SQL
  • Oracle
  • Python
  • PySpark
  • Agile
  • Scrum
  • Data Architecture
  • Integration Testing
Not scoredNo CV on file. Upload one and this job gets a score out of 100.Upload CV
Primary skills.

Primary Skill- Testing along with development exp required

ETL / Data Warehouse Testing with Strong SQL

Key secondary skills

  1. ETL/DW Testing & Data Validation โ€“ Batch, incremental loads, CDC, historical conversions
  2. Advanced SQL โ€“ Complex queries, stored procedures, reconciliation and backend validation
  3. ETL Development โ€“ Minimum 3 years development background
  4. Oracle Autonomous Data Warehouse (ADW)
  5. BI/Reporting Validation
  6. Python & PySpark
  7. Shell Scripting & Batch Monitoring
  8. Data Lineage & Data Mapping
  9. SIT/UAT/Regression Testing
  10. Agile/Scrum
Job Description


Role Summary
Reliance Matrix (RSL) is seeking an experienced Senior ETL QA Engineer with a background in ETL development to establish an end-to-end QA governance model. The ideal candidate possesses a deep understanding of data architecture, end-to-end data flows (from ETL pipelines to BI reports), and large-scale enterprise data validation. In this role, you will collaborate closely with developers and business analysts to reverse-engineer system architectures and create essential baseline QA documentation, includingdata mapping sheets anddata lineage diagrams.
Key Responsibilities
- Test Strategy & Execution: Design and execute comprehensive test strategies for ETL pipelines, Data Warehouses (EDW/ADW), Data Lakes, and reporting systems.
- Data Validation: Validate batch processing, incremental loads, Change Data Capture (CDC), and historical data conversions.
- Database & Layer Testing: Perform backend database testing using complexSQL queries and stored procedures to validate staging tables, dimensions, facts, aggregate tables, and reporting layers.
- Transformation & Analytics Logic: Validate complex transformation logic, business rules, and reporting accuracy between the data warehouse and business intelligence systems.
-Cross-Functional Collaboration: Partner with ETL developers, data engineers, business analysts, and product owners to ensure data integrity.
- Lifecycle Support: DriveSystem Integration Testing (SIT),User Acceptance Testing (UAT),regression testing,release validation, andpost-deployment verification.
Required Qualifications
- Testing Experience: Minimum 7+ years of experience in ETL /Data Warehouse testing.
- Development Experience: Minimum 3 years of experience as an ETL / DW developer.
- BI Validation: Minimum 2+ years of experience in Business Intelligence (BI) and reporting validation or development.
- Database Expertise: StrongSQL expertise with large-scale enterprise databases, including hands-on experience withOracle Autonomous Data Warehouse (ADW).
- Technical Skills: Proficiency withSQL Developer,CloudBerry,Python, andPySpark.
- Operations & Scripting: Practical experience withShell Scripting,server log analysis,batch monitoring, andtroubleshooting.
- Methodology: Proven experience working inAgile/Scrum environments.

ETL Testing ยท Diverse Lynx India

Auto apply with Likeremote