Informatica Engineer - Fort Worth, TX; locals

Job Title:
Informatica Engineer

Location:
Fort Worth, TX (locals only)

Mode of Work:
Hybrid

Yrs of exp: 6+

Any Visa

Description:

Infromatica Engineer POSITION

Web/Mobile Developer

Job Responsibilities

This role is responsible for designing, coding, and modifying ETL processes using Informatica based on mappings from Source to Target applications. Experience in migration to Cloud

Developer Job Duties

- 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 Power Center 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 SF Power Exchange to Mongo

DB database using Informatica.

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

- Works with Informatica Data Quality (Analyst and Developer)

- Primary skill is Informatica Power Center

- 5-7 years of experience.

Developer Skills and Qualifications

Informatica Power Center, Informatica Powerxchange.
Mongo

DB, IMS , Relational Database

Education/Experience

• Bachelor’s Degree in computer science or equivalent training required

• 5+ years’ experience required