• Involved in Extraction, Transformation and Loading of data from 10 Source Systems into our data warehouse.• Work with the offshore team for the day-to-day work and review the tasks done by them get the status updates in the daily meetings.• Created Jobs for Bigdata batch and streaming jobs to cleanse and loaf data coming from Source system.• Implemented data profiling and scorecards on spark.

• Worked in the Data Integration Team to perform data and application integration with a goal of moving data more effectively, efficiently and with high performance to assist in business-critical projects coming up with huge data extraction.• Broad design, development and testing experience with Talend and Bigdata Integration Suite and knowledge in Performance Tuning of mappings.• Deployed and scheduled Talend jobs in Administration console and monitoring the execution.• Excellent knowledge with Talend Administration console, Talend installation, using Context and global map variables in Talend.• Experience in Spark to process large stream of data. • Imported the data from different sources like AWS S3 using Spark on EMR.• Used to pick files from AWS S3 Buckets and load into AWS Redshift Database

• Extracted data from various sources, applied business logic to load them into the Data Warehouse.• Worked on Informatica 8.6.1 client tools like Source Analyzer, Warehouse Designer, Mapping Designer, Workflow Manager and Workflow Monitor.• Involved in design and development of complex ETL mappings.

• Worked on Informatica tool - Source Analyzer, Data warehousing designer, Mapping Designer, Mapplets and Transformations Developer.• Interacted with Business Users and Managers in gathering business requirements• Created mappings using Informatica Designer to build business rules to load data.• Most of the transformations were used like the Source Qualifier, Aggregator, Lookup, Router, Filter, Sequence Generator, Expression, Joiner and Update Strategy.