ETL Developer - Remote Home Based Worker - Data Integration Specialist with Ab Initio, Informatica, and MongoDB Expertise

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.