Rajshekar

• Developed ETL jobs to extract data from multiple sources such as Oracle, MySQL and flat files using Talend Studio
• Designed complex mappings for data transformation from source to target systems with Talend components like tMap, tJoin, tAggregate, tUniq Row, and tFilterRow
• Implemented error handling techniques in Talend jobs by configuring components like tDie, tWarn and tJavaFlex
• Good knowledge of Slowly Changing Dimensions of type I, II, and III in Talend
• Experience working with various data formats (e.g CSV, JSON, XML, TXT, Excel)
• Monitored the execution of scheduled jobs on a daily basis and troubleshooted any issues encountered during runtime in TMC
• Proficiency in using Talend components like tFileInputDelimited, tFileInputJSON, and tFileInputXML
• Coordinated with business users to understand requirements related to data extraction, transformation and loading process
• Configured scheduling options in order to automate the execution of developed ETL processes at regular intervals
• Extract data from Snowflake, transform it using Talend's data integration capabilities, and load the transformed data into the desired target system (e.g., another database, data warehouse, or cloud storage)
• Excellent communication skills, with experience communicating with business stakeholders, technical teams, and management

Project #1 - File migration using Talend

• Environment: Talend 7.2, Data stage, SQL
• Developed and implemented an ETL (Extract, Transform, Load) pipeline to automate the ingestion and processing of data files from an FTP server into Snowflake
• This pipeline involved downloading files, applying business logic, loading data into Snowflake, and managing file storage and backups
• Responsibilities: Gathering requirements and implementing them into source to target mappings in loading
• Interacting with business analysis in understanding the database requirements
• Worked on unit testing and performance tuning of the jobs
• Involved in the Integration Testing
• Error logs used debugger to test mapping and fixed bugs in development, following change procedures and validation
• Precisely documented mappings to ETL Technical specification document for all stages for future reference
• Automated file cleanup by deleting processed files from the local drive
• Effectively played a multi-dynamic role, facing all challenges, and managed working on similar projects as well.

Project #2 - Talend Development Project

• Environment: Talend data integration 5.4, 6.1.1, Oracle 10g,11g.
• The project aimed to enhance operational efficiency by automating and optimizing the integration of data from Excel files into a JIRA-based workflow
• The initiative focused on managing data files, updating JIRA tickets, and applying complex data transformations based on business rules, with the ultimate goal of loading the transformed data into a target system
• Responsibilities: Analyzed and performed data integration using Talend open integration suite
• Worked closely with Business Analysts to review the business specifications of the project and to gather the ETL requirements
• Worked on improving the performance of Talend jobs
• Created mappings in Talend using tHash, tMap, and tUniqueRow
• Used tStatsCatcher, tDie, tLogRow to create a generic job that stores processing stats into a Database table
• Worked on performance tuning of the jobs
• Precisely documented mappings to ETL Technical specification document for all stages for future reference
• Effectively played a multi-dynamic role, facing all challenges, and managed working on similar projects as well
• Used Database components like tOracleOutput, tOracleInput, and tOracleconnection
• Worked with various File components like tFileCopy, tFileExist, and TFileDelete
• Created repository schemas
• Resolved assigned tickets within Service Level Agreements (SLA's)

Project #3: Snowflake to S3 Data Pipeline

• Extract data from Snowflake tables.
• Transform the data using Talend components (e.g., tMap, tFilterRow, tSortRow).
• Load the transformed data into Amazon S3 in a desired format (e.g., CSV).

• Developed stored procedures, functions and triggers to support application requirements
• Integrated multiple data sources into one unified view using views or joins in SQL queries
• Created database objects like tables, views, indexes in Oracle 11g and 12c databases
• Resolved customer service requests related to database errors or performance issues quickly and efficiently
• Implemented data migration from legacy systems to new databases.