ETL Testing
Job Location
Published By
Tavant Technologies
Type of Job
Full Time
Published Date
About the job
Job Description :
• 3 – 5 Years of experience in ETL and Datawarehouse Testing
• QA Testing professional who will work directly with the Development team to validate Business Intelligence solutions.
• Build test strategy and test plans and test cases for Informatica MDM, ETL (SSIS), Power BI, MS Azure Data Lake, Azure Data Warehouse.
• Write MS SQL queries to validate the test cases and test results.
• Work with Business Analysts, 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 Data Warehousing / BI Testing, using any ETL and Reporting Tool with SQL Server or Azure Data Lake
• Extensive experience in writing and troubleshooting SQL Queries using any of the Databases –SQL Server
• 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 Tool - Microsoft SSIS Experience in Validating the Dashboards / Reports on any of the Reporting tools – Power BI
• Hands-on experience and strong understanding of Software Testing Life Cycle (STLC).
• Good experience of Quality Assurance methodologies like Agile, Scrum.
• Well versed with writing detailed test cases for functional & non-functional requirements.
• Expertise in using TFS / Excel for writing the Test Cases and tracking the Defects.
• An effective communicator with strong analytical abilities combined with skills to plan, implement & presentation of projects
Requirements
Job Description:
• 3 – 5 Years of experience in ETL and Datawarehouse Testing
• QA Testing professional who will work directly with the Development team to validate Business Intelligence solutions.
• Build test strategy and test plans and test cases for Informatica MDM, ETL (SSIS), Power BI, MS Azure Data Lake, Azure Data Warehouse.
• Write MS SQL queries to validate the test cases and test results.
• Work with Business Analysts, 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 Data Warehousing / BI Testing, using any ETL and Reporting Tool with SQL Server or Azure Data Lake
• Extensive experience in writing and troubleshooting SQL Queries using any of the Databases –SQL Server
• 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 Tool - Microsoft SSIS Experience in Validating the Dashboards / Reports on any of the Reporting tools – Power BI
• Hands-on experience and strong understanding of Software Testing Life Cycle (STLC).
• Good experience of Quality Assurance methodologies like Agile, Scrum.
• Well versed with writing detailed test cases for functional & non-functional requirements.
• Expertise in using TFS / Excel for writing the Test Cases and tracking the Defects.
• An effective communicator with strong analytical abilities combined with skills to plan, implement & presentation of projects
Job Type:PermanentNo of Vacancy:3Gender:BothAge Limit:NAExp Required:3 - 8 YearsSalary:INR 4,00,000 - 15,00,000 PAUG Qualification:ComputersPG Qualification:ComputersPHD Qualification:NoneCandidate Profile:
MUST HAVES:
Notice Period | 30days or less
Industry:IT-Software / Software ServicesFunctional Area:IT Software - Application Programming, Maintenance (Software Developer)
Benefits
Salary:INR 4,00,000 - 15,00,000 PA
Address
Bengaluru, Karnataka, India