Stay current with common problems and solutions for recent releases.
  HOME > Job Description
Share |

Thank you for showing interest in the job position: ETL Developer.

In order to be considered for this position, please review the job description provided below, Click Apply and fill out the Job Application Form.

Berean Group is seeking an ETL Developer
 
Location: Santa Monica, CA
Duration: Full-time
 
Note: US Citizens and those authorized to work in the US are encouraged to apply. We are unable to sponsor H1b candidates at this time.
 
Summary
As a key member of our technical team, you will work on developing new ETL programs for Data Acquisition & Reporting to enhance our Enterprise Data Warehouse ? extensively used by client business users and partners. You will work with a group of ETL developers and Business/System Analysts. Looking for a talented, self-motivated, and a quick learner, able to work on multiple projects simultaneously.
 
Primary Duties/Responsibilities:
  • Must have 3 ? 6 years of experience in designing, implementing, and testing ETL programs independently using Informatica in Oracle DB environments.
  • Ability to Code, test, debug, schedule, implement and document complex ETL programs Using Informatica 9.5 ETL tool suite.
  • Strong knowledge on various ETL architectures and ability to establish best practices.
  • Experience in Data warehouse systems and its related implementations using Informatica like slowly changing dimensions, Fact tables, aggregation tables
  • Must have experience in writing complex SQL queries in Oracle 10g and 11g DB
  • Experience in performance tuning of slowly performing data loads/ ETLs
  • Experience in data modeling using ErWin data modeling tool is a plus.
  • Experience in Developing test plans and quality assurance tests to ensure data integrity
  • Experience in Shell scripting ? UNIX, Linux.
  • Support Operations and/or project personnel in resolving project/production problems.
  • Strong problem solving skills.
  • Experience with Agile/Scrum very desirable.
  • Strong interpersonal and communication skills; works well in a team environment.

Requirements

  • Must have 3 ? 6 years of experience in designing, implementing, and testing ETL programs independently using Informatica in Oracle DB environments.
  • Ability to Code, test, debug, schedule, implement and document complex ETL programs Using Informatica 9.5 ETL tool suite.
  • Strong knowledge on various ETL architectures and ability to establish best practices.
  • Experience in Data warehouse systems and its related implementations using Informatica like slowly changing dimensions, Fact tables, aggregation tables
  • Must have experience in writing complex SQL queries in Oracle 10g and 11g DB
  • Experience in performance tuning of slowly performing data loads/ ETLs.

Desired

  • Experience in data modeling using ErWin data modeling tool is a plus.
  • Experience in Developing test plans and quality assurance tests to ensure data integrity
  • Experience in Shell scripting ? UNIX, Linux.
  • Support Operations and/or project personnel in resolving project/production problems.
  • Strong problem solving skills.
  • Experience with Agile/Scrum very desirable.
  • Strong interpersonal and communication skills; works well in a team environment.
 
APPLY