What You'll do:

• Work with Product development team / Business Analysts, BI Developers to translate Business requirements into Test Cases
• Responsible for validating the data sources, extraction of data, applying transformation logic, and loading the data in the target tables.
• Designing, documenting, and executing test plans, test harness, test scenarios/scripts & test cases for manual, automated & bug tracking tools.

What makes you a great fit:

• Experience in ETL / BI Testing, using any ETL and Reporting Tool with Oracle / SQL Server / as Database.
• Expertise in any 2 ETL tools (Informatica, Talend, Matillion, Data Stage), and hosting technologies like the AWS stack (Redshift, EC2) is mandatory
• Extensive experience in writing and troubleshooting SQL Queries using any of the Databases Redshift / SQL Server / Oracle
• Expert knowledge of Power BI, SQL with the capability to performance tune complex SQL queries in tradition and distributed RDDMS systems is must.
• Exposure to Data Warehousing and Dimensional Modelling Concepts
• Experience in understanding of ETL Source to Target Mapping Document
• Experience in testing the code on any of the ETL Tools Informatica PowerCenter / Microsoft SSIS / SnapLogic / DataStage
• Experience in Validating the Dashboards / Reports on any of the Reporting tools – Tableau / SAP Business Objects / MicroStrategy
• Hands-on experience and a strong understanding of the Software Development Life Cycle (SDLC) and Software Testing Life Cycle (STLC).
• Good experience of Quality Assurance methodologies like Waterfall, V-Model, Agile, Scrum.
• Well versed with writing detailed test cases for functional & non-functional requirements.
• Experience in different types of testing that includes Black Box testing, Smoke testing, Functional testing, System Integration testing, End-to-End Testing, Regression testing & User Acceptance Testing (UAT) & Involved in Load Testing, Performance Testing & Stress Testing.
• Expertise in using TFS / JIRA / Excel for writing the Test Cases and tracking the Defects
• Experience in scripting languages like Python to create automated Test Scripts or Automated tools like Query Surge will be an added advantage
• An effective communicator with strong analytical abilities combined with skills to plan, implement & presentation of projects.