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.
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.
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.