ETL Developer (Remote)

ETL/API Developer (603604)

Location: 400 E. 14th St, Des Moines, IA 50319 – local candidates will get first pick

Web Cam Interview Only – June 8th

REMOTE WORK PERMITTED: Due to COVID-19, the client has agreed to allow the selected candidate to work remotely for the time being. However, the chosen candidate must be available to report in person as directed by the client to pick up equipment on the first day. This position REQUIRES the selected candidate to work ONSITE for the duration of the assignment once clear to return to the building.

Contract till 05/07/2021
This candidate should be an expert in creating, modifying, and maintaining SSIS packages which will be used to move data from source systems to the data warehouse backend. Advanced skills in writing complex Structured Query Language (SQL) queries are required. Expertise with Microsoft development toolsets and industry-standard API technologies is required.Candidate

• Proficient in development of SQL Server Integration Services (SSIS) packages.
• Proficient using MS SQL 2014 or later and writing relational database queries and stored procedures using SQL
• Experience extracting data from a large variety of sources, transforming, and loading to a SQL data warehouse
• Experience with MVC, Microsoft development tools (ASP.NET, C#.NET, Entity Framework), RESTful APIs, and integrated authentication methods
• Experience converting data to and from relational stores and JSON or XML formats
• Evaluate and address data quality issues
• Developing error checking and resolution routines
• Experience in interacting with customers regarding application requirements.
• Strong business writing and interpersonal skills necessary for customer contact.

Requirements

• Develop, modify, and optimize SSIS packages - 5 years of experience
• SQL 2008 – 5 years of experience
• Experience building SSIS packages using built-in SSIS components - 5 years of experience
• Experience writing complex T-SQL
• Experience analyzing, profiling, manipulating data from a large variety of sources
• Experience loading data into a SQL Data Warehouse
• Troubleshoot abstract data, profile, analyze and optimize data
• Develop error checking and resolution routines
• Data modeling experience
• Analyze and optimize table design
• Ability to work with end users to extract business requirements
• Ability to analyze data and apply business rules and requirements
• Agile Project experience is highly desired

Skill Required / Desired Amount Years

• Develop, modify and optimize SSIS packages Required 5 Years
• SQL 2008 Required 5 Years
• Experience building SSIS packages using built-in SSIS components Required 5 Years
• Experience writing complex T-SQL Required 5 Years
• Experience analyzing, profiling, manipulating data from a large variety of sources Required 5 Years
• Experience loading data into a SQL Data Warehouse Required 5 Years
• Troubleshoot abstract data, profile, analyze and optimize data Required 5 Years
• Develop error checking and resolution routines Required 5 Years
• Data modeling experience Required 5 Years
• Analyze and optimize table design Required 5 Years
• Ability to work with end users to extract business requirements Required 5 Years
• Ability to analyze data and apply business rules and requirements Required 5 Years
• Agile project experience Highly desired

Job Type: Contract

Pay: $55.00 - $57.00 per hour

Experience:

• C#.net: 1 year (Preferred)
• table design: 5 years (Preferred)
• SQL Data Warehouse: 5 years (Preferred)
• SQL 2008: 5 years (Preferred)
• SSIS packages: 5 years (Preferred)
• Develop error checking: 5 years (Preferred)
• ETL Developer: 5 years (Preferred)
• Data modeling: 5 years (Preferred)