Should have experience with developing a complete DWH ETL lifecycle
Should have experience in developing ETL processes - ETL control tables, error logging, auditing, data quality, etc. - using ETL tools such as Informatica, BODS, SSIS etc.
Should be able to implement reusability, parameterization, workflow design, etc.
Should have experience of interacting with customers in understanding business requirement documents and translating them into ETL specifications and Low level design documents
Experience in understanding complex source system data structures preferably in Financial services/ Banking (Insurance preferred)
Experience in Data Analysis, Data Modeling and Data Mart design
Strong database development skills like complex SQL queries, complex stored procedures
Good verbal and written communication in English, Strong interpersonal, analytical and problem-solving abilities.
Ability to work with minimal guidance or supervision in a time critical environment.
Willingness to travel and work at various customer sites across the globe