Lead ETL Informatica Engineer Mexico or Remote

Responsibilities

• Utilize open source frameworks, third-party libraries, and commercial tools to manage database schema variations across systems
• Develop effective data models and generate reports via BI platforms
• Establish automated, consistent workflows for managing database modifications
• Work collaboratively with development teams to enhance application efficiency
• Work with support teams to pinpoint data inconsistencies and carry out data adjustments
• Improve current health insurance applications benefiting both consumers and operational personnel
• Analyze query plans and refine query efficiency
• Facilitate change through automation and refine existing methodologies
• Define exact performance goals and keep records of performance metrics

Requirements

• Bachelor’s degree in Computer Science or a related discipline
• More than 5 years of experience with ETL tools, with a preference for Informatica, Kafka, and AWS Glue
• At least 1 year of relevant leadership background
• Robust expertise in database architecture and analysis including relational and NoSQL databases such as Oracle, DynamoDB
• Understanding of data warehousing and data modeling practices including Star and Dimensional Modeling
• Familiarity with BI and reporting tools like Tableau
• Proficiency in PL/SQL and Oracle XML development
• Advanced understanding of Oracle Database and database optimization
• Background in Cloud and Big Data technologies
• Capability to manage data consistency and concurrency considerations

Nice to have

• Background in using Liquibase for managing database schema changes
• Innovative approach to resolving complex technical challenges
• Strong dedication to customer service in addressing user issues

We offer

• 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