Mani Gandan

Data Analyst with 6.5 years of experience of SQL and TALEND ETL tool in developing jobs as well as SQL complex queries for better performance tuning.  Talend long running job are fine tuned to achieve the 95% accuracy.  In-depth knowledge of database development, SQL server Backups and Restore, On-Spot Talend ETL jobs creations, business analysis.  Migration of data from end to end with Talend software tool. 

• Extensive experience in ETL methodology for performing Data Migration, ETL(Extraction, Transformation and Loading) using Talend and designated data conversion from wide variety of source systems like SQL server, excel 
• Manual testing of jobs after developing and analysis the performance of Talend ETL job, etc.
• Worked with Talend jobs on performance level analysis, better performance, and complexity of jobs.
• Designed and developed the automated Talend job for reconciliation business purpose.
• Main Motive – Talend ETL automated job is to reduce the manual effect for reconciliation purpose. 
• Expertise in creative mappings in TALEND using context variables, tMap, tJoin, tBufferinput, tBufferoutput, tfileCopy, tSortRow, tMap, tHashInput, tFilterRow, tLogRow, etc.
• Proficient in designing and developing complex SP using SQL queries and query optimization and loading speed by 95%.
• SSIS (SQL Server Integration Services) – ETL tools for data migration and maintenance of data in server.

• May 2016   - Master In Engineering(M.E)   - Computer Science & Engineering with First Class 
• May 2014   - Bachelor of Engineering(B.E)  - Computer Science & Engineering with First Class