10/11/2026 updated
100 % available
ETL Tester | Data Validation Specialist | Big Data & Kafka Testing
hyderabad, India
Only remote
BTECHSql Data WarehouseApache AirflowAcceptance Test-Driven DevelopmentAutomatic Test EquipmentTest AutomationAutomated Testing FrameworkData AuditingData ValidationDatabase TestingLinuxApache HadoopApache HiveE2e TestingBacktestingData Driven Tests
ETL Testing & Data Validation
Expertise in source-to-target validation, data integrity and quality checks, DDL/CDC validations, and duplicate validation across multiple ETL cycles using tools like Informatica PowerCenter and IDMC.
Big Data & Kafka Testing
Hands-on experience with Hadoop and Kafka-based data ingestion pipelines, including producer/consumer workflows, partitioning, offset management, and DB-to-UI testing via Control Center and BFW.
SQL & Database Scripting
Proficiency in writing and executing complex SQL queries for data validation using Oracle databases, ensuring accurate end-to-end data flow and transformation logic verification.
Scheduling Tools
Experience with Autosys and Cascade schedulers for executing and monitoring ETL jobs, including Near Real-Time, End-of-Day, and Box job types within automated ETL workflows.
Agile Tools & Methodology
Active participation in Agile ceremonies including Sprint Planning, Retrospectives, Iteration Reviews, and Backlog Refinement, with use of Jira, qTest, and Octane for test tracking and defect management.
Programming & Scripting
Working knowledge of Python and Linux for scripting and automation tasks within data engineering and testing environments.
Other Tools
Familiarity with Bitbucket for version control, PuTTY for remote server access and log review, and Toad for Oracle database management.
Regression & Functional Testing
Execution of Integration, Functional, Regression, System, Sanity, and UAT testing, including regression testing via the RAFT framework in cross-functional team environments.
Expertise in source-to-target validation, data integrity and quality checks, DDL/CDC validations, and duplicate validation across multiple ETL cycles using tools like Informatica PowerCenter and IDMC.
Big Data & Kafka Testing
Hands-on experience with Hadoop and Kafka-based data ingestion pipelines, including producer/consumer workflows, partitioning, offset management, and DB-to-UI testing via Control Center and BFW.
SQL & Database Scripting
Proficiency in writing and executing complex SQL queries for data validation using Oracle databases, ensuring accurate end-to-end data flow and transformation logic verification.
Scheduling Tools
Experience with Autosys and Cascade schedulers for executing and monitoring ETL jobs, including Near Real-Time, End-of-Day, and Box job types within automated ETL workflows.
Agile Tools & Methodology
Active participation in Agile ceremonies including Sprint Planning, Retrospectives, Iteration Reviews, and Backlog Refinement, with use of Jira, qTest, and Octane for test tracking and defect management.
Programming & Scripting
Working knowledge of Python and Linux for scripting and automation tasks within data engineering and testing environments.
Other Tools
Familiarity with Bitbucket for version control, PuTTY for remote server access and log review, and Toad for Oracle database management.
Regression & Functional Testing
Execution of Integration, Functional, Regression, System, Sanity, and UAT testing, including regression testing via the RAFT framework in cross-functional team environments.
Experience
Professional experience0 - 5 years
Freelancer since2026
Languages
EnglishFluent
Project history
Prepared and executed complex SQL queries to verify data integrity between source and target databases across ETL pipelines. Analyzed Source-to-Target mapping documents, validated file-based systems, performed data integrity, DDL, CDC, and duplicate validations. Conducted Kafka testing for data ingestion pipelines, performed DB-to-UI testing via Control Center, coordinated with upstream teams for test data, executed Integration, Functional, Regression, System, Sanity, and UAT testing, and mentored new team members on ETL applications and Agile processes.
Executed and monitored Hadoop and Informatica ETL jobs using the Autosys scheduler and reviewed execution logs via PuTTY. Participated in Agile ceremonies, documented and tracked test results in JIRA, analyzed business and technical requirements to design ETL test cases, and tested Autosys job types including NRT, EOD, and Box jobs within automated ETL workflows.