Already a Member? Sign In

Sql/etl Developer Jobs

Albany, New York
<p>We have an opening with one of our client for SQL/ETL Developer position, please send your resumes.</p><p># of position: 1 (Contract to Hire)</p><p>Duration: 12+ Months</p><p>Work Authorization Type: US Citizen, GC, EAD, TN</p><p>Required Skills:</p><p>Tasks: Design, develop, and implement ETL processes for loading an enterprise data warehouse and data marts Create and optimize queries for front-end and back-end applications Design and develop views and stored procedures in support of system and information requirements Contribute to the design of dimensional modeling schemas for a data warehouse Identify and recommend solutions for database performance issues and optimization Work with the Database Administrator to create and execute DDL scripts Recommend solutions by defining database physical structure and functional capabilities, database security, data back-up, and recovery specifications Recommend and establish optimum data access techniques; support database functions by designing and coding utilities and scripts; contribute to the creation and maintenance of an enterprise data dictionary Work with key stakeholders on a disaster recovery plan Maintain a high level of service by establishing and enforcing organization standards and following established change management processes Continue to improve professional and technical knowledge by attending educational workshops; reviewing professional publications; establishing personal networks; benchmarking state-of-the-art practices; participating in professional societies Foster and contribute to a culture of excellence grounded in listening, learning, problem solving, and teamwork Assist in the improvement and integration of automation and tools designed to support work and decision making Effectively communicate, collaborate and problem-solve with relevant stakeholders Perform other responsibilities as assigned</p><p>Expected Deliverablesa. Tested ETL codeb. Optimized queriesc. Tested DDL scripts</p><p>The Contractor should be able to demonstrate the following skills</p><p> Four years of relevant experience as described above A strong technical knowledge of Microsoft SQL Server (version 2012 or newer preferred) Significant experience with SQL Server Integration Services Strong scripting abilities utilizing various programming/scripting languages (T-SQL, VBScript, Powershell, Bat files, C#, etc.) Experience developing ETL in a data warehouse environment Experience with Tableau (preferred) An understanding of Microsoft Windows Server 2008+, Active Directory, Windows networking (DHCP, DNS) Strong ability to work in a team dedicated to creating systems that are user-friendly, enable easy self-service, and are scalable and flexible to support emerging strategic needs of NYSERDA Demonstrated commitment to ongoing learning / ability to share and facilitate knowledge within a highly dynamic team. Demonstrated problem-solving ability; an entrepreneurial edge, resourcefulness, adaptability, and an instinct for surfacing value and pragmatic solutions As this contract may become a permanent position: Bachelor degree in information systems or related field and 4 years relevant work experience as a SQL Server Developer; or an unrelated degree and 6 years relevant work experience as a SQL Server Developer; certificates from recognized programs that indicate mastery of tools and techniques relevant to the assignment may substitute for up to six months of experience As this contract may become a permanent position it is requested that all applicants be eligible for hire within New York State government at the time of submission.</p><p></p><p></p>
Apply here