Hi, I’m
Arun Mathaiyan
Azure Data Engineer
Summary
Azure Data Engineer with 15+ years of experience as MS SQL Server programming (T-SQL) and Business Intelligence developer (SSIS, SSRS and SSAS). Lead the Team with good Communication & Management skills. Experienced in Azure data bricks/Data lake storage, note book creation using sql/scala. Designed pipeline using Azure data factory components. Involved in migration of on-perm SSIS package to Azure data factory. Involved in monitoring ADF pipelines. Played Onsite role in USA as a Technical lead from March 2016 to Jan 2017. Designing and Deployment of Reports for the End-User requests using SSRS. Expertise in designing databases and writing complex SQL queries and Performance tuning. Expertise in Performance tuning, Optimization, Data integrity and Statistics by using SQL Profiler. Involved in migration of SSIS Packages 2012/2014 SP1 CU5 and troubleshoot migration issues. Experience in providing Logging, Error handling by using Event Handler, and Custom Logging for SSIS Packages. Expertise in Performance Tuning in SSIS packages by using Row Transformations, Parallel execution, Block and Unblock Transformations.
Overview
15
years of professional experience
4
Certifications
2
Language
Work History
Cognizant
Senior associate
8 2018 - Current
Job overview
- Understanding the Business change requirements
- Designing and implementing the changes/requirements by client
- Designing Azure Data factory Pipelines and monitoring pipeline trigger schedules
- Coding databrick notebook using scala/sql for data processing
- Involved in performance tuning of ADF pipelines and slow running queries
- Migration of On-Prem database/process to Azure Data Lake
- Writing complex stored procedure Implemented column store index
- Implemented SQL 2017 features.
Accenture Pvt Ltd
Technical Lead
11.2009 - 07.2018
Job overview
- Understanding the Business change requirements
- Analyzing technical Feasibility of implementing the changes that are required for business
- Identifying risks involved in implementing change requirements if any
- Proposing process improvements in existing system
- Designing and implementing the changes/Requirements by client
- Involved in logical and physical data model store for Global Compensation Solutions Designing ETL packages using Accenture ETL Framework
- Organizing Meeting with team and gather status of each development process that is going currently
- Conveyed Build status to business managers in onshore team
- Represented reporting technical team in all across team impact analysis meetings
- Assisted functional lead and project manager with work plan tasks
- Monitoring reporting/database jobs and ensures all reports are delivered during Compensation administration support focal in time
- Identifying slow running process if any in generating reports and take necessary actions to improve its performance using performance monitoring tool
- Resolving Adhoc requests if any during compensation administration support focal.
Savant Technologies Pvt Ltd
Software Engineer
03.2007 - 09.2009
Job overview
- Create database objects like Tables, Views, functions etc
- Involved in writing stored procedures required for the modules
- Uploading energy deregulatory body pricing data to MX Pricing System through DTS package Performed designing, coding and unit testing
- Designed SSRS reports for data analysis
- Involved in performance tuning.
Education
Sri Ramakrishna Engineering College, Coimbatore
Bachelor of Engineering in Electronics and Instrumentation
01.2002 - 2006.04
Skills
Azure Data factory
Certification
AZ-900 Microsoft Azure Fundamentals
Passportinformation
H4812728
Personal Information
- Date of Birth: 02/14/1985
- Gender: Male
- Nationality: Indian
- Marital Status: Married
Timeline
Technical Lead
Accenture Pvt Ltd
11.2009 - 07.2018
Software Engineer
Savant Technologies Pvt Ltd
03.2007 - 09.2009
Sri Ramakrishna Engineering College, Coimbatore
Bachelor of Engineering in Electronics and Instrumentation
01.2002 - 2006.04
Senior associate
Cognizant
8 2018 - Current
Similar Profiles
Navya VootlaNavya Vootla
Associate at CognizantAssociate at Cognizant
Vyshali Santhosh KumarVyshali Santhosh Kumar
Support Engineer at CognizantSupport Engineer at Cognizant
Preethi RPreethi R
Programmer Analyst at CognizantProgrammer Analyst at Cognizant
MANISHA REDDY KUCHANPALLYMANISHA REDDY KUCHANPALLY
Infra Dev Specialist at CognizantInfra Dev Specialist at Cognizant
Shray YadavShray Yadav
Senior Associate at EXL Services (India) Private LimitedSenior Associate at EXL Services (India) Private Limited