· Highly motivated SQL Developer and Database Management enthusiast with around 7 years of Software Development experience in Data Integration, Data Mining, Data Analysis, Application Development and Reporting.
· Expert in Database Design, Data modeling, Development, Implementation, ETL and Reporting in ORACLE and SQL Server 2005/2008/2012/2014/2016.
· Experience in Application Development Analysis, Requirement Analysis, Scoping, Developing, Debugging, Testing and Documentation of various phases in a project life cycle of Client/Server Applications.
· Conversant with RDBMS concepts including Oracle 11g, MySQL and proficient in SQL, PL/SQL, Stored Procedures, Triggers, Tables, Indexes, Functions, Views, Joins etc.
· Efficient in creating SQL joins and sub-queries for complex queries involving multiple tables.
· Well versed in Normalization/De-normalization techniques for optimum performance in relational and dimensional database environments.
· Expert in Data Extraction, Transforming and Loading (ETL) using Informatica Cloud, ALTERYX and SQL Server Integration Services (SSIS), DTS and BCP.
· Experience in design of ETL packages for integrating data from heterogeneous sources like (SAP BW, SAP Table Reader, Salesforce.com, ZUORA, Oracle Eloqua, EDW, Oracle, Flat file, CSV) by using multiple transformations provided by Informatica Cloud and SSIS.
· Experience in creating jobs, SQL Mail, Alerts and schedule Informatica ETL Packages using Informatica Cloud and Powercenter.
· Deployed SSIS packages to different environments.
· Used Microsoft Power BI, Power Query to extract data from external sources and modify data to certain format as required in Excel, and created SSIS packages to load excel sheets from PC to database
· Experience in MS SQL Server Integration Services (SSIS) and MS SQL Server Reporting Services (SSRS) with good knowledge on MS SQL Server Analysis Services (SSAS).
· Involved in Analyzing, designing, building &, testing of OLAP cubes with SSAS.
· Well versed in creating the OLAP cubes using various dimensions and creating SQL Server Analysis Projects using SSAS 2005. Adept in defining referenced relationships and calculated members in SSAS, creating OLAP structures from OLTP databases.
· Experience in Report generation and Reporting Services for MS SQL Server, Oracle using Alteryx, Power BI and expertise on MS Excel.
· Expert in Data Extraction, Transforming and Loading (ETL) using various tools such as SQL Server Integration Services (SSIS), DTS, Bulk Insert and BCP.
· Experience with performing various SSIS data transformation tasks like Look-ups, Fuzzy Look-ups, Checksum, Conditional Splits and Event Handlers, Error Handlers etc.
· Possess in-depth technical prowess in Core Java concepts including Object Oriented Programming, JDBC, Multi-threading and Advanced Java concepts including JSP, Servlets, XML, Java Beans and J2EE Design patterns.
· Experience in writing and executing the Test cases using JUNIT.
· Possess strong web design and development skills and used HTML5, CSS3, Javascript, Perl, Python extensively.
· Possess excellent communication, leadership and team playing skills. Possess an outlook to bring in novel ideas and best practices to achieve business goals and thereby contribute to the success of the company