Job Description
Job ID 815789
Location Pasadena,  CA
Other Location
Description The Senior Ab Initio Developer will be primarily responsible for ETL tools development to build a mission critical enterprise market data platform, which supports various data management needs within The Company. 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 the market data management team.  He/she will also work closely with the Project Manager, Lead Systems Architect, JAVA developers, QA engineers, and Business Analyst throughout project lifecycle under minimum supervision of project manager.

  • Work with Database Developer/Molder, JAVA developer, Business Analyst, DBA, System Administrator, and QA engineer to design and implement ETL workflow and programs required for various market data systems.
  •  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.
  Option 1: Create a New Profile
  Option 2: Login and Apply

Apply With