Long-term consulting engagement: Data Integration/ETL Database Developer

Project Description

URGENT: Data Integration/ETL Database Developer

 Both individuals and companies are welcome to apply. 

Requirements:

· Motivated, self-starter, ability and strong desire to learn new technologies and methodologies as
  required

· Several years of experience in implementing data integration solutions in either IT or Product
  environment. Preferable to have experience in at least one of the following ETL products, Pentaho,
  Talend, Infomatica and SAP Data Services

· Must have hands-on experience implementing data extraction and transformations from a variety of
  data sources such as SQL, NoSQL and Hadoop-like systems

· Ability to build and optimize data transformations, data quality routines and workflows

· Can write custom transformations in Java to process data in multiple formats (Relational, S3, Swift,
  etc.) to a structure required for the data marts

· Experienced in designing and building logical and physical data models of operational data marts/data
  warehouses based on Analytics data store technology such as Vertica, Oracle or EMC Greenplum.

· Strong data modeling skills, specifically in design and building of Snow-flake and Star schema models
  to achieve manageable, high performance reporting data store

· Ideal to have worked on a large data mart or data warehouse implementation (Terabytes in size)

· Strong SQL skills. Programming experience in a higher language such as Java and PL/SQL is a must

· Familiarity with data management disciplines required to design, build and implement high quality
  data marts

· Demonstrable experience in creating ETL solution that involves data extraction from source systems
  all the way through creating analytics friendly database tables and views

· Familiarity with Big Data Analytics architecture and patterns using highly scalable, parallel processing
  data platforms

· Hadoop Map Reduce and Spark experience are a strong plus