• 10+ Years of extensive experience in Talend cloud,Informatica development and production support of Enterprise Data Warehouse in HCL Technologies Limited.• Worked extensively as an ETL Developer using Talend cloud, Informatica PowerCenter & IBM Data Stage. Worked on SQL and PL/SQL Development on demand basis.• Responsible for understanding and gathering requirements from client SMEs/BA, implementing them as per the business needs, create/update functional specifications assuring quality (TAT's, SLA's) and industry best practices.• Experience in extraction, transformation and loading of data from different source systems.• Extensively worked on various kinds of the transformations to implement simple and complex business logic. Ex: Source qualifier, Joiner, Expression, Lookup, Aggregator, Router, Filter, Stored Procedure, Update Strategy and Sequence Generator.• Experience in scheduling and monitoring the Informatica inbuild scheduler and Control M jobs.• Extensive experience on End-to-End informatica production support.• Enhancement/process improvement work on client environment.• Created and maintained PL/SQL scripts, stored procedures and object types. Inheriting PL/SQL object types.• Responsible for writing programs, functions and queries in order to manipulate the data and structure of a database using the Structured Query Language.• Possess poised knowledge of Relational Databases (Data Warehouse, Data Mart, Star Schema, Snowflakes Schema and Dimension Modelling).• Writing complex SQL Queries to filter out data at early stage of ETL cycle• Experience in Unix shell scripting and Windows PowerShell scripting.