Is the informatica role at Erostechnologiesinc remote?

The informatica role at Erostechnologiesinc is an on-site position located in King of Prussia.

How do I apply for the informatica position at Erostechnologiesinc?

You can apply for the informatica position at Erostechnologiesinc directly through HireHere. Click the "Apply" button on the job listing to be taken to the application page.

informatica

ErostechnologiesincKing of Prussia1d ago

SQL

Job Description

Looking an Informatica PowerCenter Developer with BI/DW experience needed to develop and enhance ETLs from various sources to SQL Server data warehouse. Devising data conversion strategy for a system focused on delivering an analytical capability. This position requires work along with Data Analysts and EDW Architects in designing/enhancing ETL architecture. Creation of new Informatica scripts, transition of SQL ETLs to new Informatica scripts, or modification of existing scripts. Must actively participate in analyzing transaction errors, troubleshooting issues, bug-fixes, involving in performance tuning efforts.

Requirement:

· Ability to work in a complex data environment as well as the ability to partner with the business and IT to find creative data solutions to business problems

· Ability to create high complexity detailed technical design specifications, Develops detailed analysis, design, construction and testing specifications ensuring technical compatibility and integration.

· Comply with ETL standards and guidelines related to the design, construction, testing, and deployment activities within the Delivery Management environments.

· Evaluate and understand a variety of modeling and/or diagramming techniques, with the ability to create process flow diagrams and the ability read data flow and entity relationship models.

· Expertise on Informatica Power Center 9.x, advanced transformations like Web Service Consumer, XML transformations, CSV.

· Experience in development, maintenance, and enhancement of Informatica Mappings, Work-flows, and processes for populating large scale data marts and/or data warehouses.

· Must have expertise in Audit mechanisms, Troubleshooting, Error handling and ETL strategies.

· Ability to analyze and retrieve metadata from Informatica repository, Experience with developing complex SQL query

· Experience in large Database and DW Implementation

· Financial Services / Banking Industry domain background

· Coordinate and support implementations

· Strong verbal and written communication skills

Additional Information

All your information will be kept confidential according to EEO guidelines.

informatica

Additional Information

Explore Data

Skills in this job

People also search for