Lead ETL Developer
Data Integration
& 5 others
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