Senior Associate - Project Data Engineer (Databricks, Synapse Analytics & Snowflake)
Cognizant - India
مجموع سنوات الخبرة :9 years, 4 أشهر
Handled multiple data load pipelines, built and handled the Azure ADF pipelines, prepared the copy, lookup activity, pipeline, SSIS Packages and stored procedure activities, developed datasets, loaded data into different layers, moved data from sources to the destination, utilized ADF for transforming data, prepared T-SQL, worked on DDL and DML, conducted SQL queries and stored procedure performance tuning, and developed Power BI Report views.
Resolved production concerns, managed ETL load levels, worked extensively with SQL Server Integration Services (SSIS), utilized Excel and SQL Server to organize and format client files, supported production deployment, and maintained compliance and governance metrics.
Worked on SSIS 2012/2014/2016 Package Development, created complex reports in Power BI and SSRS, implemented business logic using Views, Stored Procedures, and table-valued functions, conducted UAT, cleanse, de-duplicate, and format client files using Excel and SQL Server
Conducted system analysis, developed functional requirements, performed ETL Loads, designed, updated, and modified packages, worked on the SQL Server Integration Services (SSIS), developed SQL Server Query for manager reporting needs, cleaned, de-duplicated, and formatted client files using Excel and SQL Server, and created Parameterized Queries for SSRS 2012 Tabular generation.
Bachelors of Engineering - Computer Science