Data Analyst @ Business Intelligence Unit
Worli, Maharashtra, India
Automated the end-to-end process of extracting and loading KRA data into Oracle DataMart using Informatica ETL tools. Key achievements include:1) ETL Automation: Completely automated the extraction and loading process, significantly improving efficiency and accuracy, Designed specific mappings and workflows to support features like Truncate, Append, and Update with a single click.2) Scalable SQL Logic: Enhanced the SQL code to facilitate regular data loading intervals, incorporating intelligent selections, adhoc capabilities, variable usage to reduce data redundancy, and real-time error handling via email notifications.