Previous Job
ETL Developer
Ref No.: 17-00092
Location: San Ramon, California
Position Type:Contract
Start Date: 04/17/2017
We are looking for a qualified and motivated ETL developer with hands on experience in ETL architecture, standards and best practices, collaborating with cutting edge ETL technologies.

  • Develops ETL processes using Informatica, ETL control tables, error logging, auditing, data quality, etc.
  • Evaluates the integration a various data sources like Oracle, SQL server, VSAM and sequential files into staging area and recommends and/or implements efficiencies.
  • Work with team members on the evaluation of data using the Informatica Data Quality (IDQ) toolkit.
  • Performs technical walk-through as needed to communicate design/coded solution and to seek input from team members.
  • Implements data cleanup procedures, transformations, scripts, stored procedures, and execution of test plans for loading the data successfully into the targets.
  • Performs other duties as assigned.
  • Extensive Informatica technical knowledge in:- Informatica Designer Components -Source Analyzer, Warehouse Designer, Mapping Designer & Mapplet Designer, Transformation Developer, Workflow Manager and Workflow Monitor.
  • 8 plus of experience at Enterprise-level ETL development and ETL architecture using Informatica, Teradata, and understading the COBOL file structures.
  • Robust Teradata technical knowledge in the areas of general SQL, and use of Teradata export and import utilities (FastExport, FastLoad, MLoad)
  • Good knowledge of analytical and logical conceptual level programming skills
  • Good knowledge of Erwin model generation tools (logical and physical); Teradata and the Teradata Financial Services Logical Data Model
  • Data analysis, data mapping, data loading, and data validation.
  • Understand reusability, parameterization, workflow design, etc.
  • Assist other ETL developers when needed
  • Performance tuning and end-to-end lifescycle experience with Enterprise wide data warehouse
Bachelor's Degree in Computer Science or related field required