Oracle PL/SQL DeveloperLocation: Owings Mills MD Rate: DOE $/hr. Position Type: Contract Interview Process: Phone Followed by F2F US Citizen, Green Card and GC EADJob Description:Over 7 years of programming experience as an Oracle PL/SQL Developer in Analysis, Design and Implementation of Business Applications using the Oracle Relational Database Management System (RDBMS). Financial experience Involved in Agile methodology by analyzing business requirements and understanding the functional work flow of information from source systems to destination systems, completed work through Sprints Involved in all phases of the SDLC (Software Development Life Cycle) from analysis, design, development, testing, implementation and maintenance with timely delivery against aggressive deadlines.
Experience with Data flow diagrams, Data dictionary, Database normalization theory techniques, Entity relation modeling and design techniques. Expertise in Client-Server application development using Oracle 11g/10g/9i/8i, PL/SQL, SQL *PLUS, TOAD and SQL*LOADER. Effectively made use of Table Functions, Indexes, Table Partitioning, Collections, Analytical functions, Materialized Views, Query Re-Write and Transportable table spaces. Programmer Analyst creates and maintains moderate to highly complex technical solutions based on their translation of business requirements and unit tests solutions to ensure proper functionality for business use. Creates technical specifications and design documents from which programs and applications are developed. Designs solutions and estimates the effort required to complete complex, moderate to large scale projects based on detailed analysis of requirements. Collaborates within their team to provide status updates, discuss issues and ensure technical solutions will work within the existing architecture. Mentors less experienced technical staff including other Programmer Analysts and Information Technology Associates. Supports systems by diagnosing, isolating, and de-bugging issues and performing problem resolution. Documents resolutions appropriatelyTechnical Skills:Databases: Oracle 7.x/8i/9i/10g/11g (SQL, PL/SQL, Stored Procedures, Triggers), MS SQL SERVER 2000/2005/2008, DB2/UDB, Teradata, SAP Tables and MS Access.ETL Tools: Informatica (PowerCenter 5.1/6.2/7.1/8.6.1/9.1.0, PowerMart 5.1, Power Connect/Power Exchange for SAP R/3, MainFrame and Oracle Change Data Capture (CDC), AB Initio 1.8 and SQL*Loader.Reporting Tools: Business Objects Developer Suite 5.1/BO XIR2, Cognos Suite, Cognos Report Net 1.1MR2, Crystal Reports, Oracle Reports 2.5Operating Systems: UNIX(Sun Solaris, LINUX, Client UNIX, AIX), Windows NT/98/95/2000 & Windows XP.Data Modeling: Erwin 3.5.2,4.0Languages/Utilities: SQL, PL/SQL, Unix shell scripts, Java, XML, C and Cobol.Other Tools: AutoSys, Control-M, PVCS, WIN CVS, Informatica Data Quality, B2B Data Transformation, Informatica Power Exchange Informatica 9.1.0 Developer/Analyst, TPump, Fast Load, BTEQ