PRABHAKAR ALAGARSAMY

Results-driven professional with 17+ years of software development experience and 5.2 years of snowflake experience in solving complex challenges effectively. Possess strong development and performance engineering abilities to drive innovative solutions. Proficient in Snowflake, ETL, Oracle, SQL Server, AWS S3, IICS, and DB2. Actively involved in all phases of the Software Development Life Cycle (SDLC), ensuring timely delivery under tight deadlines. Specialize in ETL processes and Snowflake Data Warehouse solutions. Successfully collaborate with business analysts to implement data integration requirements provided by stakeholders. Solid understanding of data warehouse concepts including star schemas, snowflake schemas, fact tables, and dimension tables. Hands-on experience with Oracle, Snowflake, and DB2 databases, including developing Snowpipe for seamless data integration between AWS cloud and Snowflake Database. Skilled in writing SQL queries for transformation logic based on business requirements. Proficient in SDLC methodologies. Experienced with both Windows and UNIX operating systems.

· Client Name: Beirut Hellenic Bank, Australia

· Environment: Snowflake, DB2, Oracle.

· Tools: SSIS, IICS & JIRA

· Managed data migration from Oracle Database to Snowflake using flat files to facilitate application migration.

· Developed various Snowflake objects, including warehouses, schemas, databases, tables, views, pipes, stages, and scaling policies.

· Executed data utilization, role assignments, and structured data migration by creating stages and employing the COPY command for transformation.

· Implemented error handling, file formatting, and all relevant copy options during data migration.

· Client Name: Bucephale Finance, France

· Environment: Snowflake, DB2, Oracle.

· Tools: IICS, SSIS & JIRA.

· Experienced in loading unstructured data with minimal overhead using features like the VARIANT datatype, FLATTEN, and Parquet file formats.

· Developed Snowflake procedures, functions, and user-defined table functions (UDTFs).

· Created external tables to access data from files when direct access to AWS S3 was restricted.

· Tested transformation functions and record formats for various input data files.

· Client Name: Carlsquare, Germany

· Environment: Snowflake, DB2, Oracle.

· Tools: SSIS, IICS, JIRA

· Translated business requirements into complex SQL queries and subqueries, utilizing analytical functions, joins, and operators.

· Created Snowpipe to read data from AWS S3 and load it into Snowflake DB, ensuring seamless and continuous data integration between Oracle and Snowflake databases.

· Designed Snowflake tasks as a task tree to process data from Snow Stream objects created on base tables, maintaining data backups during DML operations in the Snowflake database.

· Utilized secure views and materialized views to share data with partner applications based on data access requests.