Senior Data Integration Architect with 15+ years IT experience

Seenu Subramaniam Srinivasan

Address: **** ********** *****, ***** ** 75024

Phone: 214-***-****

Email: ***********@*****.***

Professional Summary: Senior Data Integration Architect with 15+ years of experience in enterprise data warehousing, ETL development, and cloud data integration. Over 6 years of hands on experience with Informatica Intelligent Cloud Services (IICS) and Informatica Intelligent Data Management Cloud (IDMC) delivering large-scale enterprise data integration and migration solutions. Proven expertise in migrating Informatica PowerCenter assets to IICS/IDMC, designing scalable ETL pipelines, optimizing SQL performance, and implementing automated DevOps deployment processes. Extensive experience across banking, telecom, healthcare, and retail industries.

Technical Skills

ETL & Data Integration: Informatica IICS, IDMC, Informatica PowerCenter, DataStage, SSIS, Pentaho

Cloud & DevOps: AWS S3, AWS EC2, JFROG Artifactory, IBM UrbanCode Deploy, CI/CD Pipelines

Databases: Oracle, Teradata, SQL Server, MySQL, Netezza, Informix

Languages: SQL, PL/SQL, Python, Korn Shell, Perl, C, COBOL

Tools: Toad, SQL*Plus, SQL Loader, ESP Scheduler, Control M, AutoSys, TFS

Operating Systems: HP UX, AIX, Sun Solaris, Windows

Education

Master of Science in Computer Science – City University of New York (CUNY)

Bachelor of Engineering in Electronics Engineering – India

Professional Certifications

Teradata Certified Master

Brainbench Certification in Oracle PL/SQL

Professional Experience

Artech Inc – Consultant Jan 2026 – Present

Working on a large enterprise migration program converting Informatica PowerCenter workflows, mappings, and sessions to IICS/IDMC Data Integration services. Designed and implemented cloud-native IICS mappings, mapping tasks, and taskflows. Developed advanced Oracle SQL validation scripts and analytical functions to reconcile PowerCenter vs IICS results. Implemented automated validation frameworks to ensure accuracy during migration.

Randstad Consulting – Consultant Sept 2025 – Dec 2025

Maintained and enhanced Informatica ETL pipelines supporting investment account data processing. Developed SQL and PL/SQL logic to validate data transformations and improve performance. Prepared several ETL pipelines for modernization and migration to IICS/IDMC environments. Worked on ORACLE Databases.

Tata Consultancy Services – Consultant Oct 2024 – Sept 2025

Developed and maintained enterprise ETL pipelines using Informatica PowerCenter and Informatica IICS. Designed multiple IICS mappings, mapping tasks and taskflows integrating Salesforce, Oracle and flat files. Implemented hybrid integration using IDMC to orchestrate data pipelines between cloud and on prem environments. Exported PowerCenter XML metadata and re-engineered workflows as IICS pipelines. Worked on ORACLE databases.

TEKsystems – Global Projects Consultant May 2021 – Apr 2024

Worked on three Client Assignments: PNC Bank, Availity Inc and Pratt & Whiney. Designed large-scale enterprise ETL solutions. Built reusable IICS mappings and taskflows to cleanse, validate, and integrate enterprise data. Developed automation frameworks using shell scripts and Python to support ETL operations. Implemented data quality rules using Informatica Data Quality (IDQ). Managed deployment pipelines using JFROG Artifactory and IBM UrbanCode Deploy. Configured TPT to load through ETL process into Teradata Databases Worked on TERADATA, ORACLE, SQLSERVER, and MySQL Databases.

Bank of New York Mellon – Consultant Aug 2020 – Jan 2021

Designed ETL solutions using Informatica PowerCenter and prepared migration strategy for cloud data integration using Informatica IICS. Developed Oracle PL/SQL procedures supporting financial data integration pipelines. Also, fulfilled the role of a Data Analyst and prepared detailed Requirements and Design Documents by understanding the Business Context Diagrams

Earlier Experience (2010 – 2020)

Worked with Verizon, Bank of America, Infosys, Solera, XO Telecom, PepsiCo delivering enterprise data warehousing solutions using Informatica PowerCenter, DataStage, SSIS, Korn Shell scripts. Performed a POC to load data into ORACLE tables through AWS S3 buckets. (File System)

Configured TPT to load through ETL process into Teradata Databases. Developed Shell Scripts, COBOL JCL, CONTROL CARDS, BTEQ Scripts, ORACLE SQLLOADER, TERADATA LOAD scripts like mload, TPUMP. Worked with ORACLE, SQLSERVER, TERADATA Databases.

Visa Status

U.S. Citizen

Contact this candidate