14 days old
  • Job Code
    574992
  • Payrate
    $55 To $60

Job Description:


Randstad Technologies is currently seeking a talented ETL Developer to join a well-known client of ours within a line of business in the great Orange County area. This person will act in the highest level technical role as an individual contributor and/or team lead for the most complex computer applications and/or application initiatives. Utilizes a thorough understanding of available technology, tools, and existing designs. Works on the most complex problems where analysis of situations or data requires evaluation of intangible variance factors. Plans, performs, and acts as the escalation point for the most complex platform designs, coding, and testing. Leads most complex multiple modeling, simulations, and analysis efforts. Acts as expert technical resource to programming staff in the program development, testing, and implementation process.


General Duties/responsibilities:



  • Creates prototypes/ETL specifications based on requirements and analysis of data
  • Designs and develops ETL mappings and workflows/sessions
  • Creates scripts for Oracle database tables and unit tests them
  • Creates/modifies UNIX scripts
  • Ensures adherence to locally defined standards for all developed components
  • Supports the development and design of the internal data integration framework
  • Performs unit tests and initial QA tests with test data
  • Participates in DI design of new Data Warehouse projects
  • Participates in design and development reviews
  • Creates change controls and coordinates approvals for implementation
  • Works with source system owners to resolve source data issues and refine transformation rules


Requirements:



  • 10+ years' application development and implementation experience.
  • This position involves design and development of the ETL jobs and processes to support the business requirements for Data Warehouse.
  • Should have worked in a Development role. Database Analysts or Informatica Developers with Unix experience
  • Minimum 3 years Informatica Development experience and overall knowledge of PowerCenter is a must
  • Minimum 3 years SQL scripting experience is a must
  • 1-3 years hands-on Unix shell scripting experience is a must
  • Experience with reporting tools and/or understanding of statistical analysis is desirable.
  • Experience with one or more of PSP, JSP, HTML/JavaScript is desirable


Other Requirements:



  • Bachelor's degree in CS or relevant discipline
  • 3+ years of experience as an ETL developer
  • Informatica, Oracle and Unix skills essential
  • Informatica Certification preferred
  • Metadata management and data integrity skills will be an added benefit
  • Effective oral and written communication skills required

Categories

  • Information Technology

Randstad utilizes a technology-driven focus with a human touch to provide better staffing and business solutions to organizations around the world. Our team of experts match professionals with available career opportunities in a variety of fields.

Featured Jobs

Career News

Share this job:

ETL Developer

Randstad Technologies
Irvine, CA 92618

Share this job

ETL Developer

Randstad Technologies
Irvine, CA
US

Separate email addresses with commas

Enter valid email address for sender.

Join us to start saving your Favorite Jobs!

Sign In Create Account
Powered ByCareerCast