40 Dwh Testing Jobs

ETL Test Automation with expertise in SQL, Azure, Snowflake, and Power BI. Strong in data quality, validation, and testing ETL pipelines using tools like Informatica. Skilled in data warehousing concepts and ensuring accurate, reliable data delivery.

Key Responsibilities: Analyze business requirements and technical specifications to design comprehensive test plans and test cases for ETL processes. Perform data validation, data reconciliation, and data quality checks across source and target systems. Execute manual and automated tests to verify data transformations and loading logic. Identify, document, and track defects using tools like JIRA or Bugzilla. Collaborate with developers, data engineers, and business analysts to resolve issues and improve data quality. Create and maintain test data and test environments. Generate test reports and provide regular updates to stakeholders. Required Skills: Strong experience in ETL testing using tools like Informatica, Talend, SSIS, or DataStage. Proficiency in writing complex SQL queries for data validation and analysis. Experience with data warehousing concepts and data modeling. Familiarity with test management tools (e.g., HP ALM, TestRail). Understanding of Agile/Scrum methodologies. Excellent analytical and problem-solving skills. Preferred Qualifications: Experience with automation tools like Selenium, Python, or Apache Airflow for ETL testing. Knowledge of cloud platforms (AWS, Azure, GCP) and cloud-based data services. Exposure to big data technologies (Hadoop, Spark) is a plus.

Job Title: ETL Tester AWS Ecosystem Experience: 3–4 Years Location: Pune Employment Type: Full-Time Job Summary: We are looking for a skilled ETL Tester with hands-on experience in validating data pipelines and data transformations in an AWS-based ecosystem . The ideal candidate should have a strong background in ETL testing, a solid understanding of data warehousing concepts, and proficiency with tools and services in AWS like S3, Redshift, Glue, Athena, and Lambda. Key Responsibilities: Design and execute ETL test cases for data ingestion, transformation, and loading processes. Perform data validation and reconciliation across source systems, staging, and target layers (e.g., S3, Redshift, RDS). Understand data mappings and business rules; write SQL queries to validate transformation logic. Conduct end-to-end testing including functional, regression, and performance testing of ETL jobs. Work closely with developers, data engineers, and business analysts to identify and troubleshoot defects . Validate data pipelines orchestrated through AWS Glue, Step Functions, and Lambda functions . Utilize Athena and Redshift Spectrum for testing data stored in S3. Collaborate using tools like JIRA, Confluence, Git, and CI/CD pipelines . Prepare detailed test documentation including test plans, test cases, and test summary reports. Required Skills: 3–4 years of experience in ETL/Data Warehouse testing . Strong SQL skills for data validation across large datasets. Working knowledge of AWS services such as S3, Redshift, Glue, Athena, Lambda, CloudWatch. Experience testing batch and streaming data pipelines . Familiarity with Python or PySpark is a plus for data transformation or test automation. Experience in using ETL tools (e.g., Informatica, Talend, or AWS Glue ETL scripts). Knowledge of Agile/Scrum methodology . Understanding of data quality frameworks and test automation practices . Good to Have: Exposure to BI tools like QuickSight, Tableau, or Power BI. Basic understanding of data lake and data lakehouse architectures . Experience in working with JSON, Parquet , and other semi-structured data formats.

The resource should have a strong background in working with cloud platforms, APIs, and data processing. Experience with tools like AWS Glue, Athena, and Databricks will be highly beneficial. AWS Glue Jobs: The QE should have familiarity with AWS Glue jobs for ETL processes. We expect them to validate the successful execution of around Glue jobs, ensuring that transformations and data ingestion tasks are working smoothly without errors. Athena Querying: Experience with querying data using AWS Athena is a must, as the QE will be required to validate queries across multiple datasets. We expect the resource to run and validate Athena queries for data accuracy and integrity. Databricks Testing: The candidate should also have experience with Databricks, particularly in validating data pipelines and transformations within the Databricks environment. The QE will need to test Databricks notebooks or jobs, ensuring data accuracy in the Bronze, Silver, and Gold layers. Boomi integrations

Greetings from Zensar ! We are seeking a ETL Tester with the skillset below : QA professional with 7+ years of experience in manual testing of web applications, ETL processes, and reporting solutions - Power BI. Skilled in validating data pipelines, backend systems, and ensuring data integrity across UI and reports using strong SQL skills. Experienced in Agile/Scrum teams with a focus on high-quality, data-driven application delivery. Key Responsibilities: Design and execute manual test cases for web apps, reports, and data workflows Validate ETL data flows and transformations across staging and target systems Use SQL for backend testing, data reconciliation, and report validation Test Power BI dashboards for accuracy, performance, and data integrity Collaborate with developers, BAs, and data teams to ensure complete test coverage Track defects and support releases using Jira in Agile sprints Skills & Tools: Manual Testing | Web Apps | SQL | ETL Testing | Power BI | Reporting Validation | Jira | Agile/Scrum

Job Title ETL/DWT Test Lead Responsibilities A day in the life of an Infoscion As part of the Infosys delivery team, your primary role would be to interface with the client for quality assurance, issue resolution and ensuring high customer satisfaction. You will understand requirements, create and review designs, validate the architecture and ensure high levels of service offerings to clients in the technology domain. You will participate in project estimation, provide inputs for solution delivery, conduct technical risk planning, perform code reviews and unit test plan reviews. You will lead and guide your teams towards developing optimized high quality code deliverables, continual knowledge management and adherence to the organizational guidelines and processes. You would be a key contributor to building efficient programs/ systems and if you think you fit right in to help our clients navigate their next in their digital transformation journey, this is the place for you!If you think you fit right in to help our clients navigate their next in their digital transformation journey, this is the place for you! Technical and Professional Requirements: Primary skills: Technology->E testing/Datawarehouse Testing Additional Responsibilities: Knowledge of more than one technology Basics of Architecture and Design fundamentals Knowledge of Testing tools Knowledge of agile methodologies Understanding of Project life cycle activities on development and maintenance projects Understanding of one or more Estimation methodologies, Knowledge of Quality processes Basics of business domain to understand the business requirements Analytical abilities, Strong Technical Skills, Good communication skills Good understanding of the technology and domain Ability to demonstrate a sound understanding of software quality assurance principles, SOLID design principles and modelling methods Awareness of latest technologies and trends Excellent problem solving, analytical and debugging skills Educational Requirements BTECH/BE/MTECH/ME/BCA/MCA/BSC/MSC

Test Data management Location - Hyderabad / Pune Expr - 10+ Years Define and implement test strategies and test plans for DWH projects, covering data pipelines, data integrity, and reporting accuracy. Develop and execute comprehensive test cases and SQL queries to validate data accuracy, completeness, and transformation logic. Test ETL workflows for data extraction, transformation, and loading processes, ensuring alignment with business requirements. Perform data validation testing and reconciliation across data sources, staging, and data warehouses. Test and validate BI reports and dashboards built using tools like Tableau, Power BI, and ThoughtSpot, ensuring data correctness, visual accuracy, and performance. Collaborate with BI developers and stakeholders to validate KPIs, data visualizations, and user interface requirements. Perform performance testing for complex BI dashboards, ensuring scalability and optimal query performance. Oversee defect management and issue resolution using tools like Jira or Azure DevOps. Conduct root cause analysis for data issues and collaborate with engineering teams for resolution. Automate data validation processes using scripting tools such as Python or frameworks like dbt to optimize testing efficiency. Generate test reports and metrics, providing updates on testing progress, issues, and resolution status. Drive continuous improvements in QA processes, tools, and techniques to ensure testing scalability and efficiency. Ensure all testing adheres to organizational quality standards and best practices for DWH and BI projects.

Job description Hiring for ETL Testing with experience range 3 years & above Mandatory Skills: ETL Testing , DWH testing Education: BE/B.Tech/MCA/M.Tech/MSc./MS Responsibilities A day in the life of an Infoscion As part of the Infosys consulting team, your primary role would be to actively aid the consulting team in different phases of the project including problem definition, effort estimation, diagnosis, solution generation and design and deployment You will explore the alternatives to the recommended solutions based on research that includes literature surveys, information available in public domains, vendor evaluation information, etc. and build POCs You will create requirement specifications from the business needs, define the to-be-processes and detailed functional designs based on requirements. You will support configuring solution requirements on the products; understand if any issues, diagnose the root-cause of such issues, seek clarifications, and then identify and shortlist solution alternatives You will also contribute to unit-level and organizational initiatives with an objective of providing high quality value adding solutions to customers. If you think you fit right in to help our clients navigate their next in their digital transformation journey, this is the place for you!

About the Role: We are seeking a skilled ETL (Extract, Transform, Load) Tester to join our team. The ETL Tester will be responsible for ensuring the quality of data extraction, transformation, and loading processes within the data warehouse environment. The ideal candidate will have a strong understanding of ETL processes, experience with testing large datasets, and the ability to work closely with development and business intelligence teams to ensure the reliability and accuracy of data. Key Responsibilities: Understanding business requirements and ETL specifications to develop test plans and test cases. Executing test cases to ensure accurate extraction, transformation, and loading of data from source systems to the data warehouse. Verifying data integrity and accuracy throughout the ETL process. Identifying and reporting data quality issues and working with the development team to address them. Collaborating with business analysts, ETL developers, and other team members to ensure comprehensive testing coverage. Participating in cross-functional meetings to provide testing insights and contribute to process improvements. Documenting test results, issues, and resolution steps for future reference. Qualifications: Bachelors degree in Computer Science, Information Systems, or a related field. Proven experience in ETL testing, preferably in the insurance domain. Familiarity with ETL tools such as Informatica, Talend, or SSIS. Strong SQL skills for data validation and verification. Knowledge of data warehousing concepts and methodologies. Understanding of insurance industry processes, data models, and regulatory requirements. Ability to work effectively in a team environment and communicate complex technical concepts clearly.

Job description Hiring for ETL Testing with experience range 3 to 10 years Mandatory Skills: ETL/DWH/Big data testing Education: BE/B.Tech/MCA/M.Tech/MSc./MS Responsibilities A day in the life of an Infoscion As part of the Infosys consulting team, your primary role would be to actively aid the consulting team in different phases of the project including problem definition, effort estimation, diagnosis, solution generation and design and deployment You will explore the alternatives to the recommended solutions based on research that includes literature surveys, information available in public domains, vendor evaluation information, etc. and build POCs You will create requirement specifications from the business needs, define the to-be-processes and detailed functional designs based on requirements. You will support configuring solution requirements on the products; understand if any issues, diagnose the root-cause of such issues, seek clarifications, and then identify and shortlist solution alternatives You will also contribute to unit-level and organizational initiatives with an objective of providing high quality value adding solutions to customers. If you think you fit right in to help our clients navigate their next in their digital transformation journey, this is the place for you!

We are seeking a skilled ETL/DWH Tester to support CXM testing for our insurance sector clients. The candidate will possess strong expertise in ETL testing, SQL, and experience in the insurance domain. Proficiency in Agile, JIRA, and ETL automation.

Job description, Hiring for ETL testing with experience range 3-10 years Mandatory Skills: ETL Testing Location - Bangalore/Hyderabad/Pune/kolkata/Chennai/Bhubaneswar Education: BE/B.Tech/MCA/M.Tech/MSc./MS Responsibilities A day in the life of an Infoscion As part of the Infosys consulting team, your primary role would be to actively aid the consulting team in different phases of the project including problem definition, effort estimation, diagnosis, solution generation and design and deployment You will explore the alternatives to the recommended solutions based on research that includes literature surveys, information available in public domains, vendor evaluation information, etc. and build POCs You will create requirement specifications from the business needs, define the to-be-processes and detailed functional designs based on requirements. You will support configuring solution requirements on the products; understand if any issues, diagnose the root-cause of such issues, seek clarifications, and then identify and shortlist solution alternatives You will also contribute to unit-level and organizational initiatives with an objective of providing high quality value adding solutions to customers. If you think you fit right in to help our clients navigate their next in their digital transformation journey, this is the place for you!

About Client Hiring for One of the Most Prestigious Multinational Corporations! Job Description Job Title : ETL Test lead Required skills and qualifications : ETL testing Data Warehousing SQL Snowflake Python/Pyspark (knowledge) Qualification : Any Graduate or Above Relevant Experience : 7 to 12 Location : Hyderabad/Bangalore/Chennai CTC Range : 20 to 25 LPA (fixed) Notice period : Immediate joiners /Currently serving Mode of Interview : Virtual Mode of Work : Hybrid Gayatri G Staffing analyst - IT recruiter Black and White Business solutions PVT Ltd Bangalore, Karnataka, INDIA gayatri@blackwhite.in I www.blackwhite.in +91 8067432472

Minimum of 5 Years of Experience in Quality Assurance, Database Testing, Data warehouse testing/ETL Testing. Experience with Data Warehouse/Data Marts IS REQUIRED. Experience with any one of the Industry ETL Tools like Informatica, Abinitio, SSIS Financial software testing experience with solid SQL/Database skills ARE REQUIRED, SQL Server, and/or Oracle preferred. Experience in knowledge of industry standard best practices as related to software testing Experience in creating test cases, scripts, use of automated test tools, testing client/server applications. Experience in working with Agile projects. Experience in handling large programs and teams.

Job Description Strong knowledge of SQL and ETL Testing Strong SQL skills- Ability to write and interpret complex SQL queries. Extensive experience in ETL/ Data warehouse backend testing and BI Intelligence reports testing Hands-on experience in identifying issues in complex ETL data processing. Expertise in test management tools and defect tracking tools i.e JIRA Proficient experience of working on SDLC & Agile Methodology Excellent Knowledge of Database Systems Vertica /Oracle/ Teradata Experience in Business Intelligence testing in various reports Using Tableau Strong comprehension, analytical, and problem-solving skills Strong communication skills to put forward their point of view in various connects Desired Candidate Profile 7-12 years of experience in ETL Testing or Data Warehouse Testing (DWH). Strong understanding of complex SQL queries and ability to write efficient code snippets. Proficiency in Bi Testing tools such as Tableau or similar technologies. Experience working on Agile projects using Scrum methodology.

Primary Strong expereince in DW testing Strong Experience in testing ETL jobs Experience in writing test scripts for Java/Python scripts Strong Experience in writing complex SQL queries Strong Understanding of data warehouse concepts and data mart testing; To ensure Date integrity is not compromised Test Case Preparation and Execution Transform complex Business logic into SQL or PL/SQL queries Defect tracking experience (i.e. AzDO, Jira, Rally, etc) Exposure to large data sets and understand Data Quality Framework • Automates applicable test cases for regression testing • Good understanding of software testing methodologies, processes and quality metrics • Performs testing • Programming skills in Java • Identifies defects and work with scrum team on resolution • Experience in Selenium, SoapUI or similar tools or as stated in Program tech stack requirements • Accountable for overall test quality (functional & regression) • Promotes environment of collaboration within the test team • Coordinates test planning and execution (FFT, SIT, CVT; performance tests, load tests, etc.) • Provides reports related to product quality metrics • Provides quality related inputs on go/no-go for every release (incl. promotion to INT, CVT & prod environments) • Attends scrum ceremonies • Updates status in Rally on a daily basis • Ensures test cases cover 100% of new functionality

Role: TSO Exp: Min 2 years Must have Exp in Data Migration Testing (ETL Testing), Manual & Automation, Agile Scrum Methodology and Financial domain experience Salary: Max 5.25 LPA. Location: Chennai/Pune Regards, Vicky 7200396456.

Job description Min 8-10 years of experience on Manual/Automation testing Able to develop automation scripts using keyword based tool Experience in any of the OOPS (JAVA/Python/C# (Atleast one preferred)) Strong understanding of OOPS Concepts

Job description Hiring for ETL/DWT/BigData Testing with experience range 5+ years & above Mandatory Skills: ETL/DWT/BigData Testing Education: BE/B.Tech/MCA/M.Tech/MSc./MS

Job Description: We are looking for an experienced ETL Tester with 35 years of hands-on experience in ETL testing , along with strong proficiency in SQL and Python scripting . The ideal candidate should be well-versed in validating data pipelines, ensuring data quality, and automating test cases for large-scale data processing systems. Key Responsibilities: Perform end-to-end ETL testing to ensure data accuracy and completeness. Write complex SQL queries for data validation and reconciliation. Develop test scripts and automation frameworks using Python . Work closely with data engineers and analysts to understand data requirements. Identify and report defects, and drive them to resolution. Prepare test plans, test cases, and documentation. Key Skills & Experience: 3–5 years of experience in ETL/Data Warehouse testing . Strong SQL skills for writing complex queries and validating datasets. Proficiency in Python for test automation and scripting. Good understanding of ETL tools and data workflows (e.g., Informatica, Talend, or custom pipelines). Familiarity with data quality concepts and best practices. Experience with Agile methodologies and test management tools is a plus.

Job Greeting. We are looking for Tosca Automation Test Engineer (With experience in Database Testing OR ETL OR Writing SQL Queries. We don't have any demand in ETL Testing, and neither we have any demand in Manual Test Role - Tosca Automation Test Engineer (With experience in Database Testing OR ETL OR Writing SQL Queries. Tosca Automation Must have good Experience in Database Testing OR ETL Testing OR Backend Testing OR Must have skills /Mandatory Skills Tosca Automation+ API Testing+ Database Testing Experience Range -3+ Yrs. Location – Pune/Hyderabad /Bangalore /Chennai. Work Mode – Min 2 days are mandatory to work from home. Salary – Experience between 3- 5 Years ( 9-13 LPA), If Experience is more than 7+ Yrs. ( Salary -Up to 15 LPA) -Fixed CTC Point to be remember Pls fill the Candidate Summary Sheet. Not Considering more than 30 days’ notice period. Highlights of this role. It’s a long term role. High Possibility of conversion within 6 Months or After 6 months ( if you perform well). Interview -Total 2 rounds of Interview ( Both Virtual), but one face to face meeting is mandatory @ any location - Pune/Hyderabad /Bangalore /Chennai. Client Company – One of Leading Technology Consulting Payroll Company – One of Leading IT Services & Staffing Company ( This company has a presence in India, UK, Europe , Australia , New Zealand, US, Canada, Singapore, Indonesia, and Middle east. Do not change the subject line or do not create new email while sharing /applying for this position. Pls reply on this email thread only. Role - Tosca Automation Test Engineer ( With experience in Database Testing OR ETL OR Writing SQL Queries. We are seeking a highly skilled and experienced Senior Tosca Automation Test Engineer with a proven track record of designing, developing, and executing robust automation solutions using Tricentis Tosca. The ideal candidate will have extensive experience in end-to-end testing, including a strong emphasis on database validation, API testing, and UI automation, within an Agile/DevOps environment. Required Skills & Qualifications: Bachelor's degree in Computer Science, Engineering, or a related field. 6+ years of progressive experience in software quality assurance, with a strong focus on test automation. Minimum 3-5 years of hands-on experience with Tricentis Tosca for test automation. Strong expertise in database testing, including advanced SQL querying (e.g., joins, subqueries, DML operations, aggregate functions). Proven experience with API testing and automation using Tosca. In-depth understanding of software testing methodologies (Agile, Scrum, Waterfall) and the Software Development Life Cycle (SDLC). Extensive experience in database testing (SQL/NoSQL) to validate data integrity, consistency, and accuracy. Write complex SQL queries (joins, subqueries, aggregate functions) to perform data validation, compare expected vs. actual results, and verify backend data operations. *** Mandatory to share ***Candidate Summary Sheet*** Interested parties can share their resume at (shant@harel-consulting.com) along with below details Your Name – Contact NO – Email ID – Do you have valid passport – Total Experience – Experience in Automation Testing – Experience in Tosca Automation - Experience in database testing – Experience in SQL - Current CTC – Expected CTC – What is your notice period in your current Company- Are you currently working or not- If not working then when you have left your last company – Current location – Preferred Location – It’s a Contract to Hire role, Are you ok with that- Highest Qualification – Current Employer (Payroll Company Name) Previous Employer (Payroll Company Name)- 2nd Previous Employer (Payroll Company Name) – 3rd Previous Employer (Payroll Company Name)- Are you holding any Offer – Are you Expecting any offer - Are you open to consider Contract to Hire role , It’s a C2H Role- PF Deduction is happening in Current Company – PF Deduction happened in 2nd last Employer- PF Deduction happened in 3 last Employer – Latest Photo - If incase you are working with a company whose employee strength is less than 2000 employees, than its mandatory to share UAN Service history. BR Shantpriya Harel Consulting shant@harel-consulting.com 9582718094

Responsibilities: Translate project requirements into effective and comprehensive test cases. Define clear testing objectives that align with overall project goals. Establish the testing scope, prioritizing critical features and functionalities. Document expected deliverables, such as detailed test plans, scripts, and reports. Use dbt to build tests that ensures the ETL process is working as intended Automate the common manual testing done by the QA through creating macros in dbt Build and monitor automated system health checks Collaborate with Enterprise Data Engineers to investigate root cause of issues and suggest resolutions. Orchestrate data testing solutions using airflow Be able to support the team in doing releases Develop and maintain test automation frameworks, integrating them with CI/CD pipelines. Collaborate effectively with developers to implement testing strategies at lower levels, facilitating a "shift left" approach and promoting early defect detection. Take ownership of application quality from requirements gathering through development and testing, ensuring a high standard of product excellence Qualification: Strong SQL and data transformation skills Experience in programming or scripting languages such as Python, C#, Java JavaScript/TypeScript Understanding of ETL/ELT process fundamentals Experience in designing, developing, and maintaining robust and scalable test automation frameworks such as Playwright, Selenium or Cypress Experience in testing of data with tools such as PowerBI, DBT and Snowflake (nice to have) Experience with GitHub Actions or similar platforms for automating and managing test workflows. Technical Skills You are a proactive advocate for "shifting left", aiming to identify and address defects earlier in the development lifecycle. You are passionate about test automation and committed to continuously improving testing processes. You enjoy collaborating with your team members to build solutions which improves the data quality within the data warehouse You have a drive to automate processes that mainly focuses on ensuring data quality and process rigidity You have experience within data engineering. You have experience working with relational databases and investigating root cause of issues. Your SQL and data transformation skills are a key skill of yours You have an understanding of database management systems and scripting.

Greetings from Cognizant!!! We are hiring for Permanent Position with Cognizant. Experience:- 3 - 6 Yrs. Mandatory to have experience in ETL Testing, Mongo DB, Python, SQL, Azure databricks . Work Location: Chennai, Coimbatore Interview Mode : ( Virtual ) Interview Date : Weekday & Weekend

Job description Hiring for ETL/DWT/BigData Testing with experience range 3-10 years & above Mandatory Skills: ETL/DWT/BigData Testing Education: BE/B.Tech/MCA/M.Tech/MSc./MS

The ETL Tester role involves working with relevant technologies, ensuring smooth operations, and contributing to business objectives. Responsibilities include analysis, development, implementation, and troubleshooting within the ETL Tester domain.