Data Engineer - Python AI - Assistant Vice President

Citi; Pune District; On-site; INR 900,000 - 1,300,000; Full time

Job summary

Citi is seeking a Data Engineer with 7-10 years of experience to design, develop, and maintain ETL data pipelines and warehousing solutions. The role requires strong Python, PL/SQL, and SQL skills, plus data modeling and database management expertise.

You will collaborate with analysts and stakeholders, implement data quality checks, and optimize pipelines for performance and scale, while documenting processes and staying current with industry trends.

Qualifications

• 7–10 years of hands-on data engineering experience.
• Expertise with Python, ETL, SQL and PL/SQL.
• Experience with data warehousing concepts.
• Ability to design scalable data pipelines.

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., Polars, 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

Tools

Polars

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.