ETL Tester

Job Description

3-5 years of hands-on experience in manual testing involving functional, non-functional, regression, and integration testing in a structured environment.

Candidate should have exceptional communication skills.

Should have minimum 1 year work experience in data comparison testing.

Experience in testing web-based applications.

Able to define the scope of testing.

Experience in testing large-scale solutions integrating multiple source and target systems.

Experience in API testing.

Experience in Database verification using SQL queries.

Experience working in an Agile team.

Should be able to attend Agile ceremonies in UK hours.

Having a good understanding of Data Migration projects will be a plus.

🚀 Hiring: QA Engineer (Manual + Automation)

⭐ Experience: 3+ Years

📍 Location: Bangalore

⭐ Work Mode:- Hybrid

⏱️ Notice Period: Immediate Joiners

(Only immediate joiners & candidates serving notice period)

💫 About the Role:

We’re looking for a skilled QA Engineer You’ll ensure product quality through manual and automated testing across web, mobile, and APIs — working with tools and technologies like Postman, Playwright, Appium, Rest Assured, GCP/AWS, and React/Next.js.

Key Responsibilities:

✅ Develop & maintain automated tests using Cucumber, Playwright, Pytest, etc.

✅ Perform API testing using Postman.

✅ Work on cloud platforms (GCP/AWS) and CI/CD (Jenkins).

✅ Test web & mobile apps (Appium, BrowserStack, LambdaTest).

✅ Collaborate with developers to ensure seamless releases.

Must-Have Skills:

✅ API Testing (Postman)

✅ Cloud (GCP / AWS)

✅ Frontend understanding (React / Next.js)

✅ Strong SQL & Git skills

✅ Familiarity with OpenAI APIs

Manual Tester with Crew Domain Knowledge

Skill Set/Experience

1.   •       Experience: 5–12 Years

2.   •       Locations: Chennai, Bangalore, Trivandrum, Cochin

3.   •       Notice Period: Immediate to <30 days

1. Very good understanding of airline Crew and Ops business processes
2. Experience in UAT and SIT testing including on-site customer interactions (added advantage).
3. Strong business/testing skills – Use case review, Test case creation (Interface, Functional and UAT and End to End ) , review and execution
4. Basic knowledge of SQL, UNIX
5. Experience in API/Interfaces testing
6. Experience with any of the defect tracking systems.
7. Exposure in using selenium Test Automation tool is added advantage

As a Data Quality Engineer at PalTech, you will be responsible for designing and executing comprehensive test strategies for end-to-end data validation. Your role will ensure data completeness, accuracy, and integrity across ETL processes, data warehouses, and reporting environments. You will automate data validation using Python, validate fact and dimension tables, large datasets, file ingestions, and data exports, while ensuring adherence to data security standards, including encryption and authorization. This role requires strong analytical abilities, proficiency in SQL and Python, and the capability to collaborate effectively with cross-functional teams to drive continuous improvements through automation and best practices.

Key Responsibilities

• Create test strategies, test plans, business scenarios, and data validation scripts for end-to-end data validation.
• Verify data completeness, accuracy, and integrity throughout ETL processes, data pipelines, and reports.
• Evaluate and monitor the performance of ETL jobs to ensure adherence to defined SLAs.
• Automate data testing processes using Python or other relevant technologies.
• Validate various types of fact and dimension tables within data warehouse environments.
• Apply strong data warehousing (DWH) skills to ensure accurate data modeling and validation.
• Validate large datasets and ensure accuracy across relational databases.
• Validate file ingestions and data exports across different data sources.
• Assess and validate implementation of data security standards (encryption, authorization, anonymization).
• Demonstrate proficiency in SQL, Python, and ETL/ELT validation techniques.
• Validate reports and dashboards built on Power BI, Tableau, or similar platforms.
• Write complex scripts to validate business logic and KPIs across datasets.
• Create test data as required based on business use cases and scenarios.
• Identify, validate, and test corner business cases and edge scenarios.
• Prepare comprehensive test documentation including test cases, test results, and test summary reports.
• Collaborate closely with developers, business analysts, data architects, and other stakeholders.
• Recommend enhancements and implement best practices to strengthen and streamline testing processes.

Required Skills and Qualifications

• Education: Bachelor’s degree in Computer Science, Information Technology, or a related discipline.
• Technical Expertise: Strong understanding of ETL processes, data warehousing concepts, SQL, and Python.
• Experience: 4–6 years of experience in ETL testing, data validation, and report/dashboard validation; prior experience in automating data validation processes.
• Tools: Hands-on experience with ETL tools such as ADF, DBT, etc., defect tracking systems like JIRA, and reporting platforms such as Power BI or Tableau.
• Soft Skills: Excellent communication and teamwork abilities, with strong analytical and problem-solving skills.

Why Join PalTech?

• Great Place to Work Certified: We prioritize employee well-being and nurture an inclusive, collaborative environment where everyone can thrive.
• Competitive compensation, strong learning and professional g

Skills Required -

• No handholding
• Logical thinking (scenario)
• API testing (POSTMAN)
• Database SQL (think of null & able to write join query)
• Why & when regression and different types of testing
• Able to write test case
• Web testing

• Reviews design specifications to understand the scope, requirements, and function of the software product.
• Preparation of test data and execution of test cases (including functional, system, regression, performance, API and database layer etc.)
• Identifies appropriate processes, parameters, functions, and data to test and validate; parameters may include general function, the validity of results, accuracy, reliability, and compliance with industry standards.
• Lead and participate in test case reviews with Business, Developers, other team members
• Estimate, prioritize, plan and coordinate testing activities
• Ensure that user expectations are met during the testing process
• Design, develop and execute automation scripts using open source tools
• When a product does not perform within specifications, reporting defects to programmers while identifying and recommending solutions, improvements, and updates.
• Identifies, logs, and recreates error codes, bugs, and defects.
• Draft quality assurance policies and procedures
• Investigate production issues
• Conducts testing to ensure products perform according to product requirements and within established guidelines.

About the Role

We are looking for a Quality Assurance (QA) engineer to develop and execute exploratory and automated tests to ensure product quality. QA engineer responsibilities include designing and implementing tests, debugging, and defining corrective actions. You will also review system requirements and track quality assurance metrics (e.g. defect densities and open defect counts.)

Responsibilities

Excellent command of Manual Testing and Automation Testing (Any tool).

Good knowledge of UI automation using Selenium or equivalent

Good knowledge in writing advanced SQL queries and data validation techniques Solid knowledge of SDLC and STLC concepts, Functional Testing

Fundamentals Good Experience of working in an Agile environment

and Expected skillset (Good to have)

Experience working with defect management tools like JIRA Well versed with all types of testing artifacts.

What you need to have: 

A Software Testing Engineer is required to fully test the product or system to ensure it functions properly and meets the business needs. The job responsibilities include:

Role and Responsibilities

• Responsible for creating and executing tests to verify that software runs properly and without defects on each platform requested and to handle test procedures efficiently to result in extreme product stability, product usability and performance.
• Responsible for creating test plans and test cases.
• Understanding how a feature is implemented to develop test cases for the functionality, performance, stress, and fault conditions.
• Responsible for reviewing and analyzing project documentation to ensure product testability.
• Responsible for providing detailed testing status.

Skills  Required: 

• Should have experience in creating Test Plans, Test scripts, Test cases.
•  Knowledge in Selenium web drivers is mandatory. They should be able to write the scripts and run them in Selenium.
• Should have good experience in SQL databases.
• Good knowledge on System and Integration Test Cases.
• Good knowledge on System and Integration Testing.
• Able to write Test Scenarios.
• Able to Test the application independently.
• Hands on experience in UI testing 

Qualifications:

• B.Tech (Computer Science)