Ankit Kumar
@Ankit15
Data Engineer at Capgemini
Bangalore, Karnataka, India
ETL Informatica Developer with 2+ years of experience designing, building, and optimizing large-scale data pipelines in Banking and Finance domains. Strong expertise in Informatica PowerCenter, SQL, Unix Shell Scripting, and Python for ingestion, transformation, and validation of high-volume transactional data (200M+ records/day). Experienced in data warehousing concepts, SCD Type 2, performance tuning, data quality checks, and production support in enterprise environments.
Experience
Data Engineer
Capgemini
Designed, developed, and maintained enterprise-grade ETL pipelines using Informatica PowerCenter, SQL, Python, and Unix Shell to process 200M+ daily financial transactions into DB2 data warehouse. Implemented SCD Type 2 logic, incremental loads, and historical data management to support regulatory and analytical reporting. Optimized SQL procedures, Informatica mappings, and shell scripts, achieving 30% reduction in batch processing time. Built data quality checks, reconciliation logic, and exception handling for missing data, holidays, and tolerance breaches. Automated ETL monitoring and alerting workflows, reducing manual intervention by 40% and improving SLA adherence.
Sales Engineer
TG Advait India Private Limited
Generated reports and dashboards to track costs and trends for strategic decision-making. Coordinated with procurement, production, and finance teams to collect and analyse raw material data, driving efficient and data-driven decision-making for project costing. Communicated with clients to understand their requirements and translated those into data-backed costing proposals.
Education
Uttarakhand Technical University
B-Tech
Electronics and Communication Engineering
Gyansthali, Bhadeja
Senior Secondary
Licenses & Certifications
Certification in Python 101 for Data Science
Certification in SQL
HackerRank