Summary
Overview
Work History
Education
Skills
Timeline
Generic

Hari Krishna V S

ETL IICS Developer
Chennai

Summary

Experienced ETL Informatica Developer skilled in designing, developing, and implementing data integration solutions. Proficient in creating efficient workflows and optimizing data processing, ensuring accurate and timely delivery of information.

Overview

5
5
years of professional experience
6
6
years of post-secondary education

Work History

IICS Developer

Innova Solutions
Chennai
12.2024 - Current
  • Client Overview: Cenetene Corporations ,provide access to affordable, high-quality services to Medicaid and Medicare members, as well as to individuals and families served by the Health Insurance Marketplace
  • Environment: IICS, Datastage,Snowflake,Greenplumb,Control-M,Git
  • Assessed and cataloged existing DataStage jobs, stages, and dependencies for migration planning.
  • Replicated Datastage jobs to IICS mappings using transformations such as Expression, Lookup, Joiner, Aggregator, and Router.
  • Replicated Datastage Sequences to IICS Taskflows with conditional branching, loops, and error handling for seamless ETL orchestration.
  • Rebuilt legacy DataStage jobs in IICS, ensuring accurate logic translation and performance improvements.
  • Conducted thorough unit testing and data reconciliation between DS and IICS to verify source-to-target accuracy.
  • Monitored job executions via the IICS Monitor dashboard, resolving failures and optimizing resource usage.
  • Supported incremental loads, SCD implementation, and ETL logic for fact/dimension tables.
  • Documented mapping logic, business rules, and transformation strategies for audit and training purposes.
  • Participated in daily scrum meetings, providing updates on development progress and blockers.

ETL Informatica Developer

Cognizant Technology Solutions
Coimbatore
12.2020 - 09.2024
  • Company Overview: Client: AbbVie Inc (AbbVie) is a specialty biopharmaceutical company, which discovers, develops, manufactures, and commercializes drugs for the treatment of chronic and complex diseases.
  • Environment: IICS/Informatica Power Center 10.4/IICS/Snowflake/Oracle/Unix
  • Recognizing the business rules and utilizing IICS to get data from many source systems.
  • Designing and customizing data models for Data warehouse supporting data from multiple sources.
  • Implemented Type1, Type2 and Incremental load strategies.
  • Extracted data from flat files, Excel files and transformed the data based on user requirement using Informatica Power Center and IICS.
  • Carried out a quality assessment of the source data to ascertain the veracity of the information being reported.
  • Debugging the mappings and used session log files to trace errors that occur while loading.
  • Performance tuning by optimizing the mappings and sessions. Performed Unit Testing and tuned for better performance.
  • Worked closely with DBAs, admins, ETL developers and change control management team for migrating developed mappings across Dev, QA, and PROD environments.
  • Provide support for deployment activities and production support activities.
  • The objective of this conversion project is to move the ETL from Informatica 10.2 to Informatica 10.4.
  • Engaged in development and quality assurance testing with Production Hypercare's ongoing assistance.
  • Development testing included running the flow in environments 10.2 and 10.4 to find any discrepancies in the data implications; if found, we would rectify them so the flow would function in the new environment.
  • Testing for quality assurance involves ETL using production-like data and recording observations for user acceptability assessment.
  • Participated in the transfer of the flows to Production as well as providing assistance during the hypercare phase till the end of the initial production run.
  • Collaborated with database administrators to migrate tables, make DDL changes, and handle data change requests.

Education

Bachelor of Engineering - Mechanical

Sri Krishna College of Engineering And Technology
Coimbatore
01.2016 - 01.2020

Higher Secondary School - undefined

Adharsh Vidhyalayam
01.2014 - 01.2016

Skills

IICS

Informatica Powercenter

Snowflake

IBM Datastage

Shell scripting

undefined

Timeline

IICS Developer

Innova Solutions
12.2024 - Current

ETL Informatica Developer

Cognizant Technology Solutions
12.2020 - 09.2024

Bachelor of Engineering - Mechanical

Sri Krishna College of Engineering And Technology
01.2016 - 01.2020

Higher Secondary School - undefined

Adharsh Vidhyalayam
01.2014 - 01.2016
Hari Krishna V SETL IICS Developer