Description:

The State of Michigan is looking for: Programmer Analyst 3 

Duration: 1 year with extension possible 

Top Skills & Years of Experience:

• Resource must have a high level of SQL query writing skills to write complex queries to pull data from a Sybase and MS SQL Server database - 10 years.

• T-SQL Query Writing - 10 Years.

• Must have experience documenting and performing unit testing - 10 Years.

• PowerBuilder Development (version 7 or higher) - 5 Years.

• Experience working with source control technologies such as TFS/Azure DevOps, or GIT. - 5 Years.

Interview Process: Interviews will be held via MS Teams. Please use laptop and be prepared to share screen if asked.

Remote or On-site: Local candidates (strongly preferred) or non-local (must be willing to relocate at their own expense from acceptance with no delays & follow the hybrid schedule).

Will need to be onsite starting day 1 for hybrid work schedule which is onsite 2 days a week (Wednesdays are mandatory to be onsite. The other onsite day can be flexible.). NO REMOTE ONLY OPTION.

Please add a link to the candidate's LinkedIn profile at the top of the resume. This is required by the manager for this posting.

A cover letter that highlights the candidate's experiences and skills related to the job is required. This is separate from the SOMI coversheet and should be attached as a separate document. Please do not include any persona/contact information (phone number, address, email).

Prescreening questions are attached and are required for this posting. Please attach these to your submission.

Posting Summary: Looking for a PowerBuilder Developer and IT Analyst with a strong background specialized in PowerBuilder Development (version 7 or higher) and possess advanced skills in T-SQL query writing for Sybase and MS SQL Server databases. Day to day activities include data management, source control (TFS/Azure DevOps, GIT), unit testing, documentation, testing, production support, change management, software development and data integrity.

Minimum Qualifications:

• Some college preferably in Computer Science, Information Technology, Computer Engineering, or related IT discipline
• PowerBuilder Development (version 7 or higher)
• Work in a hybrid office
• Willingness to learn

Required Skills

Job Function

Description

Years of Experience

PowerBuilder Developer

Research and modify PowerBuilder source code to document the steps the application uses with data.

Current experience 5

T-SQL Query Writing

Resource must have a high level of SQL query writing skills to write complex queries to pull data from a Sybase and MS SQL Server database. 

Must have experience developing processes to extract and manipulate data to support data migration and data cleansing of application data.

10

Data Management

Must have experience in performing data profiling, data mapping, data manipulation, validation, and analysis.

10

Source Control

Must have experience working with source control technologies such as TFS/Azure DevOps, or GIT.

5

Unit Testing

Must have experience documenting and performing unit testing to support program changes.

10

Documentation

Must have experience creating, updating, and maintaining documentation for programs, system specs, and flow diagrams.

10

Testing

Must be able to work with the client and/or Business Analyst to support test scenarios.

5

Production Support

Analyze and document identified problems to determine root cause and provide root cause analysis.

5

Change Management

Follow change management procedures and provide input to execute changes.

5