Ashutosh

·        Currently working as an ETL Developer at Kellton Tech and the responsibilities include:-

·        Having 7 + years’ experience of working on Informatica (Powercenter Designer 9.6), SSIS, Talend, Oracle 11g and Microsoft SQL Server 2012.

·        Worked on different projects of Investment Banking and Travel Domain with specific requirements like Data Integration and End to End development from Data Warehousing to ETL.

·        Tasks like implementing Incremental loading and SCD2 for maintaining history of data.

·        Designing the Data warehouse and Data Marts by using Dimension/Facts Modelling.

·        Creating new workflows and Procedures for the new development processes and doing Performance Tuning on existing workflows and Oracle procedures.

·        Creating procedures, indexes, triggers on tables according to requirement in SQL Server and performed SQL Tuning to reduce run time of long running procedures.

·        Creating SSIS packages for ETL requirements and deployment of these packages to various environments.

·        Leading team at offshore, creating Design Documents, UT Documents.

·        Working on Agile Methodology, participating in Sprint Planning meetings.