• 7+ years experience of Data Warehousing and ETL o Deep understanding of Data warehousing concepts. • 5+ years experience on Informatica PowerCenter platform (specifically version 10.x), as well as process and workflow tuning and optimization. • 3+ years experience in working with Oracle PL/SQL procedures • Strong debugging, problem solving and investigative skills. Ability to assimilate disparate information (log files, error messages etc.) and pursue leads to find root cause problems. • Expertise in using partitioning, transformations, incremental caching in Informatica toolset • Expert understanding of slowly changing dimensions (SCD's) in Informatica. • Expert understanding of join logic and query optimization in Informatica • Experience with stored procedures, Triggers, PL/SQL in Oracle. • Expert in writing efficient Analytic and windowing functions in Oracle. • Extensive Business and/or technical background in the areas of Data modeling, EDW, Data Mart, Master Data Management, Metadata management, Data Quality, Data Governance, Data integration (ETL) and Data Security • Carry out data modeling, including evolution from conceptual to physical models using a tool like ERWIN • Define data profiling and analysis criteria and development of data quality metrics • Financial Services Industry experience is a big plus. • Proficiency in Linux and shell scripts, job scheduling.