informatica

EROS Technologies was founded with a simple motive of offering the clients exactly what they want, how they want and when they want it. By leveraging for its clients its technological edge and right-sourcing advantage, EROS in a short period of time has grown to become one of the most trusted strategic technology partners. Treating every client as the top priority, we customize our solutions and services to align with the unique needs of each client.

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​

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