I am Software Consultant with approx. 100+ Months of experience mainly in Business Intelligence and Data warehousing assignments using Talend , IBM datastage and Pentaho as ETL tool.
• Certified Talend Open Studio (ETL) professional.
• Certified SQL(1Z0-007) professional with good experience in writing complex SQL Queries.
• Experience with Global IT companies like HSBC, Sapient Nitro, IBM, Fidelity Information Services.
• Expertise with processing structured (CSV, EXCEL) and unstructured (RAW) having more than 20 million records (around 2-5 GB)
• Processing complex hierarchical XML files and transforming them to Flat files before loading to different databases.
• Database migration, consolidation and De-duplication.
• Retrieving and Loading data from RETS servers using RETS connector.
• Retrieving and Loading data from Web APIs using ETL Tool.
• Thorough understanding of the SDLC with proficiency in mapping business requirements, technical documentation, application design, development, integration, testing and troubleshooting.
• Knowledge of OLAP, BI & Data warehousing Concepts and Dimension Modeling.
•
• Other Skills: Working knowledge of UNIX, SQL.
Punjab Technical University
