Lead ETL Developer

Hybrid in Brazil,

Location-specific conditions & benefits*

Brazil

Join our team as a Lead ETL Developer and take a pivotal role in building and maintaining ETL code using Informatica PowerCenter within our enterprise data warehouse.

Partner with data architects and application teams to deliver high-quality solutions. If you have a passion for data integration and a drive for impactful contributions, this opportunity is for you.

Responsibilities

Develop ETL processes and improve existing code using Informatica PowerCenter
Build, configure, and unit test programs based on technical specifications
Collaborate with data architects and application teams to support ETL initiatives
Design ETL solutions for various projects while providing effort estimates
Coordinate ETL development tasks across onshore and offshore teams
Support administrative and production environments for Informatica
Provide advanced troubleshooting and operational support
Define best practices for the ETL development team and ensure adherence
Document runbooks to support developed code and ongoing operations
Propose enhancements to the data warehouse and oversee offshore implementation efforts
Communicate and escalate critical issues to appropriate stakeholders

Requirements

At least 5 years in a data warehouse development role
More than 7 years of experience working with Informatica Mappings, Workflows, and process development
Competency in creating and using complex SQL for ETL solutions
Expertise in leveraging Informatica tools across various use cases
Understanding of integration technologies and related processes
Proficiency in English at a B2+ level or higher

Nice to have

Knowledge of Kimball, Inmon, and Millbrook methodologies
Familiarity with testing methodologies and tools
Background in working within Windows-based environments
Awareness of EDW reconciliation and related solutions
Credentials validating expertise in Informatica or similar technologies

Benefits

International projects with top brands
Work with global teams of highly skilled, diverse peers
Healthcare benefits
Employee financial programs
Paid time off and sick leave
Upskilling, reskilling and certification courses
Unlimited access to the LinkedIn Learning library and 22,000+ courses
Global career opportunities
Volunteer and community involvement opportunities
EPAM Employee Groups
Award-winning culture recognized by Glassdoor, Newsweek and LinkedIn