Datastage ETL Developer

This job is no longer active. View similar jobs.

POST DATE 9/12/2016
END DATE 10/24/2016

Modis San Francisco, CA

Company
Modis
Job Classification
Full Time
Company Ref #
23179923.21600993
AJE Ref #
576145117
Location
San Francisco, CA
Job Type
Regular
Required Licenses/Certifications
df-aj

JOB DESCRIPTION

span span style='color:#000000;background-color:transparent;font-family:Times New Roman;font-size:12pt;font-weight:normal;font-style:normal;' Modis' client has an opening for an ETL Developer with experience in Datastage and Oracle in San Francisco and Pleasanton (travel required to both locations). *If you would like to apply directly, please email stacy.song at modis.com* br /span B   /B span style='color:#000000;background-color:transparent;font-family:Times New Roman;font-size:12pt;font-weight:normal;font-style:normal;' br /span B Description: /B span style='color:#000000;background-color:transparent;font-family:Times New Roman;font-size:12pt;font-weight:normal;font-style:normal;' br The ETL developer  will work in the Oracle Financials/HR Technical Unit in the Information Technology Dept.  This Unit is responsible for the support, maintenance, and enhancement of the Banking Application. The current environment is in-house built Banking application interface with the various source system. br   br /span B Responsibilities: /B br ul
li Extensive hands-on experience in building ETL interfaces using Datastage 9.1 and higher to aggregate, cleanse and migrate data across enterprise-wide MDM, ODS and Data Warehousing systems using staged data processing techniques, patterns and best practices. /li li Strong experience in full lifecycle management of capturing, versioning and migrating various Datastage ETL metadata including data mapping and other data integration artifacts (such as schedulers, scripts, etc.) across environments using vendor platforms such as Data Stage,  or other equivalent tools (including open source) by establishing standards, guidelines and best practices. /li li Combined experience of advanced SQL and stored procedures (in DB2, SQL Server, and/or Oracle Database Platforms) with hands-on experience of designing solutions for optimal performance and handling other non-functional aspects of availability, reliability and security of DATASTAGE ETL Platform. /li li Experience with both normalized and dimensional data models, hands-on knowledge of other data integration techniques such as database replication, change data capture (CDC) etc. and familiarity of SOA and ESB technologies and patterns. /li li Strong knowledge of SQL, PL/SQL, and query tools (e.g.  SQLPlus, Toad, RapidSql etc.). /li li Strong knowledge of database systems such as Oracle, SQL Server and DB2 /li li Experience in RDMBS including Oracle 11x-12x and should have strong working knowledge in PL/SQL, SQL. /li li Extensively used UNIX scripts for scheduling the jobs. /li li Assists developers with difficult Oracle PL/SQL code needed for queries, triggers, and stored procedures /li li Design, develop, implement and maintain custom oracle applications written in PL/SQL. /li /ul
span style='color:#000000;background-color:transparent;font-family:Times New Roman;font-size:12pt;font-weight:normal;font-style:normal;'   br /span B Desired Experience/Skills /B span style='color:#000000;background-color:transparent;font-family:Times New Roman;font-size:12pt;font-weight:normal;font-style:normal;' br The Oracle Senior PL/SQL Developer shall possess most of the following technical skills and experience: /span br ul
li Current knowledge of trends in IT and experience in the development of new technologies /li li Experience with change management Procedures is a must. /li li Experience with SQL, PL/SQL and SQL*Loader. /li li Experience with SOX compliance environments with segregation of duties