We are actively seeking a Lead Data Integration Engineer to become a part of our team in Lisbon, tasked with leading the development of ETL solutions across a diverse range of industries.
This position is essential for handling complex data types and improving our capabilities in business intelligence. The ideal candidate will have deep knowledge of data integration tools and be able to efficiently manage projects, while working seamlessly with both local and remote teams.
#LI-DNI
Responsibilities
- Act as the key liaison between clients and remote teams
- Create, design, and implement effective Informatica ETL mappings
- Develop stored procedures and perform efficient database queries
- Convert business requirements and analyst inputs into technical specifications
- Discover, test, and fix bugs and performance issues in ETL solutions
- Maintain high performance and quality of Informatica mappings and PLSQL packages
- Consistently deliver project updates including milestones and deliverables
- Collaborate with remote teams to ensure project alignment with client expectations
- Offer support and address issues within the Informatica mappings
Want more jobs like this?
Get jobs in Lisbon, Portugal delivered to your inbox every week.
- At least 3 years of experience in a comparable role
- Proficiency in Oracle 12c, Informatica PowerCenter 10.x, and PLSQL
- Background in crafting advanced SQL queries and some query optimization
- Experience in data architecture and implementing comprehensive ETL processes with Informatica for ODS, staging, and data warehousing contexts
- Familiarity with developing advanced UNIX Shell Scripts
- Skills in deploying and troubleshooting Informatica Mappings environments
- Strong communication skills and the ability to interact effectively with business users and technical peers
- Demonstration of exceptional analytical and problem-solving skills
- Familiarity with C#/.NET
- Proficiency in Dell Boomi with 1-2 years of experience
- Background in data modeling
- Competitive compensation depending on experience and skills
- Variety of projects within one company
- Being a part of a project following engineering excellence standards
- Individual career path and professional growth opportunities
- Internal events and communities
- Flexible work hours