SSIS Developer

Company Description

ONE datAI, a division of One Technologies, specializes in providing comprehensive Data and Artificial Intelligence (AI) solutions. Since its establishment in 2006, ONE datAI has been a leader in Israel's data landscape, transforming complex data challenges into strategic opportunities for over 200 customers. The company's expertise encompasses data engineering, analytics, automation, AI/ML solutions, and strategic consulting. Trusted by leading organizations in various sectors, including finance, healthcare, retail, and defense, ONE datAI is committed to delivering innovative and impactful data-driven strategies. With a team of over 200 skilled professionals, we drive success through data and technology excellence.

We are looking for a skilled ETL Developer with at least 5 years of experience in SSIS or Data Services (DS) development. The ideal candidate will have strong expertise in SQL, with a focus on PL/SQL, and experience working with databases (preferably Oracle).

Key Requirements:

• At least 5 years of experience in SSIS or Data Services (DS) development – required
• Proficiency in writing SQL queries (preferably PL/SQL) – required
• Experience working with databases (advantage for Oracle) – required
• Strong experience in writing Source to Target mapping documents – required
• In-depth knowledge of SQL, including Stored Procedures, Indexing, and Performance Tuning – required
• Experience working in development environments – required
• Experience with SAP core systems and SAP Data Services – advantage
• Understanding of DWH and Data Lake architecture
• Familiarity with exciting technologies such as AWS and Databricks (coming soon)

Job Description:

• ETL process maintenance, development, and testing
• Mapping data from source systems to DWH models
• Working under pressure and managing multiple tasks simultaneously

If you're looking for a challenging and dynamic role where you can grow and work with cutting-edge technologies, apply now!