Informatica Developer (IICS, IDMC rest API, CAI, CDI, oracle/sqlserver, edw, BI, analytic, analysis.) - Telework/Remote

  • Posted 14 hours ago | Updated 14 hours ago

Overview

Remote
Depends on Experience
Contract - Independent
Contract - 6 Month(s)

Skills

Informatica
Informatica IICS
IICS
REST
JSON
APIs
Oracle
RDBMS
PL/SQL
SQL Server
data analysis
data integrity
IDMC
Salesforce
mapping
source-to-target
source-to-ETL mapping
Enterprise Data Warehouse
Business Intelligence
analytic computing
pattern identification
SaaS vendors
Workday
Unanet
Snowflake
Agile
Waterfall
Systems Engineering

Job Details

Title: Informatica Developer (IICS, IDMC rest API, CAI, CDI, oracle/sqlserver, edw, BI, analytic, analysis.)
location;PA, USA, Telework/Remote
duration: long term
interview: TEAMS w/ video

Informatica Developer to design and develop application integrations via Informatica IDMC APIs using Cloud Application Integration (CAI) and Cloud Data Integration (CDI) services .
The candidate should have strong SQL database query knowledge working with applications. The developer should also have thorough experience in developing IDMC REST API interfaces with CDI and CAI. The candidate should also have expertise with testing REST APIs using a software tool such as Bruno or an equivalent. Additionally, the candidate should also have a strong understanding of JSON data formatting.
The developer should have expertise in building ETL/ELT mappings and workflows using CDI. The candidate should have experience loading a Data Warehouse and be knowledgeable with Star Schema and 3rd normal form design. The candidate will contribute throughout the data management lifecycle process areas such as data acquisition, management, manipulation, and implement integrations between SaaS vendors, on-premise applications, and the Enterprise Data Warehouse environment.

Must- Haves (Hard Skills)
A minimum of a bachelor s degree coupled with 5+ years experience in the information technology arena.
5+ years experience in Enterprise Data Warehouse, Business Intelligence, analytic computing, data analysis, and pattern identification with various forms of data.
3+ years experience in Informatica IICS using REST/JSON/APIs.
2+ years experience with Oracle RDBMS, PL/SQL & SQL Server platforms
Excellent communication and organizational skills.
Ability to perform data analysis, troubleshoot data integrity issues and strong analytical/problem solving skills.

Nice-To- Haves (Hard Skills)
Prior experience with Informatica IDMC prebuilt connectors with Salesforce
Experience in documenting and mapping interaction (source-to-target, source-to-ETL mapping) between business processes, information, and data for projects which are of medium to high complexity and moderate to high risk.
Experience with SaaS vendors such as Salesforce, Workday, Unanet
Experience with Snowflake
Familiarity with development methodology such as A Agile, Waterfall and Systems Engineering.

Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.