Anjan Kumar Kanamarlapudi Email & Phone Number

Worked on Agile Methodology, participated in daily/weekly team meetings, guided two groups of seven developers in Informatica IICS, IDMC and proposed ETL strategies based on requirements.• Involved in Migration from Informatica PowerCenter to Informatica Intelligent Cloud Services (IICS).• To interact with SMEs and Business to understand the requirements.• Create / Update data models to accommodate new requirements and publish the data models.• To get the logical model reviewed with Business users and enterprise architects for approval.• Analyze the requirements and prepare documents which include high level and low-level design documents, and Data flow diagrams.• Configured AWS Cloud Watch to monitor the Role creation and alerts whenever a new role is created.• Designed, Developed, and Implemented ETL processes using lICS Data integration.• Designed, Developed and Implemented ETL processes using IICS/IDMC Data integration• Created IICS/IDMC connections using various cloud connectors in IICS/IDMC administrator• Installed and configured Windows Secure Agent register with IICS org.• Extensively used performance tuning techniques while loading data into Azure Synapse using IICS.• Designed, developed, and implemented integration solutions using Informatica Intelligent Cloud Services (IICS) to connect various enterprise applications and systems.• Design Mappings and create corresponding mapping tasks and task flows in IICS.• Create Mass ingestion, Synchronization, and replication tasks as and when needed in IICS.

India

Collaborated with business stakeholders to define metadata standards and implemented metadata governance practices within IICS/IDMC.• Extracted data from Sql Server Datawarehouse and pushed the data to Amazon Redshift to support the cloud migration strategy using Informatica Cloud• Designed and implemented data pipelines in IICS/IDMC to load and transform data into a cloud data warehouse, leveraging IICS/IDMC's cloud-native capabilities for scalability and performance.• Interacted with business analysts and architects to analyze data models using er studio and gather the requirement specifications.• Understand the healthcare domain functionality and breakdown the requirements into high level and low-level design documents.• Breakdown the work into tasks list and provide estimations.• Coordinated with Offshore team lead and set direction for each sprint and deliverables.• Used Informatica PowerCenter to create mappings, sessions, and workflows. Created complex mappings in Power Center Designer using Aggregate, Expression, Filter, Sequence Generator, Update Strategy, SQL, Union, Lookup, Joiner, XML Source Qualifier, Unconnected lookup transformations etc...• Used Informatica IICS tool for Data Integration and Data Migration from multiple source systems like NoSQL, DB2, SQL, AWS S3, Azure Databricks for Data warehouse.• Extensively worked with Pipeline Partitioning like Round Robin Partitioning, Hash Partitioning, Key Range Partitioning, and Pass-through Partitioning.• worked extensively with Incremental Aggregation.• Worked on slowly changing dimension type 1 and type 2 mapping in IICS/Power center.

Master'S Degree, Computer Science

Bachelor'S Degree, Computer Science