📍 Job Overview

• Job Title: Database Developer with Java exposure - AVP
• Company: Citi
• Location: Pune, Maharashtra, India
• Job Type: Full-time
• Category: Database Development
• Date Posted: 2025-06-19
• Experience Level: 5-10 years
• Remote Status: On-site

🚀 Role Summary

• Lead application systems analysis and programming activities, partnering with management teams to ensure integration of functions and identify system enhancements.
• Resolve high impact problems through in-depth evaluation of complex business processes, system processes, and industry standards.
• Provide expertise in applications programming and ensure application design adheres to the overall architecture blueprint.
• Utilize advanced knowledge of system flow and develop standards for coding, testing, debugging, and implementation.
• Develop comprehensive knowledge of how areas of business, such as architecture and infrastructure, integrate to accomplish business goals.

📝 Enhancement Note: This role requires a strong understanding of database systems, application programming, and business processes to drive system enhancements and resolve complex problems. The candidate should be able to work effectively with multiple teams and stakeholders to ensure appropriate integration and meet goals.

💻 Primary Responsibilities

• System Analysis & Enhancement: Partner with management teams to identify necessary system enhancements to deploy new products and process improvements.
• Problem Resolution: Resolve high impact problems through in-depth evaluation of complex business processes, system processes, and industry standards.
• Application Programming: Provide expertise in applications programming and ensure application design adheres to the overall architecture blueprint.
• System Flow & Standards: Utilize advanced knowledge of system flow and develop standards for coding, testing, debugging, and implementation.
• Business Integration: Develop comprehensive knowledge of how areas of business, such as architecture and infrastructure, integrate to accomplish business goals.
• Team Coaching: Serve as an advisor or coach to mid-level developers and analysts, allocating work as necessary.
• 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.

📝 Enhancement Note: The candidate should have a strong problem-solving mindset, with the ability to analyze complex business processes and develop innovative solutions. They should also be able to effectively communicate and collaborate with various teams to ensure appropriate integration and meet goals.

🎓 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 and database upgrade/migration approaches
• 3+ years of hands-on experience in Java
• 2+ years of experience with Messaging (e.g., Kafka, Tibco, RabbitMQ)
• Hands-on experience in multi-threading
• Good to have experience in Middleware (Tomcat and WebSphere), Cloud Containerization (ECS), CICD tools, Angular, ExtJS, JMS, JSON, XML, ROD, LightSpeed, Spring Batch, Spring Boot, Microservices, event-based architecture, and consuming REST API
• Experience in collaboration tools (source control) like GIT/BitBucket/GitHub Copilot and tools like JIRA
• Experience in Unix (Linux) commands and scripting
• Experience in data analysis, data modeling, and SQL performance tuning, exception handling

Required Skills:

• Strong systems analysis, design, and architecture fundamentals
• Strong communication skills, able to communicate effectively with business and other stakeholders
• Preferable hands-on experience in coding in JAVA/J2EE, Spring/Spring Boot/Spring Batch, Spring framework stack, SOAP/RESTful Services
• Strong hands-on experience in writing SQL queries and data analysis

Preferred Skillsets:

• Good knowledge and experience in Workflow (e.g., JBPM)
• 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

📊 Web Portfolio & Project Requirements

Portfolio Essentials:

• A comprehensive portfolio showcasing database design, SQL queries, and application programming projects
• Examples of system enhancements and problem-solving approaches
• Demonstrations of effective collaboration and communication with various teams and stakeholders

Technical Documentation:

• Well-commented and documented code, adhering to coding standards and best practices
• Version control and deployment processes, including database schema versioning and data migration strategies
• Testing methodologies, performance metrics, and optimization techniques

📝 Enhancement Note: The candidate's portfolio should highlight their problem-solving skills, database design expertise, and ability to work effectively with various teams. It should also demonstrate their understanding of system flow, application programming, and business integration.

💵 Compensation & Benefits

Salary Range: INR 1,200,000 - 1,800,000 per annum (Estimated based on market standards for a Database Developer with Java exposure - AVP role in Pune, Maharashtra, India)

Benefits:

• Competitive compensation and benefits package
• Employee stock purchase plan
• Retirement savings plan with company match
• Health and wellness benefits
• Employee assistance program
• Tuition assistance and professional development opportunities
• Work-life balance initiatives

Working Hours: Full-time, typically 40 hours per week, with flexibility for project deadlines and maintenance windows

📝 Enhancement Note: The estimated salary range is based on market standards for a Database Developer with Java exposure - AVP role in Pune, Maharashtra, India. 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 (Over 10,000 employees)

Founded: 1812

Team Structure:

• The Database Developer with Java exposure - AVP will work within the Applications Development team, collaborating with multiple management teams to ensure appropriate integration of functions and meet goals.
• The role will report directly to the Applications Development Manager and may have supervisory responsibilities for mid-level developers and analysts.

Development Methodology:

• Agile/Scrum methodologies with sprint planning for application development projects
• Code review, testing, and quality assurance practices to ensure application quality and performance
• Deployment strategies, CI/CD pipelines, and server management to automate deployment and ensure system stability

Company Website: Citi

📝 Enhancement Note: Citi is a large financial services company with a global presence, offering a wide range of financial products and services. The company values innovation, collaboration, and customer focus, with a strong commitment to diversity, equity, and inclusion.

📈 Career & Growth Analysis

Web Technology Career Level: Senior-level Database Developer with Java exposure, responsible for leading application systems analysis and programming activities, partnering with management teams, and resolving complex business problems.

Reporting Structure: The role will report directly to the Applications Development Manager and may have supervisory responsibilities for mid-level developers and analysts.

Technical Impact: The Database Developer with Java exposure - AVP will have a significant impact on the design, implementation, and maintenance of application systems, ensuring they meet business goals and industry standards.

Growth Opportunities:

• Technical Growth: Expand expertise in database systems, application programming, and emerging technologies to take on more complex projects and leadership roles.
• Career Progression: Transition into senior management or architecture roles, driving strategic decision-making and influencing the overall technology direction.
• Technical Leadership: Develop and mentor junior team members, driving knowledge sharing and continuous learning within the team.

📝 Enhancement Note: Citi offers significant growth opportunities for Database Developers with Java exposure, with the potential to take on more complex projects, leadership roles, and influence the overall technology direction. The company values internal promotions and provides opportunities for professional development and career progression.

🌐 Work Environment

Office Type: Large, modern office space with collaborative workspaces and dedicated team areas

Office Location(s): Pune, Maharashtra, India

Workspace Context:

• Collaborative workspaces with dedicated team areas and meeting rooms
• Access to multiple monitors, testing devices, and development tools
• Cross-functional collaboration with designers, marketers, and other stakeholders

Work Schedule: Full-time, typically 40 hours per week, with flexibility for deployment windows, maintenance, and project deadlines

📝 Enhancement Note: Citi's Pune office offers a modern, collaborative work environment with access to the latest development tools and resources. The company encourages cross-functional collaboration and provides flexibility for work-life balance.

📄 Application & Technical Interview Process

Interview Process:

1. Online Assessment: Complete an online assessment to evaluate technical skills and problem-solving abilities.
2. Technical Phone Screen: Participate in a technical phone screen to discuss system design, database architecture, and application programming concepts.
3. On-site Interview: Attend an on-site interview to meet the hiring manager, team members, and discuss the role's responsibilities, expectations, and growth opportunities.
4. Final Decision: Receive a final decision and job offer, if selected.

Portfolio Review Tips:

• Highlight database design, SQL queries, and application programming projects that demonstrate problem-solving skills, system enhancements, and effective collaboration.
• Prepare case studies showcasing user experience design, performance optimization, and accessibility standards.
• Be ready to discuss technical challenges, solutions, and the impact of your work on business goals and user experience.

Technical Challenge Preparation:

• Brush up on database design principles, SQL queries, and application programming concepts.
• Review system architecture, data modeling, and performance tuning techniques.
• Practice problem-solving exercises and prepare for system design discussions.

ATS Keywords: Database SQL, PL/SQL, Java, Messaging, Multi-threading, Middleware, Cloud Containerization, CICD Tools, Data Analysis, Data Modeling, SQL Performance Tuning, Unix, Spring Boot, Microservices, REST API, GIT, Agile, Scrum, Code Review, Quality Assurance, Deployment, CI/CD Pipelines, Server Management, Leadership, Mentoring, Career Progression, Technical Impact, User Experience, Collaboration, Cross-functional Teams, Stakeholder Management, Problem-solving, System Design, Database Architecture, Application Programming, Business Integration, Risk Assessment, Compliance, Regulatory Standards, Financial Services, Banking, Fintech, Innovation, Customer Focus, Diversity, Equity, Inclusion.

📝 Enhancement Note: The interview process for the Database Developer with Java exposure - AVP role at Citi involves a comprehensive evaluation of technical skills, problem-solving abilities, and cultural fit. The candidate should be prepared to discuss their portfolio, technical challenges, and system design concepts in detail.

📌 Application Steps

To apply for the Database Developer with Java exposure - AVP position at Citi:

1. Submit your application through the provided link.
2. Customize your resume, highlighting relevant skills, experiences, and achievements in database development, application programming, and problem-solving.
3. Prepare a comprehensive portfolio showcasing your database design, SQL queries, and application programming projects, emphasizing system enhancements, problem-solving approaches, and effective collaboration.
4. Research Citi's company culture, values, and business focus to tailor your application and interview responses accordingly.
5. Practice problem-solving exercises, system design discussions, and technical challenge preparation to ensure you are well-prepared for the interview process.

⚠️ 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.