Ashishkumar Wankhede

ETL Developer with 9+ years of IT experience and 6+ years in Informatica ETL development (PowerCenter, IICS, BDM) across Banking & Financial Services. Delivered 100+ ETL mappings across multi-source pipelines (Kafka, Oracle, SQL Server, CSV, JSON, HDFS, IBM) into Hive, Snowflake, and Netezza. Expert in SCD Type I & II, data lineage, CI/CD pipeline migration (Dev→Test→QA→Prod), and L1/L2/L3 production support. Expanding into PySpark, Spark SQL, and Databricks for cloud-native ETL.

ETL Developer at Cognizant India Pvt. Ltd (2023-10 – Present)

Project_1 : EDA_Fraud_MAVERICK, Client Name : Truist Finance

• Designed and deployed 100+ ETL mappings using Informatica IICS, PowerCenter & BDM across multi source systems (CSV, JSON, HDFS, Kafka, Oracle, SQL Server, IBM) into Hive, Netezza hub and Snowflake data warehouses.
• Managed Kafka topic-based data pipelines processing (~1 GB/hr JSON) coordinated Talend Data Movement Framework — built all config/argument files to trigger PySpark ingestion scripts into Hive & Snowflake.
• Implemented SCD Type I & II mappings for Derived Master Schema, handled 50M-record relational sources with data validation and reconciliation.
• Performed end-to-end code migration across all environments (Dev → Test → QA → Production) via CI/CD pipelines using GitHub and Azure DevOps (ADO), achieving zero-defect deployments at each stage.
• Optimized ETL workflow performance through tuning and partitioning, cutting average job runtime from 10–15 minutes to under 5 minutes — a 50–67% reduction.
• Wrote UNIX shell scripts for data movement and reconciliation.
• Peer-reviewed ETL code components for a team of 3–5 developers, maintaining code quality standards and reducing post-deployment defects.
• Participated in sprint planning, weekly and monthly status calls under Agile methodology, consistently delivering ETL components on schedule across multiple release cycles.
• Resolved production incidents with root cause analysis, delivered support for defect tracking, raising CR, CTASK, and RITM for all deployment activities.
• Gathered client requirements, authored end-to-end deployment documentation STTM, LLD, HLD, Tech Spec, Unit Test Cases, Runbooks, and Release Notes, and Implementation/Breakout Plans.

ETL Developer at Cognizant India Pvt. Ltd (2023-10 – Present)

Project_2 : BRIOVIEW, Client Name : CNB AIA BLACK KNIGHT

• Designed and developed ETL jobs using IICS to meet business requirements. Built mappings for data extraction, transformation, and loading (ETL) across different source systems.
• Performed reverse engineering and data lineage analysis across 100+ Oracle DB source tables/views; documented gap analysis and STTM for ETL design.
• Designed and deployed ETL processes using Informatica IICS across all environments (Dev → Test → QA → Production) with CI/CD pipeline automation via GitHub and Azure DevOps.
• Resolved postproduction issues tracked via Azure DevOps Dashboard. Scheduled and managed migrated jobs using ESP, creating dependencies between applications and jobs.
• Raised Change Requests (CR), CTASKs, and RITMs for all deployment activities.
• Prepared full documentation suite: STTM, Unit Test Cases, Dev Package, STTM, LLD, HLD, Runbook, Release Notes, Implementation Plan, ETL code review artifacts.
• Wrote UNIX shell scripts for data movement and reconciliation processes.
• Monitored and optimized ETL workflows for better performance. Ensured adherence to data quality and security standards throughout the ETL process.

ETL Developer at Foundever India Pvt. Ltd (2018-07 – 2023-10)

System Analyst at U&D Square Pvt. Ltd (2017-08 – 2018-07)

BE(E&TC) in Electronics and Telecommunications – Imperial college of engineering and research (2008-08 – 2014-05)