Varun Kumar Yella

415-***-****

SUMMARY

•Close to 5 years of work experience as ETL Developer includes analysis modelling, design, development.

•Extensive experience using Informatica Cloud (IICS) and Informatica Data Quality tool (IDQ), Informatica Power Exchange and Power Center.

•Certified Tableau Desktop Specialist and experienced on developing dashboard reports using Tableau Desktop and published Online.

•Hands on experience on Big data tools includes Spark using Scala, HDFS, Apache Sqoop and YARN.

TECHNICAL SKILLS

ETL

Informatica Cloud (IICS), Power Center, IDQ

Database

MySQL, Oracle, MS SQL Server, Teradata

Cloud

Snow Flake, AWS Red Shift, MS Azure Data Warehouse

Data Analytics

Power BI, Tableau, R Studio, SAS, Google Analytics

Applications

JIRA, VSTS, Share Point, Visio, Microsoft Visual Studio

EMPLOYMENT

Pacific Data Integrators

ETL Developer

Client- Save on Foods

April 2020-Present

Implement Application Integration for Hand Held Devices to Back end systems.

Develop OAuth Authentication with Microsoft Active Directory for API security.

Used Process Designer and API Manager to created BPR file for Dynamic Test Process method.

Extensively used Process mappings, service connectors, App Connections and process objects to develop API code.

Document best practices and training documents to share with client team.

Environment- Informatica IICS, Microsoft Azure, FTP/SFTP

Client- Wynn Las Vegas

April 2019 - March 2020

Data Integration from different system such as Gaming and Lodging into Teradata Data Warehouse

Designed and developed mappings using Source Qualifier, Expression, Lookup, Router, Aggregator, Filter, Sequence Generator, Update Strategy, Joiner transformations.

Developing ETL mapping and its corresponding sessions, workflows for newly implemented changes.

Effectively performed Unit testing and pushed to code to Staging and then deployed into production.

Pull Real time CDC data using Informatica Power Exchange based on changes in gaming systems.

Extensively used Teradata TPT and Salesforce connections to load data.

Create Informatica Cloud Folders, mappings and load into new AWS Red Shift Data Warehouse.

Develop IICS synchronization and task flows to load accordingly into the database.

Worked on Informatica Hierarchy and Web services transformations.

Environment: Informatica Cloud (IICS), Informatica Power Exchange, Salesforce, Teradata, Agile.

Croyten, LLC

ETL Developer

Client- Shorelight Education

July 2018-March 2019

Shorelight is an educational company which provides services to international students in United States.

Data Integration from different system such as Netsuite, Marketo and Folder Wave to Salesforce classic using Informatica cloud.

Developed Hierarchy builder mappings to generate xml files for student screening activity.

Monitoring daily scheduled jobs and fix the issues based on the failures.

Worked on Data Synchronization tasks, Data replication tasks to quickly import the data from Salesforce to AWS Redshift and between 2 Salesforce orgs.

Used different connectors such as File List Processor, File I/O, XML target, Excel and Drop box, AWS Redshift, NetSuite and Salesforce.

Involved in technical discussion for building ETL architecture and Source to Target mapping to load data into Data warehouse.

Co-ordinated with stake holders for smooth functioning based on cut over and project plan activities.

Environment: Informatica Cloud (IICS), AWS Redshift, AWS EC2, Salesforce

Accenture Services Pvt Ltd

ETL Developer

Client – Valeo

July 2014-Aug 2016

Valeo is a multi-national automotive supplier and partner of automakers based out in France. Compass V4 deployment is a data migration worldwide rolled out project across 14 countries. Data Migration from legacy SAP R/3 V2 & V3 systems to new SAP ECC6 V4 system. Integration using ETL Informatica tool and intermediate Oracle database for data transformation into target system.

Roles and Responsibilities:

•Effectively used Informatica parameter files for defining mapping variables, workflow variables, FTP connections and relational connections.

•Using standard ETL code with cluster specific customization to incorporate cluster specific changes based on the requirement.

•Working with IDOCS and LSMW files for which data will be stored before loading into target systems.

•Performed system integration testing and prepared test results for client review.

•Supported in Go-Live activities for multiple clusters.

•Development and maintenance of code with cluster specific changes.

•Analyzing Functional Specifications for fixing List of Open Points received from stake holders during the process.

•Worked on IDQ to create profiles and shared with client used for Data cleansing activity.

Environment: Informatica Power Center 9.6, Oracle, SAP R2, R3 & ECC6

EDUCATION

Northern Illinois University GPA: 3.8

Master’s in Information Technology Aug 2016 - May 2018

SASTRA University GPA: 3.25

Bachelor’s in Engineering and Technology June 2010 - May 2014

CERTIFICATIONS

Dell EMC Big Data Analytics certified

Splunk User certified

AWS Certified Cloud Practitioner

Tableau Desktop Specialist

Contact this candidate