Adarsh J Email & Phone Number

With eight years of experience specializing in performance tuning and optimization of ETL data flows, as well as designing and enhancing database logical models, I bring expertise in AWS Cloud services such as Redshift, Glue, and Cloud Formation. Proficient in troubleshooting CDK, Step Function, SNS, and SQS, I collaborate effectively with cross-functional teams to develop robust data integration solutions. My skill set includes Python, Terraform, and Informatica, enabling me to create various data visualizations using Python and Tableau, manage VPCs and subnets, and migrate Oracle data into Hadoop with custom UDFs in Python. Spearheading big data processing initiatives using Spark, Pyspark, and Scala, I optimize data workflows and implement Hive queries and data models while leveraging Map Reduce programming for comprehensive big data analysis.Additionally, I excel in orchestrating the design and implementation of MySQL, NoSQL databases (MongoDB, Cassandra, Dynamo DB), and PostgreSQL, ensuring adherence to data governance policies and standards. I am adept at testing Snowflake for cloud resource optimization, crafting dynamic data visualizations in Power BI, and developing interactive dashboards in Tableau. Proficient in version control using Git and project management with Jira, I possess extensive expertise in Azure Data Factory, Databricks, SQL Database, Blob Storage, and Data Lake Storage, ensuring streamlined data processing and workflow automation. Furthermore, I have a proven track record in developing PL/SQL and shell scripts to support ETL data flows, optimizing Spark jobs for large-scale data processing, and administering MySQL, NoSQL databases, and PostgreSQL for robust data storage and retrieval solutions.

• 

  Data Engineer

  Oscar Health

  Jul 2021 - Present - New York, United States

  With hands-on experience in AWS Cloud services such as Redshift cluster, AWS Glue, Cloud Formation, Cloud Watch, CDK, and Route 53 domain configuration, I've worked extensively with various AWS components including Elastic Search, EMR, Athena, SNS, Step Function, SQS, Cloud Formation, Secret Manager, and Snowflake. In the realm of data engineering, I bring comprehensive experience in performance tuning and optimization of Informatica workflows, as well as performance profiling and tuning of ETL data flows. I have a track record of designing ETL dataflows and database logical models for feature enhancement, alongside creating various types of data visualizations using Python and Tableau schemas, and managing VPCs and subnets. Migrating Oracle data into Hadoop and writing custom UDFs in Python are among the technical tasks I have undertaken, along with spearheading big data processing initiatives using Spark and Pyspark, and developing and maintaining Scala applications to enhance data processing capabilities.My expertise extends to areas such as designing and implementing Hive queries and data models, conducting performance tuning on Spark jobs, Scala applications, and Hive queries, and developing Map Reduce Programs using Apache Hadoop for analyzing big data using EMR and Cloudera platforms. Furthermore, I have orchestrated the creation of dynamic and insightful data visualizations using Power BI and designed interactive dashboards in Tableau. I have also been instrumental in implementing version control and collaborative development strategies using Git, and utilizing Jira for effective project management, maintaining clear communication and coordination within the data engineering team, and tracking progress through agile methodologies.

• 

  Chaitanya Bharathi Institute Of Technology

  A+