Shalini Kumari

Overall 8.1 years of IT experience, including 4+ years of relevant experience in AWS Data Engineering, with strong expertise in building scalable, secure, and high-performance data platforms. Proven experience in designing and implementing data lake architectures, ETL/ELT pipelines, and cloud migration solutions across AWS and Google Cloud environments to support enterprise analytics and business intelligence. Skilled in optimizing large-scale data processing systems, automating workflows, and ensuring high standards of data reliability, governance, and performance.

Experienced in managing the end-to-end data lifecycle, including data ingestion, transformation, orchestration, monitoring, and visualization. Demonstrated ability to collaborate effectively with engineering and analytics teams to deliver actionable insights and enable data-driven decision-making. Recognized for driving improvements in automation, performance optimization, and compliance-focused architecture design.

AWS Data Engineer at Aptia Group India, Gurugram (in service continuation from Mercer) (2022-10 – 2026-01)

Worked on a large-scale AWS-based data engineering platform for pension, employee benefits, insurance, and HR administration data received from multiple client systems in the UK and US. The platform was designed to ingest, process, validate, and analyze data and deliver dashboards and reports for operations, claims, pension processing, and management.

• Designed end-to-end AWS data pipeline architecture
• Developed Glue ETL jobs using Python and PySpark
• Created S3-based data lake and maintained data partitions
• Built and managed Glue Crawlers and Glue Catalog tables
• Developed Lambda functions for automation and event handling
• Created Step Function workflows for orchestrating ETL jobs
• Designed Redshift dimensional models and reporting tables
• Tuned Redshift queries for performance optimization
• Processed large datasets using Spark on EMR
• Created EC2-based utilities for source system integration
• Performed data quality validation and reconciliation
• Worked with business teams to understand pension and benefits requirements
• Supported production deployments and issue resolution
• Participated in Agile ceremonies, sprint planning, and code reviews

AWS Data Engineer at Aptia Group India, Gurugram (2021-09 – 2022-10)

Built a cloud-based Open Enrollment Readiness platform to support annual employee benefits enrollment cycles for US and UK clients. The platform collected data from HR systems, payroll vendors, benefits administrators, and insurance carriers, automating data validation, eligibility checks, premium calculations, and readiness reporting.

• Designed and implemented AWS-based open enrollment validation pipelines
• Developed PySpark Glue jobs for employee, dependent, and payroll validation
• Created Lambda functions and Step Functions for automated workflow execution
• Built Redshift tables and SQL views for readiness reporting
• Performed data quality checks and reconciled payroll deduction differences
• Integrated HR, payroll, and insurance source systems into a common data lake
• Collaborated with HR, benefits, payroll, and business teams during enrollment periods
• Supported production deployments and resolved critical enrollment issues
• Improved ETL performance and reduced file-processing time

Data Engineer at Optum (2019-04 – 2022-10)

Worked on data engineering projects building ETL pipelines and data infrastructure.

• Built end-to-end data pipelines from multiple source systems to visualization layers using Python, SQL and Power BI
• Designed and managed enterprise-scale AWS data lake solutions
• Developed and maintained scalable ETL pipelines processing terabytes of data daily
• Automated workflow orchestration using Airflow DAGs
• Engineered Python-based ETL frameworks for API data extraction
• Enhanced Amazon Redshift performance through optimization techniques
• Implemented comprehensive data validation and reconciliation processes
• Partnered with BI teams to design and deliver Power BI dashboards
• Created monitoring dashboards using Looker
• Developed cost analysis dashboards for cloud optimization
• Applied data quality frameworks using Monte Carlo and Great Expectations

Data Associate at Concentrix (2016-10 – 2019-02)

Entry-level data engineering role supporting data processing and pipeline development.

B.Sc (Honours) in Mathematics – B. R. Ambedkar Bihar University (2012 – 2015)