ETL Tester - Delhi, India - Axtria India Pvt Ltd

    Axtria India Pvt Ltd
    Axtria India Pvt Ltd Delhi, India

    Found in: Talent IN 2A C2 - 1 week ago

    Default job background
    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.

    • 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.
    Required Technical and Professional Expertise :

    • 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.
    )