Informatica ETL Analyst

company banner
Capgemini America, Inc.
Banking, Data analysis, Data warehouse, Informatica, ETL, Business requirements, Data modeling, Functional requirements, Data warehouse architecture, Shell scripting, Unix, PL/SQL
Full Time
Depends on Experience

Job Description

Job Description:

  • Worked in the Data Warehousing domain in the last 6 years
  • Should understand Banking system/processes and data flow and recent experience with Banking client
  • Understanding of Data Models: Conceptual, Logical, and Physical & Dimensional/Relational Data Model Design.  
    Should able to understand Data Warehouse architecture and code
  • Develop detailed ETL specifications based on business requirements
  • Develop Source to Target Mapping
  • Analyze functional specifications and assist in designing potential technical solutions
  • Identifies data sources and works with source system team and data analyst to define data extraction methodologies
  • Good experience on Data Analysis, Data Profiling and  Root Cause Analysis
  • Proficient in ETL Informatica  
  • Defines, develops, documents and maintains Informatica ETL mappings and need to be well versed in Unix shell scripting
  • Good knowledge in writing complex queries in Oracle PL/SQL
  • Unit/Integration testing activities and assist in User Acceptance Testing
  • Maintain batch processing jobs and respond to critical production issues

Posted By

Swapnil Gaikwad

Company Information

Global leader in consulting, technology, outsourcing, and local professional services. Capgemini is headquartered in Paris, France and operates in over 40 countries. We are, above all, a people company — 180,000 people worldwide. Read more:
Dice Id : KANBAY
Position Id : 6573535
Originally Posted : 2 months ago

Similar Positions at Capgemini America, Inc.

ETL Developer
  • Columbia, SC
  • 22 hours ago
Informatica ETL/Hadoop Team Lead
  • New York, NY
  • 22 hours ago
Informatica Developer
  • New York City, NY
  • 22 hours ago
Informatica MDM Developer
  • New York, NY
  • 1 week ago
Senior Informatica Developer
  • New York City, NY
  • 9 months ago
Informatica Developer
  • New York, NY
  • 5 months ago
Data Analyst
  • Jersey City, NJ
  • 22 hours ago
IDQ Developer
  • Tempe, AZ
  • 1 week ago