ETL/Informatica Developer
Previous Job
Previous
ETL/Informatica Developer
Ref No.: 18-21322
Location: Charlotte, North Carolina
Position Type:Direct Placement
Experience Level: 11 Years
Start Date: 03/29/2018
The ETL Developer resource is responsible for developing complex ETL/models in data ware housing environment, involving technical design, development, testing, and migration of Oracle objects (Data Modeling for Leadership Reporting, Monthly Workforce Matrix, Performance Reviews, Global Workforce Reporting). Resource should have ability to create and debug Oracle code base & have prior experience working on database frameworks. Resource should be detailed and be accountable for migrations across environments. Resource should test and identify data anomalies/data patterns in huge data sets. Resource should have critical thinking to ensure all assumptions, constraints, behaviors are well thought through – and have good communication skills. Resource should have prior work experience in data ware house involving millions of rows transformation. 
Required Skills: 
• Informatica 
• Agile Development 
• Dataware house Experience (involving manipulation/transformation of millions of rows with optimal methods). 
• Good SQL &PL/SQL knowledge. 
• Good Analytical skills, debugging and critical thinking. 
• Knowledge of these specific applications: 
• SQL, PL/SQL 
• TOAD 
• Unix Shell Scripts 
• Autosys 
• Reporting-OBIEE 12C