Diljot Singh
Bakersfield,CA
Summary
Computer Science graduate with 6 months of hands-on experience as a Data Analyst and Data Engineer Intern, working on data mapping (STTMs), QA collaboration, and cloud-based ETL pipelines. Proficient in Python, SQL, Databricks, and Azure Data Factory, with applied experience in machine learning and data-driven system design.
Overview
1
1
year of professional experience
Work History
Data Analyst
MS Staffing
Wayne, PA
12.2025 - Current
- Developed and maintained Source-to-Target Mapping (STTM) documents to define data transformations, business rules, and field-level mappings between source and target systems.
- Translated business and source system requirements into clear STTMs, ensuring accurate representation of data definitions, transformations, and constraints.
- Reviewed source data structures and highlighted potential data issues (nulls, duplicates, data type mismatches) during STTM creation.
- Assisted QA by explaining transformation logic, data rules, and edge cases documented in STTMs to ensure accurate test case development.
- Acted as a bridge between business, engineering, and QA teams by maintaining accurate and up-to-date STTM documentation.
Data Engineer Intern
Ccs Global Tech
Wayne, PA
06.2025 - 12.2025
- Worked and trained on several cloud technologies including Microsoft Azure, Amazon AWS and Google Cloud Platform.
- Developed data pipelines to streamline data integration from various sources including JSON, Rest APIs, relational databases and Cloud Storage using Microsoft ADF and Databricks using Python.
- Improved data pipeline performance through efficient data partitioning, optimized joins, and resource tuning in cloud-based data processing environments.
- Developed automated data workflows using Azure Data Factory pipelines and Databricks notebooks, incorporating basic monitoring and alerting to track pipeline execution and failures.
- Implemented ETL processes using tools such as Apache Airflow and SQL.
Education
Bachelor of Science - Computer Science
Western Governors University
08-2024
Skills
- Data visualization and presentations
- Data analysis
- Python programming
- SQL
- Tableau
- Machine learning
- ETL processes
- Data profiling
Languages
English
Full Professional
Hindi
Full Professional
Punjabi
Full Professional
Spanish
Limited Working
Timeline
Data Analyst
MS Staffing
12.2025 - Current
Data Engineer Intern
Ccs Global Tech
06.2025 - 12.2025
Bachelor of Science - Computer Science
Western Governors University