Description
You will focus on designing ETL processes and managing data movement within a Business Intelligence environment.
Responsibilities
- Design SSIIS ETL packages to move data from Oracle and flat files.
- Extract and transform data within Business Intelligence environments.
- Develop and manage SQL programming objects including stored procedures, user-defined functions, and common table expressions.
- Maintain SQL Agent jobs and ETL workflows.
Required Skills
- 4+ years of experience with Microsoft SQL Server.
- 4+ years of experience with SQL programming objects.
- 4+ years of experience with ETL Development and/or Python.
- 2+ years of experience designing SSIIS ETL packages.
- 2+ years of experience extracting and transforming data in BI environments.
- Proficiency in SQL, Oracle, and Python.
- Bachelor degree in computer science, information systems science, or equivalent experience.
Preferred Skills
- Working knowledge of Azure Data Factory.
- Knowledge of general business, quality/regulatory requirements, or manufacturing systems.