Join MassMutual as a Mastery-Level ETL Developer, where you will lead the design and optimization of scalable ETL pipelines critical to our data platform. You will work closely with both business and technical stakeholders to deliver high-quality solutions in a dynamic environment.
Key Responsibilities
Design and develop complex ELT/ETL pipelines using Informatica IICS/IDMC, Python, and SQL
Translate high-level business requirements into detailed technical solutions
Ingest and integrate data from disparate sources into centralized data lakes and data warehouses
Ensure data quality through robust cleansing, validation, and profiling techniques
Implement best practices for performance tuning, error handling, and job logging
Guide and mentor junior team members
Document technical specifications, data lineage, and transformation logic
Required Qualifications
Bachelor’s degree in computer engineering, computer science or related technical field
8+ years of software engineering/development
5+ years of ETL/ELT development experience with Informatica (PowerCenter writing Unix shell scripts, IDMC)
2+ years of experience using IDMC or similar data management platforms
5+ years of advanced SQL experience on multiple DBMS technologies, such as MS SQL Server, Teradata, and Vertica
5+ years of experience developing ETL/ELT logic using Python
3+ years of experience working with AWS Cloud
5+ years of experience with workflow orchestration tools
Preferred Qualifications
Additional development experience in Java 17+, Spring Boot, Kafka, React.js, Docker, Kubernetes, GitHub, and Jenkins
Experience with wealth management or financial services projects
Strong knowledge of architecture principles, development standards, and best practices
Advanced knowledge and experience with Data Governance and MDM technologies
Experience with data lake technologies such as Data Bricks