Skip to main contentA logo with &quat;the muse&quat; in dark blue text.

Lead Informatica Developer

AT Allstate
Allstate

Lead Informatica Developer

Pune, India

At Allstate, great things happen when our people work together to protect families and their belongings from life's uncertainties. And for more than 90 years our innovative drive has kept us a step ahead of our customers' evolving needs. From advocating for seat belts, air bags and graduated driving laws, to being an industry leader in pricing sophistication, telematics, and, more recently, device and identity protection.

Job Description
We are seeking a highly skilled and experienced Senior Informatica Developer to join our team. The ideal candidate will have a strong background in data integration, ETL processes, and data warehousing, with at least 8 years of hands-on experience in Informatica development.

Key Responsibilities:

Want more jobs like this?

Get jobs in Pune, India delivered to your inbox every week.

By signing up, you agree to our Terms of Service & Privacy Policy.


  • Design and Development: Develop, implement, and maintain ETL processes using Informatica PowerCenter and other Informatica tools.
  • Data Integration: Integrate data from various sources, ensuring data quality and consistency.
  • Performance Tuning: Optimize ETL processes for performance and scalability.
  • Collaboration: Work closely with business analysts, data architects, and other stakeholders to understand data requirements and deliver solutions.
  • Documentation: Create and maintain technical documentation for ETL processes and data flows.
  • Support and Maintenance: Provide ongoing support and maintenance for ETL processes, including troubleshooting and resolving issues.
  • Mentorship: Mentor junior developers and provide technical guidance to the team.

Qualifications:

  • Education: Bachelor's or Master's degree in Computer Science, Information Technology, or a related field.
  • Experience: Minimum of 8 years of experience in Informatica development.
  • Technical Skills:
    • Proficiency in Informatica PowerCenter, Informatica Cloud, and other Informatica/ETL tools.
    • Strong SQL and PL/SQL skills.
    • Experience with data warehousing concepts and BI tools.
    • Knowledge of Unix/Linux or Python scripting.
    • Familiarity with cloud platforms like AWS or Azure is a plus.
  • Soft Skills:
    • Excellent problem-solving and analytical skills.
    • Strong communication and interpersonal skills.
    • Ability to work independently and as part of a team.

Primary Skills
Customer Centricity, Digital Literacy, Inclusive Leadership, Learning Agility, Results-Oriented

Shift Time

Recruiter Info
Hiral Rughani [C]

hrugj@allstate.com

About Allstate

Joining our team isn't just a job - it's an opportunity. One that takes your skills and pushes them to the next level. One that encourages you to challenge the status quo. And one where you can impact the future for the greater good.

You'll do all this in a flexible environment that embraces connection and belonging. And with the recognition of several inclusivity and diversity awards, we've proven that Allstate empowers everyone to lead, drive change and give back where they work and live.

Good Hands. Greater Together.

The Allstate Corporation is one of the largest publicly held insurance providers in the United States. Ranked No. 84 in the 2023 Fortune 500 list of the largest United States corporations by total revenue, The Allstate Corporation owns and operates 18 companies in the United States, Canada, Northern Ireland, and India. Allstate India Private Limited, also known as Allstate India, is a subsidiary of The Allstate Corporation. The India talent center was set up in 2012 and operates under the corporation's Good Hands promise. As it innovates operations and technology, Allstate India has evolved beyond its technology functions to be the critical strategic business services arm of the corporation. With offices in Bengaluru and Pune, the company offers expertise to the parent organization's business areas including technology and innovation, accounting and imaging services, policy administration, transformation solution design and support services, transformation of property liability service design, global operations and integration, and training and transition.

Learn more about Allstate India here.

Client-provided location(s): Pune, Maharashtra, India
Job ID: allstate-145403186
Employment Type: Other

Perks and Benefits

  • Health and Wellness

    • Health Insurance
    • Dental Insurance
    • Vision Insurance
    • Life Insurance
    • Long-Term Disability
    • Short-Term Disability
    • HSA
    • FSA
    • Mental Health Benefits
    • On-Site Gym
    • Pet Insurance
    • Virtual Fitness Classes
    • Health Reimbursement Account
  • Parental Benefits

    • Non-Birth Parent or Paternity Leave
    • Birth Parent or Maternity Leave
    • Adoption Leave
    • Family Support Resources
    • Adoption Assistance Program
  • Work Flexibility

    • Remote Work Opportunities
    • Hybrid Work Opportunities
    • Work-From-Home Stipend
    • Four-Day Work Week
  • Office Life and Perks

    • Commuter Benefits Program
    • Casual Dress
    • On-Site Cafeteria
  • Vacation and Time Off

    • Paid Vacation
    • Paid Holidays
    • Leave of Absence
  • Financial and Retirement

    • 401(K)
    • 401(K) With Company Matching
    • Pension
    • Financial Counseling
    • Relocation Assistance
  • Professional Development

    • Tuition Reimbursement
    • Access to Online Courses
    • Internship Program
    • Promote From Within
    • Mentor Program
    • Lunch and Learns
    • Leadership Training Program
    • Associate or Rotational Training Program
  • Diversity and Inclusion

    • Employee Resource Groups (ERG)
    • Diversity, Equity, and Inclusion Program

Company Videos

Hear directly from employees about what it is like to work at Allstate.