• Create test artifacts using the HP Quality Center
• Participate in various review meetings to refine and understand testing requirements.
• Execute/process transactions as needed to test new software functionality and ensure existing functionality has been maintained
• Document test findings.
• Report findings to senior team members for escalation of critical issues in a timely manner.
• Assist in assessing readiness and deviation of product/project performance based on test results and product specifications.
• Execute SSIS packages and validate data migrations.
• Automate QA and status reporting of data migrations to keep all stakeholders informed.
• Automate data validations and telemetry of migrated data.
• Analyse, understand and document data models and data transformation logic.
• Create and run stored procedures.
• Gather requirements from development teams and get sign-off on requirements from various stakeholders.
• Working on data visualization and dashboards.
• Writing and running queries involving huge volumes of data.

Skills: HP Quality Center, Testing Requirements, Functionality Testing, Issue Escalation, SSIS Execution, Data Validation, Requirements Management, Data Visualization.

• Performing RCA (Root Cause Analysis) of the failed test cases and providing the related data samples to the client.
• Responsible for reviewing test plans for team members to ensure high-quality deliverables.
• Coordinating with the client and getting proper updates from Onsite (if the project setup is based on an onsite-offshore model).
• Incorporate UAT test cases into testing.
• Identify the bugs/issues/problems and provide solutions for potential issues based on the knowledge acquired on the application.
• Provide observations of the overall system that are not expected and could potentially be bugs.
• Help with the analysis of issues and Data Reconciliation.
• Onsite communications and coordination with clients on test cases created.
• Create, compile, and provide test reports and Metrics.
• Provide support to businesses during the UAT phase.
• Execute any data migration-related tasks and provide feedback on the automated migration steps and queries

Skills: Root Cause Analysis, Test Plan Review, Client Coordination, UAT Integration, Issue Identification, System Observation, Data Reconciliation, Onsite Communication.

• Understand the requirements and design specifications, technical documents, source-to-target mapping documents and other related documentation from a testing perspective.
• Create and maintain the test strategy document for ETL tasks and also other related applications that communicate with ETL tools and technologies.
• Design the test cases as per the test plan and user specs.
• Estimate the efforts required to design the test cases and execute the project.
• Traceability of requirements to test cases.
• Create Test Plan, Test Scenario, Test Cases and Test Scripts to validate source and Target data.
• Play a key role in the development/automation of SQL queries while preparing the test case scripts.
• Test data creation in case of the onsite/offshore model and if the data is sensitive.
• Test data creation for volumetric testing and any performance testing. 
• Creating, maintaining, and executing Reusable scripts.
• Execute test scripts including pre-requisites, detailed instructions and anticipated results.
• Execute backend data-driven test cases.

Skills: Requirements Analysis, Test Strategy Development, Test Case Design, Effort Estimation, Requirements Traceability, SQL Query Automation, Test Data Creation, Script Execution.

• Translate business requirements and specifications into test plans and test cases
• Write and execute test cases
• Document test results in test case management software
• Troubleshoot and document bugs and defects using bug-tracking systems
• Analyze data and compare with expected or anticipated results
• Work closely with Business Analysts and Software Developers to identify system requirements
• Participate in daily stand-ups and other meetings 
• Coordinating testing activities and optimizing test cycles working with the project team.
• Test data warehouse systems and have defined test approaches for data warehouse projects.
• Create test plans, test cases, and engineering best practices related to software test engineering, both manual and automated testing. 

Skills: Test Planning, Test Execution, Result Documentation, Bug Tracking, Data Analysis, Cross-functional Collaboration, Testing Coordination, Data Warehouse Testing.

• Coordinate and supervise testing activities with developers, testers, and business representatives
• Write and execute tests to validate products and software applications
• Script and test to validate software application processing
• Contribute to the development of Accessibility Quality Assurance test philosophies and methodologies
• Build and/or execute comprehensive automation scripts and manage testers doing the same
• Review business and technical design documentation to identify gaps in analysis and critical areas for testing
• Partner with the Business Analysis and Design team to ensure that functional and technical requirements are defined and validated
• Help manage User Acceptance Testing (UAT) activities with internal and external stakeholders
• Develop and execute test plans that assign and track testing activities across teams
• Map testing documentation to business and technical requirements and develop a protocol for test script updates

Skills: Testing Coordination, Test Execution, Scripting, Accessibility QA, Automation Management, Documentation Review, Requirements Validation, UAT Management.

• Execute SQL queries and commands to set up and test the ETL process and databases
• Analyzing and evaluating data sources, data volume, and business rules.
• Support the client teams to execute user acceptance testing (UAT)
• Review input and output test scenarios at use case levels and ensure there is test coverage for all scenario types
• Involved in requirement understanding and interacting with the dev team/BA on various aspects
• Actively involved in test preparation activity such as test cases, test data setup, test execution and ensure test coverage is 100% against requirement
• Understanding ETL deliverables and being able to create AI graphs wherever required to minimize manual efforts
• Highlight the risks, Report/Escalate issues to the test manager/program manager as appropriate
• Provide guidance to other team members on technology/domain/application queries
• Explore automation area using Unix/python scripting wherever possible and should be comfortable in writing scripts in Unix/python
• Publish daily/weekly test execution progress reports.
• Ensure that test case execution and defect status are reported in concise form in progress reports
• Provide guidance to other team members on technology/domain/application queries
• Understand Databases and data flows to help the team with the setup of test scenario data
• Develop automated test scripts using existing new frameworks
• Work closely with individual teams to walk through and understand development and test lifecycle and build integration testing strategy plans
• Provide recommendations on Automation framework and bring new thought leadership enabling the team to move fast

Skills: SQL Proficiency, Data Analysis, UAT Support, Scenario Testing, ETL Knowledge, Risk Identification, Scripting, Automation Development.

• Experience in QA
• Experience in a variety of delivery models, including Agile, Iterative, and Waterfall
• Familiar with Various Testing Techniques
• Familiar with Various Test and Defect Management Tools, such as JIRA
• Ability to Lead/Mentor Other Team Members, on and offshore
• Able to Offer Recommendations for Process Improvement and Carry Out a Plan to Implement Changes
• Familiar with various technologies, including but not limited to Unix, SQL, SOAPUI, Informatica, and Business Objects. 
• Strong SQL and ETL testing experience is required for this position. 
• Experience testing web services 
• Experience testing mobile apps - Android and IOS. Must have experience with Agile. 
• Must have hands-on experience with service testing

Qualifications: BS in Computer Science with 8 Years of Experience

• Experience in QuerySurge Automation Tool.
• Good debugging and analysis knowledge in Informatica and Oracle issues.
• Having experience in Control-M execution.
• Work experience in Tech upgrade projects will be having advantage.
• Good knowledge of Testing Methodology.
• Good SQL knowledge and should be able to write, and understand SQL queries
• Proven ability to work independently or as a team member
• Extensive experience with creating SQL queries (Selects, Joins, subqueries)
• Strong grasp of the Agile QA process
• Excellent listening, oral, and written communication skills
• Highly detail-oriented and well-organized

Qualifications: BS in Information Systems with 3 Years of Experience

• Good hands-on experience in ETL Testing
• Hands on knowledge of SQL Server.
• Ability to write complex SQL queries.
• Ability to understand the business functionality and write manual test cases
• Good experience in defect tracking, defect triage, HP ALM/JIRA/TFS.
• Good analytical thinking and problem-solving skills
• Good communication skills
• Ability to interact with the Client team and offshore Lead
• Strong interpersonal and teamwork skills
• Experience with creating SQL views/materialized views
• Experience with Informatica, PL/SQL
• Experience with Reports Testing
• Ability to balance multiple projects

Qualifications: BS in Data Science with 8 Years of Experience

• Experience in testing ETL and Data Warehouse applications in a cloud environment
• Experience in writing SQL Queries
• Experience in REST API testing and working with tools such as Postman to test API calls
• Experience with scripting skills around test automation like Python with Selenium or Java with Selenium
• Experience in creating test plans and test cases based on business requirements.
• Thorough knowledge of fundamental quality assurance concepts and best practices
• Ability to communicate effectively with both technical and non-technical team members
• Demonstrated attention to detail, commitment to continuous improvement, and focus on excellence in work product delivery
• Demonstrated an ability to use quantitative data to inform decisions
• Strong team player who can build and maintain strong relationships across a matrixed organization
• Strong ability to direct and handle multiple, simultaneous projects under deadline pressure and in a fast-paced environment
• Flexibility/adaptability - comfortable working with ambiguity and continually evolving priorities

Qualifications: BS in Software Engineering with 6 Years of Experience

• Experience using ETL testing tools
• API Automation Testing experience
• Strong SQL (SSMS, SQL, SSIS, SSRS, tSQLt, HVR) knowledge to work with ERP team
• Exceptional written and oral English communication skills 
• Superior organizational skills, self-driven with attention to detail, and follow-through on tasks
• Experience using Artificial Intelligence to monitor ETL processes
• UI Automation Testing experience
• Knowledge of the Big data ecosystem
• Good knowledge of Kafka, Hive, and Hadoop and able to test both Structured and unstructured data.
• Able to showcase different testing methodologies for testing Structured and unstructured data
• Strong testing knowledge of data testing, data lineage, data analysis, and data profiling 
• Knowledge of Informatica, ETL testing
• Strong analysis and problem-solving skills.
• Very good communication and interpersonal skills are necessary to be able to interact with a diversified team, and ownership the ability to deliver tasks.

Qualifications: BS in Business Analytics with 6 Years of Experience

• Excellent working knowledge of Test Plans, Test Strategies, Test Estimates, Test Requirements and Test Case.
• Experience in creating traceability matrix mapping Test Scenarios / Test Cases with requirements.
• Solid Back back-end testing experience in writing complex SQL Queries.
• Experience in agile testing methodologies
• Experience in working with diverse teams: Onsite - offshore model
• Strong knowledge in writing complex queries for validation of the ETL process
• Strong technical background problem-solving and analytical abilities
• Strong knowledge and hands-on experience in Data concepts, ETL tool (Ab-Initio, Informatica), Data Warehousing, SQL scripting with exposure to Unix, Mainframes
• Ability to work under tight deadlines whilst maintaining quality alongside driving test execution independently along with exposure to automating ETL area.
• Knowledge of Informatica, Ab-initio, Unix, Oracle, Teradata, Mainframe Basics
• Awareness of modern programming languages like Python
• Exposure to Automation framework, scripting skills

Qualifications: BS in Information Technology with 5 Years of Experience