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

Oracle SQL Developer - Programmer Analyst 4

In United States

Save this job

Oracle SQL Developer - Programmer Analyst 4   

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

JOB TITLE:

Oracle SQL Developer - Programmer Analyst 4

JOB TYPE:

JOB SKILLS:

JOB LOCATION:

Lansing, MI United States

JOB DESCRIPTION:

108638--Lansing, MI - IT - DTMB - Agency Services - Treasury - Programmer Analyst 4 -- (Software testing in SAP)

Position: Programmer Analyst 4--( Software testing in SAP)
 
Position location:7285 Parsons Dr., Dimondale, MI, 48821
 
Interviews: MS TEAMS/Video with camera on and integrated audio used.
Duration: until 9/30; extension likely

Must be able to come onsite 2x a week to Dimondale location from day 1
 
JOB DESCRIPTION:
 

Requirements:

Supporting the Department of Treasury, the elected person will need to be fingerprinted in addition to the State of Michigan background check. 

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

 

Skills:

• Experience with querying databases such as Oracle and SQL Server – required 5 years

• Ability to create reports, display in 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 team about status and issues – required 5 years

 

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.

 

CLIENT SKILL MATRIX:

Top Skills Candidate years of experience


• Experience with querying databases such as Oracle and SQL Server – 
• Ability to create reports, display in visual manner for easy consumption – 
• Software testing in SAP –
• Create mocked up data files – 
• Effective communication skills to coordinate with team about status and issues – 

 

Position Details

POSTED:

Jan 17, 2023

EMPLOYMENT:

INDUSTRY:

SNAPRECRUIT ID:

S16619904338943369

LOCATION:

United States

CITY:

Lansing, MI

Job Origin:

OORWIN_ORGANIC_FEED

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

Oracle SQL Developer - Programmer Analyst 4    Apply

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

<h2 data-legacy-thread-id="182f4dc4175d5653" data-thread-perm-id="thread-a:r9210862592045714903" id=":11w" tabindex="-1"><span style="font-size:12px;">108638--Lansing, MI - IT - DTMB - Agency Services - Treasury - Programmer Analyst 4 -- (Software testing in SAP)</span></h2> <div><font color="#000000">Position: Programmer Analyst 4--( </font>Software testing in SAP)</div> <div> </div> <div><font color="#000000">Position location:7285 Parsons Dr., Dimondale, MI, 48821</font></div> <div> </div> <div><font color="#000000">Interviews: MS TEAMS/Video with camera on and integrated audio used. </font><br /> <font color="#000000">Duration: until 9/30; extension likely</font><br /> <br /> <b><font color="#660000">Must be able to come onsite 2x a week to Dimondale location from day 1</font></b><br /> </div> <div> </div> <div><b><font color="#ff0000">JOB DESCRIPTION:</font></b></div> <div> </div> <div> <p style="margin-bottom:11px"><span style="font-size:11pt"><span style="line-height:15.6933px"><span style="font-family:Calibri, "sans-serif"">Requirements:</span></span></span></p> <p style="margin-bottom:11px"><span style="font-size:11pt"><span style="line-height:15.6933px"><span style="font-family:Calibri, "sans-serif"">Supporting the Department of Treasury, the elected person will need to be fingerprinted in addition to the State of Michigan background check. </span></span></span></p> <p style="margin-bottom:11px"><span style="font-size:11pt"><span style="line-height:15.6933px"><span style="font-family:Calibri, "sans-serif"">Role Description:</span></span></span></p> <p style="margin-bottom:11px"><span style="font-size:11pt"><span style="line-height:15.6933px"><span style="font-family:Calibri, "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 is required.</span></span></span></p> <p style="margin-bottom:11px"><span style="font-size:11pt"><span style="line-height:15.6933px"><span style="font-family:Calibri, "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.</span></span></span></p> <p style="margin-bottom:11px"><span style="font-size:11pt"><span style="line-height:15.6933px"><span style="font-family:Calibri, "sans-serif"">During the interview, a demonstration of writing a basic PSQL query will be required.</span></span></span></p> <p style="margin-bottom:11px"><span style="font-size:11pt"><span style="line-height:15.6933px"><span style="font-family:Calibri, "sans-serif""> </span></span></span></p> <p style="margin-bottom:11px"><span style="font-size:11pt"><span style="line-height:15.6933px"><span style="font-family:Calibri, "sans-serif"">Skills:</span></span></span></p> <p style="margin-bottom:11px"><span style="font-size:11pt"><span style="line-height:15.6933px"><span style="font-family:Calibri, "sans-serif"">• Experience with querying databases such as Oracle and SQL Server – required 5 years</span></span></span></p> <p style="margin-bottom:11px"><span style="font-size:11pt"><span style="line-height:15.6933px"><span style="font-family:Calibri, "sans-serif"">• Ability to create reports, display in visual manner for easy consumption – required 5 years</span></span></span></p> <p style="margin-bottom:11px"><span style="font-size:11pt"><span style="line-height:15.6933px"><span style="font-family:Calibri, "sans-serif"">• Software testing in SAP – required 2 years</span></span></span></p> <p style="margin-bottom:11px"><span style="font-size:11pt"><span style="line-height:15.6933px"><span style="font-family:Calibri, "sans-serif"">• Create mocked up data files – 3 years</span></span></span></p> <p style="margin-bottom:11px"><span style="font-size:11pt"><span style="line-height:15.6933px"><span style="font-family:Calibri, "sans-serif"">• Effective communication skills to coordinate with team about status and issues – required 5 years</span></span></span></p> <p style="margin-bottom:11px"><span style="font-size:11pt"><span style="line-height:15.6933px"><span style="font-family:Calibri, "sans-serif""> </span></span></span></p> <p style="margin-bottom:11px"><span style="font-size:11pt"><span style="line-height:15.6933px"><span style="font-family:Calibri, "sans-serif"">Responsibilities:</span></span></span></p> <p style="margin-bottom:11px"><span style="font-size:11pt"><span style="line-height:15.6933px"><span style="font-family:Calibri, "sans-serif"">• Create and modify test data.</span></span></span></p> <p style="margin-bottom:11px"><span style="font-size:11pt"><span style="line-height:15.6933px"><span style="font-family:Calibri, "sans-serif"">• Create data files.</span></span></span></p> <p style="margin-bottom:11px"><span style="font-size:11pt"><span style="line-height:15.6933px"><span style="font-family:Calibri, "sans-serif"">• Validate data has been scrambled using SQL.</span></span></span></p> <p style="margin-bottom:11px"><span style="font-size:11pt"><span style="line-height:15.6933px"><span style="font-family:Calibri, "sans-serif"">• Consistently provide high quality queries with results in various formats (spreadsheets, visual tables).</span></span></span></p> <p style="margin-bottom:11px"><span style="font-size:11pt"><span style="line-height:15.6933px"><span style="font-family:Calibri, "sans-serif"">• Create queries for data analysis and profiling.</span></span></span></p> <p style="margin-bottom:11px"> </p> <p style="margin-bottom:11px"><span style="font-size:11pt"><span style="line-height:15.6933px"><span style="font-family:Calibri, "sans-serif""><b><font color="#660000">CLIENT SKILL MATRIX:</font></b></span></span></span></p> <p style="margin-bottom:11px"><span style="font-size:11pt"><span style="line-height:15.6933px"><span style="font-family:Calibri, "sans-serif""><span style="font-size:small"><span style="font-family:Arial, Helvetica, sans-serif"><b><font color="#660000">Top Skills Candidate years of experience</font></b></span></span></span></span></span></p> <p style="margin-bottom:11px"><br style="font-family:Arial, Helvetica, sans-serif; font-size:small" /> <span style="font-size:11pt"><span style="line-height:15.6933px"><span style="font-family:Calibri, "sans-serif""><span style="font-size:small"><span style="font-family:Arial, Helvetica, sans-serif">• Experience with querying databases such as Oracle and SQL Server – </span></span><br style="font-family:Arial, Helvetica, sans-serif; font-size:small" /> <span style="font-size:small"><span style="font-family:Arial, Helvetica, sans-serif">• Ability to create reports, display in visual manner for easy consumption – </span></span><br style="font-family:Arial, Helvetica, sans-serif; font-size:small" /> <span style="font-size:small"><span style="font-family:Arial, Helvetica, sans-serif">• Software testing in SAP –</span></span><br style="font-family:Arial, Helvetica, sans-serif; font-size:small" /> <span style="font-size:small"><span style="font-family:Arial, Helvetica, sans-serif">• Create mocked up data files – </span></span><br style="font-family:Arial, Helvetica, sans-serif; font-size:small" /> <span style="font-size:small"><span style="font-family:Arial, Helvetica, sans-serif">• Effective communication skills to coordinate with team about status and issues – </span></span></span></span></span></p> </div> <div> </div>


Please wait..!!