Job Title

Senior ETL Tester

Company Name
Cambridge Technology Enterprises
Job Type
Full-time
Qualification
B.Tech/B.E.
Experience
4 Years  -  8 Years
Vacancies
1
Salary Offered
Not Disclosed
Job Category
Location
Hyderabad, Telangana, India
Job Description

We are seeing an experienced ETL tester, with Hands-on 4+yrs of experience in ETL/DWH-BI Testing in SSIS and Informatics & Minimum of 2+yrs experience in Database Testing using SQL Server & PostgreSQL. You are expected to be proficient in writing complex SQL queries, the ability to determine the types of testing that must be conducted (i.e., data validation, regression, etc.), including evaluating the testability of requirements and create a comprehensive test plan that supports the business and technological solutions being delivered.

Skills Required:
Thorough knowledge of Software Test Life Cycle, Test Case Life Cycle, Defect Life Cycle, etc. Proficiency with Test Case Preparation and Execution.
Knowledge and experience in data masking methodologies - Familiar with Meta Data Management tools, Data warehousing Concepts, ETL process standards & Data warehousing requirements
Extensive exposure to Back-end/ETL Testing with high-level SQL skills is required.
Experience in tuning SQL queries, Stored Procedures, Views, etc for performance improvements
Should have adequate experience and a clear understanding of data warehouse and data mart testing.
In-depth understanding of large-scale data, such as data warehouses and their best practice and principles for managing them
Strong technical capabilities and good knowledge of the coding languages commonly used in ETL development, such as Java, SQL, XML
Good interpersonal skills & Learn new technologies and undertake challenges

Roles & Responsibilities:
Write test scripts based on ETL mapping artifacts Execute scripts and detailed analysis of the scripts.
Running the jobs/Workflows for the ETL process
Perform data validation testing by writing SQL queries
Tune SQL queries, Stored Procedures, Views, etc for performance improvements
Validating the Data by using various checks: Schema Validation, Count Check, Reconciliation check, Null Validation Check, Auditing
Maintaining Test case Document, Defect Tracker, and Results of all validation in Excel as a deliverable
Raising defects in case of a code development issue and notifying the development team accordingly
Perform Initial data profiling and analysis and build a series of data quality scorecards classifying the areas of concern in the data
Develop and review Test Scenarios, Test Conditions, and Test Cases based on Business and Technical Requirements.
Prepare SQL Queries for test execution as per the business rules and transformation logic provided in the mapping documents.
Verify the Process by backtracking, and Front tracking by SQL and other methods.
Analyze source data before and after extracting to staging.
Understanding Verify Corrected, Cleaned, source data in staging.
Verify matched and consolidated data.
Verify the Transformations used in the ETL process against Business Specifications.
Defect logging, defect reporting, and tracking till the closure of the defect.
Continuous improvement of testing processes ensures quality product delivery and ensuring client satisfaction.
Checking data in databases, automating deployment and data generation for ETL flows

Recruiter's Name
--
Telephone
--
Posted Date
July 27, 2022
Additional information

--