Azim Raza

ETL Consultnat

NCS

Location: Singapore
Education: Bachelor's degree, Computer Science &Engineering
Experience: 14 years, 6 Months

Work Experience

Total years of experience :14 years, 6 Months

ETL Consultnat at NCS

Singapore
My current job since January 2019

Designing the ETL templates and developing numbers of ETL-SSIS.
• Data mapping between Source Data files to Staging tables, Staging tables to DW tables and DW tables to Data mart tables
• Designing ETL packages (SSIS) and Database design (Sachems, Tables, Defining Key Relations, Triggers, Indexes, and Stored Procedures),
• Creating and scheduling SQL Server Agent Jobs.
• Writing complex T SQL scripts for Data Mart.
• Preparing deployment documentation of SSIS.
• Meeting with Business Analyst and data modeling team to understand requirements and existing.
• Creating number of test cases for Unit testing.
• Unit testing, Preparing Functionality and Technical Documents
• Interaction with customer on business requirement.

Senior Developer at Tech Mahindra

India - Hyderabad
February 2015 to January 2019

• Creation of Design detail specification for ETL.
• Data mapping between Source Data files to Staging tables, Staging tables to ODS tables and ODS tables to Data mart tables
• Designing ETL packages (SSIS) and Database design (Sachems, Tables, Defining Key Relations, Triggers, Indexes, and Stored Procedures),
• Development and deployment of various parameterized reports with SQL Reporting Services (SSRS)2005,
• Creating and scheduling SQL Server Agent Jobs.
• Preparing POCs for the customer and giving presentation.
• Preparing deployment documentation of SSIS
• Creating number of test cases for Unit testing,
• Unit testing, Preparing Functionality and Technical Documents
• Interaction with customer on business requirement.

Senior Developer at Mindtree

India - Bengaluru
December 2010 to January 2015

• Analysis of given requirements and do the effort estimation for the same.
• Creation of technical document of enhancement task and get the approval from business.
• Creation/Modification of Stored Procedure
• Creating packages in SSIS Designer using Control Flow and Data Flow transformations to implement business rules.
• Creation of SQL Jobs.
• Scheduling and Monitoring the ETL Packages for daily load in SQL Server job Agent
• Unit Testing and reviewing all deliverables.
• Check in - check out in TFS.
• Troubleshoot and correct any reported data issues in deliverables.
• Respond quickly to bug fixes and enhancement requests.
• Playing Module lead role as well as.