Informatica PowerCenter @ Orcapod Consulting

Job Description

Job description
Roles and Responsibilities

MUMBAI location only

Job description:

5+ of hands-on experience developing complex Informatica PowrCenter is a must
Participates in ETL Design of new or changing mappings and workflows 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.
Works with XML's, XML parser, Java and HTTP transformation within Informatica.
Monitor and support the existing Informatica jobs and ability to troubleshoot and fix the production failure

Desired Candidate Profile

1 resource for 5+ yrs of experience
RTO position. Work from Mumbai office (Sewree, south Mumbai)

Employement Category:

Employement Type: Full time
Industry: Management Consulting / Strategy
Role Category: Hardware / Telecom Equipment DesignNetwork / System Administration
Functional Area: Not Applicable
Role/Responsibilies: Informatica PowerCenter

+ View Contact

Keyskills:   xml http informatica c2h etl sql queries power center