Application Programmer (ETL Tools, SQL Environment)

Energy Vault; Baton Rouge (LA); Remote; USD 75,000 - 95,000; Full time

Job summary

A leading company in information technology solutions is seeking a skilled application developer to take on critical data conversion tasks in a remote role. The candidate will be responsible for developing ETL processes, tackling data quality issues, and providing training and documentation to state personnel. This position requires strong SQL and SSIS expertise, along with a solid background in Agile methodologies, offering a competitive salary within the range of $75,000 to $95,000 annually.

Benefits

Health insurance

Paid time off

Tuition assistance

Qualifications

• 3+ years in application development with ETL tools and SQL.
• 2+ years in Agile/Scrum environment.
• Expertise in SQL server, data conversion projects preferred.

Responsibilities

• Analyze and document data conversion scope and requirements.
• Map legacy data files to new system tables.
• Develop program modules using SSIS ETL tools.

Skills

Problem-solving

Troubleshooting

Interpersonal skills

Attention to detail

Organizational skills

Communication

Tools

SSIS

SQL

GitHub

JIRA

Job description

Benefits:

• Health insurance
• Paid time off
• Tuition assistance

Expertiseand/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:

• 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

The scope of the proposed services will include 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 State personnel for all requested work.
  
  

This is a remote position.

Compensation: $75,000.00 - $95,000.00 per year

Matrix Systems and Technologies Inc., is a leading information technology solutions provider based in the Washington, DC metro area.

We have provided services in full life-cycle engineering analysis, strategic planning, testing and process management for clients across the North-eastern corridor since 1996. Our client base includes; The State of Maryland, Maryland State Department of Education, Prince George’s County Maryland, IRS, Northrop Grumman, Computer Sciences Corporation, SAIC, Lockheed Martin, American University, and the Department of Health and Human Services.