ETL lead

Yogini Dandekar

Hillsboro, OR *****, USA * 470-***-**** * **************@*****.***

SUMMARY

• 6+ years of IT industry experience encompassing a wide range of skill sets working as a Data analytics and Data integration, Data Visualization fields.

• Skillset includes Python, spark, HIVE, Hadoop,ETL, Unix scripting, RDBMS.

• Experience with analysis, design, development and implementation of banking applications .

• Searching for opportunity to bring 6+ years of ETL/data analytics experience to efficiently contribute to the company’s growth and to grow in the area of big data technologies and cloud services like AWS. SKILLS

Data Warehousing/ETL Tools:

RDBMS:

Programming Languages:

Scripting Languages:

Scheduling Tools:

Big Data Technologies:

Informatica 9/10, Ab Initio 3.3

Oracle SQL

Python (MOOC)

Unix Scripting

Control M Scheduling, CA7 Scheduling

Hadoop, Spark (MOOC)

Cloud Computing Platform: AWS(MOOC)

Data Visualization tools: Cognos, Tableu

WORK EXPERIENCE

IBM-SUNTRUST BANK, Atlanta, GA

Data Analyst, ETL Tech Lead-Abinitio

Nov 2015 - Present

Understanding the business requirements to use data source applications like ALS, ACAPS for designing the ETL process building different Abinitio Graphs .

Implement the ETL process for these SunTrust's consumer applications based on the design using Data Lake architecture.

Validating the data lineages using Meta data hub and EME dependencies. Performance improvement of the ETL process by using resource pool. Worked on Meta programming, Dependency analysis, PDL, Meta hub data lineage, control center. Creation of the UNIX scripts to further accommodate the client requirement to manage the data controls. Loading the data to Oracle tables and DB2 tables.

Using the Hadoop distributed file systems to load data using partitions into HIVE partitions. Analyze the data loaded into Distributed systems using Interface like Hue. Led the technical team both onsite and offshore in order to meet task deliverables. IBM- J P MORGAN & CHASE BANK, Pune, Maharashtra

Senior ETL Developer-Abinitio Feb 2014 - Oct 2015

Modification of existing ETL graphs based on LLD design migration points. Graph Enhancements using PDL and maintaining the version of EME objects. Creation of the PSET’s for generic object.

Dependency analysis (DA) for PSET created.

End to end testing(Manual) of graphs created based on the ETL process dependencies. Developing test case documents for the unit testing. Testing overall process by automated scheduling using control M scheduler in all environment. Data validation using development and production data comparison. IBM- SUNTRUST BANK, Pune, Maharashtra

ETL Developer-Abinitio Mar 2013 - Jan 2014

Extracting the data from mainframe.

Apply the transformation rules defined by various transform components using mapping documents using Graphs . Generating load ready files and validate the results against the target data format. Involved in end to end data validation by interacting with the business users (UAT). Loading the data into appliance database like DB2 using ETL load utilities. Defect handling by backtracking the ETL process using Ab>Initio. Creating generic shell scripts to add data quality checks. Preparing or updating high/low level documents, mapping documents as per client requirements for any enhancement/defect.

EDUCATION

UNIVERSITY OF MUMBAI

Mumbai, Maharashtra

B.S. Computer Engineering

June 2008-May 2012

AWARDS

Service Excellence award for the year 2018: Received this award for performance tuning for FDR, which is a credit card processing and payment solution for different merchants, which was recognized by the client. Orion Award for the year 2015: Received this award for being the best contributor of the team.

Contact this candidate