Saikumar Anumalla

About Saikumar Anumalla

I am an Informatica ETL Developer with over 4 years of experience in data integration and transformation solutions in complex enterprise environments. I bring deep expertise in designing, developing, and optimizing end-to-end ETL workflows using Informatica PowerCenter, backed by a strong foundation in data warehousing principles.I have a proven ability to ensure data accuracy, reliability, and integrity across large volumes of data. I\'m also well-versed in SQL and Unix scripting, and experienced in working with Oracle, Netezza, flat files, and modern BI tools like Snowflake, Sap BO, and Tableau.

Experience

1. Technology Support Specialist

   Infosys

   Apr 2023 — Present · Hyderabad, IN

   Played a key role in designing and executing ETL workflows to extract, transform, and load data across diverse systems.Developed complex Informatica mappings using transformations like Expression, Joiner, Aggregator, Lookup (connected, unconnected, dynamic), Filter, Router, Sorter, and Update Strategy.Created modular, reusable mapplets and transformations incorporating core business logic.Implemented both Type 1 and Type 2 Slowly Changing Dimensions (SCDs) to manage historical data efficiently.Configured, scheduled, and monitored workflows, worklets, and sessions in Informatica Workflow Manager.Managed data integration from multiple sources including Oracle databases and flat file systems.Identified and resolved mapping, source, or target-level performance bottlenecks.Utilized mapping parameters, variables, and parameter files to enable incremental data loads.Performed end-to-end performance tuning of mappings and workflows to enhance processing speed.Configured and managed lookups, session logs, and workflow logs to handle exceptions and ensure data integrity.Built file-based target mappings and automated related workflows for scheduled execution.Collaborated on debugging, troubleshooting, and resolving errors in ETL pipelines using logs and Informatica Debugger.

Education

• RGUKT Basar

  Pre University Course - M.P.C

  2013 — 2015

• Rajiv Gandhi University Of Knowledge Technologies Basar

  Bachelor of Technology

  2015 — 2019