ETL Developer Job at Global Soft Systems, Remote

eU5tZmtBTC9tRyt4cWtxQmE0K1JBODdw
  • Global Soft Systems
  • Remote

Job Description

Position: ETL Developer

Duration: 6+ months Contract

REMOTE but prefers candidates in and around Kansas City

No OPT candidates


Develop SQL Server Integration Services (SSIS) programs to support Enterprise Datawarehouse. This is a contract position, and the successful candidate in this position will be expected to bring knowledge and experience with Microsoft SQL Server Integration Services (SSIS) and applying SSIS to develop data extraction-transformation-load function to create this integration.



Essential Functions & Accountabilities:

  • Take direction from Manager/Architect/Senior Programmer for SSIS Development and on daily tasks and activities.
  • Write new or modify existing SSIS packages/projects according to specified systems designs.
  • Test new or modified programs to ensure that they conform to design. Develop test data for use in program testing.
  • Write documentation of system changes in conformance with department standards
  • Write any necessary user documentation (report descriptions, user procedures, operations procedures)
  • Provide timely and concise summaries of project status to manager.



Knowledge, Skills, and Abilities:

  • Microsoft SQL Server Integration Services (SSIS) knowledge and demonstrated experience required.
  • Familiarity with project deployment model, use of project and package parameters, and Integration Services Catalog (including Environments) preferred.
  • Knowledge of designing and developing data transformation solutions using a variety of SSIS components (Data Flow Task, Data Flow transform tasks, Data Flow containers, Foreach Loop containers, Script components using C#).
  • Reviews user requirements for new applications or enhancements to existing applications and performs analysis, design, development, testing, installation, and training related to the application developed.
  • Software development life cycle and software quality assurance best practices and methodologies.
  • Proficient in SQL query writing and editing.
  • Familiarity with building SQL database objects (tables, views, stored procedures).
  • Develop complex ETL routines to load a dimensional star schema with a strong focus on data quality, error handling, and logging processes.
  • Stay updated on new ETL techniques and methodologies and communicate trends.
  • Assess requirements for completeness and accuracy and determine actionable steps for the ETL team.
  • Identify necessary changes to current business and data integration processes.
  • Communicate risks and ensure understanding.

Experience:

  • 7 years of IT Development experience with advanced experience working on ETLs for Datawarehouse in SQL Server databases
  • Advanced experience with job scheduling tools, scripting languages (JavaScript, PowerShell, Command scripting), programming languages (C# and Python), SQL programming, and ETL tools such as SSIS.
  • Experience with Azure, Azure DevOps, Azure Data Lake, Azure SQL Server
  • Advanced experience with T-SQL, data warehousing design, BI concepts, and best practices
  • Clear verbal and written communication skills.
  • Previous experience in the health industry, SSRS, or Power BI is a plus.
  • Preferred Insurance background

Requirement: Bachelor's degree in Computer Science or related field or equivalent combination of industry-related professional experience and education

Job Tags

Full time, Contract work, Remote job,

Similar Jobs

Connvertex Technologies Inc.

Paid Digital Media Buyer Job at Connvertex Technologies Inc.

 ...seeks a highly experienced Paid Digital Marketing Media Buyer to support our in-house digital...  ...including SEM, PPC, display advertising, social media advertising, and programmatic...  ...master's degree is a plus. ~5+ years of experience in paid digital marketing and ad... 

Toyota of Easley

Parts Delivery Driver Job at Toyota of Easley

 ...This is a full-time,hourly positionresponsible for supporting delivery of parts to commercial customers and controlling inventory processes...  ...deliver to Qualifications Must have a clean and valid driver's license Must have at least one year ofparts delivery experience... 

MatchaTalent

Global Oil Gas Senior Linear Programming LP Engineer Job at MatchaTalent

 ...in the exploration production transportation and sale of crude oil and natural gas. It operates through the following segments: Upstream...  ...seeking a Linear Programming (LP) Engineer with expertise in refinery optimization and economics to join our Operation Engineering... 

The Borgen Project

Writer/Journalist Internship Job at The Borgen Project

 ...Are you passionate about making a difference in the world? Look no further! The Borgen Project ( is an international organization that works at the political level to improve living conditions for people impacted by war, famine and poverty. With 20 years of experience... 

Palm Healthcare

LOCUM Trauma Nurse Practitioner Job at Palm Healthcare

 ...Salary: $100.00 - $120.00 We are hiring a LOCUM TENEN Trauma Nurse Practitioner or Physician Assistant for one of our amazing teams near Myrtle Beach, South Carolina!! Our team is looking for a full time experience Trauma Critical Care Nurse Practitioner or Physician...