informatica

SmartRecruiters, Inc.; King of Prussia (PA); On-site; USD 95,000 - 135,000; Full time

Job summary

EROS Technologies is seeking an Informatica PowerCenter Developer with BI/DW experience to develop and enhance ETLs from various sources to a SQL Server data warehouse. You will work with Data Analysts and EDW Architects to design and enhance ETL architecture, create new Informatica scripts, transition SQL ETLs, and troubleshoot performance issues.

The role requires expertise in Informatica PowerCenter 9.x, ETL standards, complex SQL querying, and data warehouse population on a large scale.

Qualifications

• Experience with Informatica PowerCenter 9.x and ETL development.
• Ability to design and implement data integration solutions for data warehouses.
• Strong SQL skills and data modelling for large analytic environments.
• Experience in auditing, troubleshooting, and performance tuning ETL processes.

Responsibilities

• Develop and enhance ETLs from multiple sources to SQL Server data warehouse.
• Create and modify Informatica scripts; transition SQL ETLs to Informatica scripts.
• Collaborate with Data Analysts and EDW Architects on ETL architecture.
• Analyze transaction errors and perform debugging/bug fixes; optimize ETL performance.

Skills

Informatica PowerCenter

ETL

SQL

Data warehousing

Web Service Consumer

XML Transformations

Audit & Troubleshooting

Performance tuning

Banking domain

CSV

Tools

Informatica PowerCenter 9.x

Job description

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

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.