Skip to main content
portfolio@
saran-durgam
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
[email protected]
+1 940 366 8108
linkedin
github
visitor@portfolio
:
~
$
echo "Thanks for visiting!"
Saran Durgam — Senior Data Engineer at Cigna Healthcare | grad.jobs