ETL APPLICATION PROGRAMMER

Overview

On Site
Depends on Experience
Contract - Independent
Contract - W2
Contract - 6 Month(s)

Skills

IBM
Cognos

Job Details

Project Overview

This position provides reporting and ETL application support for Division of Assessment and Accountability. This role is critical to the development of new and maintenance of existing processes for

data loading and reporting of information collected as part of state and federal requirements.

Deliverables include data loads into the MSDE Education Data Warehouse (EDW) and report implementations for executive leadership, local education agencies, and the public.

This position is a liaison with DoIT as needed and provides backup support to the EDW data architect.

Technical skills required:

IBM Cognos 12 Framework Manager, IBM Cognos Analytics 12.4, Informatica

10.4/10.5, Informatica Cloud (IICS), Oracle 19c/21c, MS SQL Server, SQL, Adobe Pro DC, PKZIP,

PowerShell scripts, AWS.

Duties/Responsibilities

Use Cognos Framework Manager to build business models of metadata derived from the underlying EDW table structures (logical, business, and presentation layers) for report developers and end

users.

Use web-based tools to create analytical reports for ESSA-related reporting; create data downloads and publications for the Maryland Report Card.

  • Provide backup for critical routine Informatica workflows; support end users in analyzing failures and restarting workflows.
  • Perform extraction, transformation, and loading (ETL) from source systems into the EDW using Informatica.
  • Use Oracle 12c/19c and SQL Server to access repositories and audit tables and to analyze/reporting issues.
  • Use Adobe Pro DC to make PDF reports meet accessibility requirements per federal and state requirements.
  • Use PKZIP to package reports for sending to local education agencies.
  • Create and execute SQL scripts for requirements analysis, development, testing, and extraction of datasets from EDW; debug Cognos reports using SQL extracted from Cognos.
  • Create and execute Windows (DOS) PowerShell scripts for batch renaming of Cognos-bursted filenames.

Innosoft is an Equal Opportunity/Affirmative Action employer

  • Install Cognos upgrades and set up Active Directory as needed; act as secondary/backup administrator for Informatica and assist with version upgrades.
  • Perform routine backups and maintenance of Cognos server; requirements gathering, development, testing/validation, and enhancement of analytic reports.
  • Create accountability and assessment deliverables (e.g., targets and assessment results, enrollment, attendance, participation, equity, climate survey, chronic absenteeism, MCAP, and other

assessments).

Minimum Qualifications Required

  • Bachelor s degree in Computer Science, Information Systems, or a related field; or equivalent experience.
  • 6+ years of experience designing, developing, and supporting ETL and analytics/reporting solutions.
  • 3+ years hands-on with IBM Cognos Analytics (v11/12) and Framework Manager (modeling logical/business/presentation layers).
  • 3+ years building and supporting Informatica PowerCenter 10.x and/or Informatica Cloud (IICS) workflows.
  • Strong SQL skills and experience with Oracle (12c/19c/21c) and Microsoft SQL Server.
  • Experience producing accessible PDF reports (Section 508/WCAG 2.1) using Adobe Acrobat Pro/Adobe Pro DC.
  • Experience with Windows scripting/automation (e.g., PowerShell, batch) and packaging artifacts (e.g., PKZIP).
  • Experience diagnosing/reporting issues, supporting production jobs, and assisting with upgrades in multi-environment (DEV/QA/PROD) setups.
  • Relevant certifications (e.g., IBM Cognos Author/Modeler, Informatica Developer) or equivalent demonstrated expertise
Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.