JOB DESCRIPTION TEMPLATE
Job title
Senior Data Engineer (or equivalent)
Position description
At MassMutual, we're passionate about helping millions of people find financial freedom and this passion has driven our approach to developing highly interactive digital experiences for our customers. To help us achieve our mission, we are looking to hire senior data engineer for our Data Platform Data Engineering team.
What great looks like in this role
Our ideal Senior Data Engineer is someone who is passionate about data.
You enjoy building data projects from the ground up and are equally comfortable working with business partners to understand requirements as you are developing and delivering robust solutions that meet the highest standards.
Learning new technologies and working in the cloud excite you.
You are team oriented and a strong communicator.
Provide a description of what the position does within your group/department
Department name
Data Platform
Supervisor
Location
Hyderabad
Key responsibilities and accountabilities
- Design, build and maintain complex ELT/ETL jobs that deliver business value.
- transform and load data from various sources including databases, APIs, and flat files using IICS or Python/SQL.
- Translate high-level business requirements into technical specs
- Conduct unit testing, integration testing, and system testing of data integration solutions to ensure accuracy and quality
- Ingest data from disparate sources into the data lake and data warehouse
- Cleanse and enrich data and apply adequate data quality controls
- Provide technical expertise and guidance to team members on Informatica IICS/IDMC and data engineering best practices to guide the future development of MassMutual's Data Platform.
- Develop re-usable tools to help streamline the delivery of new projects
Knowledge, skills and abilities
Please refer 'Education and Experience'
Education and experience• Bachelor's degree in computer science, engineering, or a related field. Master's degree preferred.• Data: 5+ years of experience with data analytics and data warehousing. Sound knowledge of data warehousing concepts.• SQL: 5+ years of hands-on experience on SQL and query optimization for data pipelines.• ELT/ETL: 5+ years of experience in Informatica/ 3+ years of experience in IICS/IDMC• Migration Experience: Experience Informatica on prem to IICS/IDMC migration• Cloud: 5+ years' experience working in AWS cloud environment• Python: 5+ years of hands-on experience of development with Python• Workflow: 4+ years of experience in orchestration and scheduling tools (e.g. Apache Airflow)• Advanced Data Processing: Experience using data processing technologies such as Apache Spark or Kafka• Troubleshooting: Experience with troubleshooting and root cause analysis to determine and remediate potential issues• Communication: Excellent communication, problem-solving and organizational and analytical skills• Able to work independently and to provide leadership to small teams of developers.• Reporting: Experience with data reporting (e.g. MicroStrategy, Tableau, Looker) and data cataloging tools (e.g. Alation)• Experience in Design and Implementation of ETL solutions with effective design and optimized performance, ETL Development with industry standard recommendations for jobs recovery, fail over, logging, alerting mechanisms.
Specify the minimum acceptable level of education, experience, certifications necessary for the role
Application Requirements
No special requirements
Support Hours
India GCC - US (EST) hours overlap for 2-3 hours
Top Skills
What the Team is Saying
What We Do
With our world class Global Capability Centre (GCC) in the heart of Hyderabad, we at MassMutual are extending a nearly 170-year legacy of securing futures and protecting loved ones to Telangana, India in 2020. The Hyderabad GCC has been established to explore the global talent pool with an in-house team of experts in full-stack Development & Support, DevOps, Quality Assurance, Security & Cloud Engineering, Data Science and several other areas such as insurance, business, security, and operations.
Living Mutual has always been at the core of MassMutual’s purpose. Since 1851, MassMutual’s mutual way of life has been reflected in its various initiatives, be it Social Responsibility, Corporate Governance, or Diversity & Inclusion.
With the opening of our Hyderabad facility, you’ll not only get to work in our innovative, state-of-the-art Global Capability Centre, you’ll also be supported by colleagues in our global MassMutual community.
Spread across 73000+ square feet facility on the 7th floor of BSR IT SEZ, the Global Capability Center in Hyderabad can house more than 600 employees. Located at the heart of Financial District, the facility boasts of work class infrastructure and amenities, enabled by state-of-the-art technology and security systems. In-house gymnasium / aerobics center, yoga room, indoor games room, mothers’ / wellness room, 200+ seater cafeteria, high-rise & lounge seating are some of the amenities available for the employees. The SEZ facility will also provide common creche and eat-out restaurants in the building premises, once operational.
Join us now to collaborate with teams across the world on projects and initiatives that will contribute to the growth of MassMutual as a global financial services leader.
Why Work With Us
MassMutual is leading the financial services industry in digital enablement, and the new MassMutual
India Global Capability Center is a result of this effort. We are here to empower careers and help
people secure their futures through innovation and technology.
Gallery
MassMutual India Offices
OnSite Workspace
