About Me

Having around 7 years of experience in Software development and Production support in Data Warehouse Projects using ETL toll Informatica Power Center. Extensively worked with implementation of the Star schema model, Snow-Flake model, Fact and Dimensi... Extensively worked with implementation of the Star schema model, Snow-Flake model, Fact and Dimension tables. Having experience in Informatica power center 9.x and 10.2 versions. Experience in Developing Slowly Changing Dimensions like Type 1, Type 2 for loading the data into dimension tables. Worked in Power Center Designer, Workflow Manager &Monitor tools. Experience on Designer tools Source Analyzer, Target Designer, Transformation Developer, Mapping Designer and Workflow Manager Tools - Task Developer, Worklet & Workflow Designer. Developed mappings in Informatica Power center using different transformations like Source Qualifier, Expression, Filter, Joiner, Union, Lookup, Update Strategy, Sorter, Rank, Router, Aggregator, Sequence generator. Responsible for creating reusable transformations and used in other mappings. Created Sessions and Workflows and run the workflows using scheduling tool. Involved in preparation of Unit Test Cases (UTC) & Execution of Unit test cases. Experience with CA workload and Autosys Scheduling tools for scheduling jobs and Monitoring purpose. Experience in creating Rule sheets (Mapping Specification Documents). Good databases experience in Oracle and Sql Server. Basic level Experience in Netezza DB. Experience Azure like Azure Data Factory, Azure Data Lake Storage and Data flows creation. Experience in Azure Sql. Experience in Azure activities like copy, linked connection, Look up, Stored Procedure, etc. Experience in Migrating data from on-premises DB to Azure cloud. Experience in direct Interaction with Customer, daily standup meetings and Sprint planning and review meetings. Following agile process for project daily tracking purpose. Status and stand-ups with team every day. Experience in Working with teams and Individuals application development. Basic level experience in Code migration one environment to another environment (Dev Test Acc Prod). Experience Incident management tools like Service now and Jira. Experience in working with parallel applications.