ETL Informatica Developer Resume

PROFESSIONAL EXPERIENCE

Confidential - Virginia Beach, VA

Designed, developed and implemented automated ETL solutions using Informatica, Unix bash and awk scripts, Oracle SQL*Loader, and Oracle PL/SQL programming in support of the excise tax division of the IRS.
Prepared supporting documentation and test cases associated with ETL deliveries including design documents, test cases, and software installation guides.
Generated sanitized test data for unit testing and large data volume performance testing in development and test environments.
Created Unix shell scripts to annually purge large volumes of production data based on data retention criteria and business rules.
Entrusted with access to Sensitive But Unclassified (SBU) data in secured work areas and granted Minimum Background Investigation (MBI) security clearance.
Developed logical and physical database models of data warehouse using ER Studio.
Performance tuning of SQL database queries.
Monitored the execution of ETL jobs in production. Troubleshoot and diagnose complex data issues and resolved as required in the form of data cleanup and code changes.
Conducted code peer reviews for database and ETL software releases.
Minor database administration responsibilities including installations, backups, imports, exports and other database activities to support the software development team.
Maintained a high level of customer satisfaction by maintaining a good rapport with the client and providing prompt and thorough resolutions to technical issues.
Mentored junior level database and ETL developers.

Confidential - Denver, CO

Responsibilities:

Designed and developed data conversion utilities from a mainframe Adabas database to a Microsoft SQL Server database using SQL Server DTS within a strict time frame.
Worked closely with Subject Matter Experts to capture requirements and develop data conversion logic for a state unemployment insurance tax system.
Produced detailed error and exception reports to identify data cleansing needs and verify the successful conversion of the data.

Confidential - Norcross, GA

Responsibilities:

Following the closure of RSI, I joined a small, dedicated team deemed essential to successfully complete the vehicle titling project in order to fulfill Unisys contractual obligations, continuing in the capacity of lead data conversion programmer and analyst.

Confidential, Alpharetta, GA

Responsibilities:

Team lead of property tax and city permits software system. Facilitated all communications with the client, coordinated tasks and delegated assignments to team members.
C programming on SCO Unix platform and Informix database. Debugged legacy program systems and implemented programming enhancements.
Lead programmer for the data conversion of a state vehicle titling and registration system using Microsoft Visual C++ and Oracle pro*c to migrate data from a legacy mainframe system to an Oracle database.
Worked closely with application and database development teams to identify and resolve data integrity issues and to ensure converted data was fully integrated and supported by the application.

Confidential - Atlanta, GA

Responsibilities:

Implemented programming enhancements and maintenance fixes for a proprietary warehouse management software used to manage warehouse product inventory.
Using Crystal Reports and Visual Basic 6.0, created reports and a front-end application to dynamically summarize and display product tracking measurements.

Confidential - Charleston, SC

Responsibilities:

Wrote engineering work procedures for refueling operations and temporary support systems of Confidential submarines to incorporate technical requirements and provide engineering resolutions to identified deficiencies.

We provide IT Staff Augmentation Services!

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship