Nandini Purimitila

About Nandini Purimitila

Informatica IICS Developer with 4 years of experience in designing, developing, and implementing data integration and ETL solutions using Informatica IICS Cloud, PowerCenter, CDI, and CAI. Proficient in oracle SQL Developer, Snowflake, windows, UNIX, and Shell Scripting, with a strong background in data warehousing and real-time integration. Adept at optimizing data workflows, troubleshooting complex ETL issues, and delivering high-quality, scalable solutions. Seeking a challenging IICS Developer position to leverage technical expertise and contribute to innovative data integration of projects.

Experience

1. Etl Developer

   Tata Consultancy Services

   Oct 2022 — Present · Bengaluru, IN

   Designed, developed, and maintained ETL workflows using Informatica PowerCenter and Informatica Intelligent Cloud Services (IICS) for large-scale data integration projects.• Developed and optimized complex IICS mappings involving transformations such as Source, Target, Aggregator, Joiner, Normalizer, Sequence, Lookup, and SQL.• Created various IICS Tasks including Mapping Tasks, Data Synchronization Tasks, Dynamic Mapping Tasks, and Data Transfer Tasks using Oracle and Snowflake as data sources and targets.• Designed and implemented Taskflows with complex logic such as Parallel Paths, Sequential Tasks with Decision Steps, File Watch Tasks, Notification Tasks, Command Tasks, and Jump Steps.• Configured and managed Input, In-Out Parameters, and Parameter Files for dynamic mapping execution across multiple environments.• Developed Incremental Load processes and implemented SCD Type 1 & Type 2 techniques for maintaining historical data in data warehouses.• Built and deployed Service Connectors for real-time integrations with third-party applications, leveraging Application Integration (CAI) capabilities.• Created Business Services using JSON for API-based integrations and workflow automation.• Worked extensively on Dynamic and Unconnected Lookups and implemented Lookup Caching for performance optimization.• Developed ETL frameworks for data extraction, transformation, and loading, ensuring scalability and reusability.• Experienced in IICS Data Integration Components such as Mappings, Taskflows, and all associated tasks.• Hands-on experience in Informatica PowerCenter 10.2.0, including Designer, Repository Manager, Workflow Manager, and Workflow Monitor.• Designed Source-to-Target mappings, applying complex transformations like Lookup, Aggregator, Router, Update Strategy, Joiner, and Rank.

Education

• JNTU Anantapur

  Bachelor of Technology - BTech, ECE

  2017 — 2021