informatica

Eros Technologies Inc.

King of Prussia (PA)

Sur place

USD 95 000 - 135 000

Plein temps

14 jours+

Obtenez une réponse de cet employeur

Votre CV et votre lettre de motivation, adaptés exactement à ce que l’employeur recherche.

Passez les filtres ATS

Résumé du poste

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.

Responsabilités

  • 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.

Connaissances

Informatica PowerCenter
ETL
SQL
Data warehousing
Web Service Consumer
XML Transformations
Audit & Troubleshooting
Performance tuning
Banking domain
CSV

Outils

Informatica PowerCenter 9.x

Description du poste

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.

Obtenez votre examen gratuit et confidentiel de votre CV.

ou faites glisser et déposez votre fichier ici.

Similar jobs

Postes similaires à comparer

Informatica PowerCenter ETL & BI/DW Developer
Informatica PowerCenter ETL & BI/DW Developer

Eros Technologies Inc. • King of Prussia (PA)

Sur place
USD 95 000 - 135 000
Informatica Developer
Informatica Developer

TechDigital Group • Purchase (NY)

Sur place
USD 120 000 - 150 000
ETL Informatica PowerCenter Developer
ETL Informatica PowerCenter Developer

OptechUs • Auburn Hills (MI)

Sur place
USD 90 000 - 110 000
Sr. Informatica Developer
Sr. Informatica Developer

Sonoma Consulting Inc. • New Brunswick (NJ)

Sur place
USD 85 000 - 110 000
Sr. Informatica Designer
Sr. Informatica Designer

Next Level Business Services, Inc. • Pleasanton (CA)

Sur place
USD 85 000 - 110 000
Informatica PowerCenter Developer
Informatica PowerCenter Developer

5 Star Recruitment • Waltham (MA)

Sur place
USD 100 000 - 130 000
ETL Developer
ETL Developer

Jobsbridge • Pleasanton (CA)

Sur place
USD 80 000 - 100 000
ETL Informatica Developer
ETL Informatica Developer

Envision Technology Solutions • Plano (TX)

Sur place
USD 85 000 - 120 000
Informatica Developer - Only Local Consultant
Informatica Developer - Only Local Consultant

Pyramid Consulting Inc. • Atlanta (GA)

Sur place
USD 80 000 - 110 000
ETL Developer
ETL Developer

AHU Technologies Inc. • États-Unis

À distance
USD 80 000 - 120 000