Description
You will develop and maintain data integration solutions, focusing on extracting, transforming, and loading data from Oracle and SQL Server databases into structured formats for analysis and reporting.
This role is on-site.
Responsibilities
- Extract geographic and non-geographic data from Oracle and SQL Server databases.
- Design and implement data pipelines to handle large datasets.
- Automate ETL integrations using SQL Server Integration Services (SSIS).
- Create APIs to enable secure data access and integration across systems.
Required Skills
- 5+ years of professional experience in ETL development.
- Proficiency with SQL Server Integration Services (SSIS).
- Strong knowledge of Oracle databases.
- Experience with SQL Server and SQL Server Integration Services.
- Ability to perform data modeling and database design.
- Experience creating reporting solutions using SSRS.
- Familiarity with API design and implementation.
Preferred Skills
- Experience with GIS data handling.
- Knowledge of database performance tuning.