What are the responsibilities and job description for the SSIS Developer (31924) position at Myticas Consulting?
Clover Consulting (a Myticas Consulting Company) has a large, direct client in need of an SSIS Developer.
This is a 100% remote position. The term of this contract position is through 2025, but it will likely be extended.
This candidate will be part of a 43-person team made up of Project Managers, Teradata and Web Developers, Data Modelers, DBAs, Business Analysts and Report Analysts. Must be able to communicate effectively, verbally and in writing, with programmers, analysts, immediate supervisor, management, system users, and operations.
Job Duties:
- Provides code repository management and SSIS packages support
- Provides support/coordination for network related issues and development
- Leads source data research and target data requirements analysis for successful conversions
- Audits existing data for quality and clarity
- Responsible for converting existing data and adding new data sources as needed according to conversion best practices
- Preserves and improves data quality during data conversion activities
- Prepare necessary forms and documentation for implementation
- Works with the stakeholders to convert existing data and reports, including algorithm to assure matching occurs between datasets before and after conversion
- Analyze and recommend process improvements
- Must be able to work independently
Required:
- 3 – 5 Years’ DEV OPS Experience in SQL/WIN Environment; SSIS packages/authored in Visual Basic
- 3 Years’s Experience using GitHub code repository or similar
- 3 Years’ Experience with troubleshooting server network issues related to firewalls, VPN, B2B connections, etc.
- 5 Years’ Experience with all phases of SDLC
Preferred:
- Bachelor’s degree or equivalent technical study
- Teradata Experience and Teradata Utilities
- Experience with SQL Assistant
- Experience performing Data Extracts, Data Transformations & Data Loads (ETL)
- Experience working with business partners to proactively identify value add solutions
- Experience with Report Development
- Experience with Analytical Tools
