Senior ETL Developer - (US-CA-Pasadena)

Senior ETL Developer - (US-CA-Pasadena)

Compensation: $75.00 - $80.00 / Hour
Minimum Education: Bachelors
Job Type: Contract
Jobcode: WJKJA37

The Senior ETL Developer will be primary responsible for ETL tools development to build a mission critical enterprise risk platform, which supports various portfolio risk management needs within Western Asset. The person will implement tasks related to data management, data extraction, business/IT rule transformation, data load to target system, and exception management, as well as support other production ETL processes and systems in risk management team. He/she will also work closely with Sr. Database Developer, Quant/SAS developers, QA engineers, and Business Analyst through out project lifecycle under minimum supervision of project manager. 

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. 





Competencies: 



§ 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 


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. 

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