Python ETL Engineer - Assistant Vice President

Citigroup Inc.; Pune District; On-site; INR 1,000,000 - 1,500,000; Full time

Job summary

A leading global financial services company is seeking a Senior Programmer Analyst with over 8 years of experience to participate in application systems development. This role involves designing and maintaining ETL processes, working with Python and PL/SQL to enhance data management. Responsibilities also include monitoring all phases of development and ensuring compliance with procedures. The ideal candidate will have a strong understanding of data warehousing and excellent problem-solving skills. The position is full-time based in Pune, India.

Qualifications

• 8+ years of relevant experience.
• Strong understanding of data warehousing concepts.
• Proficiency in Python, PL/SQL, and database technologies.

Responsibilities

• Conduct feasibility studies and IT planning.
• Monitor and control all development phases.
• Design, develop, and maintain ETL processes.
• Write complex SQL queries and PL/SQL scripts.
• Optimize ETL processes for performance.

Skills

Python

ETL

PL/SQL

SQL

Data Warehousing

Data Modeling

Database Management

Problem Solving

Communication

Teamwork

Education

Bachelor’s degree/University degree or equivalent experience

Job description

The Applications Development Senior Programmer Analyst is an intermediate level position responsible for participation in the establishment and implementation of new or revised application systems and programs in coordination with the Technology team. The overall objective of this role is to contribute to applications systems analysis and programming activities.

Responsibilities

• 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.
• 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.

Qualifications

• 8+ years of relevant experience

• Job Title: Python, ETL, AI Engineering and PL/SQL Developer

  Job Description:

  • We are seeking a skilled and motivated Python, ETL, and PL/SQL Developer to join our Data and Analytics team.
  • Candidate should have 8-12 years of industry experience on data technologies.
  • The ideal candidate will be responsible for designing, developing, and maintaining ETL processes, data pipelines, and database solutions to support our growing data needs.
  • This role requires a strong understanding of data warehousing concepts, experience with various ETL tools, and proficiency in Python, PL/SQL, and database technologies.
  • Methodology of AI includes Chunking, Embedding, AI Engineering, Prompt Engineering

  Responsibilities:

  • Design, develop, and maintain ETL processes to extract, transform, and load data from various sources into our data warehouse.
  • Write complex SQL queries and PL/SQL scripts to perform data manipulation, validation, and transformation.
  • Develop and maintain data pipelines using Python and related libraries (e.g., Polar ,Pandas).
  • Optimize ETL processes and data pipelines for performance and scalability.
  • Collaborate with data analysts and other stakeholders to understand data requirements and develop solutions to meet their needs.
  • Implement data quality checks and monitoring to ensure data accuracy and consistency.
  • Troubleshoot and resolve data-related issues.
  • Create and maintain technical documentation for ETL processes, data pipelines, and database solutions.
  • Stay up-to-date with the latest trends and technologies in data management and analytics.

  Skills:

  • Python
  • ETL
  • PL/SQL
  • SQL
  • Data Warehousing
  • Data Modeling
  • Database Management
  • Problem Solving
  • Communication
  • Teamwork

Education

• Bachelor’s degree/University degree or equivalent experience

This job description provides a high-level review of the types of work performed. Other job-related duties may be assigned as required.

Job Family Group: Technology

Job Family: Applications Development

Time Type: Full time

Most Relevant Skills: Please see the requirements listed above.

Other Relevant Skills: For complementary skills, please see above and/or contact the recruiter.

Citi is an equal opportunity employer, and qualified candidates will receive consideration without regard to their race, color, religion, sex, sexual orientation, gender identity, national origin, disability, status as a protected veteran, or any other characteristic protected by law.

If you are a person with a disability and need a reasonable accommodation to use our search tools and/or apply for a career opportunity review Accessibility at Citi.

View Citi’s EEO Policy Statement and the Know Your Rights poster.