Lohith S G

ETL Test Engineer with 5+ years of experience in validating data warehouses and ETL processes using Informatica and Oracle. Seeking a challenging position in a growth-oriented organization where I can leverage my skills in SQL, data validation, and defect management to ensure the accuracy and reliability of business-critical data.

• Having 5 years 5 months of Experience as ETL Testing.
• Strong in SQL.
• Extensive experience in Black Box Testing.
• Good experience in Test Case Development and Execution.
• Effective in Defect tracking and Bug Reporting in Bug Tracking tool.
• Hard working, Self-directed individual and have always demonstrated a good record of completing projects with high quality and on schedule.
• Experienced in Integration Testing, Regression Testing of various applications.
• Well acquainted with Software Test Life Cycle.
• Involved in writing Test cases and executing the test cases.
• Involved in Functional, Integration, System, Smoke and Sanity Testing.
• Commitment, result oriented and interested to learn new technologies.
• Innovative mind and Interest in learning new concepts, skills and implementing.
• Good knowledge on Data Warehouse and ETL process.
• Experienced on waterfall and Agile Methodologies.

Project Experiences:

Project # 2 : Cnet

Client : Careernet Technologies

Environment   : Oracle 10g, Informatica 9.6, windows,

Role : Software Test Engineer

Description : Careernet is an Indian company specializing in holistic talent solutions, providing services like recruitment process outsourcing, permanent hiring, professional staffing, and more. They offer services to various sectors including technology, banking, and financial services. Through a network of specialized companies, we connect great people with great opportunities, helping businesses win and careers soar and the company needs various reports based on its requirement like candidate report, Management report, Revenue report, billing report for clients and vendors and various other reports daily, weekly, and monthly for its smooth functioning and better client satisfaction and business growth.

Responsibilities:

· Understanding the Requirement Specification and Design documents.

· Running the Jobs/Workflow for ETL process.

· Verifying the data in target database after ETL proces.

· Prepared and ran SQL queries to verify Dimensional and Fact tables.

· Prepared test data for testing.

· Verifying the data which is loaded into target database.

· Performed column data mapping between source & target database.

· Developed, Reviewed & Executed Test Scripts and Designed test data.

· Identified Test Scripts for Regression testing.

· Reporting daily testing status report.

· Interactions with BA & Dev teams to resolve the issues.

· Defect Analyzing and Reporting in QC.

PROJECT # 1

Project Name  : HPT

Client  : Hirepro technologies

Technology : Oracle 10g, Informatica, windows 

Role : Associate Test Engineer

Description  : HirePro provides a range of services focused on streamlining and enhancing the hiring process, particularly for large-scale and campus recruitment. Their solutions include virtual hiring platforms, assessment services, interview services, and onboarding processes. They leverage AI and automation to make hiring more efficient and effective. and the company needs various reports based on its requirement like candidate report, PnL, Revenue report, billing report for clients and vendors and various other reports daily, weekly, and monthly for its smooth functioning and better client satisfaction and business growth.

Responsibilities:

· Understanding Requirement Specification and Design Documents.

· Performed column data mapping between source & target database.

· Creating test cases from the user stories or from test scenarios.

· Involved in writing test cases and execution of test cases.

· Running the Jobs/Workflow for ETL process.

· Prepared and ran SQL queries to verify Dimensional and Fact tables.

· Verifying the data in target database after ETL process

· If any defect found, report it to developer and fix it.

· Interactions with BA & Dev teams to resolve the issues.

· Identified Test Scripts for Regression testing.

· Reporting daily testing status report.