Durai Murugan

Built enterprise ETL/ELT pipelines supporting large-scale data ingestion from Oracle into Snowflake for analytics workloads. Migrated more than 70% of Oracle tables to Snowflake, ensuring accurate schema mapping and consistent downstream data consumption. Developed scalable Python and SQL transformation pipelines for validating, transforming, and loading large enterprise datasets. Implemented dbt-style transformation workflows to standardize data modeling and improve maintainability of analytics datasets. Designed enterprise database schemas using PowerDesigner and deployed standardized data warehouse tables in Snowflake. Utilized AWS S3 as a landing data lake for staging raw data before loading into warehouse systems. Orchestrated production data pipelines using Control-M, ensuring reliable dependency-driven execution of enterprise workloads. Developed automated data validation scripts in Python to detect anomalies and notify stakeholders of pipeline issues. Built a Jenkins-driven AWS EC2 provisioning pipeline, reducing infrastructure setup time from 4 hours to 30 minutes.