Senior ETL (Abinitio) & Database Engineer - Vice President

• Lead the design, development, and implementation of complex ETL operation using Python , Abinitio applications for processing large datasets, leveraging expertise in distributed computing and data manipulation
• Partner with management teams to seamlessly integrate ETL Java Integration Framework & Spark-based solutions into existing data infrastructure, ensuring optimal performance and efficient data flow
• Resolve variety of high impact problems/projects through in-depth evaluation of complex business processes, system processes, and industry standards
• Provide expertise in area and advanced knowledge of applications programming and ensure application design adheres to the overall architecture blueprint
• Utilize advanced knowledge of system flow and develop standards for coding, testing, debugging, and implementation
• Develop comprehensive knowledge of how areas of business, such as architecture and infrastructure, integrate to accomplish business goals
• Provide in-depth analysis with interpretive thinking to define issues and develop innovative solutions
• Serve as advisor or coach to mid-level developers and analysts, allocating work as necessary
• Appropriately assess risk when business decisions are made, demonstrating particular consideration for the firm's reputation and safeguarding Citigroup, its clients and assets, by driving compliance with applicable laws, rules and regulations, adhering to Policy, applying sound ethical judgment regarding personal behavior, conduct and business practices, and escalating, managing and reporting control issues with transparency

• 6-10 years of extensive professional experience in ETL & Oracle PL SQL program development using Python/Abinitio ETL technologies and Oracle as database
• Proven experience with Abinitio for large-scale data processing and distributed computing
• Thorough knowledge and hands-on experience with Unix and Oracle DB
• Strong understanding of data architecture principles and data infrastructure
• 7+ Year Oracle PL/SQL or SQL experience
• 6-10+ Year ETL Experience (Abinitio, Python)
• Hands on experience in developing complex ETL applications
• Proficiency with Oracle PL/SQL or SQL, SQL tuning, writing packages, triggers, functions and procedures
• Expert in UNIX knowledge
• Experience with data conversion / migration
• Excellent trouble shooting and debugging skills
• Experience with developing and maintaining coding standards, testing, and debugging for complex applications
• Demonstrated ability to provide technical leadership and mentor junior engineers
• Excellent analytical, problem-solving, and critical thinking skills
• Strong communication and collaboration abilities, with experience partnering with various stakeholders
• Knowledge of risk assessment, data security, performance optimization, and scalability considerations
• Bachelor's degree/University degree or equivalent experience

Master's degree preferred

• 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