Lalit Dath Email & Phone Number

Pittsburgh, Pennsylvania, United States

• Built and implemented relational servers and databases for the Azure Cloud.
• Delivered and approached the data migration for advancement of current solutions from on-premises systems and apps with pipelines to Azure cloud is being developed.
• Implementing Azure Data Factory, Spark SQL, and U-SQL Azure Data Lake Storage Gen2 (ADLS) Analytics, extract, transform, and load data from sources systems to Azure Data Storage services.
• Integrated the data from on-premises SQL servers to cloud databases (Azure Synapse Analytics & Azure SQL DB).
• Created a Spark job using Azure Databricks to replace the current ETL/SSIS solution and provided Data warehouse solutions on Azure Synapse using Polybase/external tables.
• Performed with data analysis using HiveQL, HBase, and custom Map Reduce programs as well as experience importing and exporting data from RDBMS to HDFS and Hive.

Eagan, Minnesota, United States

• Interpreted the usage, installation and configuration of the various parts of the Hadoop ecosystem
• Implementation of the Google Cloud Platform's BigQuery and Cloud DataProc services to build and develop production data engineering solutions that deliver our pipeline patterns.
• Designed the tools of the Hadoop ecosystem, including HDFS, MapReduce, Hive, Pig, YARN, Spark, HBase, Oozie, Sqoop, and Zookeeper.
• Normalization of databases like Oracle, SQL, PostgreSQL, and Cassandra complies with design principles and best practices.
• Deployed Talend Data Integration and Informatica Power Center to analyze the ETL technologies for developing data warehouses, BI, analytics, ETL procedures, data mining, data mapping, data conversion, and data migration.
• Designed Power BI to build reports and dashboards, comprehend the data, and make business choices while working as a downstream data analyst.

Vernon Hills, Illinois, United States

• Examined the information at the cluster level from several databases when data transformation or data loading occurs.
• Built many SQL scripts for data discrepancies as part of data migration and worked on migrating history data from Teradata SQL to Snowflake.
• Deployed SQL Server Integration Services (SSIS) to build automated data pipelines to transport the data more effectively and used SQL Server Management Studio (SSMS) to construct database connections and write scripts.
• Defined and controlled the policies for S3 buckets, which were used by AWS as backup and storage.
• Integrated with Tibco and Spotfire and made computations along with predictive modeling using python scripts.
• Evaluated promotional activities from a number of angles to maximize the return on investment for clients including click-through rates, conversion rates (CON), seasonal trends, search queries, quality scores (QS).