• Extensive experience in Database Design, Development, and maintenance of database applications on SQL Server, Oracle, MySQL, Amazon Redshift and Snowflake in OLAP/BI environment. • Developed ingestion pipelines and data analysis systems • Provided technical expertise and created software design proposals for upcoming components • Expert in developing SSIS Packages to extract, transform and load (ETL)/DTS data into the data warehouse database from heterogeneous databases. • Expert in developing Talend ETL Jobs and deploy jobs on linux ETL servers. • High proficiency in using ETL tools such as SSIS, Talend Experience in creating jobs, SQL Mail Agent, Alerts and schedule SSIS Packages, Schedule Talend Jobs using crontab. • Created Scalar Python and SQL Functions in Amazon Redshift to Clean the data. • Created Python scripts to pull the data from different APIs and created CSV, JSON format data and loaded into warehouse. • Created Python, Pyspark scripts to process the data from CSVs and automated ETL jobs. • Building, publishing customized interactive reports and dashboards, report scheduling using Tableau server and Tableau Online. • Created Tableau workbooks for Data Alerts, Job Execution Logs. • Developed Tableau workbooks from multiple data sources using Data Blending. • Strong experience as a lead Developer and in guiding team efforts to meet objectives. • Proficient in working closely with system/network administrators, developers and end users. • Strong Interpersonal skills and equally adept at documentation. • Highly motivated and passionate about working in a challenging environment. • Expert in adapting to various environments and situations and strong organizational and management skills.