09/29/2026 updated

**** ******** ****
100 % available

Sr Data Engineer | ETL & Data Integration Expert | Informatica IICS/PowerCenter | AWS | Snowflake

Bengaluru, India
Only remote
Bachelor of Engineering in Computer Science
Bengaluru, India
Only remote
Bachelor of Engineering in Computer Science

Profile attachments

Vinoth_ETL_Informatica_IICS_14YOE.pdf

About me

Senior Data Engineer with 14 years of experience in designing scalable ETL pipelines using Informatica IICS/PowerCenter, IDMC –CDI, AWS, Snowflake and Redshift. Expertise in data warehousing, SCD implementation, dimensional modelling and data governance. IDMC & Databricks certified.

ETL & Data Integration
Extensive expertise in designing and optimizing scalable ETL pipelines using Informatica IICS, IDMC-CDI, and Informatica PowerCenter 10.5.2. Delivery of up to 75% pipeline performance improvement and 60% reduction in execution time across banking, investment, telecom, and automobile domains.

Cloud and Data Platforms
Hands-on experience with Snowflake, AWS (S3, Athena, Glue), and Amazon Redshift. Design and implementation of cloud-based data pipelines, ELT architectures, and bulk loading strategies to optimize query performance and reduce data movement overhead.

Data Modelling & Warehousing
Strong background in dimensional modelling, Star Schema, and Snowflake Schema design. Implementation of Slowly Changing Dimension (SCD) Types 1 and 2 to efficiently handle delta loads and enable accurate data ingestion processes.

Programming Languages
Proficiency in Oracle SQL, PL/SQL, MS SQL, and PySpark for data processing, query optimization, and pipeline development across various enterprise environments.

BI & Visualization
Experience with Tableau and Tableau Prep Builder for developing interactive dashboards and generating .hyper extract files, improving business performance and enabling faster strategic decision-making.

Data Governance
Implementation of data governance initiatives using IBM Infosphere Governance Catalog, including defining 30+ business glossary terms and enforcing data quality rules to enhance enterprise data integrity.

Databases
Extensive work with Oracle databases (10g, 11g, 12c), including development of PL/SQL packages, procedures, functions, and bulk data loading using SQL*Loader for high-volume record processing.

Scheduling & Orchestration
Use of Autosys for job scheduling and orchestration of data pipeline workflows in enterprise environments.

DevOps Tools
Familiarity with Git, SVN, CI/CD pipelines, LINUX, and UNIX environments to support version control and continuous integration practices.

Defect Management & Methodologies
Experience with JIRA, HP ALM, Rally, and Azure DevOps for defect tracking. Application of Agile, Scrum, and Waterfall methodologies across cross-functional project teams.

Experience

Professional experience10+ years
Freelancer since2026

Languages

EnglishFluent

Project history

Senior Principal Analyst (IICS)

Factspan Analytics, Bengaluru
Reduced patient experience data processing time by 40% and cloud processing costs by 25% by optimizing Informatica IICS ETL pipelines and implementing efficient incremental data-loading strategies. Enabled faster, reliable patient experience reporting by integrating data from multiple healthcare systems into a centralized analytics platform using Informatica IICS. Improved data pipeline efficiency and quality by tuning complex IICS mappings, optimizing transformations, and implementing data validation and error-handling frameworks.

Senior Data Engineer

TCS, Bengaluru
Contributed to end-to-end implementation of data pipelines orchestrating data flow from the ODI layer through to the RADAR reporting layer using Informatica PowerCenter for banking domain. Optimized mapping performance by fine-tuning transformations and SQL queries, reducing SLA from 2 hours to 25 minutes and achieving a 75% enhancement in data processing efficiency. Designed scalable ETL pipelines processing large-volume banking data using Informatica PowerCenter. Developed and implemented SCD Types 1 and 2 approaches to handle delta loads. Drove data governance initiatives by defining 30+ business glossary terms in IBM Infosphere Governance Catalog.

Lead Software Engineer

Fidelity Investment, Bengaluru
Designed batch ETL pipelines using IICS (CDI) integrating Oracle, AWS S3, Snowflake, and Tableau. Optimized pipeline performance by leveraging S3 staging and Snowflake bulk loading, reducing execution time by 60%. Designed and optimized Snowflake tables, views, and ELT pipelines improving query performance and analytical efficiency. Implemented Snowflake-based ELT architecture enabling in-database transformations. Built dimensional and fact tables (Star and Snowflake schema) to support reporting and analytics use cases.

Senior BI ETL Developer

USEReady Technology India Private Limited, Bengaluru
Implemented a business intelligence solution to address the organization's data analysis and reporting requirements. Designed, developed, and maintained ETL processes to extract, transform, and load data from diverse sources including database tables and flat files, generating .hyper extract files for dashboard creation through Tableau Prep Builder. Developed interactive dashboards which improved business performance by 65% by enabling faster insights and more strategic decision-making.

Senior Software Engineer

CenturyLink Technology India Private Limited, Bengaluru
Designed scalable cloud-based data pipelines integrating AWS S3 Data Lake, IICS, and Amazon Redshift. Implemented data ingestion, staging, and archival strategies for structured and semi-structured data. Improved data load performance by 40% using parallel processing and optimized Redshift loading techniques. Built end-to-end ETL pipelines for enterprise data integration across multiple source systems.

Senior Software Engineer

Robert Bosch Engineering Business and Solutions Private Limited, Coimbatore
Developed 10+ PL/SQL packages, procedures, and functions to manage and process data for core automotive business workflows, reducing manual data handling effort by approximately 30%. Optimized ETL performance by creating indexes and fine-tuning SQL queries using optimizer hints, reducing average query execution time by approximately 35%. Designed and deployed Oracle Forms and Reports applications to meet business needs for cross-functional teams across the automobile domain.

Senior Software Engineer

IGEFI Software India Private Limited trading as Multifonds, Bengaluru
Collaborated with clients and business consultants to analyze and translate functional requirements into technical specifications. Developed and optimized 15+ database components including packages, cursors, collections, materialized views, partitions, and indexes, improving query performance by approximately 40% for investment fund reporting processes handling millions of daily records. Loaded and processed large-volume data into Oracle databases using SQL*Loader, handling batch files of 500K-1M+ records. Designed Oracle Forms and Reports applications to support business reporting needs across investment fund management workflows.

Certificates

Informatica Intelligent Cloud Prof Certified

Informatica

2025

Databricks Certified Associate

Databricks

2025

Contact form

Log in to get in touch

You need to be logged in to use the contact form.

Sign upLog in