Data Engineer - Python AI - Assistant Vice President

Citigroup Inc.; Pune District; On-site; INR 2,800,000 - 4,000,000; Full time

Job summary

Citigroup Inc. is seeking a Data Engineer with 7-10 years of experience to design, develop, and maintain ETL processes and data pipelines in Pune. The role emphasizes Python, PL/SQL, and data warehousing, with a focus on data quality and scalable solutions.

The ideal candidate will implement robust data pipelines, write complex SQL, and collaborate with analysts to meet data requirements while documenting processes and staying updated on AI-enabled data practices.

Qualifications

• Proficient in Python, ETL design and PL/SQL development.
• Experience with data warehousing concepts and data modeling.
• Strong SQL skills and data validation.

Responsibilities

• Design, develop, and maintain ETL processes and data pipelines.
• Write complex SQL and PL/SQL scripts for data transformation.
• Build and optimize data pipelines using Python libraries (Polar, Pandas).
• Ensure data quality and implement monitoring across pipelines.
• Create technical documentation for ETL processes and data models.
• Stay current with data management and analytics trends.

Skills

Python

ETL

PL/SQL

SQL

Data Warehousing

Data Modeling

Database Management

Problem Solving

Communication

Teamwork

Tools

Polar

Pandas

Job description

Data Engineer (7-10 Years Exp):

Job Title: Python, ETL, AI Engineering (Optional) 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. 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

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.