ETL Developer - Remote Home Based Worker - Data Integration Specialist with Ab Initio, Informatica, and MongoDB Expertise
Posted 2025-10-26
Remote, USA
Full Time
Immediate Start
Join the Allstate Team as an ETL Developer and Be Part of a Dynamic and Innovative Company Allstate is a Fortune 100 company and a leader in the insurance industry, with a rich history of innovation and customer protection. We're now looking for a skilled ETL Developer to join our team remotely and contribute to the development of complex data integration solutions. As an ETL Developer, you will play a critical role in designing, developing, and maintaining data integration components for large-scale projects. You'll work closely with business partners to identify needs, design technology solutions, and ensure seamless execution of change management activities. About Allstate and Our Culture At Allstate, we're driven by a shared purpose: to protect people from life's uncertainties so they can realize their hopes and dreams. With a history spanning over 89 years, we've established ourselves as a leader in the insurance industry, known for our innovative approach to customer protection. Our company culture is built on values such as integrity, inclusive diversity, and accountability, and we empower every employee to lead, drive change, and give back to their communities. Our Mission and Values Protect people from life's uncertainties Empower employees to lead and drive change Foster a culture of integrity, diversity, and accountability Give back to the communities we serve Job Summary As an ETL Developer at Allstate, you will contribute to the development of code for complex modules, participate in design reviews, conduct code reviews, create test plans, and resolve moderate defects. Your role involves designing, documenting, reviewing, and maintaining components of software solutions for large-scale projects. You'll work closely with business partners to identify needs and design technology solutions to overcome process bottlenecks, reduce compliance risks, and increase operational efficiency. Key Responsibilities Analyze and evaluate detailed business, functional, and high-level technical requirements Assume responsibility for ensuring design/code reviews are scheduled and executed Provide feedback and recommend solutions Ensure design standards and documentation are followed Certify that code meets quality standards Contribute to the development of code for intermediate to complex modules Develop or confirm detailed project or system change estimates or project plans Design and implement enhanced technical documentation Apply strong understanding as a technical expert for less experienced application developers Contribute to the creation of accurate test plans, conditions, and data Participate in testing reviews and conduct basic levels of module and integration testing Track and resolve moderate defects Focus on ensuring execution of change management activities supporting production deployment Job Qualifications and Skills To be successful in this role, you should have: Essential Qualifications 3+ years of experience in broad-based ETL development (Ab Initio, Informatica, etc.) Solid scripting skills (Perl, PowerShell, etc.) Hands-on experience with MongoDB and UNIX Sound understanding of test-driven development (TDD) practice Good problem-solving capabilities Solid prioritization and project management skills Ability to develop in-depth ideas and materials Preferred Qualifications 4-year Bachelor's degree What We Offer At Allstate, we offer a competitive salary and a comprehensive benefits package, including: Competitive salary Tuition assistance Medical and dental insurance Robust pension and 401(k) Generous paid time off policy Why Join Allstate? By joining Allstate, you'll have the opportunity to: Work with a dynamic and innovative company Contribute to the development of complex data integration solutions Collaborate with business partners to identify needs and design technology solutions Grow professionally and personally in a supportive and inclusive environment How to Apply If you're a motivated and skilled ETL Developer looking for a new challenge, we encourage you to apply for this exciting opportunity. Please submit your application today, and don't hesitate to reach out if you have any questions. Allstate is an equal opportunities employer and welcomes applications from diverse candidates. Apply for this job