Skip to main contentA logo with &quat;the muse&quat; in dark blue text.

Senior ETL Informatica Engineer

AT EPAM Systems
EPAM Systems

Senior ETL Informatica Engineer

Mexico City, Mexico

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
Requirements

Want more jobs like this?

Get jobs in Mexico City, Mexico delivered to your inbox every week.

By signing up, you agree to our Terms of Service & Privacy Policy.
  • 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
Nice to have
  • Prior experience in the health insurance sector
  • Proficiency in additional BI tools or data modeling techniques
  • Certification in Informatica or related technologies
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.

Client-provided location(s): Mexico City, CDMX, Mexico
Job ID: EPAM-epamgdo_blt1fc6c5e71e1432ea_en-us_MexicoCity_Mexico
Employment Type: Other