ETL Informatica Developer

Long Finch Technologies

Raleigh, NC/ Phoenix, AZ

Posted On: Jul 23, 2024

Posted On: Jul 23, 2024

Job Overview

Job Type

Full-time

Experience

8 - 10 Years

Salary

$110,000 - $130,000 Per Year

Work Arrangement

On-Site

Travel Requirement

0%

Required Skills

  • ETL
  • SAP BODS
  • SQL
  • Agile
  • Web Services
Job Description
Roles and Responsibilities
  • Design of complex ETL interfaces with agnostic tool set for various source.
  • Planning, Developing, Implementing and Managing Data Warehouse Project Deliverables,.
  • Design Documents and High-Level Data Mapping for ETL Specifications.
  • Create transformations in ETL jobs to achieve data cleansing and standardizations during initial data load.
  • Provide support for integration testing, defect fixing and deployment. 
  • Performance Tuning & Troubleshooting skills across all technologies used.

 

Required Qualifications
  • 8+ years of experience in ETL tools, repository maintenance (Oracle, SAP, Files as source; SQL Server, file uploads etc.).
  • Ability to lead the developers and QA and adhere to timelines committed. Agile experience is preferred.
  • Proficient Knowledge in Databases like Oracle (SQL Queries), SQL Server.
  • Proficient Knowledge in Dimensional modelling, Data Mining and Data warehouse concepts.
  • Knowledge to transfer data from Oracle, SQL Server tables and Web Services either Incrementally (Delta Load) or full Load to the Data warehouse on periodic basis.
  • Knowledge in Trouble shooting existing ETL jobs and improve performance of the existing jobs
  • SAP BODS experience is strongly preferred.

Job ID: LF240322


Posted By

Andy

HR Manager