Role: Senior SQL Developer Client: NY State Office of Information Technology Visa: All Visa Except H1B Required to work 100 % on site 40 North Pearl Street Albany NY 12207 Duration : 48-month contract Mandatory Skills :
- Two or more years in a team lead
- Seven years or more years of experience working on complex projects as a developer.
- Seven years or more of experience in analysis, design, development, testing and implementation of business intelligence solutions using PL/SQL & relational databases
- Five years or more years of hands-on experience with authoring and maintaining of reports using IBM Cognos suite of tools with relational databases.
- Seven years or more years of hands-on experience writing complex SQL for querying and development of reports and data analytics.
- Seven years or more years of hands-on experience with PL/SQL writing packages, stored procedures and triggers.
- Five years or more years of hands-on experience developing data models, data mappings, data migrations and assisting in data warehouse design in Oracle environment for Cognos
- Five years of hands-on experience with design & development of Cognos cubes for analytical reporting
- Experience in developing, maintaining and managing Tableau driven dashboards & analytics and working knowledge of Tableau administration and architecture.
- Experience working with different databases structures for OLTP, OLAP & high-volume transaction systems.
Responsibilities:
- Responsible for the design, development and deployment of multi-dimensional reports using the Cognos Business Intelligence suite of products.
- Provides analysis, design, development, testing and implementation of Business Intelligence, Ad-hoc and Operational Reporting.
- Maintains and curates a central repository of enterprise Business Intelligence assets including dashboards, visualization and interactive reports.
- Monitor daily reports that identify data inconsistencies, determine the resolution and revise the incorrect operational data.
- Enables capabilities available in the Business Intelligence technology such as drill-through functionality, KPI and scorecard reporting, advanced visualizations including mapping and geospatial analysis, predictive analytics, and other capabilities as they arise.
- Communicate and coordinate with members of the development team to work across multiple projects.
- Explore, actively support and work on new technology initiatives that may be of interest to the organization.
- Actively participate in troubleshooting any technical issues that the program may have.
- Other duties as assigned.