Need ETL Application Programmer at MD - Onsite Role - In person Interview MUST

[Sharon]

Hello,

We have an urgent role with our client State of MD. Need Locals and looking Locals who can go In Person Interview.

If Interested, please share resumes to discuss further.

ETL APPLICATION PROGRAMMER

Location: 200 W Baltimore St. Baltimore, MD 21201 - On-site

Project Identifier MSDE

Project Name Division of Assessment and Accountability – MODE System 

Client State of Maryland

Agency Maryland State Department of Education (MSDE)

Teleworking is permitted at the discretion of the Supervisor

Contract Duration 5 years with 2 one-year renewal options

Interview Type In-Person

Tentative Start Date November 2025

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 

Regard's

Sharon

Account Manager

Email: sha...@akhurathasolutions.com

Akhuratha Solutions INC

43003 Lost Farm Terrace, Leesburg - VA 20175

https://www.akhurathasolutions.com/

[Sharon]

Sai,

I'm looking for local to Baltimore who can go In person Interview.

Let me know Srikanth location information.

Thanks.

Sharon

Account Manager

Direct - 703-349-6282

Email: sha...@akhurathasolutions.com

Akhuratha Solutions INC

43003 Lost Farm Terrace, Leesburg - VA 20175

https://www.akhurathasolutions.com/

---

From: Sai N <sa...@clearthoughtsolutions.com>
Sent: Tuesday, October 14, 2025 3:42 PM
To: Sharon <Sha...@akhurathasolutions.com>; immedi...@googlegroups.com <immedi...@googlegroups.com>; hotpos...@googlegroups.com <hotpos...@googlegroups.com>
Cc: srikanth s <srikan...@gmail.com>
Subject: Re: Need ETL Application Programmer at MD - Onsite Role - In person Interview MUST

 

Hello Recruiter,

 

I appreciate your email,  

               

Thank you for sharing the job description, in response to the below Job posting, please find the attachment of my consultant profile for your quick review and consideration.

Visa-H1B( Ready to relocate )

Sincerely,  

Sai Nunna 

Senior Bench sales 

Tel Direct : 919-296-1294 

                       919-825-1382 Ext-113

sa...@clearthoughtsolutions.com

Clear Thought Solutions LLC / Empro Systems LLC    

LinkedIn: www.linkedin.com/in/sai-nunna-03325b231

 

---

From: hotpos...@googlegroups.com <hotpos...@googlegroups.com> on behalf of Sharon <Sha...@akhurathasolutions.com>
Sent: Wednesday, October 15, 2025 1:06 AM
To: immedi...@googlegroups.com <immedi...@googlegroups.com>; hotpos...@googlegroups.com <hotpos...@googlegroups.com>
Subject: Need ETL Application Programmer at MD - Onsite Role - In person Interview MUST

 

--
You received this message because you are subscribed to the Google Groups "Hot positions" group.
To unsubscribe from this group and stop receiving emails from it, send an email to hotpositions...@googlegroups.com.
To view this discussion visit https://groups.google.com/d/msgid/hotpositions/CH3P221MB116565805B93C5A6E4C3EF77AFEBA%40CH3P221MB1165.NAMP221.PROD.OUTLOOK.COM.