Multiple Urgent Hiring - ETL APPLICATION PROGRAMMER / SAS APPLICATION PROGRAMMER / SENIOR BUSINESS SYSTEMS ANALYST / SENIOR IT PROJECT MANAGER /SAP - Baltimore, MD (Local Only) (Onsite)

Hope you are doing well !!

This is Amritanshu from Himflax Information Technologies Inc. We have an urgent requirement. Please review the below job description and If you are interested Please let me know. Please share your updated Resume with me at my Email: amritanshu@himflax.com or you can directly reach me at +1 551-201-9151.

Notes – sahre only Working Experience with State or Government or Federal Clients (Present or previously)

(1) Job Description:

Job Title : ETL APPLICATION PROGRAMMER
Location : Baltimore, MD (Onsite) (Local Only)
Duration: Long term Contract
Interview Mode: In-Person

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.

• 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.

(2) Job Description:

Job Title : SAS APPLICATION PROGRAMMER
Location : Baltimore, MD (Onsite) (Local Only)
Duration: Long term Contract
Interview Mode: In-Person

Duties/Responsibilities:

• Develop PROC SQL data queries to query and subset detail and summary data from the MSDE data warehouse, summarize detail data, combine tables using joins and set operators, and use macro variables in SQL.

• Develop and perform programming to manipulate data by merging, appending, and sorting datasets; manipulate data with functions; create custom formats; concatenate and merge tables; process repetitive code (DO loop and SAS array); restructure tables (PROC TRANSPOSE); and perform pattern matching (SOUNDEX).

• Use Macro functions and write SAS Macro programs to facilitate and automate data management operations.

• Use Output Delivery System (ODS) to produce RTF, PDF, HTML, and EXCEL deliverables.

• Use SAS for descriptive and inferential statistical analysis (PROC MEANS, PROC FREQ, PROC UNIVARIATE).

• Use PROC COMPARE to create verification PDF or RTF reports of databases and metadata stored in the Education Data Warehouse (EDW).

• Develop quality-assurance syntax to perform data checks to ensure correctness and integrity of education data.

• Collaborate with the data warehouse architect to ensure integrity of stored data in the MSDE data warehouse and resolve data issues.

• Perform quality review and validation of SAS programs generated by data analysts or other SAS programmers.

• Establish and maintain program folders of fully documented and validated SAS programs/macros/procedures.

• Modify/update SAS code to incorporate changes in data collection and reporting processes.

• Acquire knowledge about manuals related to MSDE data collections, gather business requirements for federal/state reporting, and provide recommendations.

• Resolve SAS performance problems and monitor computer resources and efficiency.

Minimum Qualifications Required:

• Bachelor’s degree in Computer Science, Statistics, Mathematics, Data Science, or a closely related field; or equivalent experience.

• 6+ years of professional SAS programming experience (Base SAS and Macro), developing productiongrade code.

• Strong PROC SQL skills and proficiency with Data Step programming, arrays, and macros.

• Hands-on experience with ODS to generate RTF/PDF/HTML/Excel deliverables.

• Proficiency with PROC MEANS, PROC FREQ, PROC UNIVARIATE, PROC TRANSPOSE, PROC COMPARE, and use of SOUNDEX and custom formats.

• Experience implementing data quality controls, peer review/validation, and documentation standards.

• Experience working with enterprise data warehouses (e.g., Oracle EDW) and large relational datasets.

• Base SAS Programmer and/or Advanced SAS Programmer certification, or equivalent demonstrated expertise.

(3) Job Description:

Job Title : SENIOR BUSINESS SYSTEMS ANALYST
Location : Baltimore, MD (Onsite) (Local Only)
Duration: Long term Contract
Interview Mode: In-Person

Duties/Responsibilities:

• Serves as a liaison between business stakeholders and technical teams to gather, analyze, and document functional and non-functional system requirements.

• Performs gap analyses, identifies cross-dependencies, and proposes system enhancements or new solutions.

• Translates business program requirements into functional system specifications for multiple data collections and assessment platforms.

• Collaborates with external assessment vendors in analyzing all vendor data file layouts and integrating required data elements into MSDE systems using intermediary documents.

• Supports the development of application system platforms and reporting.

• Ensures vendor data meets defined specifications and is compatible with the EDW.

• Validates data accuracy and integrity for each assessment cycle and works with vendors to resolve issues.

• Provides support and requirements gathering for internal and vendor-based applications used in data collections, including both MODE and non-MODE systems.

• Translates business program requirements to functional system requirements for data collected in the Division of Assessment and Accountability.

• Develops and executes test scenarios to validate system functionality and data integrity.

• Assists in user acceptance testing (UAT), working with program staff to ensure solutions meet requirements and function as intended.

• Tracks defects and coordinates resolution with vendors and internal teams.

• Creates and maintains detailed documentation, including business rules, requirements, test plans, process flows, and data mappings.

• Provides regular status reports to stakeholders and leadership on project progress, risks, and data readiness.

Minimum Qualifications Required:

• Bachelor’s degree in Computer Science, Information Systems, Data Analytics, or a closely related field; or equivalent experience.

• 8+ years of professional experience as a Business Systems Analyst (or similar role) delivering enterprise data and analytics solutions.

• 5+ years experience eliciting and documenting requirements (functional and non-functional) and producing BRD/FRD/RTM, process flows, and data mappings.

• 5+ years hands-on SQL for data profiling/validation and experience with Oracle-based data warehouses and BI platforms (e.g., OBIEE or equivalent).

• Demonstrated experience coordinating with external vendors and integrating vendor-supplied datasets into an enterprise EDW with strong data-quality practices.

• Experience supporting UAT and defect management with stakeholders across business and technology teams.

• Proficiency with MS Office; familiarity with Toad for Oracle (or equivalent tooling).

• Excellent communication, documentation, and stakeholder management skills within Agile delivery teams.

• Relevant business analysis certification (e.g., IIBA CBAP/CCBA or PMI-PBA), or equivalent demonstrated expertise.

(4) Job Description:

Job Title : SENIOR IT PROJECT MANAGER

Location : Baltimore, MD (Onsite) (Local Only)
Duration: Long term Contract
Interview Mode: In-Person

Project Overview:

This position requires a project manager with critical skills, including in-depth knowledge of accountability data and reporting requirements as well as IT technical and vendor management skills.

Duties/Responsibilities :

• Support MSDE agency and statewide applications including WDCS (Web Data Collection System), Maryland Report Card, MODE (Maryland Online Data Exchange), MOVEit SFTP Secure Server, PowerSchool §5-234 Minimum School Funding financial dashboard, Educator Retention Dashboard, WCAG 2.1 Web Content Accessibility Guidelines, MSDE Corporate Branding initiatives, AWS on-prem to cloud server migrations, Smartsheet PMO applications, and other duties as assigned.

• Perform day-to-day project management, identify issues and risks, and recommend mitigation strategies.

• Act as a facilitator between MSDE, DoIT, and Local Education Agencies (LEAs).

• Ensure work performed is within scope, consistent with requirements, and delivered on time and on budget.

• Identify critical paths, tasks, dates, testing, and acceptance criteria; monitor issues and provide resolutions for up-to-date status reports.

• Coordinate with vendors and assign project staff as needed across functional/technical areas; serve as primary contact with each vendor’s PM team and state resources.

• Coordinate deliverables, work product reviews/approvals, and set priorities when choices of alternatives are required;report project status information to Executive Sponsor/Committees/stakeholders.

• Completion and management of project documentation activities, including:

o Document Agile scrum, product backlog, and sprint backlog artifacts in Jira, MS Teams, and Smartsheet.

o Initiate Change Control Board (CCB) and new project intake requests in Smartsheet.

o Manage SDLC artifacts in accordance with State of Maryland DoIT policies/templates.

o Respond to monthly vulnerability-scan findings with remediation plans.

o Maintain the Project Management Plan, schedule, and WBS; maintain BRD, FRD, and RTM.

o Manage System Test Plans and test scripts for internal QA and stakeholder UAT.

o Maintain Operations and Maintenance Plans; update project plan with scope/task/date/resource/risks/issues changes; maintain status reports and lessons learned.

Minimum Qualifications Required:

• Bachelor’s degree in Information Systems, Computer Science, Business, Engineering, or a related field; or equivalent experience.

• 8+ years of progressive IT project management experience leading multi-vendor, multi-agency enterprise projects.

• Demonstrated experience delivering projects using Agile practices (scrum, backlog management) within a governed SDLC.

• Hands-on proficiency with Jira, Microsoft Teams, and Smartsheet for planning, tracking, collaboration, and reporting.

• Experience with change control/CCB, risk/issue management, and executive-level status reporting.

• Experience managing enterprise data collection and reporting platforms and/or cloud migration initiatives (e.g., AWS).

• Familiarity with government IT governance (e.g., State of Maryland DoIT PM artifacts/templates) and vulnerability management processes.

• Project Management Professional (PMP) or PMI-ACP (or PRINCE2 Practitioner) certification required, or equivalent demonstrable expertise.

• Excellent communication, stakeholder management, and vendor coordination skills.

(5) Job Description:

Job Title : SAP Programming Consultant

Location : Columbia, South Carolina (Onsite) (Local Only)
Duration: Long term Contract
Interview Mode: In-Person

Duties/Responsibilities:

• Actively participate in all Agile activities, including daily stand-ups, backlog refinement, sprint demos/reviews, and sprint retrospectives.

• Engage in all phases of development, including solution design, development, peer code reviews, and testing to ensure delivery of high-quality software.

• Complete assigned work items in alignment with defined acceptance criteria and the team’s Definition of Done (DoD).

• Work within the team’s DevOps model, taking full ownership of the end-to-end quality, deployment, and support of deliverables.

• Collaborate with the development team, architecture, and key stakeholders to design, enhance, and optimize both business and technical processes.

Education and Certifications:

• Bachelor’s degree in Computer Science, Information Management, or a related technical field, and at least two (2) years of experience in computer system development, maintenance, and modification;

• Five (5) years of experience in computer application system development and modification;

• Any equivalent combination of education, training, and experience that provides the required knowledge, skills, and abilities to perform the role successfully.

• AWS and/or Azure certifications demonstrating cloud development, deployment, and management expertise.

• Experience with ERP systems, including SAP, SAP S/4HANA, Ivalua, or other equivalent enterprise resource planning platforms.

Required Experience:

• Minimum of 5 years of hands-on application development experience using solid objectoriented design (OOD) principles and standards.

• Strong communication skills with the ability to work effectively in a collaborative, team-oriented Agile environment.

• 5+ years of Java web development experience, including proficiency with Spring Boot, Maven, and JUnit.

• 5+ years of experience developing containerized applications, with deep expertise in Docker.

• Proficient in using Git and applying standard branching strategies, such as GitFlow.

• 5+ years of experience designing and developing mature RESTful APIs, following best practices and security standards.

• Solid understanding of event-driven architectures and asynchronous design patterns.

• 5+ years of experience with Azure DevOps, including CI/CD pipeline development, backlog management, and release automation.

• Familiarity with and application of Test-Driven Development (TDD) principles.

• Proven experience operating within Agile development teams using Scrum and/or Kanban methodologies.

Preferred Experience:

• Experience developing cloud-native applications using Azure and/or AWS (Azure preferred).

• Hands-on experience with cloud integration services, such as Azure API Management, AWS API Gateway, Azure Event Grid, or similar tools.

• Proficiency in leveraging serverless computing services, including AWS Lambda, Azure Functions, Azure Container Apps, or AWS Fargate, for scalable application deployment.

• Experience working with managed database services, such as AWS RDS, Azure SQL Managed Instance, or equivalent cloud-hosted databases.

• Familiarity with industry-standard project management and DevOps tools, such as Azure DevOps, GitLab, or Jira.

• Understanding of and/or experience developing, integrating, or administering ERP systems, such as SAP, SAP S/4HANA, or Ivalua.