We are seeking a driven and highly skilled Lead Data Integration Engineer to join our team, where you will take on critical leadership responsibilities in designing, developing, and optimizing data integration solutions. This position involves overseeing ETL development efforts, directing cross-functional collaborations, mentoring team members, and ensuring the efficient operation of our enterprise data warehouse.

We accept CVs in English only.

Responsibilities

• Lead and supervise the development and enhancement of complex ETL processes using Informatica PowerCenter
• Take ownership of the solution design process, configuring and unit testing solutions based on source-to-target specifications
• Drive collaboration with data architects, application teams, and reporting stakeholders to align ETL development efforts with organizational goals
• Oversee the design, documentation, and implementation of robust ETL solutions, estimate work efforts, and monitor task status updates across the team
• Manage and coordinate offshore and onshore ETL development efforts, including task allocation and quality assurance
• Provide oversight for technical support related to Informatica administration and serve as an escalation point to troubleshoot production issues effectively
• Ensure the preparation and maintenance of technical runbooks documenting code, processes, and support requirements
• Identify and champion the implementation of improvements to enterprise data warehouse environments in collaboration with offshore teams and stakeholders
• Define and enforce best practices and methodologies for ETL development across teams
• Provide mentorship, technical leadership, and career development guidance to junior and mid-level ETL developers
• Act as a key point of contact for stakeholders, managing expectations effectively while ensuring technical deliverables align with business requirements

Requirements

• 5+ years of experience in developing, maintaining, and enhancing Informatica Mappings, Workflows, and processes
• 1+ years of experience in a lead development role for a data warehouse
• Advanced background in working with complex SQL and demonstrated expertise in ETL development
• In-depth knowledge of integration technologies, enterprise data principles, and processes
• Strong understanding of Kimball, Inmon, or Millbrook data warehouse design methodologies and their applications
• Experience in implementing EDW reconciliation solutions and using advanced testing tools and techniques
• Proficiency in working within Windows environments and familiarity with other operational environments where applicable
• Excellent analytical, organizational, and multitasking skills, with proven ability to prioritize and meet tight deadlines in a high-paced environment
• Exceptional communication and facilitation skills to engage effectively with technical and non-technical stakeholders
• English proficiency at a B2+ level

Nice to have

• Track record of leading initiatives for identifying and implementing data warehouse improvements
• Ability to quickly adapt to evolving business needs and technological advancements
• Demonstrated experience in fostering teamwork and managing globally distributed development teams
• Strong commitment to developing others and promoting a collaborative, inclusive team culture

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.