Ab Initio ETL Developer (AVP C12)

About the position

The Senior ETL Developer position requires a candidate with AbInitio ETL experience. The key responsibility will be the development and maintenance of ETL components of the Price Master Central (PMC) system. Interaction will be required with a global development team comprising Business Analysts and developers across different sites globally. Support in packaging and implementation across the different environments will be required, as well as aiding/supporting the user acceptance testing phase. The PMC application, Price Master Central (PMC), is a global reference data management application responsible for sourcing securities/Pricing data from market vendors and internal Citi sources and providing it to downstream clients after applying client-specific rules. ISG is looking for a Senior ETL Developer with 9+ years of experience in ETL (Abinitio) for a hands-on role on the Reference Data Team focused on expanding and maintaining the firm centralized reference data platforms Price Master Central (PMC) used by the Capital Markets division of ICG.

Responsibilities

• Developing and maintaining systems within PMC ETL stream.
• Work on Talend migration initiatives and building generic components as part of architecture.
• Work on Client Onboarding and managing reference data static domain tables.
• Work directly with global application development teams, Operations teams/partners to successfully integrate.
• Manage process streams assigned and work with Vendor teams (part of ETL) to assign tasks, manage and report status.
• Perform unit testing with proper documentation to adhere to application standards.
• Work closely with other team members, onsite and remote to ensure consistent approach to development is used within the application.
• Engage in architecture definition of new processes and review existing processes for improvements.
• Involve in strategic Talend Migration initiative to setup the ETL architecture.
• Provide ongoing maintenance and L3 production support.
• Keep up to date with new technologies and their possible adoption within ISG.
• Work on data initiatives within ISG (Automation and utilities).

Requirements

• Minimum 5-8 years of experience required.
• Strong command of Abinitio and working with relational databases.
• Proven proficiency in dealing with complex technical issues across all aspects of the project lifecycle.
• Knowledge and experience working with Batch and real-time processes (including micrographs).
• Experience of working and managing work allocation with other teams (including vendor teams).
• Experience of working in a demanding and results-driven, time-critical environment.
• Ability to work in a dynamic team environment which includes developers working with different technologies (such as Java, Web Services and C#/.NET) and across multiple regions.
• Experience with Ab Initio GDE and Co>Op (including experience with Conduct>IT).
• UNIX/Linux Shell scripting.
• Oracle concepts, SQL, PL/SQL.
• SQL performance tuning.
• Autosys.
• Prior experience with Reference Data (Securities and Pricing).

Nice-to-haves

• IBM Data Stage.

Benefits

• Medical, dental & vision coverage.
• 401(k).
• Life, accident, and disability insurance.
• Wellness programs.
• Paid time off packages, including planned time off (vacation), unplanned time off (sick leave), and paid holidays.