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

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

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

Senior Genai & Data Consultant

The Senior GenAI & Data Consultant role requires over 18 years of experience in ...
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
  • Industry Expertise: Health Insurance Retail. Manufacturing
  • Strong background in Big Data, Cloud, and AI/ML projects, with a focus on the health insurance or retail domains or manufacturing domains
  • Understanding of Legacy toolsets, be it ETL, reporting etc is needed
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
  • Create migration suites for cataloging, migrating, and verifying data from legacy systems to modern platforms like Databricks and Snowflake
Read More
Arrow Right
New

Project Controls Coordinator III

Under the direction of the Supervisor Project Controls, the Analyst will perform...
Location
Location
Canada , North York
Salary
Salary:
55.00 - 58.00 CAD / Hour
https://www.randstad.com Logo
Randstad
Expiration Date
June 03, 2026
Flip Icon
Requirements
Requirements
  • Four Year Degree or combination of education and related experience
  • Minimum of 5 years of Project Controls or Project Management experience
  • Project Management professional designation is preferred
  • Experienced analytical skills including Earned Value Management
  • An independent worker within a team setting
  • Demonstrated professional engagement at a high level with work group, stakeholders, and contractors in a team setting
  • Proficient in the use of SAP, Oracle and MS office suite, intermediate+ Excel skills
  • Excellent communication, interpersonal, and organizational skills
  • Ability to effectively manage and prioritize workload, bring issues forward and develop working relationships at all levels of the organization
  • Detail oriented and understands the importance of data reconciliation
Job Responsibility
Job Responsibility
  • Analyze and maintain the project costs at the WBS level including control budget, incurred costs, commitments, and forecast
  • Provide the project team with accurate and timely cost information and reporting
  • Perform earned value measurements to anticipate forecast impacts
  • Perform monthly project close processes and prepare monthly project reports and comparative capital cost estimates for the project in Excel and EcoSys
  • Prepare and document project change orders timely in accordance with Project Management Office standards
  • Engage the Project Managers in meetings and discussions to review and reforecast project costs
  • Review cost transactions to ensure accurate project costs
  • Communicate with larger Controls team for the project
  • Liaise with Project Managers and Field Cost Analysts to ensure engagement with the project progress, changes, highlights and issues
  • Maintain the project Work Breakdown Structure such that it facilitates project execution and cost control during project execution and meets accounting requirements for asset creation and project closeout
  • Fulltime
Read More
Arrow Right
New

Mechanical Engineer - Energy Solutions

Join a Team of engineers dedicated to working hand-in-hand with large manufactur...
Location
Location
Canada , North York
Salary
Salary:
65.00 - 68.00 CAD / Hour
https://www.randstad.com Logo
Randstad
Expiration Date
May 09, 2026
Flip Icon
Requirements
Requirements
  • Engineering Degree preferred, Chemical or Mechanical Engineering preferred
  • Membership in Professional Engineers of Ontario or similar professional organization is preferred
  • Proven skills in: leading and influencing without explicit authority
  • time management
  • Ability to work independently but work within team of like-minded professionals
  • Valid driver’s license with a responsible driving record is needed
Job Responsibility
Job Responsibility
  • Identify new contacts and conduct at large manufacturing facilities to for the purpose to arrange site visits
  • Attend joint-site visits with team members to support in the identification and quantification of potential energy savings projects
  • Balance multiple priorities: Able to effectively manage time and priorities, consistently delivering in firm annual savings targets
  • Quantify impact and secure buy-in: Build technical savings calculations, sometimes from scratch, to support project justification and persuade key stakeholders on execution of work
  • Provide solutions to complex problems: expertly analyze complex operations across various industries and synthesize available information to create solutions equally appealing to business and technical people
  • Forge long-term customer relationships: build and nurture professional relationships founded on unwavering trust and mutual respect, being a first-choice energy efficiency partner for your customers
  • Continuous growth and curious mindset: Proactively identify new savings opportunities to drive both short and long-term work and build a sales funnel for sustained growth
  • Drive results autonomously while thriving in a collaborative environment: Play a supporting role in managing a small group customer base and integrate into, and support broader Team to achieve personal and collective objectives
What we offer
What we offer
  • Hybrid Work Model: in-Office (Monday, Tuesday & Thursday) Remote (Wednesday & Friday)
Read More
Arrow Right
New

Senior Hardware Compliance Designer

Are you an experienced Electrical Engineer with a deep understanding of Electrom...
Location
Location
Canada , North York, Ontario
Salary
Salary:
50.00 - 58.00 CAD / Hour
https://www.randstad.com Logo
Randstad
Expiration Date
May 09, 2026
Flip Icon
Requirements
Requirements
  • Bachelor’s degree in Electrical Engineering or an equivalent combination of diplomas and work experience
  • 6 to 10+ years of professional experience in hardware qualification or testing
  • Excellent knowledge of core EMC concepts, including Cabling, Grounding techniques, and Surge Protection
  • Demonstrated familiarity with railway (or similar industry) EMC and environmental standards
  • Proficiency in operating hardware test equipment and simulators used in the qualification process
  • Professional verbal and effective writing skills to ensure clear, concise, and unambiguous technical documentation and presentations
  • High degree of professionalism, strong ability to follow directions, use sound judgment, and keep meticulous track of all assigned tasks
Job Responsibility
Job Responsibility
  • Leading the hardware qualification, certification, and verification activities for new and revised products from planning through to customer acceptance
  • Conducting in-depth Electromagnetic Compatibility (EMC) tests on electronic devices according to industry standards (e.g., EN 61000 series, EN 50121 series, FCC, AREMA, MIL standards)
  • Performing environmental qualification tests (e.g., temperature, humidity, shock & vibration) on signaling electronic devices as per standards like EN 50125 and EN 50155
  • Participating in troubleshooting EMC-related issues and providing technical data and measurements to the design team
  • Preparing and driving comprehensive project documentation to customer acceptance, including the EMC Control Plan, EMC Compatibility Study, EMC Hazard Analysis, and EMC Test Report
  • Preparing hardware environmental qualification plans and reports, understanding the impact of requirements, and providing feedback on different technical approaches
  • Leading and managing subcontractors for specific on-site EMC measurements
  • Participating in ISA committee audits related to EMC and environmental requirements
  • Mentoring and developing junior team members within the department
What we offer
What we offer
  • Impactful Work: Lead the qualification process for cutting-edge electronic devices used in safety-critical railway signaling systems
  • Technical Leadership: Be the in-house expert on EMC and environmental standards, influencing design and compliance strategies
  • Professional Development: Opportunities to develop junior team members and participate in high-level ISA committee audits
  • Global Exposure: Work with international standards and lead engagements with external subcontractors and customers for acceptance
  • Fulltime
Read More
Arrow Right
New

Customs Compliance Specialist

Are you a trade compliance expert with a specialized background in the aviation ...
Location
Location
Canada , Woodbridge, Ontario
Salary
Salary:
30.00 - 45.00 CAD / Hour
https://www.randstad.com Logo
Randstad
Expiration Date
May 15, 2026
Flip Icon
Requirements
Requirements
  • Bachelor’s degree in Supply Chain, International Business, Aviation Management, or a related field (equivalent experience considered)
  • 5+ years of dedicated customs/trade compliance experience, specifically within aerospace, aviation repair, or a high-tech regulated industry
  • Deep proficiency in EAR, HTS coding, and aviation-specific documentation (8130-3, EASA Form 1, teardown documentation)
  • Experience with NAV (Microsoft Dynamics) or similar ERP systems for tariff code management is preferred
  • A U.S. Customs Broker License, CCS, or specialized aviation compliance certification is a significant asset
  • Strong analytical ability, meticulous attention to detail, and the communication skills necessary to influence cross-functional teams in multiple countries
Job Responsibility
Job Responsibility
  • Ensure all aviation parts comply with U.S. Customs (CBP), EAR, FAA, and DOT regulations, as well as Canadian and UK (HMRC) requirements
  • Maintain expert-level accuracy for HTS codes, ECCN, country-of-origin, and valuation, specifically regarding airworthiness tags (8130-3/EASA Form 1)
  • Manage inbound consolidations and broker relationships (Expeditors/Freight Boy)
  • resolve PARs issues, and audit FedEx/broker invoices to minimize duty spend
  • Manage Item Card tariff codes in NAV
  • file and track duty recovery disputes
  • and perform gap analyses to identify process improvements
  • Serve as the primary point of contact for USCBP, BIS, and Census Bureau
  • lead internal and external compliance audits and maintain rigorous record-keeping
What we offer
What we offer
  • 6 month contract with the opportunity to become permanent
  • Hybrid work environment
  • Play a pivotal role in a highly regulated international supply chain, acting as a bridge between North American operations and UK-based parent company compliance
  • Opportunity to spearhead high-value projects, including the exploration of bonded warehouse setups and process automation within your first 120 days
  • Work within the Aerospace industry that values technical expertise and regulatory mastery
  • Fulltime
Read More
Arrow Right
Remote jobs Jobs by Category
Art and Entertainment Jobs Banking Jobs Call Center Jobs Construction Jobs Consulting Jobs Customer Service Jobs Education Jobs Energy Jobs Finance Jobs Gastronomy Jobs Health and Beauty Jobs Hospitality and Tourism Jobs Human Resources Jobs Insurance Jobs IT - Administration Jobs IT - Software Development Jobs Legal Jobs Logistics Jobs Manufacturing Jobs Marketing, Digital Marketing, SEO, SEM Jobs Media Jobs Nursing Jobs Office Administration Jobs Pharmacy Jobs Physical Work Jobs Public Relations Jobs Public Sector Jobs Purchasing Jobs Quality Control Jobs Real Estate Jobs Research and Development Jobs Sales Jobs
Job Positions Jobs by Country
United States Jobs United Kingdom Jobs India Jobs Canada Jobs Australia Jobs Germany Jobs Ireland Jobs Poland Jobs
Company
Blog Salaries About Us Contact
Follow Us
Facebook
X (Twitter)
LinkedIn
Instagram
CrawlJobs Group
ITFlashcards AllDevBlogs
© 2026 CrawlJobs Ltd. All Rights Reserved
Terms & Conditions Privacy Policy