Axtria - Ingenious Insights
Location
Noida | India
Job description
ETL -Testing Engineer ( ETL/DWH Testing) Experience – 3-8 yrs. Job Location – Noida/ Gurgaon
Job Description Axtria is life sciences & Pharma Analytics focused global big data analytics and software technology compan y, 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 lead 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, 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 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.Job tags
Salary
