SQL / DB2 WebQuery Conversion Report Developer
|Location||Irvine, California 92619|
|Date Posted||May 29, 2022|
|Pay rate||$40 /hour|
Great opportunity to work as an IBM Web Query Analyst/Developer for a company that has a presence in North and South America for 15 plus years being in business.
Location is in the Costa Mesa, CA area.
Position will be responsible for evaluation of SQL statements and conversion into IBM DB2 WebQuery as prompted reports. This effort is required for a project initially. But there will be need to provide ongoing support to various user groups i.e., Service Warranty, Finance, Legal, Call Center and Parts. This support will require development of additional queries for users and setting them up in IBM DB2 Web Query.
Prior experience with above mentioned user groups for query development would be a big plus.
Strong knowledge of SQL
Strong knowledge of IBM DB2 WebQuery application
Strong knowledge of IBM AS400 DB2 (stored procedures, tables/views)
IBM DB2 WebQuery conversion will range from easy, medium and complex:
Generally, less than 10 lines.
Contains joins 3 or less tables.
Uses simple summary functions (SUM, COUNT).
Uses simple filters prompted fields (EQUAL TO).
Contains joins of 3+ tables.
Contains derived fields (sub select with correlated fields).
Contains advanced filters prompted fields (NUMBER RANGES, TEXT STRING SEARCH).
Contains complex CTE - Common Table Expressions
Contains SQL DATE functions for date calculations AND prompting DATE fields.
Contains Summary functions Group By AND summary field prompting.
If qualified and interested in this opportunity, please reply to JO#6669 along with a copy of your updated resume.