No more applications are being accepted for this job
- 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.
- 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
- Handson 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 & nonfunctional requirements.
- Experience in different types of testing that includes Black Box testing, Smoke testing, Functional testing, System Integration testing, EndtoEnd 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.
ETL Tester - Delhi, India - Axtria India Pvt Ltd
Description
What will you do :
Knowledge of DWH processes, good in SQL, should have tested ETL workflows. Plus, basic knowledge of Python, experience in automation is preferred but not mandatory.