Expert knowledge of IBM DataStage ETL with at least 5 years of hands-on experience is required.
Experience in the Investments / Financial setting is strongly preferred.
Experience in ETL / Database interaction - Oracle (Enterprise and Connector), SQL Server / ODBC Connector.
Familiarity with DataStage Director, DataStage Admin, Operating Console tools.
DataStage v. 11.5 or higher in the Linux / Unix Server environment is strongly preferred.
Strong experience with Oracle 11g or higher - at least 5 years of Oracle experience is required.
Good understanding of Oracle on DB architecture level and Oracle SQL & PL/SQL developer's level.
Efficiently operate strings, dates, numeric data, both interactively (e.g. through TOAD or SQL Plus or similar tools) and programmatically (PL/SQL).
Analytical mind-set with hands-on skills in writing SQL queries to profile the data sets; ability to analyze, summarize and mine data, find data patterns and logical data dependencies.
SQL Server Database 3 years of experience required.
Good familiarity with DataStage Server Migration.
Familiarity with Business Objects and Business Intelligence tools.