Client is Health Care Company.
NOTE: FACE TO FACE INTERVIEW IS PREFERRED BUT AT MINIMUM A VIDEO INTERVIEW WILL BE REQUIRED
We need an Oracle Database Developer with strong experience in PL/SQL for a 6+ month contract-to-hire role with a major Healthcare client in Las Vegas, NV.
*** MUST have experience with PL/SQL, T-SQL, DTS and SSIS.
*** This job is about 70% complex PL/SQL development and 30% Informatica development. The successful candidate MUST have an excellent command of all Oracle Elements in the Oracle Database Developer's Guide.
Position Description:
This position is responsible for design, development, enhancement, verification and maintenance of ETLs from various sources to the Oracle data warehouse and to external clients using Informatica Power Center.
Duties and responsibilities include: ETL Administration; data source mapping; troubleshooting; development; source data reconciliations; ETL system development; and documenting.
Primary Responsibilities:
• Design, develop, maintain, monitor and execute production ETL processes using Informatica Power Center
• Investigate production ETL issues / problems
• Mapping database sources to specified data formats
• Verify and validate ETL deliverables
• Lead troubleshooting episodes and communicate solutions/resolutions to the team
• Translate concepts to requirements, and development into an automated production process.
• Act as a subject matter expert and resource for others on assigned ETL processes.
• Complete projects and development activities timely and accurately while following the System Development Life Cycle (SDLC).
• Suggest changes and enhancements for ETL processes.
• Document hours and development activities by following SDLC and IS Change Management guidelines.
Position Requirements:
• 3 or more years' experience using Informatica Power Center 8x or higher
• 3 or more years' experience with PL/SQL and/or T-SQL
• Strong knowledge of database design and entity relationships
• Data warehouse and/or Extract, Transform, and Load knowledge
• Bachelor's degree in MIS, Computer Science or a related field, or related work experience
Required Qualifications:
• Production ETL operations and monitoring
• Informatica Power Center experience
• General knowledge of Healthcare Data
•
Last updated on May 24, 2016