Lokesh Susani Email and Phone Number

I have 9+ years of experience as a Data Engineer with over leveraging Microsoft SQL Server products, including T-SQL, SSIS, SSRS, and Power BI. My core competencies include data mapping and validation, ensuring high data quality and integrity.I have hands-on expertise in implementing data warehouse solutions on AWS Redshift, successfully managing several projects that involved migrating data from on-premises databases to AWS services, including Redshift, RDS, and S3. My role also includes managing databases and Azure Data Platform services such as Azure Data Lake (ADLS), Data Factory (ADF), Data Lake Analytics, Stream Analytics, Azure SQL Data Warehouse, and HDInsight/Databricks, along with traditional SQL and NoSQL databases.I specialize in developing efficient data pipelines using AWS services like EC2, S3, Redshift, Glue, and Lambda functions. Additionally, I have experience with Apache Flink for processing streaming data from Kafka.I have developed production-ready applications using Apache Spark and have extensive experience with source control systems like GitHub, Bitbucket, and Jenkins for CI/CD deployments.My background includes creating, implementing, and documenting data models for enterprise applications, as well as expertise in ETL data pipelines, data visualization, and data warehousing. I am well-versed in the Big Data ecosystem, including Hadoop technologies such as HDFS, MapReduce, Hive, Pig, and Kafka, and I have developed RDDs and DataFrames to transform data efficiently.I have solid skills in Python and SQL, contributing to the design and automation of ETL pipelines from start to finish. I also utilize version control tools like GitLab and SVN Code Commit to maintain code integrity.Familiar with Agile methodologies, I engage in Scrum practices to ensure timely and high-quality deliverables. My knowledge encompasses a broad range of databases, including DynamoDB, MySQL, and various NoSQL options like MongoDB and Redis.With expertise in managing AWS services, I automate and configure instances, focusing on security and performance. I follow Python PEP guidelines and possess strong skills in Linux Bash scripting, as well as proficiency in crafting SQL queries, stored procedures, and triggers for multiple relational databases.My recent work includes creating data pipelines in Azure Data Factory, extracting and transforming data from various sources, and gaining experience with Google Cloud Platform’s DataProc, GCS, Cloud Functions, and BigQuery.