Senior ETL Consultant Resume

TECHNICAL SKILLS:

Databases: MS SQL, Oracle (Oracle Streams), SQL Server200/2005 Sybase, DB2, Terradata

Big Data: Hadoop, Hive

Programming Languages: C, Java, SQL, and PL/SQL

Operating Systems: Windows, Sun Solaris, HPUX, AIX and Linux

Software: Informatica Power Center, Informatica B2B,DAC, Talend, SSIS, Alteryx

PROFESSIONAL EXPERIENCE:

Senior ETL Consultant

Confidential

Responsibilities:

Analyze data pipeline changes required for application upgrades provide input on data model changes needed
Implement Informatica ETL changes needed
Use Alteryx to download and unzip JSON payload from AWS URL
Create Alteryx workflow to pivot and load JSON data into a Oracle
Deploy Alteryx workflow to server for invocation by AWS based applications
Alter existing Tableau reports as needed by business
Convert tableau reports into Alteryx analytical workflows to make access to data easier

Senior ETL Developer

Confidential

Responsibilities:

Engage with business to understand their data needs and recommend data sources and/or ETL strategies to deliver data
Create stories for Agile sprints to execute tasks
Analyze source data on Hadoop/Hive, flat files and/or Greenplum DB. Use Informatica to pull data from various sources, perform business transformations and load data into Greenplum or create QVD files for consumption via Qlik View
Use in house Python utilities to develop ETL run priorities and schedule via Tidal

Senior Informatica Developer

Confidential

Responsibilities:

Oversee all ETL related needs for the enterprise warehouse and participate in the hiring, mentoring and leading a team of 4 in accomplishing new ETL tasks as well as altering existing jobs
Upgrade the enterprise Informatica instance from 9.6 to 10.1 and implemented Informatica real time processing of source data
Convert existing SSIS tasks to Informatica tasks
Work with third party vendor to understand a new Final Mile system and determine new data model changes to integrate new data into existing EDW

Senior Consultant

Confidential

Responsibilities:

Help develop a robust GDW to extend OBIA complete with history keeping, full and incremental load capabilities
Used Talend to develop an access report system out of OBIA and examined Talend ESB as part of the MDM POC to integrate data
Leveraged patterns developed in previous projects to create DW extensions for the client
Act as the Informatica as well as the general architecture SME to resolve issues/alter patterns to fit new needs and lead a team of 4 junior developers

Experienced Consultant

Confidential

Responsibilities:

Played a critical role as the Informatica B2B Data Transformation tool SME. The Data Transformation tool was used to consume XML files off a messaging queue and convert data for loading into relational targets. Set up a repeatable process of integrating B2B DT tool with Power Center. Mentored junior level team members on operation of the process.
Parse EBCIDEC data from Mainframe into XML using Informatica’s B2B tool. Then use the Unstructured Data Transformation to call a B2B Service from within a Power Center Mapping to load the XML file into DB2
Worked as an integration Designer for a data migration effort. Participated in requirements gathering as well as ETL design. Provided Power Center expertise in ETL process design.

Senior Database Developer

Confidential

Responsibilities:

Participate in group reviews of newly designed ODS databases before development starts
Analyze source data develop optimal design of the databases and perform post development analysis looking for possible improvements to design
Develop mappings, sessions and workflows using various standards and appropriate dependencies and Perform unit/integration tests on workflows
Deploy workflows between Development, QA and Production environments using deployment groups and Schedule/monitor workflow runs
Develop projects to handle XML inputs using Informatica’s B2B tool and map elements into HL7 compliant XML