Report

Zimetrics - ETL Tester - Python/Automation Testing

Salary

₹12 - 20 LPA

Min Experience

3 years

Location

Pune, Maharashtra, India

JobType

full-time

Overview

About the role

Job Description

Proficient in SQL, ETL, Python automation, API testing, and RESTful services.
Experienced in using Postman and JSON for RESTful web service testing.
Skilled in writing SQL queries to retrieve data from database tables, ensuring data integrity.
Well-versed in all stages of the Software Development Life Cycle (SDLC) and Software Test Life Cycle (STLC), with expertise in mapping business requirements to test cases using a Traceability Matrix.
Ability to analyze ETL requirements and mapping sheets in collaboration with Business Analysts.
Hands-on experience in Unit, System, Integration, Regression, UAT, and GUI testing.
Strong collaboration skills, working closely with testers and developers for defect analysis and bug fixes using tools like JIRA and X-ray.
Good understanding of UNIX commands for server data validation.
Experienced in data analysis, validation, cleansing, verification, and identifying data mismatches.
Skilled in mapping source and target data, assessing duplicates, counts, nullability, string lengths, data types, constraints, and lengths.
Expertise in Python-Selenium automation frameworks to streamline front-end validation
Developed and executed SQL queries to verify dimensional and fact tables, ensuring ETL transformation logic is correctly applied before data loading.
Validated data flow from the staging area to intermediate tables, including surrogate key checks.
Strong knowledge of data warehousing concepts, including OLAP, OLTP, Star Schema, and Snowflake Schema.
Capable of analyzing SRS to ensure alignment with customer requirements, with responsibilities in test case creation, execution, bug tracking, and reporting.
Actively involved in test case reviews, performing functional, integration, regression, retesting, sanity, and database testing.

(ref:hirist.tech)

Skills

sql

python

automation testing

api testing

restful services

postman

json

software development life cycle

software test life cycle

traceability matrix

etl

unit testing

system testing

integration testing

regression testing

uat

gui testing

jira

x-ray

unix

data analysis

data validation

data cleansing

data verification

data mismatch

data mapping

data duplicates

data counts

data nullability

data string lengths

data types

data constraints

data lengths

python-selenium

sql queries

etl transformation

data warehousing

olap

oltp

star schema

snowflake schema

srs

test case creation

test case execution

bug tracking

reporting

functional testing

integration testing

regression testing

retesting

sanity testing

database testing