Having 2.0 Years of total IT experience in Data warehousing with Informatica Power CenterTechnical Skills:ETL Tool : Informatica Power Center 10.XSupporting Tools : SQL, Putty, WinSCP.Data Bases : Oracle, Sybase, RedshiftResponsibilities:• Populating the data from the source system to existing tables in ODS and EDW through the ETL tool.• Worked with project managers, business analysts, DBAs to achieve business and functional requirements.• Performing code migrations as part of weekly/Monthly Change request releases.• Discuss on Change requests, requisite analysis, Defect identified, Root cause and its resolutions• Verifying the data which is loaded into target database.• Triggering the job from Scheduler.• Running the Informatica Workflows for ETL Process.• Validated data in Target database according to business rules.• Developed mapping to load the data ran Autosys job to populate data created & configured workflow.• Prepare the unit cases and executed test plans.• Expertise in validating the external sources like DB2 etc. through power exchange.• Extensively using transformations for homogenous and heterogeneous data joins like joiner, and created various transformations like joiner, aggregator, expression, filter, update strategy and lookup.• Efficiently working on Report Requests that are raised by the user.• Completion of RRs within SLA and moving to production.• Any issue in production should clear in time and delivering Reports.• Tickets to be closed in SLA period and provide solution to the user.• Expertise in data loading into tables by using different parameters.