AYSHWARYA NAGARAJAN

PROJECT1: VISTRA

• Designed and built IICS mappings for data extraction from Oracle to Snowflake.
• Implemented Type 1, Type 2, CDC, and incremental load strategies in IICS.
• Conducted enhancement and maintenance activities for data warehouse performance.
• Developed Snowflake objects including warehouses, schemas, databases, tables, views, pipes, and stages.
• Created stored procedures and user-defined functions in Snowflake for advanced data processing.
• Worked closely with Business Analysts and End Users for gathering requirements and providing technical solutions during design phase .
• Monitored loading jobs on daily basis to ensure that all ETL jobs are running as scheduled.
• Optimized existing ETL processes by analyzing performance bottlenecks and implementing best practices in Informatica PowerCenter.
• Assisted QA team by providing necessary information which is needed while performing Unit Testing activities.
• Designed complex transformations using various transformation objects like Joiner, Lookup, Aggregator, Sorter in Informatica PowerCenter.

PROJECT 2: EVERCORE.

• Created ETL workflows and mappings using Informatica IICS to extract, transform, and load data from various sources to target systems.

• Applied complex transformation rules, such as Filter, Expressions, Aggregator, and Router transformations, and applied business logic within ETL processes to meet business requirements.

• Tuned ETL workflows for performance, handling large volumes of data efficiently, and reducing processing times.

• Managed the development, scheduling, and monitoring of Informatica IICS jobs and task flows.

• Worked with business analysts and data architects to understand data requirements, and deliver effective ETL solutions.

• Performed unit testing and validation to ensure the accuracy and correctness of data transformations.

• Implemented error logging and recovery mechanisms to manage failures, and minimize disruptions.

• Integrated ETL solutions with cloud platforms such as AWS and Azure to support scalable data management.

• Developed ETL workflows to support data migration and consolidation efforts.