Ajit Jinarali
Bangalore
Summary
- 4.5 years of Professional Experience in DWH Testing / ETL Testing, Manual Testing, Functional Testing in different QA environments and platforms.
- Writing Test Cases and Test Scenarios, Perform Test Execution and other activities of testing with a concentration on requirements.
- Experience in handling and perform data validations with SQL Queries.
- Hands on Experience in Defect life cycle.
- Good exposure in Bug Tracking tools like HP ALM, Jira.
- Understanding of the SDLC and STLC.
- Basic Knowledge on Python.
- Excellent Written and verbal communication skills, Interpersonal skills and Team working skills.
Overview
4
4
years of professional experience
Work History
ETL Tester
Qualitest
Bangalore
07.2020 - 10.2022
- Understanding of ETL Source to Target Mapping Document and Transformation logic.
- Designing Test Scenarios and Writing Test cases, Perform Test Execution, writing SQL queries
- Uploading test cases in HP ALM.
- Test Execution and fixing identified defects in HP ALM, Jira
- Validating the data sources, extraction of data, applying transformation logic, and loading the data in the target tables.
- Validating the column mapping between source and target.
- Validating the records count between source and target.
- Ensure that No Duplicates values populated in target.
- By using MINUS Query make sure that Expected result loaded into target as per requirement.
- Also we do SCD Type 2 validation for Initial and Incremental load.
ETL Tester
Speridian Technologies
Bangalore
07.2018 - 06.2020
- Understanding of ETL Source to Target Mapping Document and Transformation logic.
- Designing Test Scenarios and Writing Test cases, Perform Test Execution, writing SQL queries
- Uploading test cases in HP ALM.
- Test Execution and fixing identified defects in HP ALM, Jira
- Validating the data sources, extraction of data, applying transformation logic, and loading the data in the target tables.
- Validating the column mapping between source and target.
- Validating the records count between source and target.
- Ensure that No Duplicates values populated in target.
- By using MINUS Query make sure that Expected result loaded into target as per requirement.
- Also we do SCD Type 2 validation for Initial and Incremental load.
Education
Diploma -
Board Of Technical Education
Bangalore, India01-2018
Skills
- DWH Testing
- Writing Test cases
- SQL Server
- Agile Methodology
- ETL Testing
- Test Execution
- SQL
- Functional Testing
- Informatica
- Bug Tracking
- Black Box Testing
- Oracle
- HP ALM
- Jira
Projects
- Wegmans Food Market, Wegmans, USA, 08/01/20, 09/01/22, Helping Customers to live a healthier, better life through food. Our commitment to you is simple: Every Day You Get our Best. Our customers tell us they choose Wegmans for the helpful people in our stores, help with delicious meals from our chefs, and the freshest ingredients possible. Offering choice, quality and value in every aisle is how we hope to make your shopping experience a genuine pleasure.
- Insurance Australia Group Limited, IAG, Australia, 01/01/20, 06/01/20, IAG is a life Insurance Business that consists of modules like new Business, Policy services, Re-insurance Agency, Moment, Client data bank, and Accounts. New business is a business brought by the agent and his business is called a Proposal. Proposals will be approved by underwriters to convert into a policy. These underwriters check for all the eligible criteria like Clients annual income, age, health, etc along with this proposal needs more amount of money in suspense to convert into a policy. This includes internal and external funds maintenance for the injurer. Agency module maintains all the details about individual and company agent. Moment module maintains all the modification details of the insurer.
- Telefonicom, Telefonica, US, 01/01/19, 11/01/19, It is one of the largest telecommunications service providers in the world. The company offers fixed and mobile connectivity as well as a wide range of digital services for residential and business customers. With 369 million customers, the company operates in Europe and Latin America. Telefonica is a 100% listed company and its shares are traded on the Spanish Stock Market and on those in New York and Lima.
Job Title
Software Test Engineer
Roles And Responsibilities
- Understanding of ETL Source to Target Mapping Document and Transformation logic.
- Designing Test Scenarios and Writing Test cases, Perform Test Execution, writing SQL queries.
- Uploading test cases in HP ALM.
- Test Execution and fixing identified defects in HP ALM, Jira.
- Validating the data sources, extraction of data, applying transformation logic, and loading the data in the target tables.
- Validating the column mapping between source and target.
- Validating the records count between source and target.
- Ensure that No Duplicates values populated in target.
- By using MINUS Query make sure that Expected result loaded into target as per requirement.
- Also we do SCD Type 2 validation for Initial and Incremental load.
Timeline
ETL Tester
Qualitest
07.2020 - 10.2022
ETL Tester
Speridian Technologies
07.2018 - 06.2020
Diploma -
Board Of Technical Education