Position Summary

The ETL Developer primary responsibility is to Define and Develop ETL process to automate the data conversions, catalog uploading, error handling and auditing. Deploy and manage databases following a sophisticated practice of evolutionary database design and continuous integration associated with agile methodologies.

Duties and Responsibilities

  • Define and develop ETL process to Extract-Transform-Load various source format files in to Standard templates and databases.

  • Process Flat files to load data from source systems to targets using direct and indirect methods.

  • Using ETL tools implement process to call web services to load and transform various source files to the standard format.

  • Creating transformations using RIFL (Rapid Integration Flow Language), VB, Java, Perl scripting.

  • Write SQL queries, Stored Procedures, triggers and Functions.

  • Experience in UNIX Shell Scripting on UNIX & Linux platform.

  • Good knowledge of Relational Database Concepts, Entity Relation Diagrams, Normalization and De normalization Concepts.

  • Develop End- to- End full automation process.

Skills and Specifications

  • Bachelor’s degree in Computer Science/Engineering (or foreign equivalent) required

  • A minimum 3 years’ experience required

  • Experience with ETL tool development required, specific experience with Pervasive / ETL desired.

  • Experience in traditional scripting/coding experience: Java,VB and Perl scripting.