Who We Are MassMutual India
A career with us means you will work alongside exceptional people and be empowered to reach your professional and personal goals. Our employees are the foundation of what makes MassMutual a strong, stable, and ethical business. We seek and value unique and varied perspectives and experiences because we believe we are stronger when all voices are heard. We invite you to bring your bright, innovative ideas to MassMutual as we continue to help millions of Americans rely on each other.
Together, we re stronger.
Job Description
Key responsibilities and accountabilities:
Design, build and maintain complex ELT/ETL jobs that deliver business value.
Extract, 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 Collaborate closely with other developers and provide mentorship Evaluate and recommend tools, technologies, processes and reference Architectures Work in an Agile development environment, attending daily stand-up meetings and delivering incremental improvements Participate in code reviews and ensure all solutions are lined to architectural and requirement specifications and provide feedback on code quality, design, and performance
Skillsets:
Data: 3+ years of experience with data analytics and data warehousing. Sound knowledge of data warehousing concepts.
SQL: 3+ years of hands-on experience on SQL and query optimization for data pipelines.
ELT/ETL: 3+ years of experience in Informatica/ 1+ years of experience in IICS/IDMC
Migration Experience: Experience Informatica on prem to IICS/IDMC migration
Cloud: 3+ years experience working in AWS cloud environment
Python: 3+ years of hands-on experience of development with Python
Workflow: 2+ 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.
Why Join Us
We ve been around since 1851. During our history, we ve learned a few things about making sure our customers our top priority. In order to meet and exceed their expectations, we must have the best people providing the best thinking, products, and services. To accomplish this, we celebrate an inclusive, vibrant, and diverse culture that encourages growth, openness, and opportunities for everyone. A career with MassMutual, Great Place to Work certified and Indias Best Workplaces in BFSI 2023 - Top 50 organization means you will be part of a strong, stable, and ethical business with industry leading pay and benefits. And your voice will always be heard.
Does this sound like a great fitApply today!