AVP- Database Engineer

📍 Job Overview

• Job Title: AVP - Database Engineer
• Company: Citi
• Location: Mumbai, Maharashtra, India
• Job Type: Full-Time
• Category: Database Administration
• Date Posted: June 13, 2025
• Experience Level: 7-9 years
• Remote Status: On-site

🚀 Role Summary

• Key Responsibilities: Design, develop, and optimize Oracle database solutions using SQL and PL/SQL; implement and manage applications on Oracle Cloud Infrastructure (OCI); write Python scripts for data automation, transformation, and validation; apply Big Data principles to support large-scale data processing needs; design and maintain robust ETL workflows and data pipelines; build and support Data Warehouse solutions ensuring performance and reliability; collaborate with technical and business teams, especially data stakeholders, to understand and fulfill data requirements; leverage SAS knowledge (if applicable) to support data analysis and reporting initiatives.
• Key Skills: Strong proficiency in Oracle SQL and PL/SQL, experience with Oracle Cloud services, solid knowledge of Python programming, understanding of Big Data technologies (e.g., Hadoop, Spark), experience with ETL tools and processes, familiarity with Data Warehouse design and optimization, excellent communication and interpersonal skills.

💻 Primary Responsibilities

• Database Design & Development: Design, develop, and optimize Oracle database solutions using SQL and PL/SQL to meet business requirements and ensure data integrity.
• Cloud Infrastructure Management: Implement and manage applications on Oracle Cloud Infrastructure (OCI), leveraging cloud services to enhance scalability, availability, and performance.
• Data Automation & Transformation: Write Python scripts to automate data processing tasks, transform data, and validate data quality. Apply Big Data principles to support large-scale data processing needs.
• ETL & Data Pipeline Development: Design and maintain robust ETL workflows and data pipelines to extract, transform, and load data from various sources into data warehouses and data marts.
• Data Warehouse Management: Build and support Data Warehouse solutions, ensuring optimal performance, reliability, and scalability to support business intelligence and analytics initiatives.
• Stakeholder Collaboration: Collaborate with technical and business teams, especially data stakeholders, to understand data requirements, gather feedback, and ensure data solutions meet business needs.
• Data Analysis & Reporting: Leverage SAS knowledge (if applicable) to support data analysis and reporting initiatives, enabling data-driven decision-making and enhancing user experience.

🎓 Skills & Qualifications

Education: Bachelor’s degree in Computer Science, Information Technology, or a related field. Relevant certifications, such as Oracle Certified Professional or OCI certifications, are a plus.

Experience: 7-9 years of experience in database engineering, with a strong focus on Oracle databases and cloud infrastructure. Proven experience in ETL processes, Big Data technologies, and Data Warehousing is essential.

Required Skills:

• Strong proficiency in Oracle SQL and PL/SQL
• Experience with Oracle Cloud services
• Solid knowledge of Python programming
• Understanding of Big Data technologies (e.g., Hadoop, Spark)
• Experience with ETL tools and processes
• Familiarity with Data Warehouse design and optimization
• Excellent communication and interpersonal skills

Preferred Skills:

• Experience with SAS for data analysis, reporting, or integration
• Background in data analytics, data modeling, or performance tuning
• Prior work experience as a business consultant, interacting with multiple stakeholders
• Familiarity with additional programming/scripting languages

📊 Web Portfolio & Project Requirements

Portfolio Essentials:

• Demonstrate proficiency in Oracle SQL and PL/SQL by showcasing complex queries, stored procedures, and database design projects.
• Highlight experience with Oracle Cloud Infrastructure by presenting cloud-based application deployments and infrastructure as code (IaC) projects.
• Showcase Python scripting skills by featuring data automation, transformation, and validation projects.
• Display understanding of Big Data technologies by including projects that involve large-scale data processing, analysis, or machine learning.
• Present ETL and data pipeline projects, emphasizing data extraction, transformation, and loading processes, as well as data validation and quality assurance.
• Exhibit Data Warehouse management skills by showcasing data modeling, optimization, and performance tuning projects.

Technical Documentation:

• Include code comments and documentation that explain the purpose, functionality, and usage of your code.
• Showcase version control, deployment processes, and server configuration documentation.
• Demonstrate understanding of testing methodologies, performance metrics, and optimization techniques by including relevant documentation in your portfolio.

💵 Compensation & Benefits

Salary Range: INR 1,200,000 - 1,800,000 per annum (Estimated based on industry standards for a senior database engineer role in Mumbai)

Benefits:

• Competitive health, dental, and vision insurance plans
• Retirement savings plans with company match
• Generous time-off policies, including vacation, sick leave, and parental leave
• Employee assistance programs for mental health and wellness support
• Tuition assistance and professional development opportunities
• Employee discounts on various products and services

Working Hours: Full-time, 40 hours per week, with flexible scheduling for deployment windows, maintenance, and project deadlines.

🎯 Team & Company Context

🏢 Company Culture

Industry: Financial Services

Company Size: Large (250,000+ employees)

Founded: 1812

Team Structure:

• The database engineering team consists of various roles, including database administrators, database developers, and data engineers, working collaboratively to ensure data integrity, availability, and performance.
• The team follows a matrix reporting structure, with members reporting to both their functional managers and the data architecture team.
• Cross-functional collaboration occurs with various teams, including application development, data analytics, and business stakeholders.

Development Methodology:

• The team follows Agile/Scrum methodologies, with bi-weekly sprint planning, daily stand-ups, and regular code reviews.
• They employ continuous integration and continuous deployment (CI/CD) pipelines for automated testing, deployment, and monitoring.
• Infrastructure as code (IaC) is used to manage and provision cloud resources, ensuring consistency, version control, and automated deployment.

Company Website: Citi

📈 Career & Growth Analysis

Web Technology Career Level: Senior Database Engineer - Leads complex database projects, mentors junior team members, and influences database strategy and architecture decisions.

Reporting Structure: Reports to the Database Engineering Manager, with a dotted line to the Data Architecture team.

Technical Impact: Plays a critical role in designing, developing, and maintaining high-performing, scalable, and secure database solutions that support business operations and enable data-driven decision-making.

Growth Opportunities:

• Technical Growth: Expand expertise in cloud-native database technologies, data modeling, and data warehousing to become a subject matter expert (SME) in these areas.
• Leadership Growth: Develop leadership skills by mentoring junior team members, driving team projects, and contributing to team strategy and roadmap development.
• Architecture Growth: Gain experience in database architecture, data modeling, and data warehousing to become a technical lead or architect, driving database strategy and architecture decisions.

🌐 Work Environment

Office Type: Modern, collaborative office space with dedicated workstations, multiple monitors, and testing devices available.

Office Location(s): Mumbai, with additional locations across India and globally.

Workspace Context:

• The workspace encourages collaboration and knowledge sharing among team members, with regular team meetings, workshops, and training sessions.
• The team uses various collaboration tools, such as Slack, Microsoft Teams, and JIRA, to facilitate communication and project management.
• The workspace is equipped with high-speed internet connectivity, secure network access, and remote access solutions for off-site work.

Work Schedule: Full-time, with flexible scheduling for deployment windows, maintenance, and project deadlines. The team follows a bi-weekly sprint schedule, with daily stand-ups and regular team meetings.

📄 Application & Technical Interview Process

Interview Process:

1. Online Assessment: A 60-minute online assessment focusing on SQL, PL/SQL, and Python skills, as well as data analysis and problem-solving.
2. Technical Deep Dive: A 90-minute technical deep dive, focusing on Oracle Cloud Infrastructure, ETL processes, and data warehousing. This session also assesses communication and interpersonal skills.
3. Behavioral & Cultural Fit: A 60-minute behavioral and cultural fit interview, focusing on problem-solving, stakeholder management, and adaptability.
4. Final Evaluation: A 30-minute final evaluation with senior leadership, focusing on career aspirations, technical fit, and cultural alignment.

Portfolio Review Tips:

• Highlight complex SQL queries, stored procedures, and database design projects that demonstrate your proficiency in Oracle databases.
• Showcase Python scripts for data automation, transformation, and validation, emphasizing performance optimization and data quality.
• Present ETL and data pipeline projects, focusing on data extraction, transformation, and loading processes, as well as data validation and quality assurance.
• Exhibit Data Warehouse management skills by showcasing data modeling, optimization, and performance tuning projects.

Technical Challenge Preparation:

• Brush up on SQL, PL/SQL, and Python skills, focusing on database design, ETL processes, and data warehousing.
• Familiarize yourself with Oracle Cloud Infrastructure, Big Data technologies, and data analysis techniques.
• Prepare for behavioral and cultural fit interviews by reflecting on your problem-solving approach, stakeholder management skills, and adaptability in dynamic environments.

ATS Keywords: Oracle SQL, PL/SQL, Oracle Cloud, Python, ETL, Big Data, Data Warehouse, Data Analysis, Stakeholder Management, Problem-Solving, Adaptability, Cloud Infrastructure, Data Modeling, Data Transformation, Data Validation, Data Quality, Performance Optimization, Data-Driven Decision-Making, Agile Methodologies, CI/CD Pipelines, IaC, Mentoring, Leadership, Architecture, Technical Strategy, Database Engineering, Senior Database Engineer, Data Engineering, Data Warehousing, Data Analysis, Data-Driven Decision-Making.

📌 Application Steps

To apply for this AVP - Database Engineer position at Citi:

1. Submit your application through the Citi careers portal.
2. Customize your resume to highlight relevant skills, experiences, and achievements in database engineering, cloud infrastructure, and data analysis.
3. Prepare a comprehensive portfolio showcasing your proficiency in Oracle databases, cloud infrastructure, Python scripting, ETL processes, and data warehousing.
4. Research Citi's data engineering team, company culture, and business objectives to tailor your application and interview responses.
5. Practice SQL, PL/SQL, and Python coding challenges, focusing on database design, ETL processes, and data warehaging.
6. Prepare for behavioral and cultural fit interviews by reflecting on your problem-solving approach, stakeholder management skills, and adaptability in dynamic environments.

⚠️ Important Notice: This enhanced job description includes AI-generated insights and industry-standard assumptions. All details should be verified directly with the hiring organization before making application decisions.