Job Description:
Trigyn's direct government client has an immediate need for an ETL Developer in Schenectady, NY.
Description:
This position will be responsible for the design and development of a large multi-level system that will ETL (extract, transform and load) from an external OLAP database to an internal system.
• Use Microsoft Visual Studio to create and maintain SSIS packages and projects.
• Extract data from various sources, such as databases, spreadsheets, flat files, or APIs.
• Create and maintain database stored procedures and functions.
• Contribute to the design of a data warehouse architecture that supports data storage, retrieval, and analysis.
• Optimize query performance by creating indexes.
• Diagnose and troubleshoot various rules, calculations, and data issues on application reports using Crystal Reports.
• Report status of current tasks and outstanding issues to supervisor.
Mandatory Qualification:
• Creates computer software. May specialize in one area of computer software or may write code for many kinds of software.
• Candidate is able to provide guidance to large teams and/or has extensive industry experience and is considered at the top of his/her field.
• 84 months ETL (Extract, Transform, and Load) experience creating SQL Server SSIS objects
• 84 months SQL Server Programming; views, stored procedures, and functions.
• 60 months of experience in Data Warehousing.
• 60 months experience with OLAP (On-line Analytical Processing).
For Immediate Response call 732-640-2404, or send your resume to RecruiterPK@Trigyn.com
TRIGYN TECHNOLOGIES, INC. is an EQUAL OPPORTUNITY EMPLOYER and has been in business for 35 years. TRIGYN is an ISO 9001:2015, , ISO 27001:2013 (ISMS),ISO 20000:2018 and CMMI Level 5 certified company.