ACTIMIZE – ETL designing, development and Testing using SQL Server 2012, SSIS and INFORMATICA for current IWB project. Design, Development and Testing of Mappings using SSIS and Informatica. Successfully converted 2005 SSIS packages into 2012 SSIS packages and migrated to the new server. Deployed all the converted packages to the production environment. Monitoring job execution every day and Resolving issues if job gets failed. Converting EBCDIC files into ASCII and loading them in SQL staging tables using Micro Focus COBOL. Developing .NET console application project with a program that processes one or more record types. Finding PII fields once data load from the EBCDIC files into SQL tables in the ASCII format. Masking PII fields from staging tables and loading them into the target tables. Involved in creating SSRS reports for the Daily, weekly and Monthly SSIS and INFORMATICA jobs success and failure results using CONTROL-M log data. Participating daily agile scrum meetings. Works with business analyst to modify demo for presentations.
- B.E / B.Tech