Oracle PLSQL & SQL Server ETL Developer (ERWIN Data Modeling, Linux Shell Scripting)

Albany, GA - USA

Monthly Salary: Not Disclosed

Posted on: 8 hours ago

Vacancies: 1 Vacancy

Job Summary

Title: Oracle PL/SQL & SQL Server ETL Developer (ERWIN Data Modeling Linux Shell Scripting)

Location: Hybrid - Albany NY 12210

Experience: min 12 Yr (5 yr in USA)

Duration:30 months

Contract: C2C

Interview Mode: Video

State Client: NYS

Note: The Passport Details & 3 Official References are mandatory for all the applicants including GC. The H1B candidate is required to submit a previous stamping/ead copy as well.(non-negotiable)

Job Description:

Minimum Qualifications:

84 months experiencecreating Views Triggers stored procedures functions andwriting SQLinOracle (12c or higher)andSQL Server (2014 or higher).
84 months of experience usingdata modelingtools such asERWINto createphysicalandlogical data modelsreverse engineer existing databases andcompare existing databasesinSQL Server (2014 or higher)andOracle (12c or higher).
84 months of experiencedeveloping complex ETL processesusingshell scripts (Korn Bash and Power Shell) SQL scripts PL/SQL and T-SQL objects.
84 months of experienceperforming data analysisandcreating reports for customers.
84 months of experienceoptimizing SQL queriesanddebugging PL/SQL packages functions andprocedures.
60 months of experiencedeveloping Korn shellandbash shell scriptsin aLinux environment.

This individual will be expected to participate in the following activities:
Implementing Integrated Justice Portal standards related to database development
Utilize uses cases business requirements documents and flow diagrams to design complex relational databases
Follow all phases of the Software Development Life Cycle (SDLC) - analysis design testing implementation maintenance
Follow and contribute to agency standards and utilize industry best practices
Develop queries and stored procedures for data extraction using SQL and one or more relational databases such as Oracle or SQL Server; write complex efficient SQL
Perform ongoing support for production applications - including system monitoring processing user support and performance tuning
Create maintain and deploy batch processes to support portfolio business processes
Research emerging technologies to improve current processes.

Required Skills:

ErwinPL/SQLETL

Title: Oracle PL/SQL & SQL Server ETL Developer (ERWIN Data Modeling Linux Shell Scripting) Location: Hybrid - Albany NY 12210 Experience: min 12 Yr (5 yr in USA) Duration:30 months Contract: C2C Interview Mode: Video State Client: NYS Note: The Passport Details & 3 Official References are mandator...