Shiva Panchal

Helped multiple US FSO Banking & Capital Markets clients in setting up Datawarehouse , ETL, cloud modernization, data modeling, client gaps and requirement analysis, data extraction, data loading, and scheduling.

Expertise in estimating ETL requirements and designing.

Prepared and gathered data for modeling purposes.

Maintained Data Warehouse using Snowflake stored procedures.

Managed Raw, Stage, Conformed, and EDW layers within Data Warehouse.

Migrated On-Premise Data Warehouse to cloud environment utilizing Azure and Snowflake.

Created Power BI reports on Semantic Database for customer visualization.

Developed Data Platform for Star Billing to facilitate interchange fee charging like VISA cards.

Designed ETL workflows and mappings to ensure timely code delivery.

Gathered and analysed client requirements to drive project success.

Created business documents and maintained mapping sheets for clear communication.

Developed Informatica mappings, Snowflake stored procedures, and UNIX scripts per specifications.

Designed ETL workflows and mappings, ensuring timely delivery of code.

Created mapping templates using Power Center Mapping Architect for multiple business logic applications.

Designed new mappings with Informatica tools including Source Analyzer and Warehouse Designer.

Implemented Change Data Capture logic on Hadoop cluster utilizing Informatica Developer.

Executed data quality rule implementation, modifications, and testing.

Applied data quality governance processes to ensure compliance and standards.

Conducted data quality tests at source level using Informatica IDQ.