Karthic

• Over 15+ years of professional experience in Data warehouse, Relational Database and System Integration, Proficiency in gathering and analyzing user requirements and translating them into business solutions. • Around 10 years of Strong experience in development and design of ETL (Extract, Transform and Loading data) methodology for supporting data transformations and processing ETL solutions using Informatica Intelligent Data Management Cloud , Informatica Power Center and Informatica Data Quality (IDQ). • 2 years extensive experience in Python (Programming Language), Data Analysis, Development Tools, Data Structures, and Algorithms and worked on Predictive analytics use-cases using Python language. • Experience in orchestrating complex data integration workflows across hybrid and multi-cloud environments using IDMC taskflows and mappings. • Experience in AWS cloud data platforms to analyze and validate data between different processing zones within our S3. • Experience in AWS cloud data platforms to analyze and validation of the data between different processing zones within our S3. • Experience in writing SQL queries, functions, packages, cursors and stored procedures, database triggers using PL/SQL in Oracle & Snowflake. • Hands on experience in AWS cloud services such as S3, AWS Glue, EC2, EMR and Redshift. • Expertise in Performance tuning mappings, identifying, and resolving performance bottlenecks at various levels like sources, targets, mappings, and sessions. • Extensive experience in Data profiling and Data cleansing using Informatica, SQL Scripts, Stored Procedures, and execution of test plans for loading data successfully into the target Systems. • Data Engineer specializing in modern ELT workflows using dbt, Snowflake, Fivetran, and Airflow. • Proficient in dbt Core and dbt Cloud, with advanced SQL modeling and CI/CD integration.