Senior Location IN Company Larsen & Toubro Infotech Ltd "Talend Job Description Must have- ? Experience in Talend with Autosys, Redshift & AWS knowledge ?
6 years of experience in full life cycle of software project development in various areas like design, Applications development of Enterprise Data Warehouse on large scale development efforts leveraging industry standard using Talend- ?
5 years of experience using Talend Data Integration Standard Edition / Big Data Integration (7-2) / Talend Data Quality- ?
Extensive knowledge of business process and functioning of Mortgage, Financial, Retail and Banking sectors- ? 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 Netezza, Oracle, DB2, SQL server, Teradata, Hive, Hana and non - relational sources like flat files, XML and Mainframe files- ?
Should be strong 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, tFilter, tGlobalmap, tDie etc- ?
Strong Experience with shell scripting, understanding of approaches for business intelligence, data warehouse- ? Self-Starter and Team Player with excellent communication, organizational and interpersonal skills with the ability to grasp things quickly- ?
Should have created many complex ETL jobs for data exchange from and to Database Server and various other systems including RDBMS, XML, CSV, and Flat file structures- ?
Console (TAC) for scheduling jobs and adding users- ? Should have experience in creating a generic joblets- ? Solid experience in implementing complex business rules by creating re-usable transformations and robust mappings using Talend transformations like tConvertType, tSortRow, tReplace, tAggregateRow, tUnite etc- ?
Should have experience in integrating java code inside Talend studio by using components like tJavaRow, tJava, tJavaFlex and Routines- ?
Should have Experience in using debug mode of talend to debug a job to fix errors- Created complex mappings using tHashOutput, tHashInput, tNormalize, tDenormalize, tMap, tUniqueRow- tPivotToColumnsDelimited, etc- ?
Used tRunJob component to run child job from a parent job and to pass parameters from parent to child job- ? Should have experience in creating Implicit, local and global Context variables in the job to run Talend jobs against different environments- ?
Used tParalleize component and multi thread execution option to run subjobs in parallel which increases the performance of a job- ?
Implemented FTP operations using Talend Studio to transfer files in between network folders as well as to FTP server using components like tFileCopy, TFileAcrchive, tFileDelete, tCreateTemporaryFile, tFTPDelete, tFTPCopy, tFTPRename, tFTPut, tFTPGet etc- ?
Experienced in Building a Talend job outside of a Talend studio as well as on TAC server- Nice to have- ? Talend Admin nice to have ?
To Create Talend ETL jobs to receive attachment files from pop e-mail using tPop, tFileList and tFileInputMail and then loaded data from attachments into database and achieved the files- ?
Strong understanding of NoSQL databases like HBase, MongoDB- ? Expertise in Data modeling techniques like Data Modeling- Dimensional / Star Schema and Snowflake modeling, Slowly Changing Dimensions (SCD Type 1, Type 2, and Type 3)- ?
Excellent working experience in Waterfall, Agile methodologies- Proficient in performance analysis, monitoring and SQL query tuning using EXPLAINPLAN, Collect Statistics, Hints and SQL Trace both in Teradata as well as Oracle- ?
Well versed with Talend Big Data, Hadoop, Hive and used Talend Big data components like tHDFSInput, tHDFSOutput, tPigLoad, tPigFilterRow, tPigFilterColumn, tPigStoreR Job Segment Business Intelligence, Data Warehouse, Database, Developer, Warehouse, Manufacturing, Technology