Senior Etl Test Engineer
- Criticalriver
- 4 - 7 years
- Hyderabad
- 3 months ago
- Email to a friend
- Report this job
Job Description
Job Title - Sr ETL Tester
Shift Timings - 3 PM to 12 AM
Years of Exp - 4 to 7 years
Job Profile (Brief description) -
We are seeking a detail-oriented and technically skilled ETL / Fivetran Data Pipeline Tester to validate and ensure data accuracy, integrity, and performance across modern data pipelines. The role will focus on testing integrations involving Fivetran connectors and Snowflake data warehouse, ensuring end-to-end data consistency from source systems to reporting layers.
Skill Set -
- Strong command over SQL (joins, aggregates, window functions)
- Familiarity with data quality validation, data profiling, and data integrity checks
- Hands-on experience with Fivetran connectors and understanding of CDC/incremental syncs
Role & responsibilities
- Validate data pipelines built using Fivetran for various source systems (e.g.,NetSuite, Excel, Salesforce, S3, Navan, etc).
- Conduct end-to-end data validation from source to Snowflake, including schema, data type, and row-level validations.
- Perform incremental load testing, CDC validation, and schema drift assessments.
- Write and execute complex SQL queries for data comparison and transformation validation in Snowflake.
- Collaborate with developers, data engineers, and business analysts to understand requirements and test cases.
- Monitor and troubleshoot issues in Fivetran connector syncs using logs and dashboard insights.
- Validate data transformation logic using dbt or other transformation frameworks (if required).
Document test cases, test results, and defect reports using tools like JIRA, Azure DevOps
Preferred candidate profile
- 4 to 7 years of ETL/data warehouse testing experience
- Hands-on experience with Fivetran connectors and understanding of CDC/incremental syncs
- Strong command over SQL (joins, aggregates, window functions)
- Experience with Snowflake or similar cloud data warehouse platforms
- Experience with API testing (for Fivetran APIs or downstream apps)
- Familiarity with data quality validation, data profiling, and data integrity checks
- Understanding of ELT pipelines, schema mapping, and data transformation rules
- Experience with defect management and test documentation tools
Familiarity with BI tools (e.g., Tableau, Power BI) for validating reporting layer data
Job Classification
Industry: IT Services & ConsultingFunctional Area / Department: Engineering - Software & QARole Category: DBA / Data warehousingRole: DBA / Data warehousing - OtherEmployement Type: Full timeContact Details:
Company: CriticalriverLocation(s): Hyderabad
Keyskills: Data Warehouse Testing SQL Queries ETL Testing Big Data Testing Snowflake Informatica Testing DWH Testing
Similar positions
Criticalriver
About CriticalRiver: Critical River Inc is a technology services organization focused on design and implementation of Oracle and SaaS based solutions. In addition, we have a strong strategic staffing practice. One thing that differentiates us from our peers is that the founders of the firm and m...
Job Listings
We are in open beta version of website, please let us know if any issues, at: info(at)indigojobs.in