Summary
Overview
Work History
Education
Skills
Certification
Languages
Timeline
Generic
Om Prakash Kumar

Om Prakash Kumar

Bangalore

Summary

Highly proficient Data Engineer with 8.5 years of IT experience, including 6.5 years specializing in ETL development utilizing Informatica PowerCenter and IICS, alongside 2 years of practical experience with AWS services.

Overview

9
9
years of professional experience
1
1
Certification

Work History

Senior Data Engineer

Harman Connected Services
Bangalore
02.2023 - Current
  • Migrated legacy ETL workflows from PowerCenter to IICS cloud environment.
  • Developed mappings, taskflows, and automation pipelines within IICS framework.
  • Conducted thorough unit tests and release testing to ensure compliance with company standards.
  • Created and implemented reporting dashboards using ThoughtSpot for data visualization.
  • Managed end-to-end testing, validation, and documentation processes.
  • Integrated data solutions with Snowflake for optimized cloud storage management.
  • Provided support for production systems.

ETL Informatica Developer

Larsen & Toubro Infotech
Bangalore
03.2021 - 02.2023
  • Developed and supported ETL jobs using Informatica IICS and PowerCenter.
  • Designed complex transformations using various transformation objects like Joiner, Lookup, Aggregator, Sorter in Informatica PowerCenter.
  • Automated job execution, enhancing data pipeline performance significantly.
  • Coordinated production deployments and resolved incidents through SNOW.
  • Mentored junior team members, facilitating knowledge transfer and skill development.
  • Migrated existing code base from lower version of informatica to higher version.
  • Provided production support for all ETL related issues involving Informatica PowerCenter.

Programmer Analyst

Cognizant Technology Solutions
Kolkata
10.2016 - 03.2021
  • Implemented Informatica-based ETL solutions that met stringent performance criteria.
  • Analyzed design specifications and data mapping documents for seamless migration processes.
  • Designed and developed ETL mappings using various transformations available in PowerCenter.
  • Conducted thorough testing, including unit and system tests, to resolve complex design issues.
  • Configured AWS resources, including Auto Scaling groups and VPCs, for optimal performance.
  • Creating an AWS Workspace for different users and rebuilding it as per requirements.

Education

B.Tech - Electrical Engineering

B.P. Poddar Institute of Management & Technology
Kolkata
06-2016

12th -

Saraswati Vidya Mandir
Dhanbad
06-2011

10th -

Saraswati Vidya Mandir
Dhanbad
06-2009

Skills

  • ETL tools: Informatica PowerCenter, IICS
  • Cloud services: AWS (EC2, S3, VPC, ELB, Auto Scaling Groups, IAM, CloudWatch)
  • Databases: SQL Server, Oracle, Snowflake, Db2, Informix
  • Development tools: SQL Developer, Microsoft SQL Server
  • Programming languages: Unix, Python
  • Scheduling tools: Autosys, Control-M
  • Reporting tool: ThoughtSpot
  • Other tools: PuTTY, WinSCP, Jira, ServiceNow
  • Operating systems: Windows, Unix

Certification

  • AWS Certified Cloud Practitioner Certification
  • Hands-On Essentials: Data Applications by Snowflake

Languages

Hindi
First Language
English
Proficient (C2)
C2
Bengali
Upper Intermediate (B2)
B2

Timeline

Senior Data Engineer

Harman Connected Services
02.2023 - Current

ETL Informatica Developer

Larsen & Toubro Infotech
03.2021 - 02.2023

Programmer Analyst

Cognizant Technology Solutions
10.2016 - 03.2021

B.Tech - Electrical Engineering

B.P. Poddar Institute of Management & Technology

12th -

Saraswati Vidya Mandir

10th -

Saraswati Vidya Mandir

Similar Profiles

CREATE PROFILE
Om Prakash Kumar