Title: PLSQL-ETL Developer (NTTJP00002708)
Duration: 0-6 months
Location: San Francisco, CA
Day to Day job Duties: (what this person will do on a daily/weekly basis) Design solutions in Data Warehouse to meet business requirements Transform requirements to data models and designs based on analysis of data Have development experience in any ETL tool (Abinitio, Informatica, Data Stage etc) Create prototypes/PLSQL specifications based on requirements and analysis of data Works on production defect fixes. Support UAT and SIT by preparing the test environment and providing defect fixes. Production job monitoring Ability to work multiple priority projects at the same time Provides informal mentoring to less experienced colleagues. Develops innovative and creative output based on interpretation and analysis. Provides design and documentation at an application or function capability level. Effectively communicates application and technical direction to the business and within the client's IT organization. Advises on issues of systems integration, compatibility, scalability and multiple platforms.
Basic Qualifications: (what are the skills required to this job with minimum years of experience on each)
Minimum 5+ years of experience in Oracle-SQL
Minimum 5+ years of experience in Oracle PLSQL programming language.
Minimum 5+ years of experience in writing Packages/Functions/Procedures
Minimum 3+ years of development experience in any ETL tool (Like Abinitio, Informatica, Data Stage etc)
Minimum 3+ years of experience in Unix Shell Script and Autosys
Minimum 3+ years experience in performance tuning of database queries/ database schema
Minimum 3+ years of experience in wring high level and low level design Willing to learn new technologies
Degree: Bachelors in Computer Science or equivalent work experience