ETL Engineer/Administrator Resume

SUMMARY:

Over six years of experience in Informatica ETL development and administration, Oracle PL/SQL development, UNIX and SQL Server 2005
Superior work ethic, team player, communication skills and problem solver
Consitently utilized UNIX and perl commands to automate internal and external customer data imports and extracts

TECHNICAL SKILLS:

SQL Server
Oracle
Informatica PowerCenter 8.6
Informatica PowerExchange 8.6
Informatica PowerCenter 9.1
Informatica PowerExchange 9.1
UNIX scripting
Perl scripting
SOX Compliance
ASP.NET
VB.NET
MS Word
MS PowerPoint
MS Excel

PROFESSIONAL EXPERIENCE:

Confidential

ETL Engineer/Administrator

Responsibilities:

Monitor the Informatica development and production nodes for job performance and identify opportunities for improvement
Implemented Real - Time change data capture for DB2zOS sources in Informatica PowerExchange which reduced the delay in loading reporting data to the ODS layer by 24 hours
Set up and manage users, roles, and groups on the Informatica repositories
Develop new mappings and workflows using PowerExchange and PowerCenter to import data from mainframe and DB2 sources as well as Oracle and SQL Server
Create automated processes to monitor nightly replication jobs by querying the repository tables and emailing a report twice daily
Stop and restart Informatica services for monthly maintenance
Deploy reusable and non-reusable Informatica objects from development to production
Use Oracle merge commands in pre/post-sql, as well as Informatica update strategy for incremental data loads
Create processes which source and write date files using Informatica FTP connections
Convert Oracle views to Informatica table loads
Upgrade Informatica services PowerCenter and PowerExchange from version 8.6 to version 9.1
Write UNIX scripts which are called from Informatica to perform file manipulation
Familiar with the Informatica repository tables and rely on those to send daily success or fail reports for Informatica tasks
Represent the Business Intelligence team in daily Agile SCRUM meetings
Provide 24 hour administrator on-call support
Work closely with DBA team to create new objects in Stage, OLAP, and ODS layers for internal and external reporting

Confidential

Programmer/Analyst

Responsibilities:

Execute perl scripts from Informatica to receive, archive, and delete data from various file transfer protocol (FTP) sites
Monitor and service nightly data replication process
Generate UNIX commands and scripts to encrypt, decrypt, sign, and move data files - To date, these scripts and commands are used in over 80% of the enterprise information management team’s Informatica objects
Responsible for building nightly data replication ETL worklets for two new call centers
Assist Informatica administrator in monthly maintenance of Informatica server
Design automated Informatica workflows - To date, completed over 70 automated Informatica workflows saving over 200 hours of manual labor per month.
Assist Informatica administrator in upgrades of Informatica PowerCenter
Create procedure calls in Informatica objects to prevent manual execution - Converted a process which included over 40 procedures to a single Informatica workflow which saved the business unit over 2 days of manual processing
Invent ETL jobs for internal customers - Created a perl script for downloading files from an https site and moving them from a UNIX to a Windows server which saved over 20 hours of manual labor per month
Convert monthly external export process to a single Informatica workflow saving 10 hours of manual tasks
Utilize Visual Basic Applications (VBA) for Excel and PowerPoint to generate customer reports
Enhance web pages using ASP.NET - Added search functionality to a web site used to enter data multiple times per day which reduced errors and increased accuracy of data by over 25%

Confidential

Junior Programmer/Analyst

Responsibilities:

Provided support for data import and deployment processes
Created Informatica 7.1 user guide to assist colleagues with development of PowerCenter ETL objects
Designed Informatica workflows to import records into Oracle and SQL Server tables
Coordinated automation of legacy import processes - Trained other team members on how to create Informatica workflows which call perl and shell scripts for complete automation of data imports
Ensured proper control measures were in place and monitored for SOX compliance
Created metric tracking process to monitor nightly data replication process
Maintained key metrics, such as audit successes and import dates, on data files received from customers
Established permissions on UNIX server based on business needs

Confidential

Shipping/Receiving/Inventory Assistant

Responsibilities:

Developed an inventory tracking system using Radio Frequency Identification (RFID) tags to track availability of system parts and accessories
Assisted the shipping manager in ensuring all shipments were shipped accurately and timely
Tracked shipments using tracking codes

We provide IT Staff Augmentation Services!

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship