Officer-Ab Initio ETL Developer

Role Overview: You will be an Applications Development Intermediate Programmer Analyst at an intermediate level position responsible for participating in the establishment and implementation of new or revised application systems and programs in coordination with the Technology team. Your overall objective in this role will be to contribute to applications systems analysis and programming activities. Key Responsibilities: - Develop and maintain systems within SMC ETL stream - Work on Client Onboarding and managing reference data static domain tables - Collaborate with global application development teams and Operations teams/partners to integrate application data successfully - Conduct unit testing with proper documentation to adhere to application standards - Work closely with other team members, onsite and remote to ensure a consistent approach to development is used within the application - Engage in architecture definition of new processes and review existing processes for improvements - Participate in strategic Tech Migration initiative to set up the ETL architecture - Provide ongoing maintenance and L3 production support - Keep up to date with new technologies and their possible adoption within ISG - Work on data initiatives within ISG (Automation and utilities) Qualifications: - 5+ years of relevant experience in the Financial Service industry - Experience in Abinitio / DataStage and working with relational databases - Proven proficiency in dealing with complex technical issues across all aspects of the project lifecycle - Knowledge and experience working with Batch and real-time processes (including micrographs) - Experience of working in a demanding and results-driven, time-critical environment Required Skills: - Ab Initio GDE and Co>Op / Datastage ETL Tool - Linux/Unix scripting - Oracle concepts, SQL, PL/SQL - SQL performance tuning - Autosys Skills that are a plus: - Understanding of Securities Reference Data system - Python - Java - Understanding of ECS architecture / implementation Education: - Bachelors degree/University degree or equivalent experience Additional Details: If you are a person with a disability and need a reasonable accommodation to use Citis search tools and/or apply for a career opportunity, review Accessibility at Citi. You can also view Citis EEO Policy Statement and the Know Your Rights poster. Role Overview: You will be an Applications Development Intermediate Programmer Analyst at an intermediate level position responsible for participating in the establishment and implementation of new or revised application systems and programs in coordination with the Technology team. Your overall objective in this role will be to contribute to applications systems analysis and programming activities. Key Responsibilities: - Develop and maintain systems within SMC ETL stream - Work on Client Onboarding and managing reference data static domain tables - Collaborate with global application development teams and Operations teams/partners to integrate application data successfully - Conduct unit testing with proper documentation to adhere to application standards - Work closely with other team members, onsite and remote to ensure a consistent approach to development is used within the application - Engage in architecture definition of new processes and review existing processes for improvements - Participate in strategic Tech Migration initiative to set up the ETL architecture - Provide ongoing maintenance and L3 production support - Keep up to date with new technologies and their possible adoption within ISG - Work on data initiatives within ISG (Automation and utilities) Qualifications: - 5+ years of relevant experience in the Financial Service industry - Experience in Abinitio / DataStage and working with relational databases - Proven proficiency in dealing with complex technical issues across all aspects of the project lifecycle - Knowledge and experience working with Batch and real-time processes (including micrographs) - Experience of working in a demanding and results-driven, time-critical environment Required Skills: - Ab Initio GDE and Co>Op / Datastage ETL Tool - Linux/Unix scripting - Oracle concepts, SQL, PL/SQL - SQL performance tuning - Autosys Skills that are a plus: - Understanding of Securities Reference Data system - Python - Java - Understanding of ECS architecture / implementation Education: - Bachelors degree/University degree or equivalent experience Additional Details: If you are a person with a disability and need a reasonable accommodation to use Citis search tools and/or apply for a career opportunity, review Accessibility at Citi. You can also view Citis EEO Policy Statement and the Know Your Rights poster.