- 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