• 4+ years of experience working with ETL TALEND and PL/SQL programming for various Data Migration and Integration Projects.
• Currently working as Associate Consultant in Capgemini.
• Effectively made use of Table, Functions, Indexes, Table Partitioning, Analytical functions, Materialized Views and Query Re-Write.
• Extensively used ETL methodology for performing Data Profiling, Data Migration, Extraction, Transformation and Loading using Talend(Along with TAC) and designed data conversions from wide variety of source systems including Oracle, SQL server, Hive, relational sources like flat files and Xml(For DB, Processing, Log and Big Data components) .
• Developed Complex database objects like Stored Procedures, Functions, Packages and Triggers using SQL and PL/SQL.
• Experience with Performance Tuning for Oracle RDBMS using Explain Plan and HINTS.
• Having Good expertise in all the stages of Full software development life cycle implementation (SDLC) currently following Agile methodology.
• Created Jobs in TALEND using tMap , tJoin , tReplicate, tParallelize, tContextLoad,
tflowtoIterate, tAggregate, tSortRow, tFlowMeter, tLogCatcher,tRowGenerator,tNormalize,
tDenormalize,tSetGlobalVar,tHashInput,tHashOutput,tJava,tJavarow,tAggregateRow,tWarn, tLogCatcher, tDBScd, tFilter,tDie etc.
• Developed UNIX Shellscripts to automate repetitive tasks.
• Good experience on in Tableau Scorecards, dashboard (stackbars,bar graphs, scattered plots, geographical maps,gantt charts) .