Ramya Grandhe

Data Engineer / ETL Developer with three years of experience in data integration, ETL development, and database management. Proficient in SQL and Oracle SQL Developer, with a working knowledge of Python for data manipulation and automation. Hands-on experience in ETL, Informatica, Amazon Redshift, and data warehouse concepts. Strong ability to analyze, transform, and deliver accurate datasets to support business intelligence and reporting needs.

Projects:

1. Healthcare Equipment Finances (HEF):

Business Problem: End-to-end maintenance of this project under GEHC (General Electric Healthcare). It designs, develops, manufactures, and distributes diagnostic imaging and clinical systems.

Approach:

• Designed and maintained Informatica mappings and workflows for ETL processes.
• Maintain the above information in all the tables under the Informatica WF.
• Performed data quality checks and applied error-handling mechanisms.
• Assisted in production issue resolution, and monitored daily ETL jobs.
• Worked with business analysts to deliver datasets for dashboards and reporting solutions.

2. Data Migration to Redshift (Healthcare Domain)

Business Problem: Migration of the entire infrastructure, including servers, IAM roles of AWS, Informatica, and databases, due to the client company's separation from its parent organization.

Approach:

• Led the end-to-end migration process involving AWS Glue, Redshift, and Informatica.
• Oversaw server log purging and manual file placement using WinSCP to smooth data flow.
• Handled the starting and stopping of Informatica workflows and Teradata job chains at Redwood.
• Achieved accurate and efficient data migration by monitoring and troubleshooting ETL operations, yielding a 40% reduction in discrepancies.
• Updated and maintained Confluence documentation to reflect changes, and ensure team alignment.