Informatica developer worked as Technical Architect with all phases of SDLC and in implementing staging, operation data stores (ODS) and dimensional data modeling in large Data warehouses using Informatica PowerCenter 9.1/9.5/8.5, Oracle, DB2, SQL, teradata Server on UNIX and Windows platforms on Health Care, Banking, Financial and Sales Domains
Used IDQ to profile the project source data, data cleansing, data matching, exception handling, Consolidation and provide information on how to proceed with ETL processes.
Used the Informatica PowerExchange used Change Data Capture i.e. CDC Option which captures changes as they occur and deliver up-to-the-minute sales data to the enterprise
Extensively involved in ETL testing, Created Unit test plan and Integration test plan to test the mappings, created test data. Use of Debugging tools to resolve problems.
Worked on Informatica Scheduler and Control-M, Autosys to schedule the [url removed, login to view] strong knowledge of SQL, PL/SQL, Unix Scripting and Performance Tuning.
13 freelancers estão ofertando em média ₹2079/hora para este trabalho
I have worked on multiple projects of pl/sql and autosys job.Having good experience of unix shell scipting.Strong knowledge of pl/sql .This suites for my profile and i can do it in better way.