Senior Application Programmer - SQL / ETL Job at SYSCOM, Inc., Remote

V1lBNEVzTkFWSzNKVnpzRXQwck82NS9UcGc9PQ==
  • SYSCOM, Inc.
  • Remote

Job Description

SYSCOM, Inc. provides specialized information technology resources that possess the requisite skills and capabilities to deliver enterprise level solutions that help our client’s achieve their objectives. At SYSCOM, we have a proven process that brings the best and brightest resources into our organization. Our teammates have excellent verbal and written communication skills as well as coordination and organization skills. The objective of our approach is to ensure a high level of customer satisfaction.

SYSCOM’s client is seeking a Senior Application Programmer (ETL/SQL)  for an exciting, remote-based position.

Work Location: The position is primarily remote; however, the candidate may be required to attend onsite meetings at the client’s offices in Baton Rouge, LA - approximately once per quarter.

Job duties and responsibilities will include but are not limited to the following:
  • Analyze and document the data conversion scope, approach, validated requirements, and the strategy for how the conversion will be performed.
  • Map legacy data files and elements to the new system table(s) and columns. Mapping should include translation rules, foreign key rules, among other pertinent information.
  • Work independently in developing program modules using SSIS ETL tool (SQL Server Integration Services) based on designs/storyboards
  • Create and execute SQL Queries validating and analyzing data directly from various databases
  • Execute team members’ SSIS programs and monitor runtimes
  • Resolve SSIS program errors and program performance issues without assistance from team members
  • Analyze/troubleshoot data integrity issue and data discrepancies
  • Perform code reviews and testing on new code.
  • Test conversion program modules to ensure accuracy
  • Test how the converted data performs within the system
  • Participates in all necessary team meetings and design sessions in accordance with Scrum ceremonies.
  • Provide technical knowledge transfer, training, documentation, mentorship, and guidance to client personnel for all requested work.
Expertise and/or relevant experience in the following areas are mandatory :
  • Three (3) plus years of expertise and/or relevant experience in the following areas:
    • Working in the application development field with experience using Extract Transform and Load (ETL) tools, development experience using SSIS and writing complex database SQL queries
    • Working in a SQL Server environment
    • Creating and maintaining SQL Server Agents (SSA)
    • Working in a relational database environment
  • Two (2) plus years of experience working in an Agile / Scrum environment
Expertise and/or relevant experience in the following areas are desirable but not mandatory:
  • Experience with the GitHub Version Control System, including branching strategies for complex systems
  • Experience with conversion projects and processes strongly preferred
  • Experience in identifying and addressing data quality issues
  • Experience with large scale public sector IT projects
  • Experience with JIRA
  • Experience with mainframe systems and lotus notes applications
  • Strong problem-solving, troubleshooting and interpersonal skills
  • Strong verbal and written communication skills
  • Strong attention to detail and accuracy
  • Ability to articulate complex concepts in a clear manner
  • Strong organizational, multi-tasking, and prioritizing skills
Headquartered in Baltimore, Maryland, SYSCOM, Inc. is a US-based company whose mission is to create and deliver the right technology solutions, by teaming with our customers to understand their business needs and empower them to achieve their goals. Since 1982, SYSCOM, Inc. has been providing enterprise-wide solutions for a variety of private and public sector clients.

Job Tags

Remote job,

Similar Jobs

Santander Holdings USA, Inc.

Senior Model Risk Validation Analyst - Expert Judgement Models Job at Santander Holdings USA, Inc.

Senior Model Risk Validation Analyst Expert Judgement Models Country: United States of America Your Journey Starts Here: Santander is a global leader and innovator in the financial services industry. We believe that our employees are our greatest asset. Our... 

Comfort Inn & Suites — Lantana, FL

Hotel Night Auditor - Part-Time Job at Comfort Inn & Suites — Lantana, FL

Our property is growing rapidly and we are looking for a night auditor who loves working with people, possesses a strong commitment to customer satisfaction, and has bookkeeping experience! We provide the tools and training to bolster your hospitality career goals. If you... 

Cool-Transports & Merit Oil

Tanker Driver CDL Commercial/Wethose Merit Oil Colton Job at Cool-Transports & Merit Oil

 ...Merit Oil Company currently has career opportunities available in the Colton area of Southern California. You may visit our website...  ...actively seeking Commercial Class A driver applicants with hazmat and tanker endorsements. Ultimately, you will help us increase customer... 

Focused HR Solutions

Helpdesk Analyst 8-11 Job at Focused HR Solutions

 ...controls. DAILY DUTIES / RESPONSIBILITIES: ALL WITHIN PROJECT SCHEDULES AND OTHER DEFINED DEADLINES: Provide support with help desk calls resolving approximately 30% of the tickets averaging 6-10 tickets daily Provide technical support to ongoing projects... 

Oracle

Director of Sales, Data Platform Job at Oracle

**Job Description**Director of Sales, Data PlatformCome and join us! The ideal candidate for the Sales Leader, NACI Data Platform role...  ...benefits package which includes the following:1. Medical, dental, and vision insurance, including expert medical opinion2. Short...