ETL Developer with Informatica Experience

Informatica and ETL Developer with experience in developing and leading complex processes in large organizations. Capable of handling end-to-end tasks, from requirements gathering, design, development, testing, a$nd deployment to production. 

• Development and maintenance of ETL processes in Informatica Cloud (IICS). 
• Development and maintenance of complex ETL processes, including interfaces to multiple components: 

1. Databases: MongoDB, MySQL, DB2 AS400 
2. Files: XML, flat text (MF), CSV ◦ Messaging systems: MQ, Kafka 
3. CDC 

• ETL development from requirements intake through architecture, development, testing, and production deployment. 
• Fast response to ad-hoc business requirements and production issue support. 
• Performance optimization of existing processes.

Job Requirements 

• Minimum 2 years of experience with Informatica PowerCenter or IICS – mandatory 

• Strong SQL knowledge, query writing, and data management with at least 3 years of experience – mandatory 

• Ability to lead complex development processes 

• Experience working in AWS cloud environment – advantage 

• Relevant academic degree – advantage 

• Familiarity with open systems (Microservices) – advantage 

• Familiarity with Salesforce capabilities and components – advantage 

Required Skills 

• Very high professional expertise 

• Strong troubleshooting and problem-solving abilities 

• Ability to lead complex development processes 

• Strong understanding of complex workflows and broad system-level perspective 

• Ability to independently learn and understand existing processes 

• Team player: strong interpersonal communication, knowledge sharing, raising blockers, and status reporting 

• Ability to work independently Interfaces / Stakeholders 

• ETL team, mortgage development teams, integration teams, Salesforce team, project managers, QA, system analysts

• 4 days from the offices in Lod, 1 day from home