Informatica PowerCenter Developer Dubai UAE

Position: Informatica PowerCenter Developer

Date posted: 2023-02-01

Industry: IT

Employment type: Full Time

Experience: 3 to 5 year

Qualification: Bachelor’s Degree holder

Salary: AED 10000 to 20000

Location: Dubai, United Arab Emirates

Company: Mindpool Technologies

Description:

Hiring Informatica PowerCenter Developer

Location: Dubai (onsite) and Offshore

Job description: Informatica PowerCenter Developer

Mandatory Skills:

• Good Technical knowledge on Informatica Power center
• Advanced Query Writing Skill for Snowflake,Oracle, SQL Server and MySQL
• Comprehensive Knowledge in Data Analysis
• Ability to trouble shoot existing ETL Jobs

Good to have (optional):

• MDM
• ADF
• Comprehensive Knowledge in Data Analysis
• Micro strategy
• Power BI

Job description:

• Participates in ETL Design of new or changing mappings and workflows with the team and prepares technical specifications.
• Creates ETL Mappings, Mapp lets, Workflows, Work lets using Informatics 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 Salesforce to Oracle using Informatica
• Works with XML’s, XML parser, Java and HTTP transformation within Informatica.
• Works with Informatica Data Quality (Analyst and Developer)