Explore the IND Analyst I Wealth – PA Technology role at Aon in Gurgaon, India. Support and test Aon’s Pension Administration System by configuring systems, writing SQL/VBA code, and assisting in system testing. Ideal for candidates with programming and pension domain knowledge.
Job Details
| Job Title | IND Analyst I Wealth – PA Technology |
|---|---|
| Company | Aon |
| Location | Gurgaon, India |
| Job Type | Full-time |
| Experience | 0-1 years in Pension/Benefits or SQL/VBA |
| Education | Bachelor’s or Master’s degree in IT, Computer Science, or related fields |
| Industry | Wealth Solutions (Pension Administration) |
| Working Hours | 12:00 PM – 9:00 PM IST (may require flexibility) |
| Transportation | Provided by the company |
| Eligibility | 1-3 years of experience in Pension Domain or SQL/VBA |
About the Role
The IND Analyst I Wealth – PA Technology role at Aon focuses on supporting and testing the Pension Administration System. As part of the Wealth Solutions team, you will be involved in configuring the system, executing tests, troubleshooting errors, and ensuring smooth operations for client-specific requirements.
This is an entry-level position ideal for individuals skilled in SQL, VBA, and pension administration.
Key Responsibilities
- Demonstrate an understanding of the Pension Domain or SQL/VBA.
- Review client requirements and configure the system accordingly.
- Execute unit tests and document results.
- Troubleshoot basic defects and escalate issues as needed.
- Assist in analysis and test planning for medium complexity tasks.
- Run regression tests for releases and ensure smooth system operation.
- Collaborate with multi-cultural teams across different regions.
Role Specifications
Education/Certifications
- Bachelor’s or Master’s degree in Information Technology, Computer Science, or a related field.
Experience
- 0-1 years of experience in Pensions/Benefits, SQL, or VBA.
- 12 months in an Analyst I role or similar experience at Aon or another company.
Technical Skills
- Understanding of relational database concepts.
- Proficiency in writing SQL queries or VBA code.
- Basic knowledge of Software Development Life Cycle (SDLC) principles.
- Ability to troubleshoot system defects and interpret client documentation.
Desired Skills
- Detail-oriented and resourceful problem solver.
- Ability to stay on track with project timelines and tasks.
- Strong communication skills, both with clients and internal teams.
Behavioral Requirements
- Interest in building a career in the Wealth business.
- Self-motivated and proactive in taking initiative and contributing to team goals.
- Ability to collaborate and work within a culturally diverse team environment.
- Professional, disciplined, and respectful of others at all times.
Selection Procedure
- Screening round by HR.
- Two interview rounds focusing on technical and behavioral skills.
Work Timings and Location
- General Hours: 12:00 PM to 9:00 PM IST (with flexibility for alternate shifts).
- Location: Gurgaon, Bangalore, or Noida, India.
- Transportation: Provided by Aon.
About Aon
Aon is a global leader in human capital consulting and outsourcing solutions. The company partners with organizations to solve complex challenges in benefits, talent, and financial performance. For more information, visit: Aon Website.
1. Understand the Job Role and Responsibilities
- Core Tasks: Your role involves supporting and testing Aon’s Pension Administration System, configuring systems, reviewing client requirements, writing SQL/VBA, and testing systems.
- Key Focus:
- Demonstrating an understanding of the pension domain and system configuration.
- Writing intermediate SQL queries or VBA code.
- Working on system testing, including unit tests and release regression.
- Identifying and troubleshooting system defects.
2. Required Skills and Knowledge
- Pension Domain: Understanding the basics of pension administration, such as how pension schemes work and what their key components are.
- SQL and VBA:
- Be comfortable with writing SQL queries (select, join, group by, subqueries, etc.).
- Brush up on VBA programming basics if applicable.
- System Testing: Familiarize yourself with the Software Development Life Cycle (SDLC) and testing methodologies such as unit testing, regression testing, and troubleshooting.
- Database Concepts: Refresh your knowledge of relational database concepts, such as table relationships and keys.
3. Technical Skills Preparation
- SQL: Practice writing SQL queries to handle typical business scenarios like extracting, filtering, and analyzing data from multiple tables.
- Example: Write a query to find the average pension contribution by age group.
- VBA: If you’re not familiar, review how to automate tasks using VBA in Excel or other systems.
- Example: Automate a report generation process using VBA.
- System Configuration: Understand the process of configuring a system to meet client specifications, especially in the context of pension administration software.
4. Behavioral and Soft Skills Preparation
- Attention to Detail: Be prepared to show how you ensure accuracy and meet deadlines in your work.
- Problem-Solving: Emphasize your ability to troubleshoot and use resources to solve problems.
- Client Service: Aon values strong client service skills, so prepare examples of how you’ve worked with clients or teams in the past.
- Communication: Highlight how you effectively communicate complex technical information to different stakeholders.
5. Company Knowledge
- Aon Overview: Familiarize yourself with Aon’s role in human capital consulting, benefits, and investment management. Understand the company’s commitment to innovation and cultural sensitivity.
- Client Interaction: Be ready to discuss how you would handle interactions with clients or multi-cultural teams, especially since Aon operates globally.
6. Mock Interviews & Practice
- Technical Mock Interviews: Practice solving SQL and VBA problems in mock interviews or coding platforms.
- Behavioral Questions: Prepare answers for questions like:
- Tell me about a time when you had to troubleshoot a complex issue.
- How do you ensure accuracy in your work?
- How do you prioritize your tasks when dealing with multiple deadlines?
7. Work Timings and Flexibility
- The role mentions working from 12:00 pm to 9:00 pm IST and the possibility of working beyond business hours. Make sure you’re comfortable with these timings.
- Transportation: The role offers company transportation, so be prepared to discuss your location preferences (Bangalore, Gurugram, or Noida).
8. Interview Process
- HR Screening: Expect an initial HR screening to discuss your background, followed by two rounds of technical and behavioral interviews.
- Technical Interview: Focus on SQL, VBA, and problem-solving. They may give you practical scenarios or case studies to work through.
- Behavioral Interview: Be ready to discuss your teamwork, client service skills, and how you handle challenges.
