Pooja Kotagi

Results-driven Data Engineer / Snowflake Developer with 4+ years of experience in designing, developing, and optimizing scalable cloud-based data platforms and ETL/ELT pipelines. Strong expertise in Snowflake, DBT, SQL, AWS S3, and Azure Data Factory (ADF), with proven experience in building efficient data workflows, implementing data transformation frameworks, and improving query performance. Skilled in delivering reliable, high-quality data solutions and supporting enterprise-scale data environments across Healthcare and Semiconductor domains.

Adept at collaborating with cross-functional teams to drive data-driven business outcomes and operational efficiency.

Snowflake Developer at Santrotech Software Technologies Pvt. Ltd (2025-02 – Present)

Snowflake Developer at Broadcom Inc. USA (2023-12 – Present)

Broadcom Inc. is a global technology leader that designs, develops and supplies semiconductor and infrastructure software solutions.

• Involved in implementation and support of ETL workflows for cloud-based data warehousing solutions.
• Supervised data ingestion workflows using Azure Data Factory (ADF) pipelines.
• Orchestrated the movement of data from Azure Data Lake (ADLs) into Snowflake staging areas through ADF pipelines.
• Managed data loading into Snowflake static tables from internal staging environments.
• Directed task assignments and workflow distribution among team members.
• Created views with complex join conditions for enhanced reporting capabilities.
• Implemented data transformations using DBT, including the creation of models, Incremental model and Snapshots, Macro, Prehook and Post hook.
• Configured and managed ADF pipelines, incorporating looping constructs like "for each" activities.

ETL Developer and Team Member at Stryker (2023-01 – 2023-11)

Stryker is one of the world's leading medical technology companies and, together with its customers, is driven to make healthcare better.

• Led the end-to-end management of ETL workflows for a large-scale Snowflake data warehouse, encompassing design, implementation, administration, and ongoing support.
• Executed bulk data loads from AWS S3 into Snowflake.
• Applied the COPY command to transfer data into Snowflake from external storage stages.
• Managed the data loading process into Snowflake tables from both internal staging areas and local sources.
• Utilized commands like COPY, LIST, PUT, and GET to oversee and verify files in internal and external stages.
• Coordinated data transfers between Snowflake internal stages and external sources such as S3 buckets.
• Developed intricate SnowSQL scripts to facilitate business analysis and generate reporting insights within Snowflake.
• Directed task allocation and managed the distribution of work among team members.
• Performed troubleshooting and resolved critical ETL issues as they arose.
• Implemented performance enhancement strategies, including clustering keys and auto scaling, to optimize data loading and query execution.
• Ensured data accuracy by validating source-to-target data consistency using load and copy history records.
• Crafted advanced queries in Snowflake using various join types, such as left, right, and full outer joins.
• Developed and maintained Snowflake views, materialized views, and stored procedures to support business requirements.

M.Tech in Geo-Technical Engineering – B.K.I.T, Bhalki (2015)

B.E in Civil Engineering – B.K.I.T, Bhalki (2013)