Shivani J.

About Shivani J.

Experienced Senior Developer with 12 years of experience in Informatica Cloud(Data…

Experience

1. Associate Manager

   Accenture

   Mar 2022 — Present · Bengaluru, IN

   Project Lead – Data Migration (JMA Client)- Managed end-to-end data migration from Mainframe → Azure (ADF, SQL) → Salesforce via IICS for Contracts, Claims, and Master Data- Designed ADF pipelines, SQL transformations, and IICS integrations; ensured bidirectional data loads with strong validation and reconciliation- Extensively worked on IICS CAI for creating REST API\'s -Worked with multiple types of files like parquet, csv and json etc-Worked on POCS for IICS CDI and CAI -Extensive experience in Design & Development of Mappings, Sessions and Workflows-Expertise in using methodologies for data extraction transformation and loading data using various transformations like Expression Router Filter Lookup Update Strategy Union and Aggregator-Built parameterized and reusable ADF pipelines leveraging dynamic datasets, lookup activities, and global parameters to enable scalable multi-environment deployments- Integrated Azure Key Vault–based linked services to securely manage credentials and comply with enterprise security standards- Led cross-functional teams, coordinated with business stakeholders, and delivered project milestones with quality and compliance. Project Lead – Integration (Mondelez Client)- CI/CD practices for Data Quality projects, and overseeing project timelines and milestones to ensure successful completion-Designed and implemented Cloud Data Quality rules (completeness, consistency, uniqueness) to cleanse and standardize customer master data across Salesforce Accounts and Contacts-Created ICRT process to read /write SFDC metadata through REST API’s-Created scripts to create schema and target objects automatically using Salesforce metadata-Developed code in ICRT using process, guide, REST API’s of Informatica cloud-Proficient in writing complex sql queries, joins, subqueries, and windows functions for data extraction, validation.