Data Developer

Email: *****************@*****.***

Mobile: +91-739*******

A.Tendulkar Yadav

Professional Summary

• Over 2.8 years of experience with Talend open studio & Talend Enterprise platform for data management.

• Experience in Data Integration and Bigdata with Talend

• Extensive experience in development and maintenance in a corporate wide ETL solution using SQL, TALEND 7.x/6.x on UNIX and Windows platforms.

• Strong experience with Talend tools – Data integration and experience in Joblets, Meta data and Talend components, jobs

• Experience in Extraction, Transformation and Loading (ETL) of data from multiple sources into Data Warehouse and Data Mart.

• Well versed with Star-Schema & Snowflake schemas for designing the Data Marts.

• Extensive knowledge in complete Software Development Life Cycle (SDLC) involving Requirements.

• Extensive knowledge of various Performance Tuning Techniques on Sources, Targets, Talend Jobs, and Data Base tuning.

• Created mappings using Lookup, Aggregator, Joiner, Expression, Filter, Normalizer and De- Normalizer, Maps Transformations.

• Experienced in using Talend database components, File components and processing components as per the design requirements

• Good knowledge on implementing SCD Type-1, Type-2, Type-3 Dimensional tables and facts.

• Having experience in start and stop all TAC services like Command Line Server, Log Server, Talend Admin Server, and Job Server.

• Thorough understanding of configuration, administration and upgrading of Talend data integration.

• Experience in Publish Talend jobs in TAC.

• Experience in writing database scripts such as SQL Queries like functions, Views, Indexes, and Triggers

• Experience in Waterfall and Agile Methodology.

• Performed data validation by unit testing and Integration testing.

• Extensive experience in On Shore-Off Shore Coordination/Design Reviews/Code reviews/Implementing Standards.

• Excellent interpersonal and communication skills and is experienced in working with senior level managers, business customers and developers across multiple disciplines. Work Experience

Working as Talend Developer in WIPRO LIMITED, Banglore from September 2018 to Till Date. Academic Qualification

• Bachelor of Technology from Methodist College of Engineering & Technology, Abids, Hyderabad in 2018.

Technical Skills

Languages SQL

Operating System Windows, UNIX Fundamentals.

ETL Tools Talend DI and Big Data

Database Oracle, MSSQL, MySQL

Projects Profile

Project #2

Role Talend Developer

Client ONYX Healthcare USA.

Team Size 6

Technologies Talend 7.0, MySQL, Oracle, Windows XP,TAC. Project Description

ONYX Healthcare USA is at the forefront of this revolution by exploring the world of medical technology with innovation and efficiency. From telemedicine solutions and surgical platforms to medical box PCs and embedded boards, Onyx is a one-stop shop for a wide range of technology solutions that redefine patient engagement and care coordination. Roles & Responsibilities

• Designed and customized data models for Data warehouse supporting data from multiple sources on real-time

• Developed Talend jobs from the mapping documents and loaded the data into the warehouse.

• Created different context variables in Job level and Project level, worked with the context groups.

• Worked with Data mapping team to understand the source to target mapping rules.

• Wrote SQL queries to take data from various sources and integrated it with Talend.

• Studying the source of the data to identify the methods of data extractions.

• Prepare Metadata in Talend Open Studio repository.

• Processing the Data files in Talend Open Studio using different components like tMap, tReplicate, tFilterRow and tLogRow etc.

• Working experience with files .xlsx, .CSV, .SQL and .XML in Talend.

• Prepared the test cases and test criteria for the developed jobs.

• Worked with Error handling mechanisms and mailing components to send mails, to report the status of the job.

• Involved in different types of the Validations in development process by using the tMap component.

• Tested and monitored all the jobs according to the requirements specified.

• Implementation checklists while promoting to testing and production.

• Involved in Unit Testing.

• Perform Transformation and Validation Process.

Project #1

Role Talend Developer

Client Money Supermarket, UK

Team Size 6

Technologies Talend 6.5, Oracle, MS SQL Server, TAC. Project Description

Money supermarket Group PLC is a British price comparison website-based business specializing in financial services. The website enables consumers to compare prices on a range of products, including mortgages, credit cards and loans. Roles & Responsibilities

• Gathering Requirements and implement them into Source to Target mappings in loading and staging.

• Interacting with Business analysis in understanding the Database requirements whenever debugging is required without changing the code.

• Created source to target mapping documents from staging area to Data Warehouse and from Data Warehouse to various Data Marts.

• Extensively Identifying and creation of reusable components/jobs using TIS.

• Design of ETL process using TIS to load data from source system (Flat files/Database tables) and Data Transformations and then load to the Target (Flat files/Database tables).

• Worked on unit testing and performance tuning of the Jobs.

• Involved in the Integration Testing.

• Effectively understood session Error logs used debugger to test mapping and fixed bugs in Dev in following change procedures and validation.

• 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.

Contact this candidate