Abirami Rajendran

• Developed and maintained scalable data warehouse solutions using Snowflake, Oracle SQL, and PL/SQL for enterprise banking applications.
• Participated in large-scale data migrations from Oracle databases to Snowflake with Informatica Intelligent Cloud Services.
• Designed Snowflake database objects including tables, views, materialized views, external tables, and stored procedures.
• Implemented Snowpipe for continuous data ingestion from AWS S3 into Snowflake for near real-time processing.
• Created external stages and tables to access files stored in AWS S3 environments.
• Loaded structured and semi-structured data formats such as CSV, JSON, and Parquet into Snowflake via automated ingestion pipelines.
• Maintained Snowflake streams and tasks for change data capture activities and automated workflows.
• Utilized time travel and zero-copy cloning for effective data recovery and environment management.

• Optimized query performance and execution efficiency with Snowflake's query profile and best practices.
• Developed secure and materialized views to improve business reporting and enable effective data sharing.
• Crafted complex SQL queries using joins, subqueries, CTEs, aggregates, windows functions, and set operators.
• Utilized data warehousing concepts like star and snowflake schemas for effective database structuring.
• Created transformation logic in IICS to streamline ETL workflows and ensure data quality.
• Implemented data validation processes ensuring accuracy during system migration and integration.
• Collaborated with analysts and architects to convert business needs into technical solutions.

Domain: Investment Banking

· Supported ETL production environments and batch workflows.

· Monitored data loads and resolved production incidents.

· Developed SQL scripts for troubleshooting and data validation.

· Performed source-to-target reconciliation and performance analysis.

· Ensured SLA compliance for data processing activities.