Deepa Kukreja
Bedford,USA
Summary
Seeking a challenging Data Engineer position to leverage my extensive experience in cloud-based data architectures, ETL/ELT pipeline development, and advanced analytics. Aiming to contribute my expertise in AWS technologies, Python/PySpark development, and data governance to drive data-driven decision making and deliver high-impact solutions for complex business problems.
Overview
20
20
years of professional experience
1
1
Certification
Work History
Data Engineer
Amazon Robotics
05.2021 - Current
- Designed and implemented large-scale data solutions for Amazon Global Logistics and Inventory Tracking System
- Built optimized ETL pipelines using PySpark on AWS Glue and managed orchestration with Airflow and Step Functions
- Developed serverless data processing with AWS Lambda and event-driven systems via EventBridge
- Implemented Apache Iceberg for advanced data lake capabilities and leveraged Athena for analytics
- Automated infrastructure using AWS CDK (TypeScript) and set up CI/CD with GitHub Actions
- Created centralized monitoring, alerting (Slack), and logging frameworks using CloudWatch
- Ensured secure data sharing and governance with AWS Lake Formation
- Collaborated cross-functionally, provided technical mentorship, and followed Agile practices
- Authored technical documentation, runbooks, and led incident response planning
Lead BI Architect
HMS Eliza
10.2014 - 05.2021
- Automated multi-region infrastructure with CloudFormation, Terraform, and Ansible
- Built Jenkins pipelines for Data Lake and BI deployments
- Migrated SQL Server databases to Amazon Redshift
- Developed NiFi templates and Python scripts for real-time ingestion and data migration
- Created ETL jobs with PySpark (AWS Glue) and Talend for Redshift loading
- Built SSAS cubes and SSIS packages for BI processing
- Designed Tableau dashboards for healthcare analytics (Medicare/Medicaid focus)
- Developed secure RESTful APIs in C# for data access
Business Data Analyst
Eliza Corporation
09.2012 - 09.2014
- Designed and implemented SSIS packages for automated data ingestion into calling engine system
- Developed data extraction and transformation workflows for call results reporting
- Created optimized SQL queries for data cleansing and quality assurance
- Led comprehensive data mapping and analysis of complex speech application systems
- Implemented data governance frameworks ensuring data quality and consistency
- Conducted thorough data interpretation and pattern analysis for speech recognition systems
- Performed systematic code reviews and technical walk-throughs with development team
- Established best practices for ETL development and data quality standards
- Documented technical specifications and data mapping requirements
- Tech Stack: SQL Server 2008, SSIS (SQL Server Integration Services), SQL Server 2008 R2, SQL Server 2005
Data Warehouse Architect & Technical Lead
Bitwise Solutions/Bitwise Inc.
06.2005 - 04.2012
- Led end-to-end data warehouse initiatives across multiple projects, specializing in ETL development, data modeling, and business intelligence solutions
- Expertise spans Ab Initio, DataStage, SSIS, Teradata, and various BI tools
- Architected and implemented enterprise data warehouse solutions including Enterprise Data Store and Data Marts, focusing on extensible and generic ETL approaches
- Designed and developed comprehensive data quality framework, implementing balance and control checks for ETL processes
- Led migration initiatives including automated tool development for DataStage to SSIS and Ab Initio to expressor transitions
- Coordinated offshore-onsite delivery model, ensuring seamless project execution and knowledge transfer
- Developed complex ETL solutions using Ab Initio, DataStage, and SSIS, optimizing data loads for Teradata and Oracle
- Created and maintained OLAP solutions using Cognos and SSAS cubes for business analytics
- Implemented BI reporting solutions using Business Objects, Crystal Reports, and Cognos
- Automated scheduling solutions using JS Console for regular data quality checks and ETL processes
- Managed requirements gathering, data profiling, and data modeling activities
- Created technical documentation including design documents, data dictionaries, and mapping rules
- Conducted peer code reviews and established best practices for ETL development
- Administered BI platforms including user access management and issue resolution
- Tech Stack: Ab Initio, DataStage, SSIS, Teradata, Oracle, Unix/AIX, Cognos, Business Objects, Crystal Reports, SSAS, JS Console Scheduler, Perl
Education
Bachelor of Computer Engineering -
Pune University
Skills
- AWS (Glue, Lambda, Step Functions, MWAA/Airflow, Athena, EventBridge, CDK)
- Apache Iceberg, Confluent Kafka, Redshift, Cassandra, Oracle, SQL Server, Teradata
- Data Lakes, ETL Pipelines, Real-time & Streaming Data Solutions
- PySpark, Python, SQL, TypeScript
- Infrastructure as Code (AWS CDK, Terraform, CloudFormation)
- Data Modeling, Data Quality, Data Integrity & Reliability
- Data Governance Frameworks, Event-driven Architectures, SQL Optimization & Performance Tuning
- NiFi, Ab Initio, DataStage, Talend, SSIS, SSAS, OLAP Tools
- CI/CD Pipelines, Monitoring Solutions, Engineering Best Practices
- Agile Environments (Scrum, Sprints, Stand-ups)
Certification
Microsoft SQL Server 2008, Business Intelligence Development
Timeline
Data Engineer
Amazon Robotics
05.2021 - Current
Lead BI Architect
HMS Eliza
10.2014 - 05.2021
Business Data Analyst
Eliza Corporation
09.2012 - 09.2014
Data Warehouse Architect & Technical Lead
Bitwise Solutions/Bitwise Inc.
06.2005 - 04.2012
Bachelor of Computer Engineering -
Pune University
Similar Profiles
Briana KerrBriana Kerr
Robotics and Mechanical Technician at Amazon RoboticsRobotics and Mechanical Technician at Amazon Robotics
Laniya BarrettLaniya Barrett
Process Guide at Amazon RoboticsProcess Guide at Amazon Robotics
Loloma GarnettLoloma Garnett
Process Guide at Amazon RoboticsProcess Guide at Amazon Robotics