Informatica Developer

07 Jun 2024

Vacancy expired!

One of our clients is looking for the position of

ETL Programmer based on following skills:

Potential contract-to-hire.Currently work will be performed remotely but the candidate MUST reside in Ohio and be willing to pick up their equipment in Columbus. Will not ship equipment.The remote work policy is currently under review and may evolve into hybrid and/or on-prem work. This position will be an integral part in some of the most important data systems in the Ohio K-12 education system, notably the Education Management Information System (EMIS). EMIS is a statewide data collection system for Ohio’s primary and secondary education. It collects an enormous volume of data from schools and districts throughout Ohio. Our ETL team processes that data including demographic information, attendance, course information, financial data, and test results for use in back-end processes like the annual school and district report card and the school foundation payment system among others. We are seeking a candidate with strong analytical, mathematical and communication skills, who has prior experience creating and supporting mappings and workflows with Informatica PowerCenter.
  • The primary role of the position will be to create, test, run, and monitor Informatica PowerCenter processes primarily using Oracle but may occasionally use SQL Server.
  • Assists the EMIS (Education Management Information System) data team with daily data updates (e.g., data file loads, SQL (Structured Query Language) statement creation/review).
  • Creates or sets-up test data for performing test scenarios.
  • Verifies and documents unit and system test results to ensure ETL is producing desired results.
  • Debugs and revises ETL programs when unit and system tests do not produce desired results.
  • Identifies and documents problems and develops software solutions to business problems

Duties:
  • Defines, develops, and implements potential technical solutions to business data problems - 70%
  • Performs production support for business applications and data systems which may include routine maintenance, enhancements, and technical research to aid in troubleshooting soft-ware production errors – 15%
  • Business analysis, creating requirements and specifications from business rules – 15%
  • Total 100%

Candidate requirements:
  • 6+ years of ETL experience, at least 3 of which Informatica Powercenter 9.x or higher must have been the primary programming language used.
  • Preferred qualifications:
  • Experience with Informatica PowerCenter 10.x.x.
  • Experience with Azure DevOps and/or Microsoft Team Foundation Server (TFS) for source code control, work item management, release management, and/or build processes
  • Experience with Oracle and SQL server databases
  • Experience working independently.

The successful candidate may have to undergo a drug test and background check.

Sincerely,

Tamana Nair

Digitek Software, Inc.

650 Radio Drive, Lewis Center, OH 43035 Tel No6147648875 ext. 3105/ Fax6147925840

Email

www.digiteksoftware.com

  • ID: #42534203
  • State: Ohio Columbus 43085 Columbus USA
  • City: Columbus
  • Salary: Depends on Experience
  • Job type: Contract
  • Showed: 2022-06-07
  • Deadline: 2022-07-30
  • Category: Et cetera