Rajpal

Data Engineer
placeholder
Location  Delhi
view-icon
Total Views 57
availability
Shortlist 0
back in time
Member since 30+ Days ago
 
Candidate Information
  • User Experience
    Experience  8 Year
  • Cost
    Hourly Rate $15
  • availability
    Availability 1 Month
  • work from
    Work From Onsite
  • check list
    Category Information Technology & Services
  • back in time
    Last Active On January 18, 2022
Key Skills
Data Modelling Data Integration Data Updation Data Warehouse Design AWS SQL MYSQL Elastic MapReduce Talend Oracle Pentaho
Summary
  • Skilled software professional with 7.5+ years of experience in creating OLTP and OLAP Datawarehouse using Talend and Pentaho Suite (Pentaho Data Integration/Kettle, Pentaho BI Server, Pentaho Meta Data and Pentaho Analysis Tool & Mondrian OLAP) on Linux and Windows platform.
  • Experienced in developing BI Reports and Dashboards using Pentaho Reports and Pentaho Dashboards.
  • Worked on the complete Software Development Life Cycle (SDLC).
  • Excellent Knowledge in RDBMS Concepts and Data Modeling using Erwin 4.0, Star and Snowflake Schemas.
  • Experience with Pentaho on Amazon Web Services (AWS) Elastic MapReduce (EMR 3.4) that uses Hadoop.
  • Data storage management using Amazon S3.
  • Experienced in Data Ingestion projects to inject data into Data lake using multiple sources systems using Talend Bigdata
  • Experienced in ETL Talend Data Fabric components and used features of Context Variables, MySQL, Oracle, Hive Database components .
  • Experienced in Talend Service Oriented Web Services using SOAP, REST and XML/HTTP technologies using Talend ESB components .
  • Experience with data integration using Pentaho,Talend, processing the data over HDFS ,MongoDB and storing it into S3 bucket.
  • Proficient in writing T - SQL Statements, Complex Stored Procedures, Dynamic SQL queries, Batches, Scripts, Functions, Triggers, Views, Cursors and Query Optimization.
  • Responsible for performance tuning of stored procedures, Database Tables using Table Partitioning, SQL Profiler and Database tuning wizard.
  • Hands on experience on the whole ETL (Extract Transformation & Load) process.
  • Detail-oriented, results-driven, excellent verbal and written communication skills with interpersonal and conflict resolution skills and possesses strong analytical skills.
  • Extensive experience in ETL methodology for performing Data Profiling, Data Migration, Extraction, Transformation and Loading using Talend and designed data conversions from wide variety of source systems including Oracle, DB2, SQL server, Hive,MYSQL and non - relational sources like flat files, XML and REST API,MongoDB.
  • Big Data Hadoop Experience.
  • Expertise in creating mappings in TALEND using tMap, tJoin, tReplicate, tParallelize, tConvertType,

tflowtoIterate, tAggregate, tSortRow, tFlowMeter, tLogCatcher, tRowGenerator, tNormalize, tDenormalize,

tSetGlobalVar, tHashInput, tHashOutput, tJava, tJavarow, tAggregateRow, tWarn, tLogCatcher, tMysqlScd