JPC 3226 - OBIA - Lead
Walnut Creek, CA

Job Description

Job Description

* Share
* Share
* Email
* Facebook
* Twitter
* Linkedin


* Print

ORACLE ETL Developer with Perl

Owings mills, Maryland - United States | Posted - 06/18/18

Apply Easy Apply

Overview

PROLIM Global Corporation (www.prolim.com) is currently seeking ORACLE ETL Developer with Perl for location Owings Mills MD for one of our Top clients.

Position: ORACLE ETL Developer with Perl

Job description

REQURIEMENTS

* 10 - 15 years of Oracle experience
* Oracle 11G
* Strong data conversion and migration through PL/SQL
* Perl scripting
* Investment, trade, mutual funds data experience
* Candidates for this role will be supporting the development and operations requirements working cohesively with other database developers/leads/subject matter experts, database administrators, architects, data quality analysts, and other teams, as well as manage client relationships within the context of an individual role.
* Significant experience & demonstrated proficiency in all aspects of database programming on Oracle SQL / PL/SQL and/or related technologies that encapsulate SQL, including Cursors, Ref-cursors, Procedures, Functions and Packages, Oracle Supplied Packages, Collections, Partitioned Tables, Triggers, Table Indexing
* Participate in meetings and discussions with Functional/Technical Leads to understand the requirements and work out a design.
* Ability to interpret the requirements and build Logical and Physical Relational Data Models
* Prepare the PL/SQL Requirements and Design documents
* Write and maintain SQL and PL/SQL stored program units/packages and maintain coding standards. Experience in Query optimization, debugging, and performance tuning for improving performance.
* Write unit tests (document and code) for the PL/SQL stored program units/packages
* Participate in code reviews and ensure the code written complies with the company standards and policies
* Interact with all levels of an organization in a professional, diplomatic, and tactful manner

NOTE:

* Scripting - Perl, Shell scripting, etc.: strong
* Scheduling - Autosys preferably: medium to strong
* IFM ETL: low to medium Investment Operations (more precisely Performance Measurement and Stats) - helpful but not mandatory.

At least 8+ years' experience, solid communication skills (oral / written), hands-on experience in SQL, PL/SQL, moderate-to-advanced performance tuning skills, data modeling, experience working in a high data volume / Operations setting in all phases of SDLC with minimal supervision.

* Write unit tests (document and code) for the PL/SQL stored program units/packages
* Oracle 11g experience is a must
* Strong PL/SQL programming skills
* Excellent SQL tuning experience
* Proven record of accomplishment working in all aspects of the software development life cycle
* Experience with UNIX and shell scripting
* Understanding of Extract/Transform/Load (ETL) processes to support Data Conversion / Migration / Consolidation
* Should have good communication and writing skills
* Candidates must be willing to work independently and/or as part of a team in an energetic, team-oriented environment managing systems of varying size/complexity with a fast turn-around time
* Apply innovation, creativity, and improvement to the development/support processes
* Ability to manage multiple priorities effectively is a necessity
* BS in Computer Science or related discipline
* Financial Services/Investments industry experience preferred

Leadership:

* Demonstrates clarity of thinking to work through limited information and vague problem definitions
* Proactively identifies and removes project obstacles or barriers on behalf of the team
* Shares knowledge, power, and credit, establishing trust, credibility, and goodwill
* Flexible, self-motivated with the ability to work under pressure in an international and culturally diverse organization
* Good motivational skills plus verbal and written communication skills, strong command of English Language
* Must be able to demonstrate guidance, control & direction, specially under pressure

Personal Attributes:

* Able to work under minimal supervision
* Excellent communication skills and the ability to interface with senior leadership with confidence and clarity
* Must have proven written documentation skills
* Able to work well with global teams, including time-zone flexibility
* Skilled in providing oversight and mentoring team members

Apply online for immediate consideration, please send your updated resume and contact info via email janeeth.kumar@prolim.com

About PROLIM Corporation

PROLIM is a leading provider of end-to-end IT, PLM and Engineering Services and Solutions for Global 1000 companies. They understand business as much as technology, and help their customers improve their profitability and efficiency by providing high value technology consulting, staffing, and project management outsourcing services.

Their IT and PLM consulting offerings include; Advisory, PLM Software/Services, Program Management, Solution Architecture Training/Staffing, Cloud Solutions, Servers/Networking, Infrastructure, ERP Practices and QA Services. Engineering services include Data Translation, CAD/CAM/CAE, Process & Product Engineering, Prototyping, and Testing/Validation within a wide range of markets and industries.