Senior ETL Informatica Engineer Mexico or Remote
Senior ETL Informatica Engineer Description
We are looking for a seasoned Senior ETL Informatica Engineer to join our agile team.
The ideal candidate will assist in enhancing both existing and new database applications, ensuring optimal performance, and maintaining high data quality. As a leader, the Senior ETL Informatica Engineer will drive technical solutions and mentor junior team members in achieving exceptional standards of workmanship.
#LI-DNI
Responsibilities
- Leverage open source frameworks, third-party libraries, and commercial software to manage database schema changes across environments
- Design efficient data models and create reports using BI tools
- Implement automated, repeatable processes for managing database changes
- Collaborate with development teams to optimize application performance
- Coordinate with support teams to identify data discrepancies and execute data corrections
- Enhance existing health insurance applications serving both consumers and operational staff
- Review query plans and optimize query performance
- Manage change through automation and improve existing processes
- Set clear performance targets and maintain performance metrics records
Requirements
- Bachelor’s degree in Computer Science or a related field
- 3+ years of experience with ETL tools, preferably Informatica, Kafka, and AWS Glue
- Solid background in database design and analysis including relational and NoSQL databases like Oracle, DynamoDB
- Understanding of data warehouse and data modeling techniques including Star and Dimensional Modeling
- Familiarity with BI and reporting tools such as Tableau
- Skills in PL/SQL and Oracle XML development
- Advanced knowledge of Oracle Database and database tuning
- Experience with Cloud and Big Data technologies
- Competency in managing data consistency and concurrency principles
Nice to have
- Experience with Liquibase for database schema change management
- Creativity in solving complex technical issues
- Strong customer-service mindset when dealing with user-related 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
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.
