ISHAN KUMAR

Results-oriented ETL and Data Engineer with over 7 years of hands-on experience delivering scalable data solutions across on-premise and cloud environments. Proven track record of driving ETL modernization efforts using PySpark on AWS EMR, resulting in up to 40% faster batch performance. Adept in building reusable data ingestion frameworks, implementing CDC logic, and automating data validation workflows. Strong expertise in debugging complex data pipelines, optimizing SQL and PL/SQL queries, and delivering business-aligned reporting solutions via Tableau. Passionate about enabling teams through mentorship and technical leadership, with a foundation built on QA engineering and deep skills in data validation, pipeline monitoring, and issue resolution using Snowflake, Splunk, and AWS services.

Analytics Data Mart (ANM).

• Designed and implemented a scalable PySpark-based data platform hosted on AWS EMR to unify marketing and sales analytics.
• The system ingests and processes data from multiple sources including Salesforce and Google Analytics, delivering curated datasets for downstream business intelligence and real-time customer targeting.
• Migrated legacy Informatica ETL workflows to PySpark on AWS EMR, improving scalability and reducing batch processing time by ~40%.
• Built resilient, reusable ETL pipelines with automated recovery, alerting, and auditing mechanisms.
• Developed ingestion frameworks capable of processing APIs, CSV, XML, Parquet, and Text data.
• Automated sanity checks using UNIX scripting for data validation, record counts, and header/trailer validation.
• Reviewed and optimized complex SQL/PLSQL queries, reducing database load and improving performance.
• Supported evolving business requirements by aligning ETL logic and transformation rules.
• Delivered cleansed and enriched datasets to Tableau dashboards for campaign tracking and revenue insights.
• Collaborated with analysts and stakeholders for requirements gathering and documentation.
• Enabled automated delivery of daily data feeds to Sales and Marketing for real-time targeting.

• I-129, Validity till 30/09/2026
• B1/B2, Validity till 31/10/2028