Saikumar P

One of the leading technology-driven consumer health care and health insurance companies is focused on health insurance and unsecured consumer lending products. Their vertical – Enterprise Data Services include building a data warehouse to enhance better Decision Science process and health insurance decisions.

Roles and Responsibilities:

· Involved in developing the ETL process (weekly, daily, delta, and bulk processes).

· Monitored and managed workflows using Apache Airflow.

· Developed data pipelines following Medallion Architecture (Rawz, Cnfz, Pubz) to support analytics and reporting use cases.

· Collaborated with data analysts, Tableau teams, and downstream consumers to deliver analytics-ready datasets.

· Drove the end-to-end migration of existing AWS-based data pipelines to Databricks, improving scalability, performance, and maintainability while ensuring minimal disruption to ongoing workflows.

· Monitored production Databricks workflows and Amazon CloudWatch, ensuring 99.9% data availability.

· Performed daily production monitoring and proactively managed Databricks job failures to ensure pipeline stability.

· Configured automated notifications via Webhooks (Webex) to proactively identify job failures or long-running tasks before business impact.

Description:

Contributed to Enterprise Data Services for a leading technology-driven healthcare and health insurance organization, supporting the development of a centralized data warehouse to enhance decision science capabilities and optimize health insurance analytics and business outcomes.

Roles and Responsibilities:

• Involved in developing the ETL process (weekly, daily, delta, and bulk processes).
• Monitored and managed workflows using Apache Airflow.
• Developed data pipelines following Medallion Architecture (Rawz, Cnfz, Pubz) to support analytics and reporting use cases.
• Collaborated with data analysts, Tableau teams, and downstream consumers to deliver analytics-ready datasets.
• Drove the end-to-end migration of existing AWS-based data pipelines to Databricks, improving scalability, performance, and maintainability while ensuring minimal disruption to ongoing workflows.
• Monitored production Databricks workflows and Amazon CloudWatch, ensuring 99.9% data availability.
• Performed daily production monitoring and proactively managed Databricks job failures to ensure pipeline stability.
• Configured automated notifications via Webhooks (Webex) to proactively identify job failures or long-running tasks before business impact.
• One of the leading technology-driven consumer health care and health insurance companies is focused on health insurance and unsecured consumer lending products. Their vertical – Enterprise Data Services include building a data warehouse to enhance better Decision Science process and health insurance decisions.

Short tenure focusing on system engineering and project support. System Engineering tasks created to project requirements.

Description:

• Prepared comprehensive techno-economic feasibility reports and pre-investment studies covering market analysis, financial forecasting, plant & machinery selection, manufacturing processes, and cash flow projections. Supported investment decision-making, corporate diversification planning, and new industrial project setup through detailed market surveys, cost estimation, and strategic business analysis.

Roles and Responsibilities:

• Interacting with the client for enhancements and changes
• Attending Daily client calls
• Involved in writing high-level design (HLD) and low-level design (LLD) documents for Informatica components during the design phase
• Developed Informatica mappings Type-I & Type-II SCDs using various transformations like Expression, Router, Update strategy, etc.
• Developed mapping for Fact loading
• Prepared the required Unit test cases for assigned tasks to self-review the test cases
• Implemented a logic by which the incremental load is handled in all the mappings
• Implemented error handling strategy
• Analyse the mapping specification to understand the business logic.
• Mainly involved in ETL development
• Analysed the Source and Target databases to understand the business.
• Involved in production issues.
• Design and execution of Test Cases based on the test scenarios and business requirements.
• Involved in System Integration Testing.
• Wrote complex SQL queries to validate the data flow.
• Sending daily status reports to onsite count
• The Auto Components Manufacturers Association (ACMA)