Senior Python Data and AI Engineer - Vice President

Citi; Pune District; On-site; INR 1,800,000 - 2,800,000; Full time

Job summary

Citi in Pune is seeking a senior data engineering professional to design, develop, and optimize ETL processes and data pipelines for a data warehouse. You will write complex SQL/PLSQL, build Python-based pipelines, and ensure data quality and scalability while collaborating with analysts and stakeholders.

Expertise in Oracle, Postgres, and modern data frameworks is required, along with hands-on experience with Docker/OpenShift and API-driven architectures.

Qualifications

• Experience: At least 10+ years of hands-on application development experience.
• 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

ETL Development

SQL & PL/SQL

Python

PySpark

Oracle

PostgreSQL

MongoDB

APIs

Docker

OpenShift

LangChain

N8N

AutoGen

CrewAI

Tools

Docker

OpenShift

FastAPI

Flask

PySpark

LangChain

AutoGen

CrewAI

N8N

Google ADK

Job description

Responsibilities

• Experience: At least 10+ years of hands-on application development experience.
• 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 and Qualifications

• Database Knowledge: Strong knowledge of databases such as Oracle/MY SQL/SQL.
• Scripting: Strong knowledge of Python.
• Problem-Solving: Excellent analytical and problem-solving skills.
• Communication: Strong communication and interpersonal skills.
• Teamwork: Ability to work effectively in a team environment.
• Methodology of AI includes Chunking, Embedding, AI Engineering, Prompt Engineering
• Deep hands-on experience in engineering and executing scalable enterprise solutions.
• Expert-level proficiency in Python (e.g., FastAPI, Flask, PySpark)
• Proficiency in database technologies, such as Oracle, Postgres, or MongoDB.
• Solid understanding of core AI concepts, including knowledge representation, automated planning, decision-making under uncertainty, and multi-agent systems.
• Hands-on experience with relevant frameworks (e.g., Google ADK, LanGraph, LangChain, AutoGen, CrewAI, N8N).
• Good to have experience with machine learning frameworks (e.g., TensorFlow, PyTorch) and relevant libraries (e.g., Scikit-Learn, NumPy, Pandas).
• Proven experience in creating, deploying, and integrating MCPs (Model Context Protocol) into agentic AI systems.
• Deep familiarity with large language models (LLMs) such as ChatGPT, Claude, Gemini, and Llama, including their application within agentic systems.
• Demonstrated experience in designing and implementing robust APIs for AI services.
• Proficient in software development best practices, including version control (Git), CI/CD pipelines, comprehensive testing, and code reviews. Strong understanding of agile methodologies, application resiliency, and security principles applied to complex AI projects. Proven expertise in system design, application development, and ensuring operational stability for AI initiatives.
• Deep experience with application and data architecture patterns and designs.
• Experience leveraging managed services and existing platforms, with a strong emphasis on API-First Design, microservices, and event-driven architectures.
• Hands-on experience with Docker and Openshift.

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.

Equal Opportunity Statement

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.