Senior Database Developer

Marsh McLennan India is seeking candidates for the following position based in the Noida/Gurgaon office:

Senior Manager - Applications Development

What can you expect?

We are looking for strong Senior Database Developer. Candidates primary focus will be to develop & deliver high quality ETL and DB solutions with large Dataset.

What is in it for you?

Discover what's great about working at Marsh McLennan from the opportunities that our size brings, to our commitment to our communities and understanding the benefits youll receive. We are four businesses with one PURPOSE: helping companies meet the challenges of our time.

As a global leader in insurance broking and risk management, we are devoted to finding diverse individuals who are committed to the success of our clients and our organization. Joining us will provide a solid foundation for you to accelerate your career in the risk and insurance industry. You will join a team of talented professionals from across the globe which is dedicated to helping clients manage some of the world's most challenging and complex risks. We can promise you extraordinary challenges, extraordinary colleagues, and the opportunity to make a difference.

Our rich history has created a client service culture that we believe is second to none. Our commitments to Diversity and Inclusion, Corporate Social Responsibility, and sustainability demonstrate our commitment to stand for what is right.

As a Marsh McLennan colleague, you will also receive additional benefits such as:

• A competitive salary
• Employee friendly policies
• Health care and insurance for you and your dependents
• Healthy Work life balance
• A great working environment
• Flexible benefits packages to suit your needs and lifestyle
• Future career opportunities across a global organization

We will count on you to:

• Participate in high- and low-level design activities
• Designing, developing & delivering end to end software solutions
• Ensure reusability, security, performance and standard industry coding practices and patterns
• Creating high- and low-level technical specification documents
• Conduct code reviews
• Function as part of a highly collaborative team
• Flexibility for working in shifts to have required overlap with other geographic teams (US, UK, Australia, etc.)
• Able to implement technical solutions end to end
• Must be able to work without supervision/direction; able to resolve technical hurdles independently
• Able to discover technical requirements comparing different application versions; able to propose efficient & quality solutions/recommendations
• Should have worked with Agile Methodologies
• Excellent analytical and effective communication skills
• Able to introduce, lead & implement software engineering best practices
• Proactive in proposing new ideas and solutions
• Motivated to learn and apply new technologies
• Good command of English (communication with colleagues abroad)
• Creating self-contained, reusable, and testable modules and components

What you need to have:

At least 8 years on database development using ETL technologies and strong skills on - MSBI stack, SSIS, SSRS, SQL Server

Mandatory Skillset/Exposure:

- Proven experience as an SSIS Developer and SQL Developer

- Expert in SSIS is strongly preferred and must be experienced in designing and building complete ETL/SSIS process

- Design and implement data integration solutions using SSIS to extract, transform, and load (ETL) data from various sources into SQL Data Warehouse

- Expert in writing Stored Procedures, Functions, View, Triggers, Indexes using SQL

- Knowledge of Oracle as a developer is a plus

- Experience with data modeling and data warehousing concepts

- Knowledge of Performance Optimization, Monitoring and Automation would be a plus

- Troubleshoot and resolve issues related to data processing and reporting

- Good understanding of cyber security guidelines

- Hands On Work Experience on above mentioned technologies

- Experience in Git and continuous integration

- Good team player, able to learn and share knowledge

- Proactive in proposing new ideas and solutions

- Motivated to learn and apply new technologies

- Good command of English (communication with colleagues abroad)

- Should be well versed with DevOps

- Data Migration & Integration: Experience in data migration projects to move on-premise data (SQL Server) to AWS cloud-based solutions. Coordinate end-to-end processes for seamless data transfers and integrations across platforms

- Data Modeling & Warehousing: Solid understanding of data modeling techniques (e.g., star schema, snowflake schema) and experience with data warehousing solutions, particularly in the cloud (AWS)

What makes you stand out?

- Superannuation domain knowledge

- Cloud (AWS) experience

- Snyk and GitGuardian

- Agile methodology