CrawlJobs Logo

Ab-Initio ETL Developer

https://www.citi.com/ Logo

Citi

Location Icon

Location:
United Kingdom , Belfast

Category Icon
Category:
IT - Software Development

Job Type Icon

Contract Type:
Not provided

Salary Icon

Salary:

Not provided
Save Job
Save Icon
Apply Position

Job Description:

The Ab-Initio ETL Developer is an intermediate-level position responsible for the design, development, and implementation of robust and scalable data integration solutions. The successful candidate will be a key member of the Strategic Ledger program, a critical initiative focused on transforming upstream data into the CIT template for loading into Oracle Financials SaaS. This role is a core part of the Technology team, focusing on building and maintaining the firm's critical data pipelines using the Ab Initio platform. The overall objective is to contribute to high-quality data systems analysis and programming activities that support our strategic financial data objectives.

Job Responsibility:

  • Design, develop, and maintain high-performance, resilient, and scalable ETL processes using the Ab Initio suite of products (GDE, Co>Operating System, EME) to transform upstream data into the required format for Oracle Financials SaaS
  • Conduct detailed data analysis, data profiling, and data quality assessments to ensure the integrity of data moving through the Strategic Ledger pipelines
  • Translate business requirements from the Strategic Ledger program into technical specifications for ETL jobs and data models
  • Develop and optimize complex SQL queries for data extraction, transformation, and loading across various database platforms
  • Create and manage metadata within the Ab Initio Enterprise Meta>Environment (EME), ensuring proper version control and adherence to development standards for the program
  • Develop Unix/Linux shell scripts for job automation, scheduling, and file manipulation related to the data transformation process
  • Monitor and control all phases of the development process, including analysis, design, construction, testing, and implementation
  • Provide operational support for production applications, troubleshoot issues, and perform performance tuning to meet business SLAs
  • Utilize in-depth specialty knowledge of ETL and Ab Initio to analyze complex data-related problems and recommend efficient solutions
  • Collaborate with data architects, business analysts, and other technology groups to ensure solutions are aligned with enterprise standards and business needs
  • Ensure essential procedures are followed and help define operating standards and processes for the ETL framework
  • Serve as an advisor or coach to new or lower-level analysts, sharing expertise in Ab Initio and data integration best practices
  • Appropriately assess risk when business decisions are made, demonstrating particular consideration for the firm's reputation and safeguarding Citigroup, its clients, and assets. This includes driving compliance with applicable laws, rules, and regulations related to data handling, adhering to Policy, applying sound ethical judgment, and escalating, managing, and reporting control issues with transparency

Requirements:

  • Hands-on experience in data systems analysis and ETL development
  • Proven, in-depth expertise with the Ab Initio platform (GDE, Co>Operating System, EME) is mandatory
  • Strong proficiency in SQL and experience with relational databases (e.g., Oracle, Teradata)
  • Solid experience with Unix/Linux environments and shell scripting
  • Demonstrated experience in managing and implementing successful data-centric projects, preferably within the financial services industry
  • Strong understanding of data warehousing concepts, data modeling, and ETL best practices
  • Experience with large-scale data transformation projects and loading data into financial systems (e.g., Oracle Financials, SAP) is highly desirable
  • Ability to work under pressure, manage deadlines, and adapt to unexpected changes in requirements
  • Excellent problem-solving and analytical skills
  • Experience with job scheduling tools (e.g., Autosys) is a plus
  • Working knowledge of consulting/project management techniques/methods is beneficial
  • Bachelor’s degree/University degree or equivalent experience

Nice to have:

  • Experience with job scheduling tools (e.g., Autosys) is a plus
  • Working knowledge of consulting/project management techniques/methods is beneficial

Additional Information:

Job Posted:
April 05, 2026

Employment Type:
Fulltime
Work Type:
Hybrid work
Icon
Citi - All Job Offers
Job Link Share:
Copy Link Icon
Facebook Icon Twitter Icon LinkedIn Icon
PREMIUM
More languages and countries
+ Unlock 31694 hidden job offers
Languages
English Čeština Deutsch Ελληνικά Español Français +15
Countries
United States United Kingdom India Canada Australia +
See plans
Plans from $2.99 / month

Looking for more opportunities? Search for other job offers that match your skills and interests.

Briefcase Icon

Similar Jobs for Ab-Initio ETL Developer

Senior Ab-Initio ETL Developer

Finance Technology Services is building a sophisticated next generation finance ...
Location
Location
United Kingdom , London
Salary
Salary:
Not provided
https://www.citi.com/ Logo
Citi
Expiration Date
Until further notice
Flip Icon
Requirements
Requirements
  • Experience as senior level in Abinitio & Metadata hub Applications Development role
  • Experience in Datalineage and data controls
  • Experience on starting the front-end buildout from scratch by coordinating across multiple business and technology groups
  • Experience building complex single-page applications using Abinitio/Hadoop/Hive/Kafka/Oracle and modern MOM technologies
  • Experienced with Linux/Unix platform
  • Experience in SCMs like GIT
  • and tools like JIRA
  • Familiar with the financial services industry and/or regulatory environments
  • Consistently demonstrates clear and concise written and verbal communication
  • Working experience on one of the BI Tool like, power BI, Tableau, MicroStrategy, QlikView
Job Responsibility
Job Responsibility
  • Develop Datalineage, DQS, Profiling solution for SL accounting platform involving Abinitio/DQS/MDH technologies
  • Making complex technical and design decisions for Abinitio projects
  • Utilize in-depth knowledge and skills across multiple Applications Development areas to provide technical oversight across systems and applications
  • Requirement analysis including interaction with Business Users
  • Perform Unit Testing, System Testing for all applications developed / enhancements and ensure that all critical and high-severity bugs are addressed
  • Engage in end-to-end system design and development processes
  • Ensure that application development and enhancement is in line with Citi’s Coding Standards
  • Partners with multiple Technology teams to ensure appropriate integration of functions to meet goals
  • identifies and defines necessary system enhancements to deploy new products and process enhancements
  • Solves / works a variety of high impact, high-profile problems / projects with considerable business impact through in-depth evaluation of complex business processes, system processes and industry standards
  • Fulltime
Read More
Arrow Right

Applications Development Senior Programmer Analyst

The Applications Development Senior Programmer Analyst is an intermediate level ...
Location
Location
India , Chennai
Salary
Salary:
Not provided
https://www.citi.com/ Logo
Citi
Expiration Date
Until further notice
Flip Icon
Requirements
Requirements
  • 8-12 years of relevant experience in design development using ETL Tools - AB-Initio / MS SQL Server Technology
  • Must have worked on Various Ab-Initio Products like EME/Express-IT and Experience in Continuous Flows
  • Must be Familiar with ETL Concepts and good on Implementing them
  • Knowledge of NoSQL Databases/Hadoop-Hive, Spark will be added advantage
  • Experience in systems analysis and programming of software applications
  • Experience in managing and implementing successful projects
  • Working knowledge of consulting/project management techniques/methods
  • Ability to work under pressure and manage deadlines or unexpected changes in expectations or requirements
Job Responsibility
Job Responsibility
  • Conduct tasks related to feasibility studies, time and cost estimates, IT planning, risk technology, applications development, model development, and establish and implement new or revised applications systems and programs to meet specific business needs or user areas
  • Monitor and control all phases of development process and analysis, design, construction, testing, and implementation as well as provide user and operational support on applications to business users
  • Utilize in-depth specialty knowledge of applications development to analyze complex problems/issues, provide evaluation of business process, system process, and industry standards, and make evaluative judgement
  • Recommend and develop security measures in post implementation analysis of business usage to ensure successful system design and functionality
  • Consult with users/clients and other technology groups on issues, recommend advanced programming solutions, and install and assist customer exposure systems
  • Ensure essential procedures are followed and help define operating standards and processes
  • Serve as advisor or coach to new or lower level analysts
  • Has the ability to operate with a limited level of direct supervision
  • Can exercise independence of judgement and autonomy
  • Acts as SME to senior stakeholders and /or other team members
  • Fulltime
Read More
Arrow Right

Etl Lead (Ab Initio)

We are currently seeking a ETL Lead (Ab Initio) to join our team in Halifax, Nov...
Location
Location
Canada , Halifax
Salary
Salary:
Not provided
nttdata.com Logo
NTT DATA
Expiration Date
Until further notice
Flip Icon
Requirements
Requirements
  • 5 – 7 years total experience
  • 5 years’ experience with Ab Initio
  • 5 years’ experience with ETL Development and Architecture
  • 3 – 5 years’ experience with Control M
  • 5 years’ experience with Data Warehousing
  • 5 years’ experience with SQL and Data Analysis
  • 3 years of experience with Release/Change Management
  • 3 years of experience with Technical Documentation
Job Responsibility
Job Responsibility
  • Interact with business and IT users within client to resolve the issues and to understand the business requirements and data specifications
  • Troubleshooting and Resolution of incidents, load job failures/Abends within Enterprise Data Warehouse/EDW batch schedules for various applications
  • Perform Application lead activities for ETL Extracts, Claims and Accounting
  • Reviewing technical specifications on the ETL code during touchpoint meetings, ensuring all set standards and guidelines are followed diligently
  • Analyze Control -M schedules for EDW batch schedule
  • Execute the change control and promotions tasks in EDW
  • Support production move following Release and Change Management processes
  • Provide development effort estimates for enhancements
  • Data Analysis for understanding user requirements and finalizing optimal solutions to deliver Claims and Accounting data to users
  • Providing the solution for migration of client members from old legacy system to new platform
  • Fulltime
Read More
Arrow Right

Sr. Genai & Data Consultants

We are currently seeking a GenAI Innovation Factory - Sr. GenAI & Data Consultan...
Location
Location
India , Bangalore
Salary
Salary:
Not provided
nttdata.com Logo
NTT DATA
Expiration Date
Until further notice
Flip Icon
Requirements
Requirements
  • B.E. in Electronics & Telecommunication or related field
  • 18+ years in IT, with significant experience in Big Data, Cloud, and AI/ML projects
  • Proficiency in Databricks, Snowflake, AWS, GenAI (RAG and GANs), Python, C/C++/C#, Hadoop, ETL, UNIX, SQL/Oracle, Ab-Initio
  • Databricks/Snowflake Architect certification
  • Health Insurance Retail
  • Manufacturing
  • Proven track record of developing GenAI-based applications and accelerators
  • Experience in creating migration suites for data transfer to Snowflake/Databricks
  • Designed and developed a Data Delivery Engine, significantly improving execution time
  • Strong analytical abilities, communication skills, and experience in delivering business value through diverse technology stacks
Job Responsibility
Job Responsibility
  • Engage with clients to understand their requirements and provide architectural and design solutions
  • Develop and implement accelerators to facilitate faster cloud migration
  • Create innovative use cases or solutions to solve day to day data engineering problems using AI and GenAI tools
  • Develop reference architectures for various use cases using modern cloud data platforms
  • Understanding of Legacy toolsets, be it ETL, reporting etc is needed
  • Create migration suites for cataloging, migrating, and verifying data from legacy systems to modern platforms like Databricks and Snowflake
  • Fulltime
Read More
Arrow Right

Test Automation Engineer

Join us as a Test Automation Engineer at Barclays, responsible for supporting th...
Location
Location
India , Pune
Salary
Salary:
Not provided
barclays.co.uk Logo
Barclays
Expiration Date
Until further notice
Flip Icon
Requirements
Requirements
  • Hands-on experience in one or more technical skills under any of the technology platforms: Mainframe - COBOL, IMS, CICS, DB2, VSAM, JCL, TWS, File-Aid, REXX
  • Open Systems and tools – Selenium, Java, Jenkins, J2EE, Web-services, APIs, XML, JSON, Parasoft/SoaTest –Service Virtualization
  • API Testing Tools – SOAP UI , Postman, Insomnia
  • Mid-Tier technology – MQ, WebSphere, UNIX, API 3rd party hosting platforms
  • Data warehouse – ETL, Informatica, Ab-initio, Oracle, Hadoop
  • Good knowledge of API Architecture and API Concepts
  • Preferably have domain Knowledge in Retail Banking and testing experience in one or more core banking product platforms/systems such as Accounting and clearing / General Ledger, Savings & Insurance products, Online/mobile payments, Customer & Risk systems and payments
  • Experience in JIRA and similar test management tools
  • Test Automation Skills
  • Hand on Experience of Test Automation using Java or any other Object Oriented Programming Language
Job Responsibility
Job Responsibility
  • To design, develop, and execute testing strategies to validate functionality, performance, and user experience, while collaborating with cross-functional teams to identify and resolve defects, and continuously improve testing processes and methodologies, to ensure software quality and reliability
  • Development and implementation of comprehensive test plans and strategies to validate software functionality and ensure compliance with established quality standards
  • Creation and execution automated test scripts, leveraging testing frameworks and tools to facilitate early detection of defects and quality issues
  • Collaboration with cross-functional teams to analyse requirements, participate in design discussions, and contribute to the development of acceptance criteria, ensuring a thorough understanding of the software being tested
  • Root cause analysis for identified defects, working closely with developers to provide detailed information and support defect resolution
  • Collaboration with peers, participate in code reviews, and promote a culture of code quality and knowledge sharing
  • Stay informed of industry technology trends and innovations, and actively contribute to the organization's technology communities to foster a culture of technical excellence and growth
What we offer
What we offer
  • Competitive holiday allowance
  • Life assurance
  • Private medical care
  • Pension contribution
  • Fulltime
Read More
Arrow Right
New

Senior Lecturer/Associate Professor in Literacy

As a Senior Lecturer / Associate Professor in Literacy, you will play a key role...
Location
Location
Australia , Albury-Wodonga, Bathurst, Port Macquarie, Wagga Wagga
Salary
Salary:
Not provided
csu.edu.au Logo
Charles Sturt University
Expiration Date
June 08, 2026
Flip Icon
Requirements
Requirements
  • A doctoral qualification relevant to literacy or education, with a recognised teaching qualification
  • A strong record of high-quality teaching and student-centred learning
  • An established or emerging research profile aligned to literacy, curriculum or pedagogy
  • The ability to build productive partnerships and contribute to academic leadership
Job Responsibility
Job Responsibility
  • Lead impactful literacy teaching and research
  • Teach across online and on-campus environments
  • Shape future teachers and education practice
  • Contribute to curriculum innovation
  • Build strong relationships with students and partners
  • Provide academic leadership in literacy education
  • Contribute to the School's research profile
  • Supervise higher degree research students
  • Actively engage with professional, community and government stakeholders
  • At Associate Professor level: significant academic leadership, research impact, and contribution to the broader discipline at national/international level
What we offer
What we offer
  • 17% superannuation
  • Fulltime
Read More
Arrow Right
New

Program Manager - Controls and Avionics Solutions

This position is based in Endicott, New York. New York and on-site work will be ...
Location
Location
United States , Endicott
Salary
Salary:
120874.00 - 205486.00 USD / Year
baesystems.com Logo
Baesystems
Expiration Date
Until further notice
Flip Icon
Requirements
Requirements
  • Bachelor’s degree in engineering, engineering or manufacturing management, or other discipline
  • Demonstrated ability for building strong customer/ stakeholder relationships
  • Strong communication, negotiation, and presentation skills
  • Ability to interpret data and make data-driven decisions
  • Highly adaptable with strong initiative
  • Demonstrated ability to lead and motivate cross-functional teams
  • Knowledge of the global aviation market and regulatory requirements and/ or military aviation market
Job Responsibility
Job Responsibility
  • Maintaining strong customer relationships and leading a multidisciplinary team to execute complex development programs within schedule and budget
  • Leadership and management oversight of a project team assuring that project’s financials, schedule, and technical objectives are met and that the highest level of customer satisfaction is achieved while meeting all contractual commitments
  • Work effectively and collaboratively with Engineering, Operations, and all Program Office functional leadership to assure deliveries continue to exceed customer commitments and achievement of financial commitments to the company
  • Manages, coordinates, plans, organizes, controls, integrates, and executes projects within the Military Aircraft Systems portfolio
  • Participates in the support of new business and in the development of proposals
What we offer
What we offer
  • Health insurance
  • Dental insurance
  • Vision insurance
  • Health savings accounts
  • 401(k) savings plan
  • Disability coverage
  • Life and accident insurance
  • Employee assistance program
  • Legal plan
  • Discounts on home, auto, and pet insurance
  • Fulltime
Read More
Arrow Right
New

Finance Business Partner (Research)

Full Time, Fixed Term (12 months). Level 7 - $101,421 to $110,819 p.a. (plus 17%...
Location
Location
Australia , Wagga Wagga
Salary
Salary:
101421.00 - 110819.00 AUD / Year
csu.edu.au Logo
Charles Sturt University
Expiration Date
June 02, 2026
Flip Icon
Requirements
Requirements
  • A degree in Accounting or Finance (professional accounting body membership is desirable)
  • Experience in project budgeting, forecasting and financial analysis
  • Background in management accounting or business partnering within complex environments
  • exposure to government funding or higher education is advantageous
  • Excellent stakeholder engagement skills, with the ability to work effectively with academics and researchers
  • Familiarity with business intelligence systems and dashboard reporting
Job Responsibility
Job Responsibility
  • Partner with academics to deliver strategic financial insights that enable research success
  • Directly influence world-class projects and decisions shaping the future of education and innovation
  • Lead initiatives that enhance financial governance, deliver accurate and timely reporting, and support key projects such as cost-pricing systems and research budgeting
  • Help build financial capability across the University, fostering collaboration and continuous improvement
What we offer
What we offer
  • Flexibility with a 35-hour work week
  • Access to hybrid work arrangements
  • 17% superannuation
  • Fulltime
Read More
Arrow Right