I have 8 year experience in ETL and complex SQL query in various type of data base such as oracle, DB2 and MSSQL.
below is detail of my skill:
• Develope Etl process base on user requirement
• transform data from db2 to ODS and data warehouse use extract transform and load.
• expert in big SQL query in DB2 and MSSQL
Experience designing and delivering complex, large-volume data warehouse applications
• Preferably has exposure in Map Reduce components in Talend
• Strong experience in advanced SQL programming
• Strong knowledge of Software Development Lifecycle (SDLC).
• Strong experience in Data Quality, Source Systems Analysis, Business Rules Validation, Source Target Mapping Design, Performance Tuning and High Volume Data Loads.
• Strong written and oral communication skills are essential. Strong analytical skills and ability to resolve problems are desired. Some knowledge of mortgage industry required.
• High energy, self-motivation, attention to detail, creativity, flexibility, and ability to work under pressure.
• Analyze, design, implement and maintain high volume, multi-terabyte 24/7 data warehouse robust and fast ETL applications
• Advanced ETL development using Talend Big data platform
• Develop relevant functional and technical documentation.
• Work with business users to translate requirements into system flows, data flows, data mappings etc., and develop solutions to complex business problems.