Sr. Data Base and ETL Developer/Consultant - (US-CA-Pasadena)

Minimum Education: Bachelors

Job Type: Full Time

Jobcode: WJKJA106



Long Term Assignment

Rate to $720 p/d corp to corp (less on a W-2)



 Minimum of 5 years intensive hands-on ETL workflow design and implementation experience in Ab Initio for enterprise applications.

 Minimum of 5 years of intensive SQL and PL/SQL programming experience.

 Minimum of 2 years experience with performance turning around ETL workflow, query optimization, indexing etc.

 Familiar with Oracle 10g or 11g features.

 Familiar with UNIX and Windows development environments and various scripting languages e.g. PERL and Autosys.

 Familiar with source code management and deployment tools such as SVN, CVS, Ant, and Ant Hill Pro.

 Familiar with IT SDLC methodology and best practices.

 Prior hands on experience with Ab Initio SAS plug-in and integration with FinCAD is plus.

 Prior hands on experience with J2EE, XML, industry popular frameworks, libraries, and application servers is plus.

 Prior experience with fixed income business and implementation of risk management system is a huge plus.

 Highly self-motivated, results oriented, and capable of independent and critical thinking and problem solving



RESPONSIBILITIES/DUTIES:



 Work with Database Developer/Molder, Quantitative/SAS developer, Business Analyst, DBA, System Administrator, and QA engineer to design and implement ETL workflow and programs required for the enterprise risk system.

 Design new ETL workflow and/or customize/maintain existing workflows and processes.

 Implement ETL processes primary in Ab Initio.

 Propose Ab Initio features for best design, customization, and user experience.

 Develop SQL, PL/SQL programs, and scripts to support various data operations required by applications.

 Optimize performance by analyzing, ETL workflow and query patterns.

 Manage ETL artifacts in source code management system and deploy to DEV, QA, and Production environments.

 Analyze issues & fix defects during SDLC, troubleshoot production issues, and respond to business users data inquiries.

 Produce ETL design documents, test plans, and system requirements.

 Understand complex data requirements such as Terms and Conditions, market, position and price data of vast fixed income and derivative securities.



Please quote your best rate and email a resume in Word that makes it obvious how you match the specification



Email resume in Word to TheBigGameHunter@cisny.com. Please include the job code for the position with your resume.



NO RELOCATION. NO VISA TRANSFERS. NO OVERSEAS RESUMES. NO 3RD PARTIES.

To receive a complimentary subscription to my job search ezine, No B.S. Job Search Advice, go to www.JeffAltman.com to subscribe.



Receive tweets from Twitter with job search tips and job listings – TheBigGameHuntr

See this Amp at http://amplify.com/u/a1j4z5