Talend Specialist - Data Migration and Integration
Project involves designing an ETL system to migrate data from Multi Schema Files for each US States to MSSQL Server. 1. Designing and Creating ETL Jobs to process, transform and lookup Multischema files having more than 20 million records to MSSQL server. 2. Designing the jobs to apply incremental updates for each US State. 3. Performance tuning of the Jobs to process huge data sets in quick succession. 4. Lookup and downloading data from third party Vendor API through ETL Jobs 5. Setting up infrastructure and environment to schedule the jobs. 6. Creating Technical Specifications and Mapping documents
Sobre Mim
• Certified Talend Open Studio Data Integration Consultant • 5 Star Rating in all Projects • 2000+ hours of Freelancing experience • 9 years of experience in Data Conversion, Migration and ETL. • Certified SQL(1Z0-007) professional with good experience in writing complex SQL Queries. Tools Expertise - Talend, Ab initio, Jaspersoft BI, MySQL, Oracle , Unix Excellent communication skills and take full responsibility of the work. Apart from this I am certified SQL professional and good working experience in working with databases like MySQl, Oracle and Sybase. My objective is to utilize my knowledge and experience for delivering good quality work for my clients. I have expertise in following areas: • Data Integration and Business intelligence tools like Talend open Studio, Abinitio and Oracle Business Intelligence. • Conversion of data from one format into another e.g. XML to Flat files, Excel to XML etc. • Database migration, consolidation and De-duplication. • Retrieval of data from Google Ad words, Microsoft Bing Ad-center using their web services. • Transform the data and reports retrieved from various sources and generating derived fields. • Parsing Address using Google Geo-coding API.
