Senior Data Warehouse, ETL Developer
Job Description:
Principal Accountabilities:
The ETL Developer (Specialist) is responsible for the design, development, enhancement and support of Data Warehouse Extract/Transform/Load applications.
Job Complexity:
● Requires in-depth knowledge and experience of Data Warehouse design, ETL processes and industry best practices
● Solves complex problems; takes a new perspective using existing solutions using creative thinking
● Works independently; receives minimal guidance
● Acts as a resource for colleagues with less experience
● Represents the level at which career may stabilize for many years or even until retirement
● Contributes to process improvements
● Typically resolves problems using existing solutions
● Provides informal guidance to junior staff
● Works with minimal guidance
Experience / Education:
●Typically requires 5–7 years of related experience with a 4 year degree; or 3 years and an advanced degree; or equivalent work experience.
● Works on ETL mappings and transformations on Informatica
●Modifies, updates and creates BTEQ scripts , unix shell scripts in Teradata
●Strong familiarity with SQL , Unix scripting and Teradata SQL
●Applies industry best pracitices to coding and solving problems
●Takes direction from the data warehouse manager and ETL lead on a daily basis
● Provides guidance to junior developers
● Creates documentations, help establish standards
● Familiarity with Hadoop and Big Data
Additional Experience:
●Experience with SQL , Teradata and Unix is essential
●Experience with Oracle EBS is a big plus