I Created schemas and provided grants as per requirements.
I Creating table, index, Views and applying constraints as when required.
Used PL/SQL to create Packages, Functions, and Procedure.
Usage of Advanced PL/SQL concepts such as Collections, REF Cursors, Bulk Collect.
Tuning of the SQL queries, which takes long time to process the request using Explain Plan, Hints to reduce the response time.
Used SQLLoader or External table for loading flat file into tables.
Post-coding tasks includes supporting deployment in TEST/PROD servers.
Analyses and discuss the business requirements with the clients.
Extensively used Informatica Designer to create and manipulate Source and Target definitions, Mappings and Transformations.
Extensively worked on Informatica Power Center Transformations such as Source Qualifier, Lookup, Filter, Expression, Router, Joiner, Update Strategy, Rank, Aggregator, Sorter and Sequence Generator.
Have clear understanding of Data warehousing and Business Intelligence concepts with emphasis on ETL and life cycle development using Power Center, Repository Manager, Designer, Workflow Manager and Workflow Monitor.
Knowledge of complete Software Development Life Cycle(SDLC) including Requirement Analysis, Requirement Gathering, Project Management, Design, Development, Implementation and Testing.
Configured Oracle Golden Gate Processes like Export, Remote Pump, Fanout and Replicat.
Good Experience on different Oracle.