Company: MMC Corporate
Description:
We are seeking a talented individual to join our Tech team at Mercer. This role will be based in Noida/ Gurgaon. This is a hybrid role that has a requirement of working at least three days a week in the office
Senior Principal Engineer - Applications Development
We are looking for strong Database Developer. Candidate s primary focus will be to develop & deliver high quality ETL and DB solutions with large Dataset.
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:
- Overall IT experience in range of 7 - 10 years
- BTech/ MCA
- Working experience in database development using ETL technologies and strong skills on - MSBI stack, SSIS, SSRS, SQL Server
- 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
Why join our team:
- We help you be your best through professional development opportunities, interesting work and supportive leaders.
- We foster a vibrant and inclusive culture where you can work with talented colleagues to create new solutions and have impact for colleagues, clients and communities.
- Our scale enables us to provide a range of career opportunities, as well as benefits and rewards to enhance your well-being.
Mercer believes in building brighter futures by redefining the world of work, reshaping retirement and investment outcomes, and unlocking real health and well-being. Mercer s more than 20,000 employees are based in 43 countries and the firm operates in over 130 countries. Mercer is a business of Marsh McLennan (NYSE: MMC), the world s leading professional services firm in the areas of risk, strategy and people, with more than 85,000 colleagues and annual revenue of over $23 billion. Through its market-leading businesses including Marsh , Guy Carpenter and Oliver Wyman , Marsh McLennan helps clients navigate an increasingly dynamic and complex environment. For more information, visit mercer.com . Follow Mercer on LinkedIn and X .