Informatica Developer

Overview

On Site
Full Time
Contract - W2
Contract - 12th+ Month(s)

Skills

ETL
informatica
Data Warehousing
CDC

Job Details

ETL Informatica Developer
Providence, RI or Boston, MA 3-4 days onsite role
12+Months Contract(W2) or Fulltime

Job Description:

DESIRED SKILLS AND EXPERIENCE:

  • Minimum of 12-15 years of Software experience with 5+ on Data Warehousing
  • 3+ years of Informatica (9.6+) development with Power Centre, Power Exchange, IICS, Sybase and SQL Server

Mandatory Technical Skills:

- Sound Knowledge of Data warehousing concepts, terminology and Architecture.

- Excellent ETL (Including XML) Design and development Experience

- Good understanding of the commonly used transformations like Source qualifier, joiners, union, aggregator, sorter, expressions, transaction control, xml transformation, lookups etc

- Ability to understand mapping document and translate the same to Informatica Mapping

- Ability to create CDC, SCD, Fact loads and complex mappings with ETL

- Sound concepts of RDBMS with hands on with performance tuning of ETL / DB / SQL Queries

- Good knowledge of UNIX with ability to create Unix/Linux shell scripts to run ETL jobs and trap any failures.

- Skill in gathering and documenting user requirements and writing technical specifications

- Good knowledge of SDLC for projects using DW concepts and Client/Server technologies.

- Create detail mapping documents, module spec and unit test cases

- Hand on with informatica development, Configuration and Performance tuning

- Experienced in Migrating from Informatica PC to IICS

Interpersonal Skills

- Well developed analytical & problem-solving skills

- Strong oral and written communication skills

- Excellent team player, able to work with virtual teams

- Ability to learn quickly in a dynamic start-up environment

- Able to talk to client directly and report to client/onsite

- Flexibility to work on different Shifts and Stretch

Good to have:

  • Olap Tools
  • Data Modelling
  • Worked on Finance domain related data
  • Java Coding skills
  • Agile Development Experience
  • Worked on cloud environment
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.