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.
#LI-DNI
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
Want more jobs like this?
Get Science and Engineering jobs in Río Grande, Mexico delivered to your inbox every week.
- 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
- 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
- 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
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.