5+ year of work experience in information Technology as Database / BI Developer with strong background in Data warehousing.
Experience on Data warehousing, Data modeling, Data integration, Data Migration and Business Intelligence.
• Database Experience using Oracle 11g/10g, MS SQL Server 2014, 2016, MYSQ. PostgreSQL
• Experience using SQL, PL/SQL Procedure and Packages.
• Experienced with Integration of data from heterogeneous sources such as Relational tables, flat file MS Excel, csv files.
• Working Knowledge of data warehouse techniques and practices, experience including Data Analysis, ETL Process, dimensional data modeling Star Schema, Snow Flake Schema, FACT Dimension Tables.
• Experience to develop data marts and cubes used in business intelligence analysis.
• Expertise in report designing using BI Tools.
• Experience in writing complex SQL queries.
• Experience using database tool such as SQL Developer and PL/SQL Developer.
• Experience of different transformations like Source Qualifier, Expression, Aggregate, Update Strategy and Joiner.
• Complex analytical reports with strong coding of SQL by using SQL Developer