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