Lead Data Integrator Resume , Redwood City, CA - Hire IT People

SUMMARY:

More than 8 years of experience as a Data Warehousing Developer in Insurance, Pharmaceuticals, Food & Beverage, e - commerce and online payments industries
Bachelor in Technology, Electrical and Electronics Engineering
Strong background in designing, developing and integrating ETL solutions
Experienced in SQL, Unix, data analysis, coding and problem resolution
Proficient in, Hadoop, Teradata, ETL Technologies, Informatica, Data Stage, Ab Initio
Worked as a Scrum Master in Agile Teams
Good communication, coordination and leadership skills
Organized, multi-tasking, effective team player, able to work with minimum supervision
Lead projects on data analysis and integration for Enterprise Data Warehouse (EDW)
Ensure data is extracted, processed, consolidated and maintained within EDW
Assess technical feasibility and provide estimation on ETL solutions
Analyzing dependencies of ETL applications in the EDW and determine overall implementation strategy
Provide test cases to ensure accuracy and integrity of data
Plan, schedule, coordinate and monitor ETL applications on Control-M, UC4, Appworkx
Optimize ETL solutions to improve performance and save resources like CPU, time and memory storage
Perform application gap analysis, build and support the data warehouse application
Provide technical advice and guidance to staff in resolving technical issues

TECHNICAL SKILLS:

Hadoop: HDFS, Map Reduce, Pig, Hive, Scoop, Flume, Hbase, NoSQL

ETL Tools: Ab Initio, Data Stage, Informatica,

Teradata Tools: BTEQ, Query Man, Fast Load, Fast Export, Multiload, Tpump

OLAP Tools: Business Objects, Tableau

RDBMS: Teradata, Oracle, PL/SQL

Operating Systems: Windows NT/XP, Solaris, Linux

Languages: Java, Python, C, C++, Unix shell scripts

Scheduler: Appworkx,UC4,Control M

Other : R, Git

PROFESSIONAL EXPERIENCE:

Lead Data Integrator

Confidential, Redwood City, CA

Responsibilities:

Led team of 3 providing ETL design solutions using Ab Initio / Teradata / Hadoop
Conducted impact analysis, gathered requirements for the migration of users
Identified the processes, tables and metrics to be addressed for migrating 75 million users in batches

Senior Software Engineer

Confidential, Seattle, WA

Responsibilities:

Worked as a Scrum Master and led a team of 6 software developers in providing data warehousing solutions for Shipping, Marketing and Operational Data Warehouse using Ab Initio / Teradata / Hadoop
Captured events from 165 million customers, 675 million items/day that includes label printing, package tracking, cost calculation, returns, and other global shipping solutions
Gathered requirements, developed code, implemented end- to-end solutions on carrier integration (FedEx, UPS, USPS etc.)
Provided data mart solutions that drive analytics and reporting across all Confidential marketing channels, tracked performance by channel, and leverage data for personalization and targeting
Generated reports for key metrics on key words, email campaigns sent, Click through rate etc., participated on-call production support to meet SLA

Senior ETL Engineer

Confidential, San Jose, CA

Responsibilities:

Worked on feeds for ROI data on Paid Search, Natural Search in flat file format
Identified data points in the MediaPlex feeds and integrated into the PP data warehouse for analytics and reporting
Optimized processes to improve the load performance and data available rate
Developed SQL scripts to support segmentation logic for Confidential customers by a third party vendor

Senior Data Warehouse Engineer

Confidential, Deerfield, IL

Responsibilities:

Developed code to capture data from web based systems on customer’s prescription benefits, loaded them into warehouse for various dashboard reporting
Designed and developed Medicare Part B Financial Reporting to capture customer health related information