Overview
HybridPrimarily a remote work position
Depends on Experience
Accepts corp to corp applications
Contract - W2
Contract - Independent
No Travel Required
Skills
ETL
SSIS
SQL
SSA
Agile
Scrum
GitHub
JIRA
Job Details
Position: ETL Developer
Education: Bachelor s Degree in Computer Science, Information Systems or other Information Technology major, or equivalent work experience..
Required Experience:
- Expertise and/or relevant experience in 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
- Expertise and/or relevant experience in Working in a SQL server environment
- Expertise and/or relevant experience in Creating and maintaining SQL server agents (SSA)
- Expertise and/or relevant experience in Working in a relational database environment
- Experience working in an Agile / Scrum environment
Preferred Experience:
- 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
Responsibilities:
- 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.
No phone calls please. Apply only via e-mail. No visa sponsorship provided at this time.
Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.