Job Description :

Position:  Informatica B2B Developer

Location: Jersey City, NJ


Job Description:  

Skills Required: Informatica B2B, DT scripts, Informatica PowerCenter
8 years of experience.

- Primary skill on development experience on informatica B2B dx, DT scripts, real time integrations using mq, api, http transformations

- Experience in Informatica PowerCenter development

- Participates in ETL Design of new or changing mappings and workflow s with the team and prepares technical specifications.

- Creates ETL Mappings, Mapplets, Workflows, Worklets using Informatica PowerCenter 10.x and prepare corresponding documentation.

- Designs and builds integrations supporting standard data warehousing objects (type-2 dimensions, aggregations, star schema, etc.).

- Performs source system analysis as required.

- Works with DBAs and Data Architects to plan and implement appropriate data partitioning strategy in Enterprise Data Warehouse.

- Implements versioning of the ETL repository and supporting code as necessary.

- Develops stored procedures, database triggers and SQL queries where needed.

- Implements best practices and tunes SQL code for optimization.

- Loads data from using Informatica connecting to different types of sources (Flat file, Relational DB, XML etc..)

- Works with XML s, XML parser, Java and HTTP transformation within Informatica.

- Works with Informatica Data Quality (Analyst and Developer)



Similar Jobs you may be interested in ..