Integon is a part of The Allstate Corporation, which means we have the same innovative drive that keeps us a step ahead of our customers’ evolving needs. It’s how we’ve become industry leaders in property and casualty insurance servicing. We support our insurance company affiliates by offering property and casualty insurance products inclusive of personal auto, homeowners, RV, motorcycle, small business auto insurance and more.

The position is hands-on technical lead responsible for designing, developing, and supporting enterprise data integration solutions. This role collaborates closely with database developers, business analysts, and stakeholders to analyze requirements, design scalable solutions, and implement high-quality ETL processes. The position plays a key role across the entire System Development Life Cycle (SDLC), delivering reliable data solutions ranging from small enhancements to large, complex enterprise initiatives.

Key Responsibilities
- Lead the end-to-end lifecycle of data integration solutions including requirements analysis, design, development, testing,



deployment, and production support.
- Collaborate with cross-functional teams to understand business domains, data requirements, and system dependencies.
- Design, develop, maintain, and optimize ETL workflows using Informatica PowerCenter and/or Informatica Intelligent Cloud Services (IICS).
- Develop and maintain supporting components such as Linux/ Unix shell scripts, stored procedures, functions, and advanced SQL queries.
- Ensure high performance and scalability of ETL processes through tuning, monitoring, and optimization.
- Review and validate test results with business stakeholders to ensure solutions meet functional and technical requirements.
- Follow and enforce organizational change management, version control, and release management processes.
- Analyze business requirements and map them effectively to existing or new data architecture and database structures.
- Troubleshoot and

📌 Lead Informatica Developer (Tijuana)
🏢 Integon
📍 Tijuana