Oracle Senior Programmer + Datastage Developer
CurrentEnvironment : DatawarehouseData base ; Oracle 11g and 12, Exadata.Using IBM datastage ,11.5 version (parallel version and sever as well) .Datastage knowledge :Extract data from external files,oracle tables other databases like DB2,XML files.Executing complexes processes on big data fastly as much that can be done.Utilizing the parallel property for faster process and reduce time in transactions.Oracle :Complex information retrieval on big databases and manipulate the data in efficiency way.Much knowledge of : SQL and PL/SQL to manipulate data and process it.Tunning queries.Using knowledge of many diffrent ways to write the same query.With helps of compress tables,indexes(locals,globals),explain plan,partitions,analitics fucntions ,bulk selects and DML ,dynamics selects and much more.