• 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 SQL Developer)

In United States

Save this job

Programmer Analyst 4 (Oracle SQL Developer)   

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

JOB TITLE:

Programmer Analyst 4 (Oracle SQL Developer)

JOB TYPE:

JOB SKILLS:

JOB LOCATION:

Lansing, MI United States

JOB DESCRIPTION:

Job Title: Programmer Analyst 4 (Oracle SQL Developer)--108638

Location: Lansing, MI

Direct Client: State of Michigan-DTMB

Experience: 8+



Interviews: MS TEAMS/Video with camera on and integrated audio used.
Duration: until 9/30; extension likely


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


Please fill the below Client side Skill matrix:

 

Skills Consultant years of Experience


• 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

 

JOB 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

Position Details

POSTED:

Jan 17, 2023

EMPLOYMENT:

INDUSTRY:

SNAPRECRUIT ID:

S16619904339083372

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!

Programmer Analyst 4 (Oracle SQL Developer)    Apply

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

<p><b>Job Title: Programmer Analyst 4 (Oracle SQL Developer)--108638</b></p> <p><b>Location: Lansing, MI</b></p> <p><b>Direct Client: State of Michigan-DTMB</b></p> <p><b>Experience: 8+</b></p> <p><br /> <br /> <b>Interviews: MS TEAMS/Video with camera on and integrated audio used. <br /> Duration: until 9/30; extension likely</b><br /> <br /> During the interview, a demonstration of writing a basic PSQL query will be required.</p> <p><br /> <b>Please fill the below Client side Skill matrix:</b></p> <p> </p> <p><b>Skills Consultant years of Experience</b></p> <p><br /> • Experience with querying databases such as Oracle and SQL Server – required 5 years<br /> • Ability to create reports, display in visual manner for easy consumption – required 5 years<br /> • Software testing in SAP – required 2 years<br /> • Create mocked up data files – 3 years<br /> • Effective communication skills to coordinate with team about status and issues – required 5 years </p> <p> </p> <p><b>JOB DESCRIPTION:</b><br /> </p> <p>This position is responsible for special duties on Treasury's project to replace the legacy mainframe with<br /> SAP. Duties include loading data into SAP and modifying data for testing in an interface application. The<br /> analyst will validate data scrambling in the test databases, write scripts that will create data in interface<br /> applications, create mock files for interface data loads, and query Oracle databases to profile current<br /> data. A strong foundational understanding of querying data, creating programs to create and validate<br /> data, and database structure is required.<br /> This person should possess strong attention to detail, follow processes exactly, and precisely follow<br /> security guidelines. These activities will be done in a fast-paced environment with quick turnaround and<br /> high pressure.<br /> During the interview, a demonstration of writing a basic PSQL query will be required.<br /> <br /> <strong>Skills:</strong><br /> • Experience with querying databases such as Oracle and SQL Server – required 5 years<br /> • Ability to create reports, display in visual manner for easy consumption – required 5 years<br /> • Software testing in SAP – required 2 years<br /> • Create mocked up data files – 3 years<br /> • Effective communication skills to coordinate with team about status and issues – required 5<br /> years<br /> <br /> <strong>Responsibilities:</strong><br /> • Create and modify test data.<br /> • Create data files.<br /> • Validate data has been scrambled using SQL.<br /> • Consistently provide high quality queries with results in various formats (spreadsheets, visual<br /> tables).<br /> • Create queries for data analysis and profiling</p>


Please wait..!!