visitor@portfolio:~$whoami
Informatica IDMC & PowerCenter Specialist | MDM Developer | ETL Migration Specialist
Irving, TX
visitor@portfolio:~$> cat README.md
Informatica IDMC & PowerCenter Specialist | MDM Developer | ETL Migration Specialist
visitor@portfolio:~$> experience --list
Senior Informatica Developer@The Cigna Group
Aug 2025 - Present[Plano, TX]
- Leads the migration of PowerCenter workflows and Master Data Management (MDM) applications to cloud-native IDMC/IICS environments.
- Architects IDMC mappings using pushdown optimization to reduce overall processing time by 30% for financial data integrations.
- Spearheads data validation frameworks and reconciliation analysis to ensure a 99.9% data integrity rate across production systems.
- Develops T-SQL procedures, functions, and advanced queries to support point-to-point integration for enterprise data marts.
- Mentors cross-functional team members on migrating code between test, Quality Assurance (QA), and production environments using GitLab.
Senior Informatica Developer@World Wide Technology (WWT)
Jan 2025 - Jul 2025[St. Louis, Missouri]
- Directed the transition of legacy PowerCenter mappings to IDMC Mapping Tasks by rebuilding complex logic for retail industry compatibility.
- Optimized cloud-based mappings through strategic parameterization, resulting in a 25% increase in execution efficiency.
- Managed comprehensive data validation processes using hash totals to achieve a verified data accuracy rate of 99.7%.
- Configured Secure Agents and audit logging to enable seamless, secure hybrid connectivity between Oracle and IDMC platforms.
- Orchestrated performance tuning of SQL Server statements and PL/SQL logic to support high-volume inventory data movement.
Senior Data Analyst@Emerson Electric
Aug 2024 - Dec 2024[St. Louis, Missouri]
- Led enterprise-level data profiling initiatives in IDMC and SQL Server to improve data completeness and accuracy by 20%.
- Architected Power BI dashboards integrated with IDMC and Snowflake to provide real-time KPI visibility for financial reporting.
- Directed the development of T-SQL reconciliation reports, maintaining source-to-target data accuracy at 99.8%.
- Spearheaded technical debugging and performance tuning of SQL statements executed by ETL code to meet stringent alert thresholds.
- Automated audit reporting and ETL documentation using Python scripts to eliminate manual overhead and ensure system compliance.
Senior Informatica Developer@Cisco Systems
Jan 2022 - Jul 2023[India]
- Led the development of IICS and PowerCenter mappings for complex batch and near real-time ERP data integrations.
- Developed reusable IDMC transformations and parameterized taskflows that reduced overall development effort by 15%.
- Managed Oracle and SQL Server optimization efforts, cutting query runtime by 20% for mission-critical accounting datasets.
- Spearheaded the implementation of partitioning strategies and pushdown optimization within a Windows operating system environment.
- Defines technical requirements and configuration standards for ETL environments to meet evolving user and security requirements.
Informatica Developer@Citi Group
Jun 2016 - Jan 2022[India]
- Managed high-volume banking data processing workflows using Informatica PowerCenter and enterprise-scale Oracle databases.
- Directed the optimization of T-SQL and PL/SQL procedures, improving batch reporting performance for financial users by 25%.
- Orchestrated large-scale data loading into Teradata using FastLoad and MultiLoad utilities for 50+ TB datasets.
- Spearheaded UNIX shell scripting initiatives for automated job monitoring and proactive error detection in production.
- Developed a complete set of ETL documentation describing system configurations and data movement logic for audit compliance.
visitor@portfolio:~$> npm install --save-dev
+Databases: SQL Server
+T-SQL
+Oracle
+PL/SQL
+Snowflake
+PostgreSQL
+DDL
+ETL & Integration: Informatica IDMC
+Informatica IICS
+Informatica PowerCenter
+Data Ingestion
+Pushdown Optimization
+CDC
+Cloud & Data Warehousing: AWS
+Azure
+GCP
+Teradata
+Enterprise Data Warehouse (EDW)
+Data Marts
+Languages & Programming: C# / .NET
+Python
+PySpark
+UNIX Shell Scripting
+REST API
+Tools & DevOps: GitLab
+Jenkins
+Control-M
+Autosys
+Git
+Secure Agents
+Windows OS
+Performance & Quality: SQL Tuning
+Data Profiling
+Data Validation
+Audit Logging
+Unit Testing
+Tuning Metrics
+Business Intelligence & Reporting: Power BI
+Tableau
+Financial Reporting
+KPI Visibility
+Sales & Inventory Data
visitor@portfolio:~$> cat /etc/education
Master of Science in Data Analytics
Saint Louis University
May 2025 | Saint Louis, MO, USA
Bachelor of Science
Sri Venkateshwara University
Apr 2015 | India
visitor@portfolio:~$> cat .contact
visitor@portfolio:~$echo "Thanks for visiting!"