Kapil Dev Email & Phone Number

• 8 years of IT experience in Data Engineering/Data-Warehousing, building Data/ETL pipelines with ETL tools both on-premise and Azure cloud technologies.• Highly skilled in Informatica PowerCenter,Informatica cloud services, Oracle, SQL Server, UNIX Shell Scripting,Tidal and Control-M.• Experience in migrating existing solutions on on-premise systmes/applications to Azure cloud.• Experienced in extracting data from on-premise source systems like oracle,salesforce,sap,flat files and other relational databases.• Vast experience in developing complex mappings using Source Qualifier, Router, Filter, Expression, Aggregator, Joiner, Update Strategy, Normalizer, Sequence Generator and Lookup, Union, Stored procedure and java transformations.• Experience in integrating various data sources such as Oracle, SQL Server, Salesforce, SAP, Teradata and Flat files and XML files.• Extensively worked on Push down optimization for CDC Sessions.• Experience in Deploying the signed-off new or changes to production environment by coordinating with the ETL/DB Admin/Support/Scheduling/Change Management teams by following all the necessary change management processes.• Experience working with Informatica cloud Service, worked on Creating Data replication tasks, Data synchronization tasks, mapping tasks to extract the data from Salesforce and SAP Source systems.• Proficient in Writing SQL Scripting and PL SQL Programming.• Proficient in UNIX Commands and shell scripting.• Hands on experience on Tidal,AutoSys, Control-M Scheduling tools.• Hands on experience working on Rest api data Ingestion using Matillion ETL.• Worked on end to end data Intigration components in matillion.• Strong hands on experience working with snowflake and Dynamics table, Tasks, Streams.