Sisay Filate

About Sisay Filate

Experienced Data Engineer with hands-on experience in gathering data from various sources, devising and developing automated data pipelines to collect and transform data, make the data ready for different consumption like predictive analytics, business intelligence reporting/charts/dashboards.Experienced in high-tech, high-growth, fast-paced and high-pressure environments across various Domains like Telecommunication, Data Management, Engineering, Retail, and Stakeholder Engagement.

Experience

1. Senior Aws Data Engineer

   Tata Consultancy Services

   Dec 2024 — Present · Owings Mills, MD, US

   Developed a PySpark-based ETL framework to extract, transform and load 400+ IBM DB2 tables (ranging from tens of millions to hundreds of millions of records) across the mainframe environment, supporting both initial and incremental loads based on audit columns for change tracking.* Developed and executed data pipelines on Kubernetes with Dockerized clusters, leveraging pods, nodes and executors for scalable parallel processing; monitored and debugging jobs via kubectl, Splunk, and Ubuntu terminal logs.* Automated orchestration and scheduling with Apache Airflow, dynamic executor count adjustment, backdated runs handling, and runtime parameter setup with spark-submit for optimized performance.* Built and implemented a Splunk monitoring dashboard that visually depicted ETL throughput (inserts, updates, and deletes) for each table load, providing near-real-time operational insight and helping the client ensure 400+ tables processed within the 4-hour production SLA.* Built a secure shell script to programmatically log in and automate token/credential handling (MFA included) for CLI actions like list bucket, upload and read CSV files and delete items from S3 bucket.* Built a secure shell script to programmatically log in and automate token/credential handling (MFA included) for CLI actions like list bucket, upload and read CSV files and delete items from S3 bucket.* Partnered Apache Airflow with Acryl DataHub and constructed ingestion recipes for Amazon S3 and Snowflake, enabling cross-platform lineage, metadata capture, and impact analysis.* Developed modular DBT models with robust testing methods (unique, non-null, accepted values, relationships) and established CI/CD pipelines in GitLab to automate deployments and enforce data quality standards.

Education

• Addis Ababa University

  Bachelor of Science (B.Sc.), Engineering

  2005 — 2009

• Upwardly Global

  Career Exploration/Awareness Skills

  2016 — 2017

• Karlsruhe Institute of Technology (KIT)

  Master's Degree (M.Sc.), Energy Technologies and Energy Efficiency in Buildings

  2012 — 2014

Skills

• R&D
• Teaching
• Cfd
• Web Development
• Mechanical Engineering
• Climate Change Mitigation
• Research and Development (R&D)
• Building Energy Modeling and Simulation
• Statistics
• Javascript
• Spss
• Energy
• Customer Service
• Engineering
• Renewable Energy
• Water
• Numerical Simulation
• Hvac Design
• Chemical Engineering
• Programming
• Air-Conditioning Technologies
• Low Energy Design
• Heat Transfer
• Sketchup
• Fluid Mechanics
• Energy Audits
• Energy Management
• Building Energy Modeling
• Thermodynamics
• Autocad
• Cascading Style Sheets (Css)
• Energy Efficiency
• Project Planning
• Hvac Systems
• Matlab
• Solar Energy
• Rem/Rate
• Ms Sql Server - Sql/T-Sql
• Building Physics
• Energy Modelling