SHIVANAND C

PROJECT : Swiggy INstamart

Environment : Oracle, Talend, SQL Devloper

Role : ETL Tester

Description :

The project involved enhancing the Data Warehousing (DWH) solution for Instamart, a leading online grocery delivery service. The objective was to optimize the entire data flow, improve delivery operations, and enhance overall system performance. This included refining data integration processes, improving data quality, and optimizing reporting systems to enable real-time insights into inventory management, order processing, and customer demand, supporting faster and more accurate business decisions. Additionally, the focus was on performance optimization by streamlining the ETL processes and reducing data latency. These improvements ensured that the system could handle increasing transaction volumes while maintaining high efficiency. The enhanced DWH solution enabled better scalability, faster reporting, and ultimately contributed to more effective business operations, improving both operational efficiency and customer experience.

Roles and Responsibilities :

• Understanding business requirements to create effective test plans
• Writing test cases and scenarios based on the requirements
• Creating SQL queries to check data accuracy
• Preparing the test data needed for testing
• Running test cases and checking for issues
• Logging any defects found during testing
• Coordinating with developers to fix defects
• Preparing test status reports and updates

PROJECT : Insurance Data Hub
Environment : Oracle, Talend, SQL Devloper
Role : Test Engineer

Description :

The project focused on the data warehousing solution for Insurance Times, a life insurance product with modules like New Business, Policy Services, Re-insurance, Agency, Moment, Client Data Bank, and Accounts. Key tasks involved validating data integration for proposals evaluated by underwriters, managing agent and client details, and ensuring accurate policy and fund data. As an ETL Tester, responsibilities included testing data pipelines, verifying transformations, ensuring data accuracy across modules, and supporting analytics and reporting for business insights.

Roles and Responsibilities :

• Understanding business requirements to create test plans
• Writing test cases and scenarios based on requirements
• Using SQL queries to check data accuracy
• Preparing test data for different testing needs
• Running test cases to identify issues
• Logging defects and working with developers to fix them
• Preparing and sharing test status reports