05/20/2025 updated
RD
100 % available
Big Data Analyst with ETL and Data Warehousing Experience
Pune, India
Worldwide
Bachelor of Engineering (B.E.)C (Programming Language)Amazon Web ServicesAmazon Elastic Compute CloudAmazon S3Data AnalysisBusiness IntelligenceBig DataBootstrap (Software)C++ (Programming Language)Cloud ComputingDatabasesContinuous IntegrationExtract Transform Load (ETL)Data MiningData Modeling
Big Data Technologies
Expertise in Hadoop ecosystem including HDFS, Hive, Sqoop, and Apache Spark for processing large datasets. Experience in designing and developing Big Data applications with real-time data processing capabilities.
ETL Development
Proficiency in Informatica PowerCenter IICS, PL/SQL development, and data pipeline design. Experience in data extraction, transformation, loading, and migration across various database systems.
Cloud Technologies
Working knowledge of AWS services including RDS, S3, Athena, EMR, and EC2. Experience with cloud data warehousing solutions and deploying Spark jobs on EMR clusters.
Database Management
Experience with Oracle Database, Snowflake, SQL, and Sybase for data storage and retrieval operations.
Programming Languages
Knowledge of C, C++, XML, Java Spring Boot, REACTJs, Bootstrap, PL/SQL, and Shell Scripts for application development.
Data Analysis
Skills in data warehousing, business intelligence reporting, data modeling, and regression analysis.
DevOps Practices
Experience with GIT for version control, CI/CD pipelines using Jenkins, and implementing DevOps methodologies.
Expertise in Hadoop ecosystem including HDFS, Hive, Sqoop, and Apache Spark for processing large datasets. Experience in designing and developing Big Data applications with real-time data processing capabilities.
ETL Development
Proficiency in Informatica PowerCenter IICS, PL/SQL development, and data pipeline design. Experience in data extraction, transformation, loading, and migration across various database systems.
Cloud Technologies
Working knowledge of AWS services including RDS, S3, Athena, EMR, and EC2. Experience with cloud data warehousing solutions and deploying Spark jobs on EMR clusters.
Database Management
Experience with Oracle Database, Snowflake, SQL, and Sybase for data storage and retrieval operations.
Programming Languages
Knowledge of C, C++, XML, Java Spring Boot, REACTJs, Bootstrap, PL/SQL, and Shell Scripts for application development.
Data Analysis
Skills in data warehousing, business intelligence reporting, data modeling, and regression analysis.
DevOps Practices
Experience with GIT for version control, CI/CD pipelines using Jenkins, and implementing DevOps methodologies.
Experience
Professional experience0 - 5 years
Freelancer since2025
Languages
EnglishFluent
Project history
Created EC2 instances and EMR clusters, performed data processing using Spark, Hive, and HDFS. Optimized Spark SQL queries and managed data transformations for semi-structured data formats.
Worked on OPERA & DAL project, a strategic sub-ledger application for trading activities, operations, and funding allocation. Developed PL/SQL procedures, collaborated with stakeholders, and implemented ETL processes.