Skip To Main Content
epam-logo-black.svgepam-logo-black.svg
backBack to Search

Lead ETL Informatica Engineer

Mexico
Data Integration, Business Intelligence & Data Exploration Solutions, Data Integration (ETL/ELT) Platforms, Informatica, Amazon Web Services, Apache Kafka

We seek an experienced Lead ETL Informatica Engineer to become an integral part of our agile team.

The successful applicant will enhance current and future database applications to ensure superior performance and maintain high standards of data quality. As a guide, the Senior ETL Informatica Engineer will spearhead technical initiatives and guide less experienced team members towards achieving excellence in their work.

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
Benefits
  • International projects with top brands
  • Work with global teams of highly skilled, diverse peers
  • Healthcare benefits
  • Employee financial programs
  • Paid time off and sick leave
  • Upskilling, reskilling and certification courses
  • Unlimited access to the LinkedIn Learning library and 22,000+ courses
  • Global career opportunities
  • Volunteer and community involvement opportunities
  • EPAM Employee Groups
  • Award-winning culture recognized by Glassdoor, Newsweek and LinkedIn