Aparna S Email & Phone Number

United States

• Deployed an Enterprise Data Lake supporting analytics across ingestion, processing, and reporting.
• Maintained high-quality reference data via cleaning and transformation, collaborating with stakeholders.
• Developed Spark SQL ETL solutions in Databricks for data aggregation from various sources.
• Used Athena for BI reporting on Glue ETL processed data and applied NoSQL databases (HBase, Cassandra, MongoDB) in pipeline development.
• Designed Hadoop and Hive data pipelines using… Show more
• Designed Hadoop and Hive data pipelines using Talend, PySpark, and Apache Spark;

• Developed batch and stream processing applications with Spark APIs to handle diverse data processing needs.
• Utilized Databricks notebooks for data preparation including cleansing, validation, and transformations as required by projects.
• Engineered robust data pipelines across the AWS stack (EMR, EC2, S3, RDS, Lambda, SQS, Redshift) for seamless data flow and processing.
• Developed Sqoop jobs for efficient data ingestion from RDBMS to HDFS and created custom-built REST APIs… Show more
• Developed Sqoop jobs for efficient data ingestion from RDBMS to HDFS and created custom-built REST APIs for real-time customer analytics.
• Extracted and enriched data using SparkSQL and transformed Hive queries into Spark for advanced analytics.

• Enhanced data transfer between Hadoop Data Lake and relational systems (MySQL, Oracle) using Sqoop.
• Assisted in managing Kafka topics, including custom partitioning to improve data distribution.
• Developed Spark applications in Python (PySpark) for distributed data processing across multiple projects.
• Supported application deployment in AWS environments, optimizing performance with CloudFront and AWS Lambda.
• Gained extensive experience with AWS services like EC2, S3, EMR… Show more
• Gained extensive experience with AWS services like EC2, S3, EMR, EBS, RDS, and VPC.

Chicago, Illinois, United States

• Contributed significantly to Big Data Integration and Analytics initiatives, leveraging advanced technologies such as Hadoop, Spark, SparkSQL, and NoSQL Database.
• Collaboratively participated in the meticulous maintenance of clusters, including tasks such as adding and removing cluster nodes, continuous cluster monitoring, troubleshooting, and overseeing data backups and log.
• Played a crucial role in the seamless… Show more
• Played a crucial role in the seamless loading of data from the LINUX file system to HDFS, demonstrating expertise in data migration concepts within the Hadoop ecosystem.
• Conducted in-depth data analysis using Hadoop components Hive and Pig, crafting sophisticated Hive queries that empowered market analysts to identify emerging trends through the comparison of fresh data with EDW.
• Executed critical tasks in importing data to HDFS using Sqoop from diverse RDBMS servers and facilitated data export using Sqoop to the RDBMS servers after aggregations for other ETL operations.

• Engaged in the intricate process of designing both the logical and physical data models for the data warehouse solution, ensuring a comprehensive and efficient structure.
• Implemented the creation of clustered and non-clustered indexes on tables based on the specific business requirements, optimizing data retrieval and overall database performance.
• Took charge of enforcing data and referential integrity through the creation of triggers, strategically placed on the necessary… Show more
• Took charge of enforcing data and referential integrity through the creation of triggers, strategically placed on the necessary tables.
• Conducted in-depth monitoring of complex queries, stored procedures, and their performance using SQL
• Profiler, ensuring the ongoing optimization of database operations.