86 Dwh Testing Jobs - Page 2

Must have 6+ years of experience in Testing (ETL Testing) Must have experience In Snowflake, Azure Cloud and DWH Must have good experience in SQL queries Analyze and understand the Business requirements and ability to convert that to test cases of functional and non-functional components Identification, Preparation, documentation and execution of Smoke, functional, non-functional, Automation Regression and E2E test cases Experience of working in agile teams, where to collaborate with PO, developers, and testers Adaptive team player who can be flexible to work on an aggressive timeline as an Individual contributor and as well as with the team Good communication in articulating the defects clearly documenting the required evidence in JIRA and to re-test the issues until closure Experience with JIRA/XRAY Experience in Securities & Capital Market domain is preferred Excellent Communication Skills

This role is on contract basis for 1 year, extendible and convertible based on performance. Please apply only if interested. Description: Spend and Third Party Management Technology supports the Global Supplier Services business which is responsible for the Firm's sourcing, contracts, procurement, invoicing, and third part risk functions. The goal of Spend Mgmt Technology team is to provide effective and integrated end-to-end solutions. The position carries the following responsibilities:-ETL testing for validating the data sources, extraction of data, applying transformation logic, and loading the data qualifying information while restricting duplicate records and data loss.-Review use stories and ensure requirements are understood. -Works with product owners and business analysts to ensure acceptance criteria accurately captures all use cases and provide feedback where needed.-Create detailed, comprehensive, and well-structured test plans and test cases.-Estimate all testing activities and prioritize and coordinate all required activities-Performs QA testing to determine completeness of requirements.-Implement automation wherever possible -Log all defects in a timely fashion with detailed descriptions and steps to reproduce the bug.-Perform regression testing and keep regression scripts up to date.-Track metrics such as open defect counts-Attend and actively participate in all agile ceremonies. Skills Needed: 5+ years experience in development and or software quality assurance-Strong SQL skillset Proficient in understanding the Data Models writing complex SQL queries and joins Experience in Automation and Dev Ops a plus-Strong knowledge of QA methodologies, tools, and processes. Experience with writing clear, concise, and comprehensive test plans and test cases Experience working in an Agile/Scrum development process Good written and oral communication skills Very strong attention to detail and organizational skills. Strong work ethic. Ability to multi-task and remain flexible in fast paced environment. Results-orientation. takes initiative to identify areas to add value and executes quickly Hands on current experience with unix scripting Familiar with BDD testing framework Degree in Computer Science preferred

Role Purpose The purpose of the role is to support process delivery by ensuring daily performance of the Production Specialists, resolve technical escalations and develop technical capability within the Production Specialists. Do Oversee and support process by reviewing daily transactions on performance parameters Review performance dashboard and the scores for the team Support the team in improving performance parameters by providing technical support and process guidance Record, track, and document all queries received, problem-solving steps taken and total successful and unsuccessful resolutions Ensure standard processes and procedures are followed to resolve all client queries Resolve client queries as per the SLAs defined in the contract Develop understanding of process/ product for the team members to facilitate better client interaction and troubleshooting Document and analyze call logs to spot most occurring trends to prevent future problems Identify red flags and escalate serious client issues to Team leader in cases of untimely resolution Ensure all product information and disclosures are given to clients before and after the call/email requests Avoids legal challenges by monitoring compliance with service agreements Handle technical escalations through effective diagnosis and troubleshooting of client queries Manage and resolve technical roadblocks/ escalations as per SLA and quality requirements If unable to resolve the issues, timely escalate the issues to TA & SES Provide product support and resolution to clients by performing a question diagnosis while guiding users through step-by-step solutions Troubleshoot all client queries in a user-friendly, courteous and professional manner Offer alternative solutions to clients (where appropriate) with the objective of retaining customers and clients business Organize ideas and effectively communicate oral messages appropriate to listeners and situations Follow up and make scheduled call backs to customers to record feedback and ensure compliance to contract SLAs Build people capability to ensure operational excellence and maintain superior customer service levels of the existing account/client Mentor and guide Production Specialists on improving technical knowledge Collate trainings to be conducted as triage to bridge the skill gaps identified through interviews with the Production Specialist Develop and conduct trainings (Triages) within products for production specialist as per target Inform client about the triages being conducted Undertake product trainings to stay current with product features, changes and updates Enroll in product specific and any other trainings per client requirements/recommendations Identify and document most common problems and recommend appropriate resolutions to the team Update job knowledge by participating in self learning opportunities and maintaining personal networks Mandatory Skills: Big Data Testing Experience: 5-8 Years

Key Responsibilities Design and execute detailed test plans, test cases, and scripts for ETL workflows.Kaplan Community Career Center+4Expertia+4Virtusa+4 Validate data accuracy, completeness, consistency, and transformation logic from source to target.Virtusa Perform functional, integration, regression, and performance testing for ETL processes.Expertia+15Virtusa+15Virtusa+15 Identify, document, track, and retest defects; work with data engineers to resolve data-quality issues.Reddit+14Virtusa+14Kaplan Community Career Center+14 Analyze test results, conduct root-cause analysis, and communicate findings to stakeholders. Develop and maintain automation scripts or frameworks (using Python, Shell, or tool-specific languages) to streamline ETL testing.Reddit+15Expertia+15HRBLADE+15 Collaborate in Agile teams, participate in scrum events, and maintain test documentation and reports (e.g., in JIRA, Zephyr, ALM).Himalayas+2EY Careers+2HRBLADE+2 Required Qualifications & Skills Bachelors degree in Computer Science, IT, or similar. 2–8 years of experience in ETL/data integration testing, depending on level.Virtusa Strong proficiency in SQL for writing complex queries and data validation.Virtusa+4Expertia+4Virtusa+4 Experience with ETL tools such as Informatica, Talend, SSIS, DataStage, etc.Virtusa+6HRBLADE+6Himalayas+6 Working knowledge of data warehousing concepts: star/snowflake schemas, data modeling.Reddit+10Expertia+10Himalayas+10 Familiarity with scripting languages (Python, Shell) for automation.Expertia+1Himalayas+1 Experience with test management and defect-tracking tools (JIRA, ALM, Zephyr).EY Careers+1Himalayas+1 Analytical mindset, excellent attention to detail, and strong problem-solving skills.Virtusa+1Virtusa+1 Excellent verbal and written communication skills; ability to work with tech and business stakeholders. Experience in Agile development environments.HRBLADE

Role & responsibilities Expertise in writing ETL test scenarios, test cases, and test scripts. Experience and understanding of test life cycle , defect management life cycle etc. Ensure that test cases cover various ETL scenarios, including data extraction, transformation, and loading. Execution of ETL test cases and work closely with the QA Lead, development and data teams to resolve defects and inconsistencies. Develop and Execute SQL queries to validate data transformations and ensure data integrity. Implement and maintain data quality checks to monitor ETL process performance. Analyze the Source to Target Mapping Documents. Test ETL Mappings to extract data from multiple sources like SQL Server, Flat files, etc., into target tables using transformations. Ensure data accuracy, consistency, and compliance with regulatory requirements. Identify and report defects while working closely with QA Lead and development teams to ensure timely resolution. Perform root cause analysis for defects and implement preventive measures. Contribute to the identification and implementation of automation opportunities in ETL testing. Collaborate with automation engineers to script and execute automated test cases. Create automation test scripts to verify and validate the quality of the product. Execution and maintenance of the automation test scripts. Preferred candidate profile Bachelors degree in computer science, Information Technology, or a related field. Proven experience (2 to 5 years) in ETL testing, with a strong understanding of data integration concepts and methodologies. Strong SQL skills for querying and validating data. Understanding of relational databases and data warehouse concepts. Familiarity with data warehousing, data modeling, and data transformation concepts. Excellent communication and interpersonal skills. Problem-solving mindset and ability to troubleshoot complex issues. Experience with test automation tools and frameworks is a plus. Knowledge of scripting languages (e.g., Python, Shell) for test automation. Must have the ability to multi-task and adapt quickly to changes while maintaining urgency in completing assigned tasks. Should be detail oriented with analytical mindset. Have worked in Agile Environments.

Role Purpose The purpose of the role is to support process delivery by ensuring daily performance of the Production Specialists, resolve technical escalations and develop technical capability within the Production Specialists. Do Oversee and support process by reviewing daily transactions on performance parameters Review performance dashboard and the scores for the team Support the team in improving performance parameters by providing technical support and process guidance Record, track, and document all queries received, problem-solving steps taken and total successful and unsuccessful resolutions Ensure standard processes and procedures are followed to resolve all client queries Resolve client queries as per the SLAs defined in the contract Develop understanding of process/ product for the team members to facilitate better client interaction and troubleshooting Document and analyze call logs to spot most occurring trends to prevent future problems Identify red flags and escalate serious client issues to Team leader in cases of untimely resolution Ensure all product information and disclosures are given to clients before and after the call/email requests Avoids legal challenges by monitoring compliance with service agreements Handle technical escalations through effective diagnosis and troubleshooting of client queries Manage and resolve technical roadblocks/ escalations as per SLA and quality requirements If unable to resolve the issues, timely escalate the issues to TA & SES Provide product support and resolution to clients by performing a question diagnosis while guiding users through step-by-step solutions Troubleshoot all client queries in a user-friendly, courteous and professional manner Offer alternative solutions to clients (where appropriate) with the objective of retaining customers and clients business Organize ideas and effectively communicate oral messages appropriate to listeners and situations Follow up and make scheduled call backs to customers to record feedback and ensure compliance to contract SLAs Build people capability to ensure operational excellence and maintain superior customer service levels of the existing account/client Mentor and guide Production Specialists on improving technical knowledge Collate trainings to be conducted as triage to bridge the skill gaps identified through interviews with the Production Specialist Develop and conduct trainings (Triages) within products for production specialist as per target Inform client about the triages being conducted Undertake product trainings to stay current with product features, changes and updates Enroll in product specific and any other trainings per client requirements/recommendations Identify and document most common problems and recommend appropriate resolutions to the team Update job knowledge by participating in self learning opportunities and maintaining personal networks Deliver NoPerformance ParameterMeasure1ProcessNo. of cases resolved per day, compliance to process and quality standards, meeting process level SLAs, Pulse score, Customer feedback, NSAT/ ESAT2Team ManagementProductivity, efficiency, absenteeism3Capability developmentTriages completed, Technical Test performance Mandatory Skills: Big Data Testing. Experience5-8 Years.

Lead test planning & execution Ensure SDLC & testing compliance Analyze requirements & estimate effort Liaise with stakeholders & teams Track defects & test progress Drive end-to-end testing delivery Required Candidate profile Strong in ETL, SQL, Control-M Proficient in Agile/Waterfall, JIRA, Confluence Exp in DW, Informatica, Azure DevOps Skilled in automation, stakeholder mgmt, comms Onsite-offshore coordination

Primary Skills Data tester (functional testing) Automation experience preferably in Python/Pyspark Working knowledge of No-SQL preferably MongoDb (or json format) Working knowledge of AWS S3 Working knowledge of JIRA /confluence and defect management Understands Agile ways of working Years of experience : minimum 3 years

Job description: Hirings for ETL Test Engineer Experience: 3 to 8 years Mandatory Skills: ETL TESTING/DWH TESTING Education: B.TECHBE/M.TECH/ME/BSC/MSC/BCA/MCA

Role & responsibilities Role Summary As a Data QE at PalTech you will play an important role in designing and executing test strategies for end-to-end data validation, ensuring data completeness, accuracy, and integrity across ETL processes, data warehouses, and reports. You will automate data testing 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. Proficiency in SQL, Python, ETL/ELT tools, and reporting platforms like Power BI or Tableau is essential. The role requires strong analytical skills, collaboration with cross-functional teams, and the ability to enhance testing processes through automation and best practices. Key Responsibilities Create test strategies, test plans, business scenarios, data validation scripts for end-to-end data validation. Verify data completeness, accuracy, and integrity throughout the ETL processes and reports. Evaluate the performance of ETL jobs and ensure that they meet defined SLAs Automate the data testing process using Python or other technologies Experienced in validating various types of fact tables and dimension tables DWH skills are a must Should have expertise in validating larger datasets Should have experience working with relational databases Should have experience in validation of file ingestions and data exports Should be expert in validation of the data security standards implemented in the project Should be proficient in SQL, Python, validation of ETL/ELT tools Should be proficient in validation of reports and dashboards Should be proficient in writing complex scripts to validate business logics and KPIs Should be proficient in validating data encryption, anonymization, authorization processes Extensive experience in creating test data as and when needed based on the business requirements Should be able to identify and validate the corner business use cases Prepare comprehensive test documentation including test cases, test results, and test reports. Work closely with cross-functional teams including developers, business analysts, and data architects. Suggest enhancements and implement the best practices to improve testing processes. Required Skills and Qualifications Educational Background: Bachelors degree in computer science, Information Technology, or a related field. Technical Skills: Strong understanding of ETL processes, data warehousing concepts, and SQL. Should have strong Python skills Experience: 4 to 6 years of experience in ETL testing and reports validation. Experience in automation of data validation processes Tools: Familiarity with ETL tools like ADF, DBT, etc., and defect tracking systems like JIRA. Experience with any reporting tools like Power BI, Tableau, etc Soft Skills: Excellent communication, teamwork abilities, and strong analytical and problem-solving skills. Preferred candidate profile

Stack Digital is looking for Quality Engineer-Data (ETL Tester) to join our dynamic team and embark on a rewarding career journey Developing and implementing quality standards. Developing and implementing quality control systems. Monitoring and analyzing quality performance. Inspecting and testing materials, equipment, processes, and products to ensure quality specifications are met. Collaborating with operations managers to develop and implement controls and improvements. Ensuring that workflows, processes, and products comply with safety regulations. Investigating and troubleshooting product or production issues. Developing corrective actions, solutions, and improvements. Reviewing codes, specifications, and processes.

Educational Bachelor of Engineering,BTech,BE,MTech,MCA,Master Of Technology,MSc Service Line Infosys Quality Engineering Responsibilities A day in the life of an Infoscion As part of the Infosys delivery team, your primary role would be to ensure effective Design, Development, Validation and Support activities, to assure that our clients are satisfied with the high levels of service in the technology domain. You will gather the requirements and specifications to understand the client requirements in a detailed manner and translate the same into system requirements. You will play a key role in the overall estimation of work requirements to provide the right information on project estimations to Technology Leads and Project Managers. 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! Additional Responsibilities: Knowledge of design principles and fundamentals of architecture Understanding of performance engineering Knowledge of quality processes and estimation techniques Basic understanding of project domain Ability to translate functional / nonfunctional requirements to systems requirements Ability to design and code complex programs Ability to write test cases and scenarios based on the specifications Good understanding of SDLC and agile methodologies Awareness of latest technologies and trends Logical thinking and problem solving skills along with an ability to collaborate Technical and Professional : Primary skills:Technology-Data Services Testing-Data Warehouse Testing,Technology-ETL & Data Quality-ETL - Others Preferred Skills: Technology-ETL & Data Quality-ETL - Others

Educational Bachelor of Engineering,BTech,BSc,BCA,MTech,MSc,MCA Service Line Infosys Quality Engineering 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! 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 Technical and Professional : Technology-Data Services Testing-Data Warehouse Testing, Technology-ETL & Data Quality-ETL Preferred Skills: Technology-ETL & Data Quality-ETL - Others Technology-Data Services Testing-Data Warehouse Testing

Experience 9-13 years Location: Gurgaon/Noida Education: BE/B. Tech./Master of Computer Application Work Experience: Overall 9+ years of quality engineering experience with DWH/ETL for enterprise grade applications Hands on experience with functional, non-functional and automation of products Hands on experience with leverage LLMs/GenAI for improving efficiency & effectiveness of overall delivery process Role & Responsibilities: Leading end-to-end QE for product suite Authoring QE test strategy for a release and executing it for a release Driving quality releases by closely working with development, PMs, DevOps, support and business teams Achieving automation coverage for product suite with good line coverage Manage risks and resolves issues that affect release scope, schedule and quality Work with product teams to understand impacts of branches and code merges, etc. Lead and co-ordinate the release activities including the execution of overall Ability to lead team of SDETs and help them in addressing their issues Mentoring and coaching members in the team Technical Skills: Experience in ETL / BI Testing, using any ETL and Reporting Tool with Oracle / SQL Server / as Database Exposure to Data Warehousing and Dimensional Modelling Concepts Hands-on with coding preferably Python Extensive experience in writing and troubleshooting SQL Queries Ability to achieve good functional coverage of product suite Hands on experience with automation tools (Selenium, TestNg, etc.) Experience with CI/CD tools e.g., Jenkins Experience with tools like JIRA, Confluence, SharePoint, TestRails, Zephyr etc. Experience with performance, volume and stress testing Solid understanding of cloud services platforms e.g., AWS, GCP, Azure etc. Well versed with DBs and SQLs Hand-on experience with GenAI/LLMs/RAGs/Agents Soft Skills: Excellent communication skills. Ability to convey hard/sensitive messages without any apprehensions as well as avoid creating frictions. Ability to navigate through organization independently. About AXTRIA (www.axtria.com) Axtria is a global provider of cloud software and data analytics to the Life Sciences industry. We help Life Sciences companies transform the product commercialization journey to drive sales growth and improve healthcare outcomes for patients. We are acutely aware that our work impacts millions of patients and lead passionately to improve their lives.

Looking for ETL/DB tester with 5+ years of experience. Should have strong SQL skills. Should have hands on coding knowledge in any scripting language. should be able to design and write SQL queries for data validation should be able to verify and test ETL processes understanding of Data warehousing concepts is a plus good communication skill and testing mindset

Develop and execute automated mobile test scripts using Appium. Focus on testing mobile applications across different devices and platforms to ensure performance, usability, and security.

5+Years of experience in Development and or quality software Assurance . Strong SQL skills Strong knowledge of QA methodologies,tools and process Experience working in an Agile /scrum development process Hands on current experience with Unix scripting Familiar with BDD Testing framework Degree in Computer science preferred

Hi ,Greetings From IDESLABS.This is Navyafrom IDESLABS, we have a requirement on Etl Testing for one of our clients for contract to Hire role. job Details: skillsEtl TestingExperience7+ YearsLocationBangaloreJob typeContract to HirePay roll companyIDESLABSWork ModelHybrid JD JD with Primary Skill ETL testing /Strong SQL Looking for ETL/DB tester with 5+ years of experience. Should have strong SQL skills. Should have hands on coding knowledge in any scripting language. should be able to design and write SQL queries for data validation should be able to verify and test ETL processes understanding of Data warehousing concepts is a plus good communication skill and testing mindset

Job Description We are looking for energetic, high-performing and highly skilled Quality Assurance Engineer to help shape our technology and product roadmap. You will be part of the fast-paced, entrepreneurial Enterprise Personalization portfolio focused on delivering the next generation global marketing capabilities. This team is responsible for Global campaign tracking of new accounts acquisition and bounty payments and leverages transformational technologies, such as SQL, Hadoop, Spark, Pyspark, HDFS, MapReduce, Hive, HBase, Kafka & Java. Focus: Provides domain expertise to engineers on Automation, Testing and Quality Assurance (QA) methodologies and processes, crafts and executes test scripts, assists in preparation of test strategies, sets up and maintains test data & environments as well as logs results. 4 - 6 years of hands-on software testing experience in developing test cases and test plans with extensive knowledge of automated testing and architecture. Expert knowledge of Testing Frameworks and Test Automation Design Patterns like TDD, BDD etc. Expertise in developing software test cases for Hive, Spark, SQL written in pyspark SQL and Scala. Hands-on experience in Performance and Load Testing tools such as JMeter, pytest or similar tool. Experience with industry standard tools for defect tracking, source code management, test case management, test automation, and other management and monitoring tools Experience working with Agile methodology Experience with Cloud Platform (GCP) Experience in designing, developing, testing and debugging, and operating resilient distributed systems using Big Data ClustersGood sense for software quality, the clean code principles, test driven development and an agile mindset High engagement, self-organization, strong communication skills and team spirit Experience with building and adopting new test frameworks.Bonus skills:Testing Machine learning/data mining Roles & Responsibilities Responsible for testing and quality assurance of large data processing pipeline using Pyspark and SQL. Develops and tests software, including ongoing refactoring of code, and drives continuous improvement in code structure and quality• Functions as a platform SME who drives quality and automation strategy at application level, identifies new opportunities and drives Software Engineers to deliver the highest quality code. Delivers on capabilities for the portfolio automation strategy and executes against the test and automation strategy defined at the portfolio level. Works with engineers to drive improvements in code quality via manual and automated testing. Involved in the review of the user story backlog and requirements specifications for completeness and weaknesses in function, performance, reliability, scalability, testability, usability, and security and compliance testing. Provides recommendations Plans and defines testing approach, providing advice on prioritization of testing activity in support of identified risks in project schedules or test scenarios.

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

Job role - Datawarehouse BI testing Location - Chennai / Hyderabad / Bangalore / Mumbai / Ahmedabad / Indore Experience - 4 to 10 years 4+ years of experience in software testing with a strong focus on Data Warehousing, ETL testing, and BI testing. Solid understanding of data warehouse concepts (star schema, snowflake schema, OLAP, and dimensional modeling). Proficiency in writing complex SQL queries for data validation, reconciliation, and transformation testing. Hands-on experience testing ETL tools such as Informatica, Talend, Apache Airflow, or dbt. Expertise in testing and validating reports and dashboards built on BI tools: Tableau Power BI ThoughtSpot Familiarity with cloud-based DWH platforms like Snowflake, Databricks, AWS Redshift, or Azure Synapse. Experience with defect management tools such as Jira, TestRail, or Azure DevOps. Strong analytical skills with the ability to troubleshoot data quality and performance issues. Experience with performance testing and optimization for BI dashboards and large-scale datasets. Excellent communication, leadership, and stakeholder management skills.

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