SUGUMAR KANNIYAPPAN
Portland,OR
Summary
Senior Data Engineer with 15+ years of experience across Databricks, Snowflake, AWS, Teradata, Oracle, and Informatica. Strong background in HR analytics, cloud migration, and building scalable data pipelines. Skilled in Databricks Delta Lake, PySpark, Airflow orchestration, and SQL performance tuning. Known for ownership, reliability, and delivering high‑quality data solutions for enterprise environments.
Overview
19
19
years of professional experience
Work History
Senior Data Engineer
NIKE
Beaverton, OR
02.2021 - Current
- Designed and developed Databricks Delta Lake pipelines for HR data ingestion and transformation.
- Built scalable data processing frameworks using Databricks SQL, Delta Lake, and PySpark.
- Migrated legacy Oracle/Teradata workloads to Snowflake, including schema redesign and performance tuning.
- Implemented Airflow orchestration for end‑to‑end pipeline automation and monitoring.
- Optimized SQL workloads across Databricks, Snowflake, and Teradata.
- Partnered with HR analytics teams to deliver curated datasets for Tableau dashboards.
- Ensured data governance and security using Unity Catalog and AWS IAM.
- Automated legacy Alteryx workflows and transitioned them into Databricks/Airflow pipelines.
- Mentored junior engineers and led code reviews.
Senior Data Engineer
CENTIZEN
Beaverton, OR
05.2018 - 02.2021
- Developed HR analytics workflows using Alteryx, Tableau, and SQL.
- Automated workflows using Autosys and later Airflow.
- Performed SQL tuning across Snowflake, Oracle, and Teradata.
- Supported migration from on‑prem systems to AWS Cloud.
- Built and maintained HR Datamart components.
- Developed ETL processes using Alteryx and Python.
- Launched and configured AWS EC2 instances using Terraform and Jenkins pipelines.
- Administered Alteryx and Tableau servers on AWS EC2.
Senior Developer
WIPRO
Beaverton, OR
06.2015 - 05.2018
- Designed and developed SQL/PLSQL solutions for HR analytics.
- Built macros and automated workflows in Alteryx.
- Created and maintained Oracle HR Analytics Datamart.
- Migrated on‑prem systems to AWS; supported Oracle → Snowflake migration.
- Performed performance tuning and defect resolution.
- Mentored new team members and supported Agile delivery.
Senior IDQ/IDE Developer
WIPRO
Beaverton, OR
06.2013 - 06.2015
- Built data quality rules, match/merge logic, and profiling dashboards using Informatica IDQ.
- Created scorecards, lineage, and trend analysis for enterprise data quality.
- Collaborated with data stewards to improve source data accuracy.
Informatica Developer / Production Support
WIPRO
Beaverton, OR
12.2009 - 05.2013
- Delivered 2000+ daily DataMart jobs with high reliability.
- Developed PL/SQL procedures, complex SQL queries, and ETL mappings.
- Designed dimensional models and source‑to‑target mappings.
- Provided L2/L3 production support and resolved critical issues.
Informatica & Business Objects Developer
KEANE (India)
, India
06.2007 - 12.2009
- Developed BO reports, ETL mappings, and data warehouse models.
- Supported production systems and resolved data issues.
Education
B.E. - Electronics and Communication Engineering
Anna University
Skills
- Databricks
- SQL
- Delta Lake
- PySpark
- Workflows
- Unity Catalog
- Snowflake
- AWS
- EC2
- S3
- IAM
- RDS
- Airflow
- Autosys
- Oracle
- SQL Server
- Alteryx
- Informatica PowerCenter
- Informatica IDQ
- Python
- Unix Shell Scripting
- Terraform
- Jenkins
- GitHub
- Tableau
- Business Objects
- Agile
- Data Modeling
- Performance Tuning
Timeline
Senior Data Engineer
NIKE
02.2021 - Current
Senior Data Engineer
CENTIZEN
05.2018 - 02.2021
Senior Developer
WIPRO
06.2015 - 05.2018
Senior IDQ/IDE Developer
WIPRO
06.2013 - 06.2015
Informatica Developer / Production Support
WIPRO
12.2009 - 05.2013
Informatica & Business Objects Developer
KEANE (India)
06.2007 - 12.2009
B.E. - Electronics and Communication Engineering
Anna University