Namratha Prakash

About Namratha Prakash

Hey there,I’m a Data Analytics Engineer with 4+ years working across AWS, Snowflake, Databricks, dbt, Airflow, PySpark, and SQL. I build pipelines and reporting layers that teams can actually trust and use.At Pacsun, I support ERP + data migration work (legacy to D365) and focus heavily on data validation and reconciliation. That means writing SQL checks, automating comparisons with Python, finding mismatches early, and keeping the reporting layer consistent so downstream dashboards and stakeholders aren’t chasing wrong numbers.Before that, I worked on large-scale retail and finance datasets at Wayfair and Mphasis. I’ve built and maintained ETL/ELT pipelines on AWS, modeled data for analytics use cases, and supported reporting in tools like Power BI/Tableau/MicroStrategy when the business needed it.What you’ll get from me:* Strong SQL + Python, and comfort with PySpark* Practical data modeling (facts/dims) and clean dbt projects* Workflow orchestration with Airflow* A quality-first mindset (validation, reconciliation, documentation)I’m open to Data Engineer and Data Analytics Engineer roles where I can own pipelines end-to-end and help teams make faster, more confident decisions with data.

Experience

1. Data Engineer

   Freddie Mac

   May 2025 — Present · US

   Developed and maintained ETL pipelines using AWS Glue, Apache Spark, and PySpark to ingest, clean, and transform 10+ TB of structured and semi-structured financial data from diverse sources such as mortgage portfolios, loan servicing systems, and credit bureaus.• Engineered data models in Snowflake and Redshift to support advanced credit risk scoring, loan default prediction, and regulatory compliance (e.g, Fannie Mae/Freddie Mac guidelines).• Implemented Airflow DAGs for orchestrating daily batch jobs and real-time streaming data ingestion pipelines using Kafka and AWS Kinesis, reducing data latency by 40%.• Collaborated with Data Scientists and Risk Analysts to ensure pipeline efficiency, data quality, and governance standards (SOX, GDPR), while maintaining robust data lineage and metadata tracking using AWS Glue Data Catalog and Apache Atlas.

Education

• Visvesvaraya Technological University

  Bachelor of Engineering - BE, Computer Science

• The George Washington University

  Master's degree, Data Science