We are seeking a seasoned Senior ETL Informatica Engineer to join our dynamic team of exceptional talents.

In this role, you'll be tasked with designing, constructing, testing, and supporting Individual & Family Retail Health Insurance applications and their interconnected components. If you have a proven knack for addressing complex data integration challenges within distributed applications and a fervent passion for emerging technologies, this could be your opportunity to impact our enterprise systems and vendor integrations prominently.

#LI-DNI

Responsibilities

• Leverage existing open-source frameworks, third-party components/libraries, and commercial software for tracking and managing database schema changes across multiple environments
• Create data models and efficient reports using BI tools
• Implement automation and repeatable processes to manage all database (DML/DDL) changes
• Collaborate closely with development teams to optimize application performance
• Work alongside production support and triage teams to identify and resolve data issues and perform necessary data cleanups
• Support and enhance existing insurance applications utilized by both consumers and operations staff
• Ensure application stability and performance in collaboration with infrastructure teams
• Synthesize needs from user feedback and technical constraints into robust solutions
• Guide and mentor junior engineers, encouraging best practices in ETL and data integration

• Bachelor's degree in Computer Science or related discipline
• 3+ years of experience in big data technologies, cloud computing solutions like AWS Glue, and Kafka for real-time data processing
• Competency in ETL Informatica
• Proficiency in database design, analysis, and optimization techniques including relational, XML schemas, transactional, warehouse, and NoSQL databases like DynamoDB
• Understanding of data integration principles using tools such as Informatica and ETL methodologies
• Familiarity with BI and reporting tools like Tableau or similar
• Expertise in SQL and PL/SQL database programming, Oracle XML development, Oracle 11g or newer versions
• Knowledge of Oracle Database internals, data concurrency, consistency, and query optimizations
• Experience with change management automation and process improvements, preferably using tools like Liquibase
• Display strong leadership skills, technical aptitude, and creativity in problem-solving
• Fluent English communication skills at a B2+ level

• Prior experience in the health insurance sector
• Proficiency in additional BI tools or data modeling techniques
• Certification in Informatica or related technologies

• Career plan and real growth opportunities
• Unlimited access to LinkedIn learning solutions
• International Mobility Plan within 25 countries
• Constant training, mentoring, online corporate courses, eLearning and more
• English classes with a certified teacher
• Support for employee's initiatives (Algorithms club, toastmasters, agile club and more)
• Enjoyable working environment (Gaming room, napping area, amenities, events, sport teams and more)
• Flexible work schedule and dress code
• Collaborate in a multicultural environment and share best practices from around the globe
• Hired directly by EPAM & 100% under payroll
• Law benefits (IMSS, INFONAVIT, 25% vacation bonus)
• Major medical expenses insurance: Life, Major medical expenses with dental & visual coverage (for the employee and direct family members)
• 13 % employee savings fund, capped to the law limit
• Grocery coupons
• 30 days December bonus
• Employee Stock Purchase Plan
• 12 vacations days plus 4 floating days
• Official Mexican holidays, plus 5 extra holidays (Maundry Thursday and Friday, November 2nd, December 24th & 31st)
• Relocation bonus: transportation, 2 weeks of accommodation for you and your family and more