CHETANA SIROHI iamchetana45@gmail.
com
7019518725
Bangalore
Summary
• Overall 3 years of experience in DATAWARE HOUSE testing.
• Good knowledge on ETL/DWH and Manual testing.
• Good knowledge on Data ware house concepts like star schema, Snow
flake schema, Dimension Table, Fact Table etc.
• Hands on experience in writing SQL queries Preparing test cases.
• Having complete Defect life cycle knowledge of data ware housing.
• Hands on experience on QC,JIRA.Experience on Oracle data base.
• Good knowledge in slowing changing dimension(SCD), different schemas.
• Experience in Workflow Manager, Workflow Monitor in Informatica.
• Experience and knowledge in data ware housing using data extraction,
data transformation and data loading(ETL).
Experience think and learn pvt ltd March 2020 - Nov 2022
Quality analyst
Aegis Jan 2019 - March 2020
Operations
Skills Etl testing , DWH testing
Sql, Unix
Jira, Hplam
Teradata, Oracle
Projects Byjus Finance
Role : Senior Tester
Environment : Teradata and Informatica,
JIRA,Tabluea, GitBash, Unix
DESCRIPTION:
Based on the products calculating the loans amount to be paid, active loans , closed loans and emi pending , over due emi ,
upcoming loans with vendors.
Responsibilities
• Analysing the transformation rules in mapping documents as per client
requirements.
• Understanding the Informatica mappings and work flow. Developing
Test Scenarios and Test Cases for each sprint.
• Uploading test cases in to JIRA. Execution of Test Cases and
reporting the bugs through defect tracking tool-JIRA.
• Validating data in target database according to business rules. Preparing
SQL queries to validate the ETL processed data in target database.
Verifying the column mapping between source and target database.
Verifying the records count between source and target database
• Defect logging in JIRA. Analyzing Test Results and Reporting
Defects. Select Test cases for Retesting & Regression Testing
Flipkart Warehouse
DESCRIPTION: Its an e- commerce company deals with various online products .
It acts an online flatform for the customers and sellers.
Responsibilities
Finding issue from the customer regarding orders.
Escalating to the other teams if the query is regarding other department.
Solving issue by using various CRM tools to check order date and other things.
Refund issue , return issue , order related issue etc
Education
Kuvempu University
Bachelor of Science
—
Language Hindi, Kannada
