Skip To Main Content
backBack to Search

Lead ETL Developer

Hybrid in Brazil,
& 4 others

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