Ab Initio ETL Developer (AVP C12)

CITI; Tampa (FL); On-site; USD 87,000 - 131,000; Full time

Job summary

An established industry player is seeking a Senior ETL Developer to enhance their centralized reference data platforms. This role involves developing and maintaining ETL components for a global reference data management application, ensuring integration with various teams, and supporting user acceptance testing. The ideal candidate will have extensive experience with Ab Initio and relational databases, and will thrive in a collaborative, fast-paced environment. Join a forward-thinking team where your expertise will contribute to critical data initiatives and transformation projects, while enjoying competitive benefits and a supportive workplace culture.

Benefits

Medical coverage

Dental coverage

Vision coverage

401(k) plan

Paid time off

Wellness programs

Qualifications

• 9+ years of ETL experience with strong command of Ab Initio.
• Experience with relational databases and complex technical issues.

Responsibilities

• Develop and maintain ETL components for Price Master Central (PMC).
• Engage in Talend migration initiatives and manage reference data.

Skills

Ab Initio

SQL

UNIX/Linux Shell scripting

Oracle concepts

SQL performance tuning

Batch and real-time processes

Client Onboarding

Reference Data Management

Education

Bachelor’s degree in Engineering or Computer Science

Tools

Talend

Autosys

IBM Data Stage

Job description

Senior ETL developer position requiring a candidate with AbInitio ETL experience. The Key responsibility will be development and maintenance of ETL components of Price Master Central (PMC) system.

Interaction will be required with global development team comprising of Business Analysts and developers across different sites globally. Support in packaging and implementation across the different environments will be required and 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 Reference Data Team focused on expanding and maintaining firm centralized reference data platforms Price Master Central (PMC) used by Capital Markets division of ICG.

Responsibilities:

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

Qualifications:

• 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.
• All potential candidates must be able 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.
• 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).
• Skills that are a plus:
• IBM Data Stage.

Education:

Bachelor’s degree - Engineering or computer science.

Job Family Group: Technology

Job Family: Technology Project Management

Time Type: Full time

Primary Location: Tampa Florida United States

Primary Location Full Time Salary Range: $87,280.00 - $130,920.00

In addition to salary, Citi’s offerings may also include, for eligible employees, discretionary and formulaic incentive and retention awards. Citi offers competitive employee benefits, including: medical, dental & vision coverage; 401(k); life, accident, and disability insurance; and wellness programs. Citi also offers paid time off packages, including planned time off (vacation), unplanned time off (sick leave), and paid holidays. For additional information regarding Citi employee benefits, please visit citibenefits.com. Available offerings may vary by jurisdiction, job level, and date of hire.

Anticipated Posting Close Date: Apr 21, 2025

Citi is an equal opportunity and affirmative action employer.

Qualified applicants will receive consideration without regard to their race, color, religion, sex, sexual orientation, gender identity, national origin, disability, or status as a protected veteran.

Citigroup Inc. and its subsidiaries ("Citi”) invite all qualified interested applicants to apply for career opportunities. If you are a person with a disability and need a reasonable accommodation to use our search tools and/or apply for a career opportunity review Accessibility at Citi .

View the "EEO is the Law " poster. View the EEO is the Law Supplement .

View the EEO Policy Statement .

View the Pay Transparency Posting