Etl Developer Data Engineering

Bhavana Srivastava

Consultant – Deloitte Consulting LLP Minneapolis, MN

+1-612-***-**** ️ ***********@*****.***

Professional Summary

Data Engineering Consultant with 10+ years of experience delivering large-scale ETL, data integration, and cloud migration solutions. Specialized in Informatica Intelligent Cloud Services (IICS/IDMC), PowerCenter modernization, and hybrid cloud environments. Proven ability to lead complex integration projects across government, healthcare, finance, and media sectors using APIs, automation, and advanced ETL frameworks.

Professional Experience

Deloitte Consulting LLP

Consultant – Strategy & Analytics

ETL Developer – State of Washington (OneWa Project)

Government 12 months

Developed end-to-end ETL pipelines using Informatica IICS, DIH, and PowerCenter to integrate with Workday.

Built loop-based IICS taskflows to handle multiple MFT-pushed files with custom error handling.

Integrated SOAP APIs for Workday transaction submissions and WID-based logic.

Maintained CAI configurations for multiple Workday tenants.

Led documentation, unit testing, and E2E testing support.

ETL Developer – State of Illinois (Child Welfare Project)

Government 8 months

Engineered scalable IICS pipelines to convert SACWIS data to CCWIS.

Designed SCD Type 1/2, CDC logic, and incremental load frameworks.

Integrated with Microsoft Dynamics using dynamic data sync strategies.

Tuned performance of mappings and workflows; resolved UAT issues.

Informatica Support Engineer – Walt Disney Company

Media & Entertainment 12 months

Managed production support for PowerCenter and IDMC environments.

Diagnosed ETL failures using Splunk; ensured SLA compliance.

Mentored offshore teams and supported SAP royalty reporting ETLs.

Additional Experience

Sr. IT Consultant – Humana Inc. (ATOS-Syntel)

Healthcare 4 months

Migrated PowerCenter jobs to IICS and validated outputs across job versions.

Sr. ETL Developer – Optum (eFulgent)

Healthcare 24 months

Created ingestion pipelines from West Virginia systems (FACTS, OSCAR, RAPIDS) into Optum datamarts.

Automated reporting via shell scripting, AutoSys, and MicroStrategy.

ETL/Data Modeler – Wells Fargo, T. Rowe Price (eFulgent)

Finance ~2 years

Developed and optimized ETL jobs using PowerCenter, PowerDesigner, and PL/SQL.

Led documentation, defect triage, and multi-environment deployments.

Support Analyst – Abbott Labs, Caterpillar Inc. (eFulgent)

Healthcare/Manufacturing ~2 years

Provided L2/L3 support; upgraded Informatica versions; managed Tidal scheduler.

Technical Skills

ETL & Cloud: Informatica IICS, IDMC, PowerCenter, DIH, CAI

Languages & DB: SQL, PL/SQL, Shell Script Oracle, SQL Server, Teradata, DB2

APIs & Integration: REST, SOAP, Workday API

DevOps & Scheduling: AutoSys, Tidal, GitHub, Azure DevOps

Reporting: Power BI, MicroStrategy Visio

Tools: ServiceNow, SharePoint, Rally, ALM

Education

MBA, University of Phoenix

BCA, Birla Institute of Technology, India

Certifications & Languages

Certificate in Computer Information Systems – Glendale Community College

Languages: English (Fluent), Hindi (Native)

Contact this candidate