This list contains only the countries for which job offers have been published in the selected language (e.g., in the French version, only job offers written in French are displayed, and in the English version, only those in English).
Data Engineer ETL Developer - Assistant Vice President - Citi
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
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
Ability to work under pressure, manage deadlines, and adapt to unexpected changes in requirements
Excellent problem-solving and analytical skills
What we offer
medical, dental & vision coverage
401(k)
life, accident, and disability insurance
wellness programs
paid time off packages, including planned time off (vacation), unplanned time off (sick leave), and paid holidays