Description

You will design and manage ETL processes to move data from diverse sources including Oracle and flat files.

Responsibilities

• Design SSIIS ETL packages to integrate data from various sources.
• Extract and transform data within a Business Intelligence environment.
• Develop and maintain SQL programming objects including stored procedures, user-defined functions, and common table expressions.
• Manage SQL Agent jobs and SSIS packages to ensure data integrity.
• Solve technical problems and adapt to changing project priorities.

Required Skills

• 4+ years of experience with Microsoft SQL Server.
• 4+ years of experience with ETL Development and/or Python.
• 4+ years of experience with SQL programming objects.
• 2+ years of experience designing SSIIS ETL packages.
• 2+ years of experience extracting and transforming data in BI environments.
• Proficiency in SQL and Python.
• Bachelor degree in computer science, information systems science, or equivalent experience.

Preferred Skills

• Working knowledge of Azure Data Factory.
• Experience with general business, quality/regulatory requirements, or manufacturing systems.

Key Skills

Education

Bachelor degree in computer science