ETL Developer with 4+ years in Talend & Data Integration
AI is analyzing your overall score…
Identifying your key strengths…
Evaluating your skill match against the job requirements…
Assessing your cultural and operational fit
Around 4 years of IT experience with 3+ years in full lifecycle software project development, specializing in design, application development, and data integration using Talend. Expertise includes creating complex Talend jobs, working with data warehouse concepts like Star schema and Slowly Changing Dimensions (SCD Type I, II, III), and optimizing job performance through parallelization and context variables. Experienced in error handling, version control with GIT, and end-to-end project implementation.
Jawaharlal Nehru Technological University (JNTU),Hyderabad
B.Tech · EEE
August 1, 2012 – June 30, 2016
FutureFocus Infotech Private limited
Talend developer
July 1, 2022 – Present
India
Global Logic India Pvt Ltd
Analyst
September 1, 2019 – April 1, 2020
India
Wipro BPS
Analyst
June 1, 2017 – March 1, 2019
India
Global Logic India Pvt Ltd
Associate Analyst
October 1, 2016 – June 1, 2017
India
Cigna Health Benefits
July 1, 2022 – Present
Involved in Extraction, Transformation and Loading of data. Designing and implementing ETL process using Talend Enterprise Data Integration edition to load the data from source to target database. Developing ETL mappings for various sources like .txt,.csv,.xml and load these data into relational database tables. Worked on Global context variables and context variables used over several components to create jobs. Experienced in writing SQL queries and used Joins to access data from Oracle, and MySQL. Running sub jobs in parallel, used parallelize component and multi thread execution. Worked on error handling techniques and tuning the ETL flow for better performance. Designed jobs using various Talend components like tFilterRow, tFilterColumns, tSortRow, tAggregateRow, tMap, tJoin, tUniqRow, tUnite, tReplicate, tReplace, tConvertType, tNormalize, tDenormalize, tPrejob, tPostjob, tSendMail, tLogRow and tSchemaComplianceCheck.tDie, tConvertType, tFlowMeter, tLogCatcher, tHashOutput, tHashInput. Used Talend FTP Components like tFTPGet, tFTPPut, tFTPFileList, tFTPRename, tFTPTruncate tFTPDelete, tFTPFileExist, tFTPFileProperties and tFTPConnection. Implemented Slowly Changing Dimensions Using Type2. Actively participating in daily, weekly and monthly meetings with onshore & offshore team.
Software Information
July 1, 2022 – Present
SODA - Software Dashboard is application (software) information. SODA is a new soft developed to replace the WIKI, application managers and global heads monitoring tool. We have 4 lots in soda. SODA Database + ITA Indicators, Licenses Indicators, HPC Indicators, SODA Editor + data migration. We have connected to different source system like flat files, database and servers get the different format files (xml, csv, txt) and load into Target database. Created Talend jobs to copy the files from one server to another and utilized Talend FTP components. Extensively used tMap component which does lookup & Joiner Functions, tJava, tOracle, tXml, tDelimtedFiles, tLogRow components etc. Used Talend most used components (tMap, tDie, tConvertType, tFlowMeter, tLogCatcher, tRowGenerator, tSetGlobalVar, tHashInput&tHashOutput and many more). Created Implicit, local and global Context variables in the job. Worked on Autosys for scheduling jobs. Worked on various Talend components such as tMap, tFilterRow, tAggregateRow, tFileExist, tFileCopy, tFileList, tDie etc. Used tStatsCatcher, tDie, tLogRow to create a generic joblet to store processing stats. Used tParalleize component and multi thread execution option to run subjobs in parallel which increases the performance of a job. Designed various jobs for extracting data from various sources involving flat files and relational tables. Worked on Context variables and defined contexts for database connections, file paths for easily migrating to different environments in a project. Designed various jobs for extracting data from various sources involving flat files and relational tables. Implemented Error Handling to provide the detailed error messages. Handling the execution flow for the complete workflow.
Cultural Fit Analysis
The candidate's project experience, particularly 'Cigna Health Benefits' and 'Software Information', demonstrates exposure to professional, enterprise-level environments. The mention of working with onshore & offshore teams indicates experience in distributed team settings. The breadth of Talend components and ETL methodologies used suggests adaptability and a willingness to learn and apply diverse technical solutions. The role alignment with the target ETL Developer position is strong, indicating a focused career path.
Soft Skills & Operational Fit
The candidate highlights self-motivation, excellent written/verbal communication, and teamwork skills, along with flexibility for independent responsibilities. The project descriptions indicate participation in daily, weekly, and monthly meetings, suggesting good operational fit for collaborative environments. The ability to work effectively both individually and as part of a team is explicitly stated.