Problem Solving Skills with great knowledge of Sql,NoSql,BI
• Highly Skilled Professional with over 5+ years of experience in Software Design, Development, Analysis, Testing, Data Warehouse and Business Intelligence tools.
• Extensive experience in Information Technology with special emphasis on design & development of Database/Data Warehousing/Client-Server applications.
• Good knowledge on Talend(DI,BIG DATA),Big data/Hadoop technologies, Map Reduce using Java and Hive, Pig.
• Proficient in NoSql Like Mongodb and Hbase.
• Proficient in ETL (Extract – Transform – Load) using Informatica PowerCenter tool, SQL Server Integration Services 2008 (SSIS), Abinitio.
• Exceptional background in analysis, design, development, customization, and implementation and testing of software applications and products.
• Demonstrated expertise utilizing ETL tools, including Informatica, SQL Server Integration Services (SSIS), Abinitio and ETL package design, and RDBMS systems like SQL Server, Oracle.
•Proficient preparing the insert scripts to load the development tables with the sample data for the report development and unit testing.
• Strong leader with experience training developers and advising technical groups on ETL best practices.
• Expertise in OLTP/OLAP System Study, developing Database Schemas like Star Schema and Snowflake Schema used in relational, dimensional and multidimensional modelling.
• Experience in analysis, design and construction of Data warehouses and Data marts
• Experience in Performance tuning of Queries and indexing to improve Performance.
• Ability to code and implement complex business rules in Oracle SQL, PL/SQL, Triggers and Stored Procedures.
• Team player and self-starter with excellent communication and documentation skills, ability to work independently or as part of a team and capable of picking up new skills quickly.