Damini Patil

LPL Financial – Banking & Financial Services Project 1: Migrated databases from SSMS to AWS RDS Designed and optimized ETL mappings in PowerCenter. Ensured data validation, integrity, and performance tuning. Project 2: Informatica PC to IICS Migration Migrated Informatica PowerCenter mappings to IICS (IDMC). Worked with banking data across SSMS and Oracle. Used Git for version control and JIRA for Agile tracking. Partnered with stakeholders for seamless deployment and testing. Built scalable data integration flows for customer data. Designed and implemented SCD logic (Type 1/2/3) in IICS. Integrated data from Oracle, SQL Server, and flat files. Created reusable parameterized mappings and handled production support issues.

Supported SAP data processing applications using Informatica PowerCenter, IICS, Denodo, QlikView. Worked with SSMS, Oracle, Snowflake, GCP BigQuery, AWS S3. Implemented IICS workflows using Data Integration, Application Integration, Mass Ingestion, Administration, Monitoring. Automated job executions with UNIX scripts and Pub/Sub. Ensured data consistency, reporting accuracy, and system performance. Maintained and enhanced existing ETL processes in Informatica PC. Resolved production issues and supported high-availability data pipelines. Worked closely with onsite teams for impact analysis, debugging, and optimization. Implemented pushdown optimization and pre/post SQL strategies for session tuning.