Senior ETL ( Abinitio) & Database Engineer - Vice President (Jersey City)

The Applications Development Technology Lead Analyst is a senior level position responsible for establishing and implementing new or revised application systems and programs in coordination with the Technology team. The overall objective of this role is to lead applications systems analysis and programming activities.

Responsibilities

• Lead the design, development, and implementation of complex ETL operations using Python and Abinitio applications for processing large datasets, leveraging expertise in distributed computing and data manipulation.
• Partner with management teams to seamlessly integrate ETL, Java Integration Framework, and Spark-based solutions into existing data infrastructure, ensuring optimal performance and efficient data flow.
• Resolve variety of high impact problems/projects through in-depth evaluation of complex business processes, system processes, and industry standards.
• Provide expertise in application programming and ensure application design adheres to the overall architecture blueprint.
• Utilize advanced knowledge of system flow and develop standards for coding, testing, debugging, and implementation.
• Develop comprehensive knowledge of how areas of business, such as architecture and infrastructure, integrate to accomplish business goals.
• Provide in-depth analysis with interpretive thinking to define issues and develop innovative solutions.
• Serve as advisor or coach to mid‑level developers and analysts, allocating work as necessary.
• Appropriately assess risk when business decisions are made, demonstrating particular consideration for the firm’s reputation and safeguardingCitigroup, its clients and assets, by driving compliance with applicable laws, rules and regulations, adhering to policy, applying sound ethical judgment regarding personal behavior, conduct, and business practices, and escalating, managing and reporting control issues with transparency.

Recommended Qualifications

• 6–10 years of extensive professional experience in ETL and Oracle PL/SQL program development using Python/Abinitio ETL technologies and Oracle as database.
• Proven experience with Abinitio for large‑scale data processing and distributed computing.
• Thorough knowledge and hands‑on experience with Unix and Oracle DB.
• Strong understanding of data architecture principles and data infrastructure.
• 7+ years of Oracle PL/SQL or SQL experience.
• 6–10+ years of ETL experience (Abinitio, Python). Hands‑on experience in developing complex ETL applications.
• Proficiency with Oracle PL/SQL or SQL, SQL tuning, writing packages, triggers, functions and procedures.
• Expert in UNIX knowledge.
• Experience with data conversion/migration.
• Excellent troubleshooting and debugging skills.
• Experience with developing and maintaining coding standards, testing, and debugging for complex applications.
• Demonstrated ability to provide technical leadership and mentor junior engineers.
• Excellent analytical, problem‑solving, and critical thinking skills.
• Strong communication and collaboration abilities, with experience partnering with various stakeholders.
• Knowledge of risk assessment, data security, performance optimization, and scalability considerations.

Education

• Bachelor’s degree/University degree or equivalent experience.
• Master’s degree preferred.

We are seeking a highly skilled and experienced Senior ETL Abinitio Database automation Engineer – Tech Lead to join our dynamic team. In this role, you will be responsible for designing, developing, and implementing robust and scalable data processing solutions using Core Java, Spring Integration Framework, Apache Spark, etc. You will play a crucial part in integrating these solutions into our existing data infrastructure, addressing complex data challenges, and providing technical leadership. The ideal candidate will possess a deep understanding of distributed computing, data manipulation techniques, and a commitment to best practices in software development and data governance. This will involve working closely with the business and SMEs to prioritize business requests, manage the ETL development work slate, provide estimate efforts, and ensure timely delivery on committed items and to project manage all aspects of software development according to the Software Development Lifecycle (SDLC).

Location

Jersey City, New Jersey, United States

Salary Range

$142,320.00 – $213,480.00

Benefits

In addition to salary, Citi’s offerings may also include discretionary and formulaic incentive and retention awards. Citi offers competitive employee benefits, including medical, dental and 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.

Equal Opportunity Employer

Citi is an equal opportunity employer, and qualified candidates will receive consideration without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability, status as a protected veteran, or any other characteristic protected by law.

Accessibility

For a person with a disability who needs a reasonable accommodation to use our search tools and/or apply for a career opportunity, review Accessibility at Citi. View Citi’s EEO Policy Statement and the Know Your Rights poster.