ETL Developer will be responsible for design, development of ETL in a large datawarehouse environment, data needs to be extracted, transformed and loaded to an Oracle 11g database and or Teradata environment. Ability to tune queries is a plus.
Work closely with Data architects and business analyst to understand requirement and create most efficient ETL design patterns
Creation of ETL specifications, mappings and workflows in Informatica. Emphasis on Informatica ETL
Provide help to ETL architect with design solution based on industry best practices and prior hands-On experience.
Build code for maximum reusability and restart ability
Performance tune existing ETL code and or database queries.
Provide inputs to technical lead on design patterns and demonstrate technical leadership
Engage DBA on physical optimizations and query tuning for individual modules.
Must Have Technical skills
Minimum 2-3 years total Informatica development experience.
Informatica certification preferred
5+ yrs Oracle experience * SQL (must be very strong in SQL) – Oracle 11g or Teradata v13 experience is mandatory
Technical Skills (Good To have)
Unix scripting , Scheduling tool (UC4) experience.
Ability to work towards aggressive deadlines and deliverables.
Team player that is also self-motivated Excellent verbal and written communication skills
Ability to analyze and solve problems and work with the team to identify and fix the root cause of the problems (be it data quality, performance, or programmatic oversight)
Full data warehouse life cycle experience in building large systems over 25 TB preferred