ETL Tester

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

Job Description : Software Testing (Only Female)

VirtuBox, the world's premier B2B Cloud-based SaaS solution, empowers businesses to forge unforgettable customer experiences that transcend screens and ignite brand loyalty i.e. VirtuBox is Transforming Customer Journeys, One Pixel at a Time.

Job Summary :

We are seeking a proactive and detail-oriented Software Tester with 1–2 years of experience in manual and/or automation testing. The ideal candidate will work closely with developers and product teams to ensure high-quality software delivery by identifying bugs, writing test cases, and executing comprehensive test cycles.

Key Responsibilities :

• Analyze software requirements and design test cases to ensure functionality and performance.
• Identify, document, and track defects using bug-tracking tools.
• Collaborate with developers and stakeholders to resolve issues and improve software quality.
• Perform functional, regression, system, and performance testing.
• Execute automated testing using tools like Selenium, JMeter, or Appium.
• Participate in agile development processes, including stand-up meetings and sprint planning.
• Prepare detailed test reports and documentation for stakeholders.
• Conduct security and usability testing to ensure compliance with industry standards.
• Manage test data to create realistic testing scenarios.
• Validate bug fixes and ensure all functionalities work correctly before release.

Skill Required :

1. Soft Skills 

• Strong analytical and problem-solving skills.
• Good communication and teamwork abilities.
• Attention to detail and ability to work under deadlines.

1. Technical skills

• Knowledge of manual testing and automated testing tools (Selenium, JMeter, Appium, etc.).
• Understanding of SDLC (Software Development Life Cycle) and STLC (Software Testing Life Cycle).
• Familiarity with defect tracking tools (JIRA, Bugzilla, etc.).
• Basic programming knowledge (Python, Java, SQL) is a plus.

Eligibility Criteria :

• Bachelor’s degree in Computer Science, IT, or related field.
• 1–2 years of hands-on experience in software testing.
• Excellent analytical and communication skills.
• ISTQB certification is desirable but not mandatory.
• Basic knowledge of any scripting or programming language is a plus.
• Strong problem-solving and analytical skills.

• 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 US:
Pingahla was founded by a group of people passionate about making the world a better place by harnessing
the power of Data. We are a data management firm with offices in New York and India.Our mission is to help transform the way companies operate and think about their business. We make it easier
to adopt and stay ahead of the curve in the ever-changing digital landscape. One of our core beliefs is
excellence in everything we do!

JOB DESCRIPTION:
Pingahla is recruiting ETL & BI Test Manager who can build and lead a team, establish infrastructure, processes
and best practices for our Quality Assurance vertical. The candidates are expected to have at least 5+ years of experience with ETL Testing and working in Data Management project testing. Being a growing company, we will be able to provide very good career opportunities and a very attractive remuneration.

JOB ROLE & RESPONSIBILITIES:
• Plans and manages the testing activities;
• Defect Management and Weekly & Monthly Test report Generation;
• Work as a Test Manager to design Test Strategy and approach for DW&BI - (ETL & BI) solution;
• Provide leadership and directions to the team on quality standards and testing best practices;
• Ensured that project deliverables are produced, including, but not limited to: quality assurance plans,
test plans, testing priorities, status reports, user documentation, online help, etc. Managed and
motivated teams to accomplish significant deliverables within tight deadlines.
• Test Data Management; Reviews and approves all test cases prior to execution;
• Coordinates and reviews offshore work efforts for projects and maintenance activities.

REQUIRED SKILLSET:
• Experience in Quality Assurance Management, Program Management, DW - (ETL & BI)
Management
• Minimum 5 years in ETL Testing, at least 2 years in the Team Lead role
• Technical abilities complemented by sound communication skills, user interaction abilities,
requirement gathering and analysis, and skills in data migration and conversion strategies.
• Proficient in test definition, capable of developing test plans and test cases from technical
specifications
• Single handedly looking after complete delivery from testing side.
• Experience working with remote teams, across multiple time zones.
• Must have a strong knowledge of QA processes and methodologies
• Strong UNIX and PERL scripting skills
• Expertise with ETL testing & hands-on with working on ETL tool like Informatica, DataStage
PL/SQL is a plus.
• Excellent problem solving, analytical and technical troubleshooting skills.
• Familiar with Data Management projects.
• Eager to learn, adopt and apply rapidly changing new technologies and methodologies.
• Efficient and effective at approaching and escalating quality issues when appropriate.

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.