We are seeking a driven and highly skilled Lead Data Integration Engineer to join our team, where you will take on critical leadership responsibilities in designing, developing, and optimizing data integration solutions. This position involves overseeing ETL development efforts, directing cross-functional collaborations, mentoring team members, and ensuring the efficient operation of our enterprise data warehouse.

Responsibilities

• Lead and supervise the development and enhancement of complex ETL processes using Informatica PowerCenter
• Take ownership of the solution design process, configuring and unit testing solutions based on source-to-target specifications
• Drive collaboration with data architects, application teams, and reporting stakeholders to align ETL development efforts with organizational goals
• Oversee the design, documentation, and implementation of robust ETL solutions, estimate work efforts, and monitor task status updates across the team
• Manage and coordinate offshore and onshore ETL development efforts, including task allocation and quality assurance
• Provide oversight for technical support related to Informatica administration and serve as an escalation point to troubleshoot production issues effectively
• Ensure the preparation and maintenance of technical runbooks documenting code, processes, and support requirements
• Identify and champion the implementation of improvements to enterprise data warehouse environments in collaboration with offshore teams and stakeholders
• Define and enforce best practices and methodologies for ETL development across teams
• Provide mentorship, technical leadership, and career development guidance to junior and mid-level ETL developers
• Act as a key point of contact for stakeholders, managing expectations effectively while ensuring technical deliverables align with business requirements

Requirements

• 5+ years of experience in developing, maintaining, and enhancing Informatica Mappings, Workflows, and processes
• 1+ years of experience in a lead development role for a data warehouse
• Advanced background in working with complex SQL and demonstrated expertise in ETL development
• In-depth knowledge of integration technologies, enterprise data principles, and processes
• Strong understanding of Kimball, Inmon, or Millbrook data warehouse design methodologies and their applications
• Experience in implementing EDW reconciliation solutions and using advanced testing tools and techniques
• Proficiency in working within Windows environments and familiarity with other operational environments where applicable
• Excellent analytical, organizational, and multitasking skills, with proven ability to prioritize and meet tight deadlines in a high-paced environment
• Exceptional communication and facilitation skills to engage effectively with technical and non-technical stakeholders
• English proficiency at a B2+ level

Nice to have

• Track record of leading initiatives for identifying and implementing data warehouse improvements
• Ability to quickly adapt to evolving business needs and technological advancements
• Demonstrated experience in fostering teamwork and managing globally distributed development teams
• Strong commitment to developing others and promoting a collaborative, inclusive team culture

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

EPAM is a leading global provider of digital platform engineering and development services. We are committed to having a positive impact on our customers, our employees, and our communities. We embrace a dynamic and inclusive culture. Here you will collaborate with multi-national teams, contribute to a myriad of innovative projects that deliver the most creative and cutting-edge solutions, and have an opportunity to continuously learn and grow. No matter where you are located, you will join a dedicated, creative, and diverse community that will help you discover your fullest potential.

By applying to our role, you are agreeing that your personal data may be used as in set out in EPAM´s Privacy Notice and Policy.