Jobs

    Axtria - Testing Engineer - ETL/Datawarehouse Testing - Noida/Greater Noida/Gurgaon/Gurugram, India - Axtria India Pvt Ltd

    Axtria India Pvt Ltd
    Axtria India Pvt Ltd Noida/Greater Noida/Gurgaon/Gurugram, India

    Found in: Talent IN 2A C2 - 5 days ago

    Default job background
    permanent Technology / Internet
    Description

    Role :
    Testing Engineer - ETL/DWH Testing

    Experience : - 8 yrs.

    Job Location :
    Noida / Gurgaon


    Job Description :


    Axtria is a life sciences & Pharma analytics-focused global big data analytics and software technology company, we help Life Sciences companies to transform the product commercialization journey to drive sales growth and improve healthcare outcomes for patients.

    We are acutely aware that our work impacts millions of patients and leads passionately to improve their lives.


    What will you do :

    • Knowledge of DWH processes, good in SQL, should have tested ETL workflows. Plus, basic knowledge of Python, and 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.
    )