KARTHIKEYAN KUMARAVEL

• Having 3+ years of experience in Informatica Power Center, IICS / IDMC, IDQ, Snowflake, AWS, SQL, PL/SQL and Excel.
• Optimized SQL queries to increase data retrieval efficiency by 25%.
• Collaborated with cross-functional teams to understand data requirements and optimize Mapping and data integration workflows, providing actionable insights and supporting business data strategies.
• Deployed and managed Informatica Data Management Cloud (IDMC) pipelines for automated data ingestion, transformation, and distribution across cloud platforms, optimizing data flows and enabling efficient reporting.
• Using Informatica Power Center for Extraction, Transformation, and Load (ETL) of data in the data warehouse.
• Using Informatica Power Centre tools developed workflows using task developer, worklets designer, and workflow designer in workflow manager and monitored the results using workflow monitor.
• Designed and implemented data integration workflows using Informatica Intelligent Cloud Services (IICS) for real-time and batch data processing, ensuring high-quality data migration and synchronization across enterprise systems.
• Advanced ETL development, performance tuning, workflow automation, and error handling using Workflow Manager, Designer, and Monitor.
• Reduced ETL job runtime by 40% through partitioning, pushdown optimization, and incremental loading strategies.
• Migrated 50+ on-premise PowerCenter workflows to IICS, improving scalability by 60% and cutting maintenance costs by 35%.
• Effectively made use of oracle database objects such as tables, views, mviews, synonyms, sequences and indexes.
• Well versed in writing Complex SQL queries, Functions, Constraints, Joins, Sub queries, Pseudo columns and Set operators.
• Having Basic Knowledge in PL/SQL Stored Procedures, Functions, Cursors, Exception Handling and Package.

INFORMATICA POWER CENTER