Job Description :

Job Title: ETL Developer
Location: New York, NY

 

JOB DESCRIPTION:

  • 6+years of experience as ETL Developer in Banking Domain 
  • Banking Industry experience within the last 3 years
  • Data Warehousing within the last 3 years
  • Data Integration within the last 3 years
  • Thorough understanding of DWH and BI Dashboard Reporting concepts 
  • Should have understanding of 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 and Wherescape RED
  • Defines, develops, documents and maintains Informatica/ Wherescape ETL mappings
  • 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
             

Similar Jobs you may be interested in ..