Senior Associate Data Engineer

Job Description Template Job title Senior Data Engineer (or equivalent) Position Description At MassMutual, were 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 MassMutuals 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 Bachelors degree in computer science, engineering, or a related field Masters 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+ yearsexperience 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 Show more Show less