📍 Job Overview

• Job Title: Database Developer with Java exposure - AVP - Pune
• Company: Citi
• Location: Pune, Mahārāshtra, India
• Job Type: Full-time
• Category: Web Technology - Database Administrator
• Date Posted: 2025-06-19
• Experience Level: 5-10 years
• Remote Status: On-site

🚀 Role Summary

• Lead applications systems analysis and programming activities, partnering with management teams to ensure integration of functions and identify system enhancements.
• Resolve high impact problems through evaluation of complex business processes and provide expertise in applications programming.
• Establish and implement new or revised application systems and programs in coordination with the Technology team.
• Demonstrate strong systems analysis, design, and architecture fundamentals, unit testing, and other SDLC activities.
• Collaborate effectively with business and other stakeholders, communicating complex technical concepts clearly and concisely.

📝 Enhancement Note: This role requires a strong technical background in database management and application development, with a focus on Java and messaging systems. The candidate should have experience working in a collaborative, cross-functional team environment and be able to manage multiple projects and priorities.

💻 Primary Responsibilities

• System Analysis & Design: Evaluate complex business processes, system processes, and industry standards to define system enhancements and deploy new products and process improvements.
• Application Development: Develop, test, debug, and implement application systems and programs that adhere to the overall architecture blueprint.
• Technical Leadership: Provide expertise in applications programming, establish coding standards, and mentor mid-level developers and analysts.
• Risk Assessment: Appropriately assess risk when business decisions are made, demonstrating particular consideration for the firm's reputation and safeguarding Citigroup, its clients, and assets.
• Stakeholder Management: Collaborate with multiple management teams to ensure appropriate integration of functions and meet goals, serving as an advisor or coach to mid-level developers and analysts.

📝 Enhancement Note: The candidate should have a proven track record of delivering high-quality, scalable, and maintainable solutions in a fast-paced, dynamic environment. They should be comfortable working with both technical and non-technical stakeholders and be able to balance multiple priorities and deadlines.

🎓 Skills & Qualifications

Education:

• Bachelor’s degree/University degree or equivalent experience
• Master’s degree preferred

Experience:

• 6+ years of strong hands-on experience in RDMS Database SQL (Oracle/Sybase) queries, PL/SQL, and advanced tuning techniques
• 3+ years of hands-on experience in Java
• 2+ years of experience with messaging systems (e.g., Kafka, Tibco, RabbitMQ)
• Experience in multi-threading, middleware (Tomcat and WebSphere), cloud containerization (ECS), and CICD tools
• Experience in data analysis, data modeling, SQL performance tuning, and exception handling
• Experience in collaboration tools (source control) like GIT/BitBucket/GitHub Copilot and tools like JIRA
• Experience in Unix (Linux) commands and scripting

Required Skills:

• Strong systems analysis, design, and architecture fundamentals
• Unit testing and other SDLC activities
• Strong communication skills, both written and verbal
• Ability to work effectively in a team environment and manage multiple projects and priorities

Preferred Skills:

• Experience with workflow systems (e.g., JBPM)
• Hands-on experience in coding in Java/J2EE, Spring/Spring Boot/Spring Batch, Spring framework stack, SOAP/RESTful Services
• Knowledge of scheduling tools like IBM Autosys
• Experience with SSH clients (sftp/scp) for terminal access and file transfer
• Strong software design skills, such as database packages working in a multi-threaded environment

📝 Enhancement Note: The ideal candidate will have a strong background in database management and application development, with a focus on Java and messaging systems. They should also have experience working in a collaborative, cross-functional team environment and be able to manage multiple projects and priorities.

📊 Web Portfolio & Project Requirements

Portfolio Essentials:

• Demonstrate a strong portfolio of database management and application development projects, highlighting your expertise in SQL, PL/SQL, Java, and messaging systems.
• Include case studies that showcase your ability to resolve high impact problems, analyze complex business processes, and provide expertise in applications programming.
• Highlight your experience with collaboration tools, version control systems, and project management software.

Technical Documentation:

• Provide detailed documentation for your projects, including data models, database schemas, and code comments.
• Include unit tests, integration tests, and performance tests to demonstrate your commitment to code quality and maintainability.
• Showcase your ability to write clear, concise, and well-structured technical documentation that can be easily understood by both technical and non-technical stakeholders.

📝 Enhancement Note: The candidate's portfolio should demonstrate their ability to work with complex databases, optimize SQL queries, and develop high-quality, scalable, and maintainable applications. It should also showcase their experience working in a collaborative, cross-functional team environment and their ability to manage multiple projects and priorities.

💵 Compensation & Benefits

Salary Range: INR 2,500,000 - 4,000,000 per annum (research based on regional market standards for senior database developers with Java exposure)

Benefits:

• Competitive compensation and benefits package
• Opportunities for professional growth and development
• Collaborative and inclusive work environment
• Diverse and global team with opportunities to work on international projects

Working Hours: Full-time, with flexible hours and the ability to work remotely when necessary

📝 Enhancement Note: The salary range for this role is estimated based on regional market standards for senior database developers with Java exposure. The actual salary may vary depending on the candidate's experience, skills, and the company's internal compensation structure.

🎯 Team & Company Context

Company Culture:

• Industry: Financial Services
• Company Size: Large (200,000+ employees)
• Founded: 1812, with a rich history and global presence in over 160 countries and jurisdictions

Team Structure:

• The Database Developer will work within the Applications Development team, collaborating with multiple management teams to ensure appropriate integration of functions and meet goals.
• The role will involve working with both technical and non-technical stakeholders, including business analysts, project managers, and other developers.
• The team follows Agile methodologies, with a focus on iterative development, continuous improvement, and customer value delivery.

Development Methodology:

• The team follows Agile/Scrum methodologies, with sprint planning, daily stand-ups, and regular retrospectives.
• Code reviews, testing, and quality assurance practices are integral to the development process.
• Deployment strategies, CI/CD pipelines, and server management are handled by dedicated DevOps teams.

Company Website: Citi

📝 Enhancement Note: Citi is a large, global financial services company with a rich history and a strong commitment to innovation and technology. The company values collaboration, inclusion, and continuous learning, providing opportunities for professional growth and development.

📈 Career & Growth Analysis

Web Technology Career Level: Senior Database Developer with Java exposure - AVP level, responsible for leading applications systems analysis and programming activities, and providing expertise in applications programming.

Reporting Structure: The Database Developer will report directly to the Applications Development Manager and collaborate with multiple management teams to ensure appropriate integration of functions and meet goals.

Technical Impact: The role will have a significant impact on the development and maintenance of application systems and programs, ensuring they adhere to the overall architecture blueprint and meet business objectives.

Growth Opportunities:

• Technical Growth: Expand your expertise in database management, application development, and emerging technologies such as cloud-native architectures, microservices, and event-driven systems.
• Leadership Growth: Develop your leadership skills by mentoring mid-level developers and analysts, driving technical decisions, and contributing to the overall architecture and design of the technology stack.
• Business Growth: Gain exposure to various lines of business within the company, understanding their unique needs and developing tailored solutions to meet their objectives.

📝 Enhancement Note: This role offers significant opportunities for technical and leadership growth, with the potential to make a meaningful impact on the company's technology stack and business outcomes. The ideal candidate will be eager to take on new challenges, learn from experienced colleagues, and contribute to the team's success.

🌐 Work Environment

Office Type: Modern, collaborative workspaces with open floor plans, dedicated team areas, and quiet spaces for focused work.

Office Location(s): Pune, Mahārāshtra, India, with opportunities to work remotely when necessary.

Workspace Context:

• Collaboration: The workspace is designed to foster collaboration and communication, with dedicated team areas and open floor plans.
• Equipment: Each team member is provided with modern equipment, including multiple monitors, testing devices, and development tools.
• Accessibility: The office is easily accessible by public transportation, and on-site parking is available for employees.

Work Schedule: Full-time, with flexible hours and the ability to work remotely when necessary. The work schedule may vary depending on project deadlines and maintenance windows.

📝 Enhancement Note: The work environment at Citi is designed to be collaborative, inclusive, and supportive of work-life balance. The company offers modern, well-equipped workspaces and encourages employees to maintain a healthy work-life balance.

📄 Application & Technical Interview Process

Interview Process:

1. Online Assessment: Complete an online assessment to evaluate your technical skills and problem-solving abilities.
2. Technical Phone Screen: Participate in a phone screen to discuss your technical background, experience, and career goals.
3. On-site Interview: Attend an on-site interview to meet with the hiring manager, team members, and other stakeholders. This interview will focus on your technical skills, cultural fit, and alignment with the company's mission and values.
4. Final Decision: The hiring team will review your application and make a final decision based on your qualifications, technical skills, and cultural fit.

Portfolio Review Tips:

• Tailor your portfolio to highlight your expertise in database management, application development, and Java programming.
• Include case studies that demonstrate your ability to resolve high impact problems, analyze complex business processes, and provide expertise in applications programming.
• Prepare a live demo of your portfolio, showcasing your technical skills and ability to explain complex technical concepts clearly and concisely.

Technical Challenge Preparation:

• Brush up on your SQL, PL/SQL, Java, and messaging systems knowledge, focusing on advanced topics and real-world scenarios.
• Practice coding challenges and algorithm problems to improve your problem-solving skills and ability to think critically under time pressure.
• Familiarize yourself with the company's technology stack, including databases, middleware, and cloud containerization tools.

📝 Enhancement Note: The interview process at Citi is designed to be comprehensive, fair, and transparent. The company values diversity, inclusion, and collaboration, and encourages candidates to ask questions and engage in open dialogue throughout the process.

🛠 Technology Stack & Web Infrastructure

Frontend Technologies: (Not applicable for this role)

Backend & Server Technologies:

• Databases: Oracle, Sybase, and other RDMS databases
• Programming Languages: Java, PL/SQL
• Messaging Systems: Kafka, Tibco, RabbitMQ, and other enterprise messaging platforms
• Middleware: Tomcat, WebSphere, and other application servers
• Cloud Containerization: Amazon ECS, Docker, and Kubernetes
• CICD Tools: Jenkins, GitLab CI/CD, and other automation tools

Development & DevOps Tools:

• Version Control: Git, BitBucket, and GitHub Copilot
• Project Management: JIRA, Confluence, and other collaboration tools
• Monitoring: Prometheus, Grafana, and other server monitoring tools
• Infrastructure as Code: Terraform, CloudFormation, and other IaaC tools

📝 Enhancement Note: The technology stack at Citi is diverse and extensive, with a focus on enterprise-grade, scalable, and secure solutions. The company encourages continuous learning and innovation, providing opportunities for team members to expand their skills and expertise.

👥 Team Culture & Values

Web Development Values:

• Expertise: Demonstrate a deep understanding of database management, application development, and Java programming.
• Innovation: Embrace a culture of continuous learning and improvement, staying up-to-date with emerging technologies and industry best practices.
• Collaboration: Work effectively with both technical and non-technical stakeholders, fostering a culture of open communication, active listening, and mutual respect.
• Quality: Maintain a strong commitment to code quality, testing, and maintainability, ensuring that your solutions are scalable, secure, and reliable.
• Customer Focus: Understand the unique needs of each line of business within the company, developing tailored solutions that meet their objectives and exceed their expectations.

Collaboration Style:

• Cross-functional Integration: Work closely with business analysts, project managers, and other developers to ensure appropriate integration of functions and meet goals.
• Code Review Culture: Participate in code reviews, providing constructive feedback and incorporating input from your colleagues to improve the overall quality of the codebase.
• Peer Programming: Collaborate with other developers on complex technical challenges, sharing knowledge and expertise to drive innovative solutions and continuous learning.

📝 Enhancement Note: The team culture at Citi is collaborative, inclusive, and focused on driving innovation and continuous improvement. The company values diversity, inclusion, and active engagement, encouraging team members to contribute to the team's success and grow both personally and professionally.

⚡ Challenges & Growth Opportunities

Technical Challenges:

• Database Optimization: Develop advanced SQL queries and tuning techniques to optimize database performance, improve query execution plans, and minimize resource utilization.
• Messaging Systems: Design and implement scalable, fault-tolerant messaging systems that ensure reliable and secure data transmission between applications and services.
• Cloud Migration: Lead the migration of on-premises applications and databases to cloud-based infrastructure, ensuring minimal downtime and improved performance.
• Microservices Architecture: Develop and maintain microservices architectures, ensuring loose coupling, high cohesion, and independent deployment of services.
• Data Governance: Implement data governance policies and procedures to ensure data quality, security, and compliance with regulatory requirements.

Learning & Development Opportunities:

• Technical Training: Participate in technical training programs, webinars, and workshops to expand your skills and expertise in database management, application development, and emerging technologies.
• Conference Attendance: Attend industry conferences and events to network with other professionals, learn about emerging trends, and share best practices.
• Mentorship: Seek out mentorship opportunities from experienced colleagues, leveraging their expertise to drive your professional growth and development.
• Leadership Development: Participate in leadership development programs and workshops to enhance your communication, team-building, and decision-making skills.

📝 Enhancement Note: The technical challenges and learning opportunities in this role are diverse and extensive, providing a unique opportunity for the candidate to grow both personally and professionally. The ideal candidate will be eager to take on new challenges, learn from experienced colleagues, and contribute to the team's success.

💡 Interview Preparation

Technical Questions:

• Database Fundamentals: Demonstrate a strong understanding of database design, normalization, and indexing techniques, as well as advanced SQL queries and PL/SQL programming.
• Java Programming: Showcase your expertise in Java programming, including object-oriented design, multithreading, and exception handling.
• Messaging Systems: Explain your experience with messaging systems, including message queues, message brokers, and message-oriented middleware.
• System Design: Discuss your approach to system design, architecture, and scalability, focusing on real-world scenarios and best practices.

Company & Culture Questions:

• Company Culture: Demonstrate your understanding of Citi's company culture, values, and mission, and explain how you can contribute to the team's success and drive innovation.
• Team Dynamics: Describe your experience working in a collaborative, cross-functional team environment, and explain how you can contribute to a positive and inclusive team culture.
• Problem-Solving: Provide examples of how you have approached complex technical challenges in the past, and explain your problem-solving process and decision-making strategies.

Portfolio Presentation Strategy:

• Live Demo: Prepare a live demo of your portfolio, showcasing your technical skills and ability to explain complex technical concepts clearly and concisely.
• Code Walkthrough: Develop a structured approach to walking the interviewer through your code, highlighting your problem-solving skills, coding best practices, and attention to detail.
• User Experience: Demonstrate your ability to design and develop user-friendly, intuitive, and accessible applications, focusing on the user's needs and preferences.

📝 Enhancement Note: The interview process at Citi is designed to be comprehensive, fair, and transparent. The company values diversity, inclusion, and collaboration, and encourages candidates to ask questions and engage in open dialogue throughout the process.

📌 Application Steps

To apply for this Database Developer with Java exposure - AVP - Pune position at Citi, follow these steps:

1. Tailor Your Portfolio: Highlight your expertise in database management, application development, and Java programming, focusing on real-world scenarios and best practices.
2. Optimize Your Resume: Emphasize your technical skills, experience, and accomplishments, using relevant keywords and industry-specific terminology.
3. Prepare for Technical Interviews: Brush up on your SQL, PL/SQL, Java, and messaging systems knowledge, focusing on advanced topics and real-world scenarios.
4. Research the Company: Familiarize yourself with Citi's company culture, values, and mission, and prepare thoughtful questions to ask during the interview process.
5. Submit Your Application: Follow the application link provided and submit your application, including your resume and portfolio.

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