110 Dwh Testing Jobs

We are hiring for Top reputed Product Based MNC for our client. Exp : 8+Years - 14 Years. Location : Chennai, Pune, Hyderabad, Mumbai and Gurgaon. Mandatory Skills : ETL Testing and SQL Queries. Job Type : Contract (C2H). We are looking for candidates who have experience in ETL Testing and Strong experience in SQL Queries.

About Iris- At Iris Software, our vision is to be our clients most trusted technology partner, and the first choice for the industrys top professionals to realize their full potential. With over 4,300 associates across India, U.S.A, and Canada, we help our enterprise clients thrive with technology-enabled transformation across financial services, healthcare, transportation & logistics, and professional services. Our work covers complex, mission-critical applications with the latest technologies, such as high-value complex Application & Product Engineering, Data & Analytics, Cloud, DevOps, Data & MLOps, Quality Engineering, and Business Automation. https://www.linkedin.com/company/iris-software-inc./ Working at Iris: Be valued, be inspired, be your best. At Iris Software, we invest in and create a culture where colleagues feel valued, can explore their potential, and have opportunities to grow. Our employee value proposition is about Being Your Best ” – as a professional and person. It is about being challenged by work that inspires us, being empowered to excel and grow in your career, and being part of a culture where talent is valued. We’re a place where everyone can belong. Total Exp - 5+ Mode- Hybrid Location - Noida/ Delhi/ Gurugram/ Pune Skills Required- Data Testing Strategy & Execution: Design, develop, and execute comprehensive test plans and test cases for data-centric applications, ETL processes, data warehouses, data lakes, and reporting solutions. • SQL-Driven Validation: Utilize advanced SQL queries to perform complex data validation, data reconciliation, data integrity checks, and data quality assurance across various financial data sources. • ETL Testing: Conduct thorough testing of ETL (Extract, Transform, Load) processes, ensuring data is accurately extracted, transformed according to business rules, and loaded correctly into target systems. • Data Quality Assurance: Implement and monitor data quality checks, identify data discrepancies, anomalies, and inconsistencies, and work with development and business teams to resolve issues. • Performance Testing (Data Focus): Contribute to performance testing efforts for data pipelines and database operations, ensuring optimal query and data load performance. • Test Data Management: Create and manage robust test data sets for various testing phases, including positive, negative, and edge case scenarios. • Defect Management: Identify, document, track, and re-test defects in data, collaborating closely with development and data engineering teams for timely resolution. • Documentation & Reporting: Maintain clear and concise documentation of test plans, test cases, test results, and data quality reports. Provide regular status updates to stakeholders. • Collaboration: Work effectively with business analysts, data architects, data engineers, and project managers to understand data flows, business requirements, and ensure data quality standards are met. • Process Improvement: Proactively identify opportunities for process improvements in data testing methodologies and tools. • Global Team Collaboration: Provide consistent overlap with EST working hours (until noon EST) to facilitate effective communication and collaboration with US-based teams. Required Skills & Experience: • Experience: 7+ years of hands-on experience in Data Quality Assurance, Data Testing, or ETL Testing roles. • SQL Expertise: o Advanced proficiency in SQL: Ability to write complex queries, subqueries, analytical functions (Window functions), CTEs, and stored procedures for data validation, reconciliation, and analysis. o Experience with various SQL databases (e.g., SQL Server, Oracle, PostgreSQL, MySQL, Snowflake, BigQuery). o Strong understanding of database concepts: normalization, indexing, primary/foreign keys, and data types. • Data Testing Methodologies: Solid understanding of data warehousing concepts, ETL processes, and various data testing strategies (e.g., source-to-target mapping validation, data transformation testing, data load testing, data completeness, data accuracy). • Domain Expertise: o Strong understanding and proven experience in Risk and Finance IT domain: Familiarity with financial data (e.g., trading data, market data, risk metrics, accounting data, regulatory reporting). o Knowledge of financial products, regulations, and risk management concepts. • Analytical & Problem-Solving Skills: Excellent ability to analyze complex data sets, identify root causes of data issues, and propose effective solutions. • Communication: Strong verbal and written communication skills to articulate data issues and collaborate with diverse teams. • Time Zone Overlap: Proven ability and willingness to provide consistent working hour overlap until noon EST to collaborate with teams in the Eastern Standard Time zone. Mandatory Competencies ETL - ETL - Tester Database - Database Programming - SQL Database - PostgreSQL - PostgreSQL Beh - Communication Database - Oracle - Database Design Domain Areas - FS Domain - Financial Services Domain Areas - FS Domain - Market Risk If Interested, Share your resume on kanika.singh@irissoftware.com Notice Period- Max 1 month

We are hiring for ETL Professional for our client Place in Bangalore/Chennai/Hyderabad/Pune. Please find the below details Experience: 4 to 12 yrs Work location: Bangalore/Chennai/Hyderabad/Pune. Type: working Under Nityo Payroll Work Type: WFO Skills strong DS testing . ETL tester with the combination of Python/sql/Selenium Should be available for F2F interview in client place. Notice period immediate to 30 days If you are interested, Please share your update profile to vidhya.b@nityo.com/ jagadeesh@nityo.com or reach me @ 8925740451 (Jagadeesh) to know more details about the requirement and client. Thanks & Regards, Vidhya B Phone: +91 9384850049 |Mobile: +91 8056239878| www.nityo.com https://www.linkedin.com/in/vidhya-bhaskaran-1720835/

4-8 years of experience in database testing, ETL,SQL Experience with data warehousing concepts and methodologies. Preferred certifications in relevant ETL tools or data engineering.

HCL Hiring for ETL/DWH Testing role!! Location-Bangalore/Pune/Hyderabad/Chennai/Noida Experience-5 to 7 Years Notice Period-Immediate to 30 days Skill- ETL/DWH Testing Snowflake, Cloud-AWS Experience SQL Query Informatica JD: 1. ETL QA experience on enterprise level applications which includes Data Warehouse Testing. 2. Experience in writing complex SQL queries, ability to determine the types of testing that must be conducted (i.e., data validation, regression, etc.), including evaluating the testability of requirements and create a comprehensive test plan that supports the business and technological solutions being delivered. 3. Understanding of different databases like SSMS, Oracle, Workbench, Snowflake. 4. Should have hands on experience on Cloud(AWS/Azure). 5. Should have experience testing multiple test phases in medium to large projects. 6. Should have adequate experience and clear understanding of data warehouse and data mart testing. 7. Review Data Models, Data Mappings, Architectural Documentation to create/execute effective SIT Test Plans and SIT test cases. 8. Experience in Test Management tools like HP ALM/JIRA. 9. Identification and Test Data Preparation Techniques. 10. Thorough knowledge of Software Test Life Cycle, Test Case Life Cycle, Defect Life Cycle etc. Proficiency with Test Case Preparation and Execution. 11. Extensive exposure to Back-end/ETL Testing with high-level of SQL skills is required. 12. Possess experience in using Informatica suite of tools. 13. Should have exposure to large data sets and understand Data Quality Framework.

Experience :- 5 to 9 yrs Skills :- ETL Tester, Database testing, DWH testing. Location :- Delhi/NCR /Pune /Chennai Work location :- (Noida-sec-142, Guru gram, Pune- Kalyani Nagar) Shift timings :- 12 :30 PM to 9 :30 PM Work Mode :- Hybrid (3 Days from office - Tues to Thursday) Job Description: Senior Data Quality Assurance Engineer Job Summary: We are seeking a highly skilled and experienced Senior Data Quality Assurance Engineer with 5-10 years of dedicated experience in data testing using SQL. The ideal candidate will possess deep domain expertise in Risk and Finance IT, ensuring the integrity, accuracy, and reliability of critical financial data. This role requires a strong analytical mindset, meticulous attention to detail, and the ability to work collaboratively within a fast-paced environment. A key requirement is the availability to provide overlap with EST hours to facilitate seamless collaboration with our global teams. Key Responsibilities: Data Testing Strategy & Execution: Design, develop, and execute comprehensive test plans and test cases for data-centric applications, ETL processes, data warehouses, data lakes, and reporting solutions. SQL-Driven Validation: Utilize advanced SQL queries to perform complex data validation, data reconciliation, data integrity checks, and data quality assurance across various financial data sources. ETL Testing: Conduct thorough testing of ETL (Extract, Transform, Load) processes, ensuring data is accurately extracted, transformed according to business rules, and loaded correctly into target systems. Data Quality Assurance: Implement and monitor data quality checks, identify data discrepancies, anomalies, and inconsistencies, and work with development and business teams to resolve issues. Performance Testing (Data Focus): Contribute to performance testing efforts for data pipelines and database operations, ensuring optimal query and data load performance. Test Data Management: Create and manage robust test data sets for various testing phases, including positive, negative, and edge case scenarios. Defect Management: Identify, document, track, and re-test defects in data, collaborating closely with development and data engineering teams for timely resolution. Documentation & Reporting: Maintain clear and concise documentation of test plans, test cases, test results, and data quality reports. Provide regular status updates to stakeholders. Collaboration: Work effectively with business analysts, data architects, data engineers, and project managers to understand data flows, business requirements, and ensure data quality standards are met. Process Improvement: Proactively identify opportunities for process improvements in data testing methodologies and tools. Global Team Collaboration: Provide consistent overlap with EST working hours (until noon EST) to facilitate effective communication and collaboration with US-based teams. Required Skills & Experience: Experience: 5-10 years of hands-on experience in Data Quality Assurance, Data Testing, or ETL Testing roles. SQL Expertise: Advanced proficiency in SQL: Ability to write complex queries, subqueries, analytical functions (Window functions), CTEs, and stored procedures for data validation, reconciliation, and analysis. Experience with various SQL databases (e.g., SQL Server, Oracle, PostgreSQL, MySQL, Snowflake, BigQuery). Strong understanding of database concepts: normalization, indexing, primary/foreign keys, and data types. Data Testing Methodologies: Solid understanding of data warehousing concepts, ETL processes, and various data testing strategies (e.g., source-to-target mapping validation, data transformation testing, data load testing, data completeness, data accuracy). Domain Expertise: Strong understanding and proven experience in Risk and Finance IT domain: Familiarity with financial data (e.g., trading data, market data, risk metrics, accounting data, regulatory reporting). Knowledge of financial products, regulations, and risk management concepts. Analytical & Problem-Solving Skills: Excellent ability to analyze complex data sets, identify root causes of data issues, and propose effective solutions. Communication: Strong verbal and written communication skills to articulate data issues and collaborate with diverse teams. Time Zone Overlap: Proven ability and willingness to provide consistent working hour overlap until noon EST to collaborate with teams in the Eastern Standard Time zone. Preferred Qualifications (Plus Points): Python Knowledge: Experience with Python for data manipulation, scripting, or automating data quality checks. Familiarity with data processing libraries (e.g., Pandas, NumPy). Experience with big data technologies (e.g., Hadoop, Spark) and cloud data platforms (AWS, Azure, GCP). Knowledge of data visualization tools (e.g., Tableau, Power BI) for reporting data quality metrics. Experience with automated testing frameworks for data validation. Familiarity with CI/CD pipelines in a data context. Certifications in SQL, Cloud Data Engineering, or relevant financial domains. Notice Period :- Immediate to 15 Days Joiners

The ideal candidate for the Data QA position should have 6 to 10 years of experience in ETL+ DWH Testing and Cloud Testing with expertise in AWS (S3 & Glue) and Azure, along with proficiency in SQL Server, including writing SQL queries. Additionally, familiarity with Snowflake, ADF, and API Testing is essential. Key technical skills required for this role include a strong understanding of Boomi or similar integration tools like MuleSoft, Informatica, Talend, or Workato, experience with Data Bricks, in-depth knowledge of ETL Testing, proficiency in writing SQL Queries, and good technical documentation skills. The candidate should also possess strong communication skills to effectively interact with both technical and non-technical stakeholders. Desirable skills for this role include Data Testing on AWS using Athena, the ability to run and troubleshoot AWS Glue Jobs, understanding of Data Warehousing concepts, and proficiency in Python and Apache Spark. The working hours for this position are from 11:00 am to 8:00 pm, with flexibility required for potential overlap with EST as per project requirements. This is a full-time position with a duration of 1 year, and the candidate is expected to work 2/3 days from the office in Bangalore, Pune, Mumbai, Hyderabad, or Noida, based on the hybrid model.,

As a candidate for this role, you will be expected to have experience and proficiency in Python, SQL, Snowflake, Oracle PL/SQL, Database Model 3NF, and Microsoft Power BI. Your responsibilities will include working with Snowflake, Requirements Engineering, Reporting, Requirement Analysis, DB2-SQL, SQL Server, DWH Testing, SQLite, White Box Testing, Test Requirement Management, Oracle PL SQL, ETL Testing, and BI Testing. Moreover, familiarity with Java, HTML, AWS, C, GCP, and Python is also required for this position. Your role will involve Software Development, Manual Testing, API Gateway, Application Design, ETL Testing, and Oracle PLSQL. Overall, you will be part of a dynamic team where your expertise in various technologies and tools will be crucial in contributing to the successful execution of projects and the achievement of business goals.,

Greetings from Technogen !!! We thank you for taking time about your competencies and skills, while allowing us an opportunity to explain about us and our Technogen , we understand that your experience and expertise are relevant the current open with our clients. About Technogen : https://technogenindia.com/ Technogen India Pvt. Ltd. is a boutique Talent & IT Solutions company, founded in 2008, has been serving global customers for over last 2 decades,. Talent Solutions: We assist several GCCs, Global MNCs and IT majors on their critical and unique IT talent needs through our services around Recruitment Process Outsourcing (RPO), contract staffing, permanent hiring, Hire-Train-Deploy (HTD), Build-Operate-Transfer (BOT) and Offshore staffing. Please share below details for further processing of your profile. Total years of experience: Relevant years of experience: CTC (Including Variable): ECTC: Notice Period: Reason for change: Current location: Job Title : Data Tester || ETL Tester Experience : 3+ years Work Mode: WFO-4 Days from Office. Shift Time : UK Shift Time-12:00 PM IST to 09:00 PM IST. Location : Hyderabad. Job Summary:- What Were Looking For:- Bachelors or Masters degree in Computer Science, Data Engineering, Information Systems, or a related technical field. Minimum of 3 years of experience in data testing, ETL/ELT testing, or data quality roles. Hands-on experience with Google BigQuery or other cloud-based data platforms. Proficiency in writing complex SQL queries for data validation and testing. Strong understanding of data quality, integrity, and validation techniques. Experience handling large datasets and complex data structures. Familiarity with test automation tools such as Selenium or TestNG is a plus. Working knowledge of ETL/ELT pipeline development and cloud-native data architecture. Solid grasp of data warehousing concepts, methodologies, and data governance frameworks. Familiarity with scripting languages such as Python or Shell for data validation or automation tasks. Excellent communication skills—both written and verbal. Ability to thrive in a fast-paced, collaborative, and Agile environment. Experience with Agile methodologies (Scrum, Kanban) and managing IT backlogs. A proactive problem solver and a go-to expert for data quality and testing. What Your Impact Will Be:- Test and validate ETL/ELT processes to ensure data quality, completeness and accuracy. Perform data reconciliation and verification between source systems and GBQ (Data Lake) or other target systems. Execute manual and automated test cases based on ETL specifications and business requirements to validate data accuracy and integrity Identify, log, and track defects, working closely with the development team to resolve issues. Document test results and report defects, working closely with the development team to facilitate timely resolution Collaborate with data engineers and business analysts to understand requirements and business rules. Ensure data transformation rules are correctly applied. Perform data profiling and integrity checks to ensure compliance with business requirements. Support the creation of test strategies and plans for data-related projects. Verify the BigQuery best practices—including partitioning, clustering, and query optimization—to ensure high performance and scalability. As part of the Global Technology Organization, the Enterprise Data and Analytics (ED&A) Delivery Team enables to become a data-driven organization by building a centralized, shared services platform that supports all business units. The team is responsible for:- Integrating data from diverse enterprise systems including ERP, E-commerce, Order Management, CRM, and operational platforms into a centralized, cloud-based data warehouse. Building robust ETL/ELT pipelines to automate data ingestion, transformation, and delivery using modern tools and frameworks. Delivering curated, business-ready datasets to support self-service analytics and strategic decision-making. Enforcing enterprise-wide data quality, testing, and governance standards. Leveraging orchestration tools such as Airflow/Cloud Composer for reliable pipeline scheduling and execution. Collaborating with data analysts, product owners, and BI developers to align data solutions with business needs. Best Regards, Syam.M | Sr.IT Recruiter syambabu.m@technogenindia.com www.technogenindia.com | Follow us on LinkedIn

Job Description We are looking for a skilled and motivated Database Tester with a strong background in Quality Assurance to join our dynamic team. The ideal candidate will bring a deep understanding of QA practices, data testing, and automation, with a passion for continuous learning, especially in the evolving field of AI-driven testing. Experience with data-centric projects and team management is essential for this role. Key Responsibilities Demonstrate strong expertise in Quality Assurance processes, methodologies, and best practices. Perform comprehensive testing across data layers , user interfaces , and automated testing frameworks . Execute test cases for data validation , ETL pipelines , and database integrity . Collaborate with cross-functional teams on projects involving Big Data , Azure DBT , and MSBI . Stay up-to-date and show enthusiasm to learn and implement AI-driven testing tools (e.g., Vibe Coding, Cursor). Design, develop, and maintain test automation scripts for scalable and efficient testing processes. Lead and mentor junior QA team members, manage test deliverables, and oversee the QA lifecycle. Report defects clearly and work closely with developers and analysts for timely resolution. Contribute to continuous improvement initiatives in test strategy, tools, and processes. Required Skills and Qualifications Proven experience in database testing and ETL validation . Proficiency in SQL , test automation tools , and data testing frameworks . Good understanding of UI testing and test case design . Familiarity with Big Data technologies , Azure-based tools , and MSBI components . Experience in team coordination or management within QA teams. Strong analytical and problem-solving skills. Excellent communication and collaboration abilities. Willingness to adapt and learn new tools and technologies, particularly in the AI-driven testing landscape .

Job description Hiring for ETL tseter testing with experience range 5 years & above Mandatory Skills: ETL/DWH testing Education: BE/B.Tech/BCA/MCA/M.Tech/ME/BSc/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!

Job description Hiring for ETL tseter testing with experience range 5 years & above Mandatory Skills: ETL/DWH testing Education: BE/B.Tech/BCA/MCA/M.Tech/ME/BSc/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!

Roles and Responsibilities : Design, develop, and execute comprehensive ETL tests to ensure data integrity and quality. Collaborate with cross-functional teams to identify requirements and create test plans for DWH (Data Warehouse) testing. Develop automated scripts using Informatica PowerCenter to streamline the ETL process. Analyze results, identify defects, and provide recommendations for improvement. Job Requirements : 5-9 years of experience in ETL testing with expertise in Bi Testing, Data Testing, DWH Testing, and Informatica Testing. Strong understanding of SQL queries and ability to write complex queries for data validation. Experience with automation tools such as Automic or similar technologies is an added advantage.

Greetings from SAGEIT! We are Hiring for QA Test Engineer Position. Please find the Job Description details below:- Experience:- 2 -4 Years Location:- Pune Payroll:- SAGEIT Client:- Telecom domain Key Responsibilities: Develop and implement automation, DWH, and performance scripts/tools on the DataBricks platform. Execute and monitor performance tests using tools like LoadRunner, JMeter, and Python. Identify and recommend resolutions for system performance issues and bottlenecks. Collaborate with development, operations, and architecture teams for RCA and system optimization. Design, review, and execute test cases ensuring complete coverage of requirements. Create test documentation and ensure traceability to business requirements. Participate in knowledge transfer and support peer learning. Skills & Tools Required: Hands-on experience with DataBricks platform. Proficient in Performance Testing (LoadRunner, JMeter). Familiar with Automation Testing Tools like Selenium, Python scripting. Good understanding of DWH Testing and application architecture. Exposure to DevOps tools Jenkins, Git, Docker, and Cloud Monitoring tools. Telecom domain knowledge is a plus. Qualifications : Bachelors degree in Computer Science / IT / MCA or equivalent. Candidate Details Required (Please Fill in Below): Are you ready to work under SAGE IT payroll & deployed at client (Yes/No): Are you ready to work as Individual Contributor (Yes/No): Total Experience: Relevant Experience: Current Company: Designation: Current Location: Preferred Location: CTC: Expected CTC: Notice Period (Attach LWD screenshot if serving notice): Reason for Change: Offer Status (Details if holding any offers): Aadhaar Last 4 Digits & DOB: How to Apply: Send your updated resume along with the filled details above to swadeshkumar.k@sageit.in

Key Responsibilities Understand business requirements and translate them into test scenarios. Perform data validation , ETL testing , report testing , and dashboard validations . Validate data transformation, aggregation, and loading into the data warehouse or data marts. Develop and execute test cases , SQL queries , and automation scripts as needed. Validate source to target data mapping, field-level validations, and data reconciliation. Identify, report, and track defects to closure. Collaborate with BI developers and data engineers to resolve issues and ensure data quality. Document test results, defects, and QA artifacts. Required Skills 3+ years of experience in BI/ETL testing or Data Warehouse testing . Strong SQL skills for writing complex queries to validate data. Hands-on experience with ETL tools (e.g., Informatica, Talend, SSIS). Experience with BI reporting tools like Power BI , Tableau , or QlikView . Familiarity with data modeling concepts and star/snowflake schemas. Experience in testing data pipelines, dashboards, and reports. Exposure to test management tools like JIRA , HP ALM , or TestRail .

Senior Data Test Analyst - Informatica Location : Bangalore Job Type : Full-Time, Onsite Apply at : hr@data-prowess.com Experience : 7+ Years Job Summary Data Prowess is looking for a seasoned Data Test Analyst with deep expertise in ETL testing and Informatica PowerCenter . You will play a critical role in validating data pipelines, ensuring data integrity, and collaborating with cross-functional teams to support data quality initiatives. Key Responsibilities ETL Testing : Validate ETL workflows, data transformations, and data loads using Informatica PowerCenter . Data Validation : Conduct source-to-target data validation to ensure accuracy and completeness. Test Strategy & Planning : Create test plans , test cases, and test scripts based on business requirements. SQL & Database Testing : Write and execute complex SQL queries for validating data in Oracle, SQL Server, MySQL , etc. Defect Management : Identify and log defects; track and manage through tools like JIRA, HP ALM, or TestRail . Collaboration : Work with developers, BAs, and QA teams to investigate issues and uphold data quality. Performance Testing : Identify and report performance bottlenecks in ETL jobs; suggest optimization strategies. Required Skills & Experience 7+ years of experience in ETL/Informatica Testing . Expertise in Informatica PowerCenter and ETL validation. Strong SQL knowledge with the ability to handle complex queries, joins, indexing, and performance tuning . Proficiency in test case design, execution , and defect tracking . Solid understanding of data warehousing and BI reporting tools . Experience with Agile methodologies and tools like JIRA, Confluence, or Azure DevOps . Strong analytical, debugging, and communication skills. Preferred Skills Experience with cloud-based ETL platforms. Familiarity with ETL testing automation frameworks . Exposure to big data technologies . Educational Qualification Bachelor's degree in Computer Science, Information Technology , or a related field. Competitive Salary Package Immediate Joining Reach us at - hr@data-prowess.com Contact: 8073332143

Capco, a Wipro company, is a global technology and management consulting firm. Awarded with Consultancy of the year in the British Bank Award and has been ranked Top 100 Best Companies for Women in India 2022 by Avtar & Seramount. With our presence across 32 cities across globe, we support 100+ clients acrossbanking, financial and Energy sectors. We are recognized for our deep transformation execution and delivery. WHY JOIN CAPCO You will work on engaging projects with the largest international and local banks, insurance companies, payment service providers and other key players in the industry. The projects that will transform the financial services industry. MAKE AN IMPACT Innovative thinking, delivery excellence and thought leadership to help our clients transform their business. Together with our clients and industry partners, we deliver disruptive work that is changing energy and financial services. #BEYOURSELFATWORK Capco has a tolerant, open culture that values diversity, inclusivity, and creativity. CAREER ADVANCEMENT With no forced hierarchy at Capco, everyone has the opportunity to grow as we grow, taking their career into their own hands. DIVERSITY & INCLUSION We believe that diversity of people and perspective gives us a competitive advantage. MAKE AN IMPACT Big Data Tester LocationPune (for Mastercard) Experience Level5-9 years Minimum Skill Set Required / Must Have Python PySpark Testing skills and best practices for data validation SQL (hands-on experience, especially with complex queries) and ETL Good to Have Unix Big Data: Hadoop, Spark, Kafka, NoSQL databases (MongoDB, Cassandra), Hive, etc. Data Warehouse: TraditionalOracle, Teradata, SQL Server Modern CloudAmazon Redshift, Google BigQuery, Snowflake AWS development experience (not mandatory, but beneficial) Best Fit Python + PySpark + Testing + SQL (hands-on) and ETL + Good to Have skills

As a Software Tester, you will be responsible for conducting various testing practices including Manual Testing (Block, White and Gray Box Testing), Automation Testing (primarily using Java with Selenium), Junit, Database Testing with strong database skills, Big Data Testing, and DWH Testing in projects based in Bangalore and Chennai. You will play a crucial role in ensuring the quality and reliability of the software products by executing test cases, identifying defects, and providing feedback to the development team. Your expertise in both manual and automation testing will be utilized to create robust test scripts, perform regression testing, and contribute to the continuous improvement of testing processes. Additionally, your experience in database testing will be essential for validating data integrity, analyzing data discrepancies, and ensuring the accuracy of database operations. Your proficiency in Big Data Testing and DWH Testing will be instrumental in verifying the performance and scalability of data warehouses and big data solutions. If you are passionate about testing and have a strong background in various testing practices, this role offers an exciting opportunity to work on challenging projects in dynamic environments across Bangalore and Chennai.,

Must Have Experience in ETL Testing Must Have Experience in DWH Testing Must Have Experience in IFORMATICA Must Have Experience in Banking Domain Strong SQL skills to perform database queries, data validations, and data integrity checks. Familiarity with relational databases and data management concepts. Working experience with cloud-based data warehouse platforms like Snowflake and Azure. Experience in creating and implementing ETL testing strategy Experience in data integrity, data accuracy and completeness testing

Technical and Professional Requirements: Experienced data testing profile with: SQL, ETL, Data layer validations, Microservices (API), Python / Java automation. Good to have: Master Data Management (MDM), Cloud (Azure/AWS/GCP) Data Testing. Good communication and stakeholder management. Must Skills: Data Services Testing->Data Warehouse Testing->ETL tool Education: BE/B.Tech/MCA/M.Tech/MSc./MCA

Role & responsibilities 1 strong experience in ETL Testing

8+ Years of Extensive Experience working with multiple Databases, ETL and BI testing Working experience in Investment Management and Capital Markets Domain with is preferred Experience working in the applications like Eagle, Calypso, Murex will be added advantage Experience in delivering large releases to the customer through direct and partner teams. Experience in testing data validation scenarios and Data ingestion, pipelines, and transformation processes. Problem-solving skills and the ability to analyze quantitatively, scope business requirements and effectively prioritize program deliverables. Experience in Vertica, DataStage, Teradata, and Big Data environments for both data Ingestion and Consumption. Extensive knowledge on any Business Intelligence tool, Preferably MicroStrategy and Tableau. Extensive experience in writing and troubleshooting complex SQL Queries. Identify defect leakages and Implement QA process to overcome it. Train and develop data testing skills to the team. Expert in providing QA solutions based on Data Warehousing and Dimensional Modelling design. Expert in drafting ETL Source to Target Mapping document design. Identify data validation tools that will suit the ETL project conditions. Ensure all sign offs on deliverables (overall test strategy, test plan, test cases and test results) and that testing meets governance requirements. Establishing and driving Automation Capabilities. Collaborating with dev & architect teams to identify and prioritize opportunities for automation. Experience in ETL automation with open-source tools, Service Virtualization, CI/CD. Coordinate with Project Managers and Scrum Masters to know the roadmap and resource allocation. Coordinate with QA and Dev team to fill the gaps/challenges, if any. Coordinate with US counterpart (QA, Dev leads) to give or take inputs in process/project improvements.

You have a great opportunity as an SE/SSE/SA in Chennai with 4-8 years of experience in database testing and ETL + Bigdata (Hive) testing. Your role will involve working with Agile methodology, having a minimum of 4-6 years of testing experience including test planning & execution. It would be beneficial if you have experience in the auditing domain. Your responsibilities will include strong application analysis, troubleshooting skills, and behavior skills. You should have extensive experience in manual testing, while experience with automation scripting would be an added advantage. You will also be required to lead discussions with Business, Development, and vendor teams for testing activities such as Defect Coordinator and test scenario reviews. As part of the role, you should have expertise in Data Warehouse (DWH) and ETL testing, with experience in Redshift ETL tool and AWS. Knowledge in Analytics tools like Tableau and Collibra would be beneficial. You should be open to working in 2nd shifts from 1pm to 10pm and possess excellent communication skills to effectively collaborate with various teams.,

5-8 years of experience in Data Testing using SQL Knowledge of Python is a plus Domain expertise in Risk and Finance IT

Job Description for QA Engineer: 6 + years of experience in ETL Testing, Snowflake, DWH Concepts. Strong SQL knowledge & debugging skills are a must. Banking domain is mandatory Experience on Azure and Snowflake Testing is plus Experience with Qlik Replicate and Compose tools (Change Data Capture) tools is considered a plus Strong Data warehousing Concepts, ETL tools like Talend Cloud Data Integration, Pentaho/Kettle tool Experience in JIRA, Xray defect management toolis good to have. Exposure to the financial domain knowledge is considered a plus Testing the data-readiness (data quality) address code or data issues Demonstrated ability to rationalize problems and use judgment and innovation to define clear and concise solutions Demonstrate strong collaborative experience across regions (APAC, EMEA and NA) to effectively and efficiently identify root cause of code/data issues and come up with a permanent solution Prior experience with State Street and Charles River Development (CRD) considered a plus Experience in tools such as PowerPoint, Excel, SQL Exposure to Third party data providers such as Bloomberg, Reuters, MSCI and other Rating agencies is a plus