Informatica Developer

Title: Informatica Developer

Work Arrangement: Onsite

Job Description

We are looking to fill a Long-term Contract role as Informatica Developer in Hartford, CT

Mode of Interview: In person

The selected person will be responsible for designing, coding, and modifying ETL processes using Informatica based on mappings from Source to Target applications. Experience in migration to Cloud

Responsibilities

• 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.
• Loads data from SF Power Exchange to MongoDB database using Informatica.
• Works with XML's, XML parser, Java and HTTP transformation within Informatica.
• Works with Informatica Data Quality (Analyst and Developer)
• 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.