- 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.
- 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.
Axtria - Testing Engineer - ETL/Datawarehouse Testing - Noida/Greater Noida/Gurgaon/Gurugram, India - Axtria India Pvt Ltd
Axtria India Pvt Ltd
Noida/Greater Noida/Gurgaon/Gurugram, India
Found in: Talent IN 2A C2 - 5 days ago
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.
What will you do :
Required Technical and Professional Expertise :