* Data Warehousing and Business Intelligence professional with 15 years of experience in IT industry worked on industry leading tools and technologies using Oracle SQL, Pl/Sql, Informatica PowerCenter and Unix Shell Scripting. * Developed dimensional data modelling using Star Schema and Snowflake Schema in Oracle and implemented ETL solutions using SCD Type 1, 2 and 3. * Developed business analytical reports using SQL and Tableau which influenced organizational decisions and the business planning and reviewing. * Developed Stored Procedures using Pl/Sql for data correction and improve data quality. Involved in SQL performance tuning which were used Informatica * Created Unix Shell Scripts to perform various tasks like check the connectivity between Informatica server and AS400 System, generate Token files for Informatica CDC WFs, Auto restart of WF in case of failure. * Skilled in designing physical and conceptual Data model using Erwin Tool. * Created design documents LLD, HLD and Mapping documents, validated requirements using RTM and performed code review and code tuning. * Performed Informatica Admin role, involved in user management, production and lower environment code deployments, monitoring the workflows, recovery and re-start workflows in case of any failures. * Worked on fetching data from AWS S3 and Redshift and apply business logic and load in Operational Data Source * Experience in developing Python code for multiple functionalities like generating Json events for downstream applications and executing stored procedures for data fixing. * Have good understanding of Informatica IICS, Terradata and Hadoop
Description
