Consultant-ETL Developer Job Description Template
Our company is looking for a Consultant-ETL Developer to join our team.
Responsibilities:
- Improve functionality of existing systems;
- To be involved in writing ETL logics;
- Should be able to write effective and scalable code;
- Authoritative level modeling with ability to write complex formulas in Excel or other business modeling technologies and seek complex planning models.
Requirements:
- Experience on HIVE and various components of performance tuning is preferred;
- Must have experience in writing SQL in Oracle and Teradata etc. Should be able to write and understand queries;
- Experience in Autosys is preferable but not a must;
- Should have good knowledge on performance tuning in Informatica and Teradata;
- Experience on Informatica, Teradata, Unix and Hive;
- Experienced in running an end to end ETL project interacting with users globally;
- BE/B Tech/ MCA;
- Proficient with crafting Teradata tables, choosing primary index, MLOAD, FLOAD, BTEQ, TPUMP and knowledge of Secondary Index;
- Proficient with creating Informatica mappings, sessions, workflows, mapplets and hands on Experience on designing CDC, SCD2 implementation;
- DW/BI experience with implementation of ETL solutions using Informatica and Teradata;
- Worked with large data sets and proficient using of Analytical functions;
- Excellent written and verbal communication skills;
- Understanding of HDFS is must.