My Shortlist

Your shortlisted jobs will appear here. To view your shortlist: Login Or Register

Date Added: Sat 11/09/2021

ETL Developer

Tempe, AZ, US
Apply Now

Company: KFORCE TECHNOLOGY

Job Type: Permanent, FullTime

RESPONSIBILITIES:

Kforce has a client in need of an ETL Developer in Tempe, AZ. Summary: In this role, the ETL Developer will be responsible for developing Informatica ETLs to load data from various sources into staging, dimension and fact tables, and will be developing Shell scripts to trigger Informatica workflows. The ETL Developer will also be developing Autosys JIL scripts to schedule and define dependencies and to trigger Shell scripts, and writing SQL to perform analysis, testing and troubleshoot problems. Responsibilities:
  • ETL Developer will work with data architects and analysts in understanding business requirement, business rules and mapping specification
  • Develop Informatica ETL according to mapping spec to load data into staging, dimension, fact and reporting tables
  • ETL Developer will write SQL to analyze data and find data problem in early stages, and to validate and test data loaded by ETLs
  • Write Shell scripts to trigger Informatica Workflows and handle errors
  • Create Autosys jobs to trigger Shell scripts and set job dependencies and schedules
  • In this role, the ETL Developer will investigate and troubleshoot production ETL failures and data problems
  • Create change management tickets to track changes
  • Create data flow diagrams to document data flow from source to ETL and to target
  • As a ETL Developer, you will conduct impact analysis to determine impacted ETL, tables and columns per information provided


Job Requirements:

REQUIREMENTS:

  • Candidates will play a key role in extracting system vulnerability data from a myriad of sources using among other things the "HTTP Transformation" function in Informatica; Experience in this regard is preferable
  • Candidates qualifying for this position will have similar experience along with the skills and abilities to perform the duties mentioned
  • Any relevant education and/or training will be considered a plus
Kforce is an Equal Opportunity/Affirmative Action Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, pregnancy, sexual orientation, gender identity, national origin, age, protected veteran status, or disability status.
Apply Now