RATHINA MOORTHY P

● 8+ years of IT Experience in Analysis, Design, Development, Implementation and Support of Relational Database (OLTP), Data Warehousing System (OLAP) and Data Marts in various Domains.

● 5+ Years of Experience in Data Warehousing projects using ETL tool Talend Data Integration (Talend Open Studio), SSIS, JIRA, Power BI and Microsoft SQL Server.

● Well versed with Relational and Dimensional modelling techniques like Start Schema, Snowflake Schema, Fact and Dimensional Tables.

● Design and developed end-to-end ETL process from various source systems to Staging area, from staging to Data Marts.

● Experience in Design, develop, deploy, troubleshooting, debugging and monitoring ETL solutions on premises using Task Scheduler or SQL Agent.

● Good Experience in creating jobs, workflows, data flows, SQL scripts using various transformation and successfully loading data from multiple sources into desired target.

● Analyze and present data to help the company make important decisions Perform DAX queries using Power BI tools. Having strong knowledge on database development.

● Advanced experience in writing SQL queries, data processing, database design and development.

● Strong ability to create & maintain Stored Procedures, Functions, Tables, Joins, and Hash tables. Well experienced in design, implement, maintain, and deploy the MS SSIS packages.

● Experienced in creating ADF pipeline to transfer the data from different sources to Azure database.

● Involved in preparation of Test Cases based on High level requirements and make an ensure detailed/system level process write Test Scripts Work Experience in Data Warehouse and Data Modelling.

● Experienced in query optimization and index strategies.

● Strong working experience in the Data Analysis, Data Verification and Validation of an ETL Applications using Backend/Database Testing.

Worked on various domains like Logistics, Healthcare, and Insurance. Able to work independently or as part of a team to meet the deadlines.