Prashant Gondule

• Developed various Snowflake objects, including different table types (permanent, transient, temporary), for efficient data organization. Implemented stages, SnowPipe, for seamless data ingestion and automation.
• Optimized SQL performance by modifying and refining SQL logic, and refactored PL/SQL code to streamline processes and reduce execution time.
• Developed DBT objects, including models (incremental, ephemeral, and materialized views/tables), to transform raw data into analytics-ready datasets. Implemented snapshots and tests to track historical changes and improve data quality.
• Developed rules, classifications, plan components, and managed participants in SAP SuccessFactors Incentive Management to streamline incentive processes and enhance operational efficiency.
• Debugged and analyzed Azure Data Factory pipeline failures, checked logs to pinpoint errors, and monitored activity runs.
• UAT testing for developed code and low-level design document creation.
• Worked closely with diverse teams to gather requirements and address issues, ensuring smooth project delivery.

• Managed the complete development cycle of new system functionalities as per business requirements, made modifications to existing code, addressed bugs, and created documentation (IDQ, FRS, test document).
• Performed root cause analysis for ETL job failures and data issues raised by the business.
• Created various scripts, Informatica mappings/workflows, complex queries, and Autosys jobs.
• Addressed issues and incidents within the SLA timeframe raised by downstream teams due to data issues, process failures, incorrect data from the source, or bugs.
• Constructed Autosys objects such as watchers and jobs that initiate processes.
• Automated several existing application processes using Unix shell scripts and the Autosys scheduler.