Debadyut Sahoo

Data Engineer with less than a year in scalable data pipelines & ETL processes.

Caterpillar Inc.

Siksha 'O' Anusandhan University (ITER)

Bengaluru, Karnataka, India

Since April 28, 2026

About

Aspiring Data Engineer with strong expertise in building scalable data pipelines, ETL processes, and data integration workflows using SQL and Python. Experienced in working with Snowflake data platforms, automation tools, and modern data engineering frameworks to integrate and process structured datasets from multiple sources. Skilled in data validation, query optimisation, and automation workflows. Passionate about enabling data-driven decision making through reliable and efficient data infrastructure.

Top Skills

PythonNosqlOracleGitStreamlit

Skills

PythonPandasSQLSnowflakeNosqlOracleData ValidationData WarehousingGitStreamlitAWSAzureGoogle CloudExcelSharepointLucidchart

Education

Siksha 'O' Anusandhan University (ITER)

Bachelor of Technology (B.Tech) · Computer Science Engineering

August 1, 2022 – June 30, 2026

Experience

Caterpillar Inc.

Data Engineering Intern

January 1, 2026 – Present

Bengaluru, Karnataka, India

Projects

Oracle Loader Automation

April 28, 2026 – Present

Designed and deployed a Streamlit-based UI for an ETL pipeline, enabling end-users to seamlessly upload Excel and CSV datasets directly into specific Oracle database schemas and tables. Re-engineered the manual data ingestion workflow, reducing the loading time per run from 2 hours to just 3 minutes. Achieved a 99% improvement in processing efficiency, saving the organization approximately 400 hours of operational time.

ETL Audit Automation System

April 28, 2026 – Present

Developed and deployed an automated, 24/7 ETL audit tracking system on an enterprise Windows server using Python and Batch scripts. Engineered a continuous monitoring mechanism to log failed ETL jobs, capturing precise error codes and root causes to accelerate troubleshooting. Enhanced overall system reliability and pipeline uptime by enabling rapid identification and resolution of data integration failures.

Automated Snowflake Data Pipeline

April 28, 2026 – Present

Designed and implemented a scalable ETL pipeline to ingest Excel and CSV datasets into Snowflake using Python automation scripts. Built data extraction, transformation, and loading workflows using Pandas and SQLAlchemy to prepare data for analytical processing. Implemented automated validation checks to ensure data accuracy, completeness, and quality before loading.

Business Workflow Automation

April 28, 2026 – Present

Developed automated workflows using Microsoft Power Automate to streamline repetitive business processes and data transfer tasks, integrating enterprise applications and external APIs.

Key Strengths

Demonstrated practical experience in ETL pipeline design and automation using Python, Pandas, and SQLAlchemy, as evidenced by projects like 'Oracle Loader Automation' and 'Automated Snowflake Data Pipeline'.
Exposure to various data platforms including Oracle and Snowflake, with hands-on experience in data ingestion and validation.
Experience in developing user interfaces for data interaction using Streamlit, enhancing accessibility for end-users.
Proactive approach to improving operational efficiency and reliability through automation, as shown in the 'ETL Audit Automation System' project, which reduced loading times and tracked failures.
Current internship as a Data Engineering Intern at Caterpillar Inc. provides early exposure to enterprise data initiatives, stakeholder collaboration, and best practices in data pipeline development.

Cultural & Operational Fit

Cultural Fit Analysis

Insufficient Data due to a score of 0 on the psychometric test. The psychometric assessment, which is designed to evaluate aspects like logical reasoning, work attitude, stress handling, and team collaboration, yielded a score of 0. This indicates a critical lack of information regarding the candidate's cultural fit and fundamental workplace aptitudes.

Soft Skills & Operational Fit

AI is analyzing your overall score…

Identifying your key strengths…

Evaluating your skill match against the job requirements…

Key Strengths

Demonstrated practical experience in ETL pipeline design and automation using Python, Pandas, and SQLAlchemy, as evidenced by projects like 'Oracle Loader Automation' and 'Automated Snowflake Data Pipeline'.
Exposure to various data platforms including Oracle and Snowflake, with hands-on experience in data ingestion and validation.
Experience in developing user interfaces for data interaction using Streamlit, enhancing accessibility for end-users.
Proactive approach to improving operational efficiency and reliability through automation, as shown in the 'ETL Audit Automation System' project, which reduced loading times and tracked failures.
Current internship as a Data Engineering Intern at Caterpillar Inc. provides early exposure to enterprise data initiatives, stakeholder collaboration, and best practices in data pipeline development.

Cultural & Operational Fit

Cultural Fit Analysis

Soft Skills & Operational Fit