Job PostingJob: Lansing, MI - IT - DTMB - Agency Services - DOC - Programmer Analyst 3 - PowerBuilder DeveloperLocation: Lansing, MI 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).Client: State of MIType: C2C/W2Q1 one-page cover letter that highlights the candidate's experiences and skills related to the job is required.The State of Michigan is looking for: Programmer Analyst 3Will close to submissions on 2/14 @ 10am ESTDuration: 1 year with extension possibleTop 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.Full job description attached.Interview Process: In-person. Candidates must be available for an in-person interview.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.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 disciplinePowerBuilder Development (version 7 or higher)Work in a hybrid officeWillingness to learnRequired SkillsJob Function - Description - Years of ExperiencePowerBuilder Developer - Research and modify PowerBuilder source code to document the steps the application uses with data. - Current experience 5T-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.
- 10Data Management - Must have experience in performing data profiling, data mapping, data manipulation, validation, and analysis. - 10Source Control - Must have experience working with source control technologies such as TFS/Azure DevOps, or GIT. - 5Unit Testing - Must have experience documenting and performing unit testing to support program changes. - 10Documentation - Must have experience creating, updating, and maintaining documentation for programs, system specs, and flow diagrams.
- 10Testing - Must be able to work with the client and/or Business Analyst to support test scenarios. - 5Production Support - Analyze and document identified problems to determine root cause and provide root cause analysis. - 5Change Management - Follow change management procedures and provide input to execute changes.