• Snapboard
  • Activity
  • Reports
  • Campaign
Welcome ,

Chat with the recruiter

...Minimize

Hey I'm Online! Leave me a message.
Let me know if you have any questions.

Programmer Analyst 4 (Oracle and SQL Server )

In United States

Save this job

Programmer Analyst 4 (Oracle and SQL Server )   

Click on the below icons to share this job to Linkedin, Twitter!

JOB TITLE:

Programmer Analyst 4 (Oracle and SQL Server )

JOB TYPE:

JOB SKILLS:

JOB LOCATION:

Dimondale, MI United States

JOB DESCRIPTION:

Position:  Programmer Analyst 4 (Oracle and SQL Server )
REQ ID:  107591
Direct Client:  State of Michigan -  IT - DTMB - Agency Services - Treasury

Job Location:  7285 Parsons Dr., Dimondale, MI, 48821

Must be able to come onsite 2x a week to Dimondale location from day 1
Local and Non Local may apply

Role Description:

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.

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.

During the interview, a demonstration of writing a basic PSQL query will be required.

Responsibilities:
• Create and modify test data.
• Create data files.
• Validate data has been scrambled using SQL.
• Consistently provide high-quality queries with results in various formats (spreadsheets, visual
tables).
• Create queries for data analysis and profiling.
 
Skills:   Experience 
Experience with querying databases such as Oracle and SQL Server  required 5 years  
Ability to create reports, and display them in a visual manner for easy consumption  required 5 years  
Software testing in SAP  required 2 years  
Create mocked-up data files  3 years  
Effective communication skills to coordinate with the team about status and issues  required 5  
 
Interviews: MS TEAMS/Video with the camera on and integrated audio used.
Duration: until 9/30; extension likely

Position Details

POSTED:

Jan 17, 2023

EMPLOYMENT:

INDUSTRY:

SNAPRECRUIT ID:

S16619904323533084

LOCATION:

United States

CITY:

Dimondale, MI

Job Origin:

OORWIN_ORGANIC_FEED

A job sourcing event
In Dallas Fort Worth
Aug 19, 2017 9am-6pm
All job seekers welcome!

Programmer Analyst 4 (Oracle and SQL Server )    Apply

Click on the below icons to share this job to Linkedin, Twitter!

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


Please wait..!!