We are seeking a driven and highly skilled Senior Data Integration Engineer to join our team, where you will play a pivotal role in designing, developing, and optimizing data integration solutions. This position involves managing ETL development efforts, collaborating with cross-functional teams, and ensuring the smooth operation of our enterprise data warehouse.

We accept CVs in English only.

Responsibilities

• Develop and enhance complex ETL processes using Informatica PowerCenter
• Work independently to design, configure, and unit test solutions based on source-to-target specifications
• Collaborate closely with data architects, application teams, and reporting stakeholders on ETL development and integration efforts
• Design, document, and implement ETL solutions, estimate work efforts, and provide task status updates
• Coordinate offshore and onshore ETL development efforts, allocate tasks, and ensure quality deliverables
• Provide technical support for Informatica administration and troubleshoot production issues as a level-three support resource
• Prepare and maintain technical runbooks documenting code, processes, and support requirements
• Identify and implement improvements to enterprise data warehouse environments in collaboration with the offshore team
• Establish and maintain best practices and methodologies for ETL development
• Provide mentorship and guidance to junior ETL developers as needed

Requirements

• 3+ years of experience in developing, maintaining, and enhancing Informatica Mappings, Workflows, and processes
• Background in working with complex SQL and strong ETL development expertise
• Knowledge of integration technologies and processes
• Understanding of Kimball, Inmon, or Millbrook data warehouse design methodologies
• Familiarity with EDW reconciliation solutions and testing tools and techniques
• Proficiency in working within Windows environments
• Strong analytical, organizational, and multitasking skills, with the ability to meet tight deadlines
• Proven communication and facilitation skills to engage with technical and non-technical stakeholders
• English skills at a B2 level or higher

Nice to have

• Competency in identifying and implementing data warehouse improvements
• Flexibility to adapt to evolving business and technological requirements
• Showcase of effective teamwork in managing globally distributed development teams

We offer

• Learning Culture - We want you to be the best version of yourself, that is why we offer unlimited access to learning platforms, a wide range of internal courses, and all the knowledge you need to grow professionally
• Health Coverage - Health and wellness are important, that is why we have you and up to four family members in a premiere health plan. We have a couple of options, so you can choose what is best for you and your family
• Visual Benefit - Seeing your work for us would be a sight for sore eyes. We want your vision to always be at 100% which is why we offer up to $200.000 COP for any visual health expenses
• Life Insurance Plan - We have partnered with MetLife to offer a full-coverage Ife insurance plan. So, your family is covered, even if you are gone
• Medical Leave Coverage - We are one of the few companies that cover 100% of your medical leave, for up to 90 days. Your health is the most important thing to us
• Professional Growth Opportunities - We have designed a highly competitive and complete development process, where you will have all the tools to get where you have always wanted to be, personally and professionally
• Stock Option Purchase Plan - As an EPAMer you can be more than just an employee, you will also have the opportunity to purchase stock at a reduced price and become a part owner of our organization
• Additional Income - Besides your regular salary, you will also have the chance to earn extra income by referring talent, being a technical interviewer, and many more ways
• Community Benefit - You will be part of a worldwide community of over 50,000 employees, where you can learn, challenge yourself, stand out, and share your knowledge and experience with multicultural teams!

Please note that even though you are applying for this position, you may be offered other projects to join within EPAM.

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.