Remoteville

Remote ETL Developer Job in United States Global Soft Systems, Inc.

ETL Developer Global Soft Systems, Inc.
Azure SQLETL ToolsMicrosoft SQL ServerSQL Server Integration ServicesData WarehousingDatabasesExtract Transform LoadQuery WritingScheduling ToolsStored Procedures
Senior (5-8 years) - 
United States


Connecting worlds, One Resource at a Time!!!
30+ employees
B2BHRRecruitmentConsulting


Role


Who you are

  • Require Microsoft SQL Server Integration Services SSIS knowledge and demonstrated experience
  • Familiar with project deployment model use of project and package parameters and Integration Services Catalog including Environments
  • Knowledge of designing and developing data transformation solutions using a variety of SSIS components
  • Experience reviewing user requirements and performing analysis design development testing installation and training related to the application developed
  • Proficient in SQL query writing and editing
  • Familiar 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
  • Minimum 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
  • Bachelor’s degree in Computer Science or related field or equivalent combination of industry-related professional experience and education


What the job involves

  • 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

Share this job

Hide company

More jobs at Global Soft Systems, Inc.

Company


Company mission

Global Soft Systems Inc. is one of the nation’s leading staffing and recruiting firm helping organizations accelerate business growth. A rapidly growing company providing a broad range of services for our clients. we give you the flexibility to choose the partnership model that works best for your organization and eventually drives greater value. GSS specializes in connecting talented people to the businesses who need them. We collaborate with our candidates to understand their skill set and background in order to connect them with the right businesses. At GSS, we take the time to get to know the right people, making the process as simple as possible for everyone involved.



Company values

  • Global Soft Systems Inc. is one of the nation’s leading staffing and recruiting firm helping organizations accelerate business growth. A rapidly growing company providing a broad range of services for our clients. we give you the flexibility to choose the partnership model that works best for your organization and eventually drives greater value. GSS specializes in connecting talented people to the businesses who need them. We collaborate with our candidates to understand their skill set and background in order to connect them with the right businesses. At GSS, we take the time to get to know the right people, making the process as simple as possible for everyone involved.


Company HQ

Overland Park
;