ETL Developer (Informatica IICS /SSIS
Saxon Global
Cincinnati, United States of America
6 days ago
Role details
Contract type
Temporary contract Employment type
Full-time (> 32 hours) Working hours
Regular working hours Languages
English Experience level
SeniorJob location
Cincinnati, United States of America
Tech stack
Data Integration
ETL
Data Mining
Data Warehousing
Microsoft Visual Studio
Cloud Services
Standard Sql
SQL Databases
SQL Server Integration Services
Freeform SQL
Job description
- Rewrite and optimize existing ETL and data movement code to support ingestion from a new data source into existing data warehouse schemas.
- Develop, execute, and optimize complex SQL queries for data extraction, transformation, and validation.
- Utilize extensive experience with the Data Integration module within Informatica Intelligent Cloud Services (IICS).
- Create and modify SQL Server Integration Services (SSIS) packages and jobs in Microsoft Visual Studio.
Requirements
- SQL
- Informatica Intelligent Cloud Services
- SQL Server Integration Services
- PowerCenter, Technical Skills:
- Informatica Intelligent Cloud Services (IICS) - Data Integration module.
- SQL Server Integration Services (SSIS).
- SQL.