Data Warehouse Specialist / ETL Informatica Developer

Published date Posted on Indeed on Oct 07, 2021 (9 d ago)

********MUST BE US CITIZEN OR GREEN CARD HOLDER**********

Title: Data Warehouse Specialist/ETL Developer
Duration: 1 yr plus
Location: remote. Client is in Jacksonville, FL. Prefer candidates within 3-5 hours of Jacksonville. Not required just desired

********MUST BE US CITIZEN OR GREEN CARD HOLDER**********

4-6 years of experience in ETL Development utilizing Informatica DEI Developer/IICS (Informatica PowerCenter Experience will be considered)
4-6 years of Informatica PowerExchange Development Experience
Strong SQL expertise
Strong understanding of Database Concepts and experience in Oracle 19c Database framework (PL/SQL, Stored Procedures, etc.)
Strong analytical and problem solving skills.
Strong understanding of ETL Development best practices and Star Schema Designs
Experience in performance tuning in SQL and Informatica Toolsets (DEI Developer, IICS).
Proven ability to work independently in a dynamic environment with multiple assigned projects and tasks.
Outstanding ability to communicate, both verbally and in writing.

********MUST BE US CITIZEN OR GREEN CARD HOLDER**********

Responsibilities and Expectations for the Role
Assist with overall analysis, design and development of ETL processes to support project requirements
Document new designs and/or changes utilizing Microsoft Word
Analyze code developed in Oracle stored procedures and/or packages and re-write and/or modify code as necessary utilizing the Informatica DEI Developer/IICS platform
Develop Informatica DEI Developer/IICS mappings, SQL/stored procedures as well as data maps for PowerExchange
Performs unit testing, QA, and work with business partners and other developers to resolve any issues discovered during UAT
Review ETL performance and conducts performance tuning as required on mappings / workflows or SQL.
Serve as Informatica DEI Developer/IICS Tool SME by assisting other developers with general questions about the tool
Works with DBA/Application Administrator, as needed, to promote mappings/workflows between Development and QA environment

********MUST BE US CITIZEN OR GREEN CARD HOLDER**********

Job Types: Full-time, Contract

Pay: $70.00 - $75.00 per hour

Schedule:

  • 8 hour shift

Experience:

  • SQL: 1 year (Preferred)
  • Informatica: 1 year (Preferred)
  • Data warehouse: 1 year (Preferred)
  • Informatica PowerExchange: 6 years (Required)
  • ETL: 5 years (Required)
  • Oracle 19c: 2 years (Required)
  • PL/SQL: 5 years (Required)

Work Location:

  • Fully Remote

Work Location: Remote


Let us know

Help us maintain the quality of jobs posted on RemoteTechJobs and let us know if:

Loading...
Success
Error on reporting

Related jobs

Piper Companies Piper Companies |
|
2 d ago

Piper Companies is looking for a Database Architect who would like to join an industry leader in the financial services sector located in Philadelphia, PAThis is a Remote Opportunity!Responsibilities for the Database Architect include:You will be responsible for providing leaders

Press Ganey Associates Press Ganey Associates |
9 d ago

About Press Ganey:Press Ganey pioneered the health care performance improvement movement 35 years ago. Today Press Ganey offers an integrated suite of solutions that enable enterprise transformation across the patient journey. Delivered through a cutting-edge digital platform bui

About Press GaneyPress Ganey pioneered the health care performance improvement movement 35 years ago. Today Press Ganey offers an integrated suite of solutions that enable enterprise transformation across the patient journey. Delivered through a cutting-edge digital platform buil

Mainframe DB2 DBALevel ScopeTechnical support experience and a strong programming and debugging background in transaction processing or database processing on mainframes. Engages in identifying and resolving complex problems relating to product/service installation, update, confi

LOAN IQ DEVELOPER_______________________________________________________________________________________LOCATION: Remote in USHIRE TYPE: Full-timeVERTICAL: Financial Markets_______________________________________________________________________________________Role SummaryeClerx i