Senthilkumar Kannan

Background

About Senthilkumar Kannan

Innovative & Highly qualified Data Architect, Azure certified Principal/Lead Data Engineer(PySpark & SQL), API developer Informatica BDM Developer, Senior ETL Developer & Senior Data Warehouse Developer with 15+ years of IT experience in the domain of Banking, Health Insurance and Retail with Agile, Scrum and waterfall methodologies, which includes Requirements gathering, Analysis, Planning, Design, Development, Testing and Implementation of various Data applications. • Strong problem solving skills in Businesses with good stakeholders handling experience. • Strong knowledge in developing complex ETL notebooks in Azure Databricks using Pyspark and SQL to build any kind of ETL solutions. • Designed & Developed & Scheduled Data pipelines using Azure Data factory • Strong knowledge in developing complex mappings in Azure Synapse to ingest and serve data for immediate BI • Good experience in handling cloud data storage components Azure Datalake, Azure SQL DB, Azure Synapse, HDFS and HIVE and traditional Database systems. • Strong experience in Data modelling using Kimball and Data Vault. Developed both STAR and SNOWFLAKE models. • Actively involved in CI and CD activities using Azure DevOps, Push & Pull functions between local GIT and DevOps repos, Build package using Pipelines and deploy in higher environments by designing task groups for environment variables. • Almost 7 years of experience in the traditional ETL tool Informatica. The latest version which used is Informatica BDM v10.2.2 • Have strong knowledge in developing complex ETL mappings by using other Informatica tools Informatica Developer and Power center. • Good knowledge in DWH and BI concepts & Linux shell scripts • Strong hands on experience in traditional storage systems. Teradata, Oracle, MS SQL Server and IBM DB2 • Ability to meet deadlines & decisive with strong leadership qualities, flexible in work schedules and possess good communication skills. • Almost 5 years of experience as Technical Lead and managed 8 Team members team, Motivated, Strong Organizer, Skilled negotiator, Clear Communicator, Good Reviewer, Team monitoring, Good Coach, Internal Auditor, seminars and trainings to scale up Team