At a Glance
- Tasks: Design and develop scalable ETL solutions using Ab Initio for financial data integration.
- Company: Join Citi, a leading global bank with a commitment to innovation and diversity.
- Benefits: Enjoy competitive salary, health benefits, and opportunities for professional growth.
- Other info: Dynamic team environment with excellent career advancement opportunities.
- Why this job: Make an impact on critical financial systems while working with cutting-edge technology.
- Qualifications: Experience in ETL development and proficiency in SQL and Ab Initio required.
The predicted salary is between 60000 - 80000 £ per year.
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.
Responsibilities:- 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.
- 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.
Ab-Initio ETL Developer, Assistant Vice President in Belfast employer: Citibank (Switzerland) AG
Citi is an exceptional employer that fosters a dynamic and inclusive work culture, providing employees with the opportunity to engage in meaningful projects that drive innovation in financial technology. As an Ab-Initio ETL Developer, you will benefit from comprehensive professional development programs, collaborative teamwork, and a commitment to maintaining high standards of data integrity, all while working in a vibrant city environment that encourages both personal and career growth.
StudySmarter Expert Advice🤫
We think this is how you could land Ab-Initio ETL Developer, Assistant Vice President in Belfast
✨Tip Number 1
Network like a pro! Reach out to your connections in the industry, especially those who work with ETL or data integration. A friendly chat can lead to insider info about job openings that aren't even advertised yet.
✨Tip Number 2
Show off your skills! Create a portfolio showcasing your best ETL projects, especially those using Ab Initio. This gives potential employers a tangible look at what you can do and sets you apart from the crowd.
✨Tip Number 3
Prepare for interviews by brushing up on your technical knowledge. Be ready to discuss your experience with SQL, Unix/Linux, and the Ab Initio platform. Practising common interview questions can help you feel more confident.
✨Tip Number 4
Don't forget to apply through our website! It’s the best way to ensure your application gets noticed. Plus, we love seeing candidates who are proactive about their job search!
We think you need these skills to ace Ab-Initio ETL Developer, Assistant Vice President in Belfast
Some tips for your application 🫡
Tailor Your CV:Make sure your CV highlights your experience with the Ab Initio platform and ETL processes. We want to see how your skills align with the job description, so don’t be shy about showcasing relevant projects!
Craft a Compelling Cover Letter:Your cover letter is your chance to shine! Use it to explain why you’re passionate about data integration and how your background makes you a perfect fit for our team. Keep it concise but impactful!
Showcase Your Technical Skills:When filling out your application, be specific about your technical expertise, especially in SQL and Unix/Linux environments. We love seeing candidates who can demonstrate their hands-on experience with real examples.
Apply Through Our Website:We encourage you to apply directly through our website. It’s the best way to ensure your application gets into the right hands. Plus, you’ll find all the details you need about the role there!
How to prepare for a job interview at Citibank (Switzerland) AG
✨Know Your Ab Initio Inside Out
Make sure you brush up on your knowledge of the Ab Initio platform, especially GDE, Co>Operating System, and EME. Be prepared to discuss specific projects where you've used these tools, as well as any challenges you faced and how you overcame them.
✨SQL Skills Are Key
Since strong SQL proficiency is a must for this role, practice writing complex queries ahead of time. You might be asked to solve a problem on the spot, so being comfortable with data extraction and transformation will give you an edge.
✨Showcase Your Problem-Solving Skills
Prepare examples that highlight your analytical skills and how you've tackled data-related issues in past projects. Think about times when you had to troubleshoot or optimise ETL processes and be ready to share those stories.
✨Understand the Business Context
Familiarise yourself with the Strategic Ledger program and its objectives. Being able to connect your technical skills to the business needs will demonstrate your understanding of how your role contributes to the bigger picture.
