ETL Developer - DataStage
ACCUTREND DATA CORPORATION
Greenwood Village, United States of America
24 days ago
Role details
Contract type
Permanent contract Employment type
Full-time (> 32 hours) Working hours
Regular working hours Languages
English Experience level
Junior Compensation
$ 120KJob location
Greenwood Village, United States of America
Tech stack
Data analysis
Azure
C Sharp (Programming Language)
ETL
IBM InfoSphere DataStage
Microsoft SQL Server
SQL Stored Procedures
SQL Server Integration Services
Freeform SQL
Azure
Snowflake
Information Technology
Job description
- Work with SQL Server 2012+
- Work with Snowflake
- Create Stored Procedures, Views, Functions, Custom Data Types in Microsoft SQL Server
- Write queries to analyze data and produce results such as data differences between tables and creating reports for overlapping data
- Utilize Outer Joins, Inner Joins, Not Exists, etc., commands in daily work
- Create & Modify SSIS packages and models for Extract, Transform and Load
- Create & Modify Azure Data Factory pipelines for Extract, Transform and Load
- Document and provide guidance on database solutions to fulfill business or technology requirements
Requirements
- Bachelor of Computer Science or relative work experience
- Knowledge of Microsoft Azure
- Understanding of C#
- Understanding of Azure Data Factory
- Understanding of Snowflake
- Ability to write and understand complex SQL queries
- Experience in SSIS
- Ability to work on multiple tasks at once
Benefits & conditions
- 401(k)
- Dental insurance
- Health insurance
- Vision insurance
About the company
Accutrend Data Corporation is a big data provider in a small office environment. We have a great team of data experts but are looking to take on some new employees to help with day-to-day operations and our ever-increasing data shipments. This is a great entry level position for new graduates or for someone looking to expand their current skill set.