SSIS Developer
Frederick , MD
Job Description:
No OPTs please
Required Skills :
SSIS, SQL, Data warehousing, ETL
DESIRED:
BS in Computer Science orequivalent experience
MCSD, MCAD, or other applicableadvanced certifications
Job Description :
The successful candidate will have adequate experience with SQL ServerIntegration Services, understand ETL processes, be familiar with DataWarehousing, and familiarty with Machine Learning and Data Science terminology.
RESPONSIBILITIES:
Provide technical consultation and support in the development ofbusiness solutions using various tools (SQL Server, etc)
Analyze business requirements and design documents, and write technicalspecifications
Develop complex code and provide coding guidance to less experiencedstaff
Lead and/or perform modeling, simulations and analysis efforts
Verify program logic by overseeing the preparation of test data, testingand debugging of programs
Participate in overall systems testing
Support the migration of applications to production
Develop new documentation, participates in the development of departmenttechnical procedures and designs user guides
Lead solutions, including assignment of tasks, and provides directionand guidance to less experienced staff
Ensure new features are modeled to integrate with existing applicationand provide a consistent data model
Develop and maintain documentation of the data architecture, data flowand data models
Provide direction on adoption of new technologies and best industrypractices in the field of data architecture and modeling
QUALIFICATIONS:
5+ years application development and implementation experience.
5+ years SQL Server Integration Services (SSIS)
3+ years developing SQL/Stored Procedures
Demonstrated experience in troubleshooting and issue resolution
Strongunderstanding of DataWarehousing and ETL processes