How to Write a Data Engineer Resume With Zero Experience

import requests
import psycopg2

URL = "https://api.open-meteo.com/v1/forecast"
params = {"latitude": 28.61, "longitude": 77.21, "hourly": "temperature_2m"}
data = requests.get(URL, params=params, timeout=30).json()

rows = list(zip(data["hourly"]["time"], data["hourly"]["temperature_2m"]))

conn = psycopg2.connect("dbname=weather user=de password=de host=localhost")
with conn, conn.cursor() as cur:
    cur.execute("""CREATE TABLE IF NOT EXISTS hourly_temp (
                     ts TIMESTAMP PRIMARY KEY, temp_c REAL)""")
    cur.executemany("""INSERT INTO hourly_temp (ts, temp_c) VALUES (%s, %s)
                       ON CONFLICT (ts) DO UPDATE SET temp_c = EXCLUDED.temp_c""", rows)
conn.close()

from datetime import datetime
from airflow import DAG
from airflow.operators.python import PythonOperator

def extract_load():
    import load_weather  # the script from the previous tab
    load_weather.run()

with DAG(
    dag_id="weather_daily",
    start_date=datetime(2026, 1, 1),
    schedule="@daily",
    catchup=False,
    default_args={"retries": 2},
) as dag:
    PythonOperator(task_id="extract_load", python_callable=extract_load)

SKILLS
Languages : SQL (joins, CTEs, window functions), Python
Data tools: pandas, Apache Airflow, dbt (basics)
Storage   : PostgreSQL, Amazon S3, Parquet
Practices : Git, Docker, pytest, idempotent loads
Cloud     : AWS basics (S3, IAM, EC2)

-- Daily average and 7-day moving average temperature
SELECT day,
       avg_temp,
       AVG(avg_temp) OVER (ORDER BY day
                           ROWS BETWEEN 6 PRECEDING AND CURRENT ROW) AS ma_7d
FROM (
    SELECT DATE(ts) AS day, AVG(temp_c) AS avg_temp
    FROM hourly_temp
    GROUP BY DATE(ts)
) d
ORDER BY day;

Aspiring data engineer with hands-on projects building
batch ETL pipelines in Python, SQL and Apache Airflow,
loading data into PostgreSQL and Amazon S3. Focused on
reliable, idempotent and well-documented pipelines.

IT support professional moving into data engineering.
Built three pipelines that ingest API and CSV data,
transform it with SQL and Python, and schedule loads
with Airflow. Strong at troubleshooting and documentation.

YOUR NAME
Aspiring Data Engineer | City | phone | email
LinkedIn: linkedin.com/in/yourname
GitHub:   github.com/yourname

SUMMARY
Aspiring data engineer with projects in batch ETL,
SQL modelling and workflow orchestration.

PROJECTS
Weather Data Pipeline  | Python, Airflow, PostgreSQL
- Built a daily pipeline that pulls hourly data from a
  public weather API and upserts it into PostgreSQL
- Scheduled with Airflow, with retries and logging
- github.com/yourname/weather-pipeline

Retail Star Schema     | dbt, PostgreSQL
- Modelled orders into fact and dimension tables
- Added dbt tests for unique and not-null keys

SKILLS
SQL · Python · pandas · Airflow · dbt · PostgreSQL
AWS S3 · Docker · Git · pytest

EDUCATION
B.Sc. / B.Tech / B.Com — College, Year

CERTIFICATIONS (optional)
Only ones you have actually completed