Poornima Sharath

ETL Developer with 4+ years of experience in Informatica PowerCenter and Informatica Intelligent Cloud Services (IICS), specializing in ETL development, data warehousing, and PowerCenter-to-IICS migration projects. Experienced in Oracle, SQL, production support, and Agile delivery environments. Worked onsite with clients in Raleigh, North Carolina, collaborating with offshore teams for successful project delivery. Currently upskilling in Informatica IICS and Python.

ETL Developer (Onsite) at PRA Health Science (2018-01 – 2018-12)

• Developed ETL workflows using Informatica
• Worked on Oracle source tables
• Developed mappings to convert Oracle stored procedures into ETL mappings using Informatica Power Center to load data into Oracle database.
• Collaborated with the offshore team for completing tasks.
• Understood the business logic and Performed source-to-target mappings

Software Engineer at Wissen Infotech (Client: PRA Health Sciences) (2019-01 – 2021-07)

• Designed and developed ETL mappings using Informatica PowerCenter and IICS.
• Developed ETL mappings using complex Informatica transformations including Aggregator, Joiner, Router, Lookup, Update Strategy, and Expression transformations for healthcare data processing.
• Implemented SCD Type 2 logic to maintain history.
• Supported QA, UAT, and Production issues
• Worked on performance tuning of mappings.

Senior Software Engineer at Wissen Infotech (Client: PRA Health Sciences) (2021-07 – 2021-12)

• Successfully migrated 30+ Informatica PowerCenter mappings to IICS to support cloud data integration initiatives.
• Assisted migration team in understanding the logic in the mapping while doing PowerCenter to IICS migration.
• Implemented Slowly Changing Dimension (SCD) – Type 2 logic using Informatica mapping.
• Packaged the different components and deployed the solution to QA and UAT environments.
• Addressed QA team and UAT user issues and facilitated QA/UAT sign off.
• Addressed production issues by performing root cause analysis, implementing and deploying the fix within the SLAs.

Career Break & Up skilling (2022-01 – Present)

• Took a planned career break for family responsibilities.
• Continued technical up skilling in Informatica PowerCenter, IICS and Python.
• Taught Python fundamentals to pre-university (PU) students.

MS in Information Systems Technology – Wilmington University (2015 – 2016)

BSc – Bangalore University (2010 – 2013)