Om Prakash Kumar

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.

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.

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.

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.

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.