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
posted by Unknown at 10:12 AM
<< Home