Programmer Analyst 4 (Oracle and SQL Server ) Apply
<div style="text-align:start"><span style="font-size:small"><span style="color:#222222"><span style="font-family:Arial, Helvetica, sans-serif"><span style="font-style:normal"><span style="font-variant-ligatures:normal"><span style="font-weight:400"><span style="white-space:normal"><span style="background-color:#ffffff"><span style="text-decoration-thickness:initial"><span style="text-decoration-style:initial"><span style="text-decoration-color:initial"><font face="verdana, sans-serif"><b><font color="#000000"><span style="text-align:justify">Position: </span> </font>Programmer Analyst 4 (<span style="color:#000000"><span style="white-space:nowrap">Oracle and SQL Server</span></span><span style="color:#000000"><span style="white-space:nowrap"> )</span></span></b></font></span></span></span></span></span></span></span></span></span></span></span></div> <div style="text-align:start"><span style="font-size:small"><span style="color:#222222"><span style="font-family:Arial, Helvetica, sans-serif"><span style="font-style:normal"><span style="font-variant-ligatures:normal"><span style="font-weight:400"><span style="white-space:normal"><span style="background-color:#ffffff"><span style="text-decoration-thickness:initial"><span style="text-decoration-style:initial"><span style="text-decoration-color:initial"><b><font face="verdana, sans-serif"><font color="#000000"><span style="text-align:justify">REQ ID: </span> </font>107591</font></b></span></span></span></span></span></span></span></span></span></span></span></div> <div style="text-align:start"><span style="font-size:small"><span style="color:#222222"><span style="font-family:Arial, Helvetica, sans-serif"><span style="font-style:normal"><span style="font-variant-ligatures:normal"><span style="font-weight:400"><span style="white-space:normal"><span style="background-color:#ffffff"><span style="text-decoration-thickness:initial"><span style="text-decoration-style:initial"><span style="text-decoration-color:initial"><b><font face="verdana, sans-serif"><font color="#000000"><span style="text-align:justify">Direct Client: <span style="line-height:12.1267px"><span style="background-image:initial"><span style="background-position:initial"><span style="background-size:initial"><span style="background-repeat:initial"><span style="background-origin:initial"><span style="background-clip:initial"> State of Michigan - </span></span></span></span></span></span></span></span> IT - DTMB - </font>Agency Services - Treasury</font></b></span></span></span></span></span></span></span></span></span></span></span></div> <p style="text-align:start; margin-bottom:11px"><span style="font-size:small"><span style="color:#222222"><span style="font-family:Arial, Helvetica, sans-serif"><span style="font-style:normal"><span style="font-variant-ligatures:normal"><span style="font-weight:400"><span style="white-space:normal"><span style="background-color:#ffffff"><span style="text-decoration-thickness:initial"><span style="text-decoration-style:initial"><span style="text-decoration-color:initial"><span style="line-height:13.91px"><b><font face="verdana, sans-serif"><font color="#000000"><span lang="EN-US" style="line-height:13.91px"><span style="text-align:justify">Job Location: </span> </span></font>7285 Parsons Dr., Dimondale, MI, 48821</font></b></span></span></span></span></span></span></span></span></span></span></span></span></p> <p style="text-align:start; margin-bottom:11px"><span style="font-size:small"><span style="color:#222222"><span style="font-family:Arial, Helvetica, sans-serif"><span style="font-style:normal"><span style="font-variant-ligatures:normal"><span style="font-weight:400"><span style="white-space:normal"><span style="background-color:#ffffff"><span style="text-decoration-thickness:initial"><span style="text-decoration-style:initial"><span style="text-decoration-color:initial"><span style="line-height:13.91px"><font face="verdana, sans-serif">Must be able to come onsite 2x a week to Dimondale location from day 1<br /> Local and Non Local may apply</font></span></span></span></span></span></span></span></span></span></span></span></span></p> <p style="text-align:start; margin-bottom:11px"><span style="font-size:small"><span style="color:#222222"><span style="font-family:Arial, Helvetica, sans-serif"><span style="font-style:normal"><span style="font-variant-ligatures:normal"><span style="font-weight:400"><span style="white-space:normal"><span style="background-color:#ffffff"><span style="text-decoration-thickness:initial"><span style="text-decoration-style:initial"><span style="text-decoration-color:initial"><span style="line-height:13.91px"><font face="verdana, sans-serif"><b>Role Description:</b></font></span></span></span></span></span></span></span></span></span></span></span></span></p> <p style="text-align:start; margin-bottom:11px"><span style="font-size:small"><span style="color:#222222"><span style="font-family:Arial, Helvetica, sans-serif"><span style="font-style:normal"><span style="font-variant-ligatures:normal"><span style="font-weight:400"><span style="white-space:normal"><span style="background-color:#ffffff"><span style="text-decoration-thickness:initial"><span style="text-decoration-style:initial"><span style="text-decoration-color:initial"><span style="line-height:13.91px"><font face="verdana, sans-serif">This position is responsible for special duties on Treasury's project to replace the legacy mainframe with SAP. Duties include loading data into SAP and modifying data for testing in an interface application. The analyst will validate data scrambling in the test databases, write scripts that will create data in interface applications, create mock files for interface data loads, and query Oracle databases to profile current data. A strong foundational understanding of querying data, creating programs to create and validate data, and database structure are required.</font></span></span></span></span></span></span></span></span></span></span></span></span></p> <p style="text-align:start; margin-bottom:11px"><span style="font-size:small"><span style="color:#222222"><span style="font-family:Arial, Helvetica, sans-serif"><span style="font-style:normal"><span style="font-variant-ligatures:normal"><span style="font-weight:400"><span style="white-space:normal"><span style="background-color:#ffffff"><span style="text-decoration-thickness:initial"><span style="text-decoration-style:initial"><span style="text-decoration-color:initial"><span style="line-height:13.91px"><font face="verdana, sans-serif">This person should possess strong attention to detail, follow processes exactly, and precisely follow security guidelines. These activities will be done in a fast-paced environment with quick turnaround and high pressure.</font></span></span></span></span></span></span></span></span></span></span></span></span></p> <p style="text-align:start; margin-bottom:11px"><span style="font-size:small"><span style="color:#222222"><span style="font-family:Arial, Helvetica, sans-serif"><span style="font-style:normal"><span style="font-variant-ligatures:normal"><span style="font-weight:400"><span style="white-space:normal"><span style="background-color:#ffffff"><span style="text-decoration-thickness:initial"><span style="text-decoration-style:initial"><span style="text-decoration-color:initial"><span style="line-height:13.91px"><font face="verdana, sans-serif">During the interview, a demonstration of writing a basic PSQL query will be required.</font></span></span></span></span></span></span></span></span></span></span></span></span></p> <table style="color:#222222; font-family:Arial, Helvetica, sans-serif; font-size:small; font-style:normal; font-variant-ligatures:normal; font-weight:400; text-align:start; white-space:normal; background-color:#ffffff; text-decoration-thickness:initial; text-decoration-style:initial; text-decoration-color:initial; border-collapse:collapse; width:615px" width="614"> <colgroup> <col style="width:461pt" width="614" /> </colgroup> <tbody> <tr> <td style="border-bottom:none; height:20px; width:614px; padding-top:1px; padding-right:1px; padding-left:1px; vertical-align:bottom; white-space:nowrap; background-color:#ffffff; border-top:none; border-right:none; border-left:none"><span style="font-family:Roboto,RobotoDraft,Helvetica,Arial,sans-serif"><span style="color:black"><font face="verdana, sans-serif">Responsibilities:</font></span></span></td> </tr> <tr> <td style="border-bottom:none; height:20px; padding-top:1px; padding-right:1px; padding-left:1px; vertical-align:bottom; white-space:nowrap; background-color:#ffffff; border-top:none; border-right:none; border-left:none"><span style="font-family:Roboto,RobotoDraft,Helvetica,Arial,sans-serif"><span style="color:black"><font face="verdana, sans-serif">• Create and modify test data.</font></span></span></td> </tr> <tr> <td style="border-bottom:none; height:20px; padding-top:1px; padding-right:1px; padding-left:1px; vertical-align:bottom; white-space:nowrap; background-color:#ffffff; border-top:none; border-right:none; border-left:none"><span style="font-family:Roboto,RobotoDraft,Helvetica,Arial,sans-serif"><span style="color:black"><font face="verdana, sans-serif">• Create data files.</font></span></span></td> </tr> <tr> <td style="border-bottom:none; height:20px; padding-top:1px; padding-right:1px; padding-left:1px; vertical-align:bottom; white-space:nowrap; background-color:#ffffff; border-top:none; border-right:none; border-left:none"><span style="font-family:Roboto,RobotoDraft,Helvetica,Arial,sans-serif"><span style="color:black"><font face="verdana, sans-serif">• Validate data has been scrambled using SQL.</font></span></span></td> </tr> <tr> <td style="border-bottom:none; height:20px; padding-top:1px; padding-right:1px; padding-left:1px; vertical-align:bottom; white-space:nowrap; background-color:#ffffff; border-top:none; border-right:none; border-left:none"><span style="font-family:Roboto,RobotoDraft,Helvetica,Arial,sans-serif"><span style="color:black"><font face="verdana, sans-serif">• Consistently provide high-quality queries with results in various formats (spreadsheets, visual</font></span></span></td> </tr> <tr> <td style="border-bottom:none; height:20px; padding-top:1px; padding-right:1px; padding-left:1px; vertical-align:bottom; white-space:nowrap; background-color:#ffffff; border-top:none; border-right:none; border-left:none"><span style="font-family:Roboto,RobotoDraft,Helvetica,Arial,sans-serif"><span style="color:black"><font face="verdana, sans-serif">tables).</font></span></span></td> </tr> <tr> <td style="border-bottom:none; height:20px; padding-top:1px; padding-right:1px; padding-left:1px; vertical-align:bottom; white-space:nowrap; background-color:#ffffff; border-top:none; border-right:none; border-left:none"><span style="font-family:Roboto,RobotoDraft,Helvetica,Arial,sans-serif"><span style="color:black"><font face="verdana, sans-serif">• Create queries for data analysis and profiling.</font></span></span></td> </tr> <tr> <td style="border-bottom:none; height:20px; padding-top:1px; padding-right:1px; padding-left:1px; vertical-align:bottom; white-space:nowrap; background-color:#ffffff; border-top:none; border-right:none; border-left:none"> </td> </tr> </tbody> </table> <table style="color:#222222; font-family:Arial, Helvetica, sans-serif; font-size:small; font-style:normal; font-variant-ligatures:normal; font-weight:400; text-align:start; white-space:normal; background-color:#ffffff; text-decoration-thickness:initial; text-decoration-style:initial; text-decoration-color:initial; border-collapse:collapse; width:859px" width="858"> <colgroup> <col style="width:461pt" width="614" /> <col style="width:99pt" width="132" /> <col style="width:84pt" width="112" /> </colgroup> <tbody> <tr> <td style="border-bottom:1px solid black; height:20px; width:614px; padding-top:1px; padding-right:1px; padding-left:1px; vertical-align:bottom; white-space:nowrap; background-color:#ffffff; border-top:1px solid black; border-right:1px solid black; border-left:1px solid black"><span style="font-family:Roboto,RobotoDraft,Helvetica,Arial,sans-serif"><span style="font-weight:700"><span style="color:black"><font face="verdana, sans-serif">Skills:</font></span></span></span></td> <td style="border-bottom:1px solid black; width:132px; padding-top:1px; padding-right:1px; padding-left:1px; vertical-align:bottom; white-space:nowrap; background-color:#ffffff; border-top:1px solid black; border-right:1px solid black; border-left:none"><span style="font-family:Roboto,RobotoDraft,Helvetica,Arial,sans-serif"><span style="font-weight:700"><span style="color:black"><font face="verdana, sans-serif"> </font></span></span></span></td> <td style="border-bottom:1px solid black; width:112px; padding-top:1px; padding-right:1px; padding-left:1px; vertical-align:bottom; white-space:nowrap; background-color:#ffffff; border-top:1px solid black; border-right:1px solid black; border-left:none"><span style="font-family:Roboto,RobotoDraft,Helvetica,Arial,sans-serif"><span style="font-weight:700"><span style="color:black"><font face="verdana, sans-serif">Experience </font></span></span></span></td> </tr> <tr> <td style="border-bottom:1px solid black; height:20px; padding-top:1px; padding-right:1px; padding-left:1px; vertical-align:bottom; white-space:nowrap; background-color:#ffffff; border-top:none; border-right:1px solid black; border-left:1px solid black"><span style="font-family:Roboto,RobotoDraft,Helvetica,Arial,sans-serif"><span style="color:black"><font face="verdana, sans-serif">Experience with querying databases such as Oracle and SQL Server </font></span></span></td> <td style="border-bottom:1px solid black; padding-top:1px; padding-right:1px; padding-left:1px; vertical-align:bottom; white-space:nowrap; background-color:#ffffff; border-top:none; border-right:1px solid black; border-left:none"><span style="font-family:Roboto,RobotoDraft,Helvetica,Arial,sans-serif"><span style="color:black"><font face="verdana, sans-serif">required 5 years</font></span></span></td> <td style="border-bottom:1px solid black; padding-top:1px; padding-right:1px; padding-left:1px; vertical-align:bottom; white-space:nowrap; background-color:#ffffff; border-top:none; border-right:1px solid black; border-left:none"><span style="font-family:Roboto,RobotoDraft,Helvetica,Arial,sans-serif"><span style="color:black"><font face="verdana, sans-serif"> </font></span></span></td> </tr> <tr> <td style="border-bottom:1px solid black; height:20px; padding-top:1px; padding-right:1px; padding-left:1px; vertical-align:bottom; white-space:nowrap; background-color:#ffffff; border-top:none; border-right:1px solid black; border-left:1px solid black"><span style="font-family:Roboto,RobotoDraft,Helvetica,Arial,sans-serif"><span style="color:black"><font face="verdana, sans-serif">Ability to create reports, and display them in a visual manner for easy consumption </font></span></span></td> <td style="border-bottom:1px solid black; padding-top:1px; padding-right:1px; padding-left:1px; vertical-align:bottom; white-space:nowrap; background-color:#ffffff; border-top:none; border-right:1px solid black; border-left:none"><span style="font-family:Roboto,RobotoDraft,Helvetica,Arial,sans-serif"><span style="color:black"><font face="verdana, sans-serif">required 5 years</font></span></span></td> <td style="border-bottom:1px solid black; padding-top:1px; padding-right:1px; padding-left:1px; vertical-align:bottom; white-space:nowrap; background-color:#ffffff; border-top:none; border-right:1px solid black; border-left:none"><span style="font-family:Roboto,RobotoDraft,Helvetica,Arial,sans-serif"><span style="color:black"><font face="verdana, sans-serif"> </font></span></span></td> </tr> <tr> <td style="border-bottom:1px solid black; height:20px; padding-top:1px; padding-right:1px; padding-left:1px; vertical-align:bottom; white-space:nowrap; background-color:#ffffff; border-top:none; border-right:1px solid black; border-left:1px solid black"><span style="font-family:Roboto,RobotoDraft,Helvetica,Arial,sans-serif"><span style="color:black"><font face="verdana, sans-serif">Software testing in SAP </font></span></span></td> <td style="border-bottom:1px solid black; padding-top:1px; padding-right:1px; padding-left:1px; vertical-align:bottom; white-space:nowrap; background-color:#ffffff; border-top:none; border-right:1px solid black; border-left:none"><span style="font-family:Roboto,RobotoDraft,Helvetica,Arial,sans-serif"><span style="color:black"><font face="verdana, sans-serif">required 2 years</font></span></span></td> <td style="border-bottom:1px solid black; padding-top:1px; padding-right:1px; padding-left:1px; vertical-align:bottom; white-space:nowrap; background-color:#ffffff; border-top:none; border-right:1px solid black; border-left:none"><span style="font-family:Roboto,RobotoDraft,Helvetica,Arial,sans-serif"><span style="color:black"><font face="verdana, sans-serif"> </font></span></span></td> </tr> <tr> <td style="border-bottom:1px solid black; height:20px; padding-top:1px; padding-right:1px; padding-left:1px; vertical-align:bottom; white-space:nowrap; background-color:#ffffff; border-top:none; border-right:1px solid black; border-left:1px solid black"><span style="font-family:Roboto,RobotoDraft,Helvetica,Arial,sans-serif"><span style="color:black"><font face="verdana, sans-serif">Create mocked-up data files </font></span></span></td> <td style="border-bottom:1px solid black; padding-top:1px; padding-right:1px; padding-left:1px; vertical-align:bottom; white-space:nowrap; background-color:#ffffff; border-top:none; border-right:1px solid black; border-left:none"><span style="font-family:Roboto,RobotoDraft,Helvetica,Arial,sans-serif"><span style="color:black"><font face="verdana, sans-serif">3 years</font></span></span></td> <td style="border-bottom:1px solid black; padding-top:1px; padding-right:1px; padding-left:1px; vertical-align:bottom; white-space:nowrap; background-color:#ffffff; border-top:none; border-right:1px solid black; border-left:none"><span style="font-family:Roboto,RobotoDraft,Helvetica,Arial,sans-serif"><span style="color:black"><font face="verdana, sans-serif"> </font></span></span></td> </tr> <tr> <td style="border-bottom:1px solid black; height:20px; padding-top:1px; padding-right:1px; padding-left:1px; vertical-align:bottom; white-space:nowrap; background-color:#ffffff; border-top:none; border-right:1px solid black; border-left:1px solid black"><span style="font-family:Roboto,RobotoDraft,Helvetica,Arial,sans-serif"><span style="color:black"><font face="verdana, sans-serif">Effective communication skills to coordinate with the team about status and issues </font></span></span></td> <td style="border-bottom:1px solid black; padding-top:1px; padding-right:1px; padding-left:1px; vertical-align:bottom; white-space:nowrap; background-color:#ffffff; border-top:none; border-right:1px solid black; border-left:none"><span style="font-family:Roboto,RobotoDraft,Helvetica,Arial,sans-serif"><span style="color:black"><font face="verdana, sans-serif">required 5</font></span></span></td> <td style="border-bottom:1px solid black; padding-top:1px; padding-right:1px; padding-left:1px; vertical-align:bottom; white-space:nowrap; background-color:#ffffff; border-top:none; border-right:1px solid black; border-left:none"><span style="font-family:Roboto,RobotoDraft,Helvetica,Arial,sans-serif"><span style="color:black"><font face="verdana, sans-serif"> </font></span></span></td> </tr> </tbody> </table> <div style="text-align:start"> <div data-smartmail="gmail_signature" dir="ltr"> <div dir="ltr"> <div> </div> <div dir="ltr"><span style="font-size:small"><span style="color:#222222"><span style="font-family:Arial, Helvetica, sans-serif"><span style="font-style:normal"><span style="font-variant-ligatures:normal"><span style="font-weight:400"><span style="white-space:normal"><span style="background-color:#ffffff"><span style="text-decoration-thickness:initial"><span style="text-decoration-style:initial"><span style="text-decoration-color:initial"><font face="verdana, sans-serif"><font style="background-color:#ffffff"><b><font color="#c27ba0"><span style="color:#222222"><span style="font-weight:400">Interviews: MS TEAMS/Video with the camera on and integrated audio used. </span></span><br style="color:#222222; font-weight:400" /> <span style="color:#222222"><span style="font-weight:400">Duration: until 9/30; extension likely</span></span></font></b></font></font></span></span></span></span></span></span></span></span></span></span></span></div> </div> </div> </div>
