ETL Tester

Key Responsibilities:

Extensive experience in validating ETL processes, ensuring accurate data extraction, transformation, and loading across multiple environments.
Proficient in Java programming, with the ability to understand and write Java code when required.
Advanced skills in SQL for data validation, querying databases, and ensuring data consistency and integrity throughout the ETL process.
Expertise in utilizing Unix commands to manage test environments, handle file systems, and execute system-level tasks.
Proficient in creating shell scripts to automate testing processes, enhancing productivity and reducing manual intervention.
Ensuring that data transformations and loads are accurate, with strong attention to identifying and resolving discrepancies in the ETL process.
Focused on automating repetitive tasks and optimizing testing workflows to increase overall testing efficiency.
Write and execute automated test scripts using Java to ensure the quality and functionality of ETL solutions.
Utilize Unix commands and shell scripting to automate repetitive tasks and manage system processes.
Collaborate with cross-functional teams, including data engineers, developers, and business analysts, to ensure the ETL processes meet business requirements.
Ensure that data transformations, integrations, and pipelines are robust, secure, and efficient.
Troubleshoot data discrepancies and perform root cause analysis for failed data loads.
Create comprehensive test cases, execute them, and document test results for all data flows.
Actively participate in the continuous improvement of ETL testing processes and methodologies.
Experience with version control systems (e.g., Git) and integrating testing into CI/CD pipelines.

Tools & Technologies (Good to Have):
Experience with Hadoop ecosystem tools such as HDFS, MapReduce, Hive, and Spark for handling large-scale data processing and storage.
Knowledge of NiFi for automating data flows, transforming data, and integrating different systems seamlessly.
Experience with tools like Postman, SoapUI, or RestAssured to validate REST and SOAP APIs, ensuring correct data exchange and handling of errors.

Apply for this Job

* Required

First Name *

Last Name *

Email *

Phone *

Location (City) *

Locate me

Resume/CV *

Dropbox Google Drive

(File types: pdf, doc, docx, txt, rtf)

How many years of experience do you have in overall? *

Please select

Do you have experience in Python – Pandas, Numpy for developing/designing data-driven systems? *

How many years of experience do you have Data modeling concepts & Data warehouse concepts? *

What is your current location? *

What is your preferred location? *

Please select

Are you currently working? *

Please select

What is your official notice period? If you are serving notice, please mention official last working day. *

How soon you can join us? *

Please select

What is current/ last payroll company name? *

What is your Current CTC and Expected CTC? *

Are you ready to work in Hybrid Mode/ 3 days WFO? *

Please select

LinkedIn Profile Link *

Enter the verification code sent to to confirm you are not a robot, then submit your application.

Security Code *

This application was flagged as potential bot traffic. To resubmit your application, turn off any VPNs, clear the browser's cache and cookies, or try another browser. If you still can't submit it, contact our support team through the help center.