Job Search Status
Not actively lookingDesired Job Title
ETL Architect | Lead DeveloperAS 400 Dev & RunOps LeadSenior AS400 DeveloperData Analyst InternWork Type
Full TimeLocation Preference
HybridLocation:
Open to relocation: Yes
Ankur Mishra
Work Preference
Summary
Azure Certified Data Engineer with over 15 years of IT experience, including 5 years specializing in Azure Data Factory and Azure Databricks for financial services. Expert in developing scalable data pipelines, and implementing ETL processes, ensuring data quality and reliability. Strong communicator and collaborator with extensive experience in delivering tailored cloud-based solutions in high-stakes environments.
Overview
16
16
years of professional experience
4
4
Certificates
Work History
Azure Data Engineer
Amerihealth Caritas – Fee Schedule Management
Philadelphia, IL
03.2025 - Current
- Designed and developed scalable data ingestion pipelines using Azure Data Factory and Azure Databricks.
- Implemented centralized data governance using Unity Catalog across multiple Databricks workspaces.
- Developed PySpark and Spark SQL applications for large-scale data processing, aggregation, and reporting.
- Built complex SQL queries and stored procedures; integrated with ADF to implement Change Data Capture (CDC).
- Ensured alignment with business objectives through authored and maintained data rule books.
- Troubleshot and resolved production issues, ensuring high availability and reliability of data pipelines.
Azure Data Engineer
Walgreens - Campaign Management System
Deerfield, IL, USA
04.2021 - 03.2025
- Collaborated with business users to gather requirements and design a common enterprise data architecture.
- Designed and implemented ETL pipelines using Azure Data Factory to ingest data from multiple source systems.
- Processed and transformed data using ADF Mapping Data Flows and Azure Databricks; loaded data into Azure Data Lake and Azure SQL Database.
- Built real-time data processing pipelines using Azure Event Hubs and Databricks to ingest streaming customer transaction data.
- Implemented Unity Catalog for centralized data governance across multiple workspaces in collaboration with platform admins.
- Monitored applications and ensured 24/7 production support readiness for critical data systems.
ETL Architect | Lead Developer
Walgreens - CSO: Ab Initio to Talend Migration
Noida, India
06.2019 - 03.2021
- Developed complex ETL jobs using Talend and integrated with existing workflows.
- Prepared and executed sprint plans for migrating jobs from Ab Initio to Talend DI and Big Data platform.
- Conducted UAT meetings and walkthroughs for module-wise deployment of Talend jobs.
AS 400 Dev & RunOps Lead
Walgreens – Logistics Systems: Ordering Processing, Billing & Shipping
Deerfield, IL, USA
01.2017 - 05.2019
- Gathered detailed business requirements and translated them into technical design documents.
- Coordinated in an Onshore-Offshore delivery model, effectively communicating business and technical requirements.
- Developed and maintained AS400 applications and conducted unit testing, system integration testing, and supported UAT.
Senior AS400 Developer
Walgreens – Store & DC Ordering: JDA Implementation
Deerfield, IL, USA
08.2014 - 12.2016
- Interact with business stake holders and SMEs to understand current legacy ordering system built over legacy AS400 architecture.
- Involve in data mapping brainstorming sessions and identify the master data from legacy source system (DB2 database).
- Perform impact analysis on the existing system to make sure all the impacted components are covered in the design document.
- Work with ETL Abinitio teams to understand the master data requirement and work on mapping the requirements to the master data tables in legacy AS400 system.
- Build new AS400 applications to fulfill master data requirement to be sent to Centralized JDA system through ETL layer.
- Integrate existing AS400 applications with new source of data coming from centralized ordering system from JDA.
- Work in Onshore-Offshore model and convey the business and technical requirements to the team.
- Conduct weekly status meeting with project stakeholders reviewing the progress of the projects.
- Participate in war room meetings during deployment phase as an AS400 SME and mitigate production issues found during deployment phases.
- Provide production support post deployment and monitor the application. Do enhancements and bug fixes in existing applications.
- Monitor critical applications in production and make sure smooth processing of daily store orders to vendors and Walgreens distribution centers.
- Create handbooks and do the knowledge transfer to the RunOps team.
AS400 Developer
Walgreens – Store Inventory Management System
Noida, India
06.2010 - 07.2014
- Participate in business meetings to understand and gather the requirements.
- Understand the current system and map the requirements to the impacted applications.
- Perform impact analysis on the existing system to make sure all the impacted components are covered in the design document.
- Create high level design documents and perform walkthrough meetings with business and get the signoff.
- Create technical design document with all the impacted components and get the peer review done.
- Develop the applications in AS00/Synon and do the unit testing.
- Perform system testing and work with QA team to perform quality assurance review.
- Facilitate code walkthrough and assist in user acceptance testing along with onsite team.
- Monitor critical applications and provide production support.
- Perform root cause analysis for job failures and implement permanent fixes.
- Monitor day to day incidents through BMC Remedy incident management tool.
Education
Bachelor of Technology - Computer Science & Engineering
Madan Mohan Malviya Engineering College
Skills
- Azure Data Factory
- Python
- Spark SQL
- Azure SQL Database
- Continuous Integration & Continuous Delivery
- Real-Time Data Processing
- ETL Processes
- Azure Event Hubs
- Azure Databricks
- PySpark
- Azure Data Lake Storage
- Azure Synapse Data Warehouse
- Data Governance using Unity Catalog
- Data Warehousing
- Change Data Capture (CDC)
Certification
Databricks Certified Data Engineer Associate
Work Availability
monday
tuesday
wednesday
thursday
friday
saturday
sunday
morning
afternoon
evening
swipe to browse
Timeline
Azure Data Engineer
Amerihealth Caritas – Fee Schedule Management
03.2025 - Current
Azure Data Engineer
Walgreens - Campaign Management System
04.2021 - 03.2025
ETL Architect | Lead Developer
Walgreens - CSO: Ab Initio to Talend Migration
06.2019 - 03.2021
AS 400 Dev & RunOps Lead
Walgreens – Logistics Systems: Ordering Processing, Billing & Shipping
01.2017 - 05.2019
Senior AS400 Developer
Walgreens – Store & DC Ordering: JDA Implementation
08.2014 - 12.2016
AS400 Developer
Walgreens – Store Inventory Management System
06.2010 - 07.2014
Bachelor of Technology - Computer Science & Engineering
Madan Mohan Malviya Engineering College