Senior Principal Engineer - Applications Development

Job 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 Carpenterand Oliver Wyman, Marsh McLennan helps clients navigate an increasingly dynamic and complex environment. For more information, visit mercer.com. Follow Mercer on LinkedInand X. Marsh McLennan is committed to embracing a diverse, inclusive and flexible work environment. We aim to attract and retain the best people and embrace diversity of age, background, caste, disability, ethnic origin, family duties, gender orientation or expression, gender reassignment, marital status, nationality, parental status, personal or social status, political affiliation, race, religion and beliefs, sex/gender, sexual orientation or expression, skin color, or any other characteristic protected by applicable law. Marsh McLennan is committed to hybrid work, which includes the flexibility of working remotely and the collaboration, connections and professional development benefits of working together in the office. All Marsh McLennan colleagues are expected to be in their local office or working onsite with clients at least three days per week. Office-based teams will identify at least one “anchor day” per week on which their full team will be together in person. Show more Show less