Applications System Engineer Resume Charlotte, NC - Hire IT People

PROFESSIONAL EXPERIENCE:

Confidential

Applications System Engineer, Charlotte, NC

Responsibilities:

Worked with business analysts regarding new development and revisions.
Feeds were from delimited flat files (FTP) and relational databases (SQL Server, Sybase, Oracle).
Revised and developed new T - SQL processes.
Developed multiple Autosys (jil) scripts to schedule processes based on dependencies.
Loaded data to the Operational Data Store followed by loads to the Data Warehouse via Informatica and T-SQL processes. These were also processed based on Autosys dependencies.
Created delimited flat files to feed data to external systems via FTP.
Worked with offshore team members providing documentation regarding new processes.

Environment: Informatica Powercenter 9.6.1, SQL Server 2014, T-SQL, SQL Server Management Studio, Sybase Central v6.0, UNIX, Autosys, PuTTY, FTP

Confidential

Senior ETL (Informatica) Developer, Orlando, FL

Responsibilities:

Involved in all phases of the Software Development Life Cycle ( SDLC ).
Worked with team members on the data model. Type 2-dimensional Data Warehouse (Oracle).
Worked with business analysts regarding new development and revisions.
Involved in all processes related to the new Data Warehouse (data modeling/ analysis / design / development / tuning / testing).
Developed Autosys (jil).
Data warehouse loads were performed using only Informatica.
Revised and developed new PL/SQL processes (including dynamic SQL).

Environment: Informatica PowerCenter 9.1, Oracle 11g, TOAD, UNIX, Autosys

Confidential, Owings Mills, MD

Lead ETL (Informatica) Developer

Responsibilities:

Revamped an Informatica application sourcing/ targeting an Oracle database (Financial Data). Previously, this monthly application would process for excessive periods of time. Based on enhancements made to the Informatica code and database tuning, the application processed far within the SLA.
Designed/ developed an archiving process which dramatically reduced processing times and increased OLAP response time.
Mentored two Informatica developers involved in two separate projects.

Environment: Informatica PowerCenter 8.6.1, Oracle 10g, UNIX, TOAD

Senior ETL (Informatica) Developer

Confidential

Responsibilities:

Development efforts involved sourcing XML (via Informatica PowerCenter).
Designed/ developed a strategy where XML was loaded directly into an Oracle data acquisition layer.

Environment: Informatica PowerCenter 8.1.1, XML, Oracle 10g, UNIX, TOAD, Turbo XML

Senior ETL (Informatica) Developer

Confidential

Responsibilities:

Development efforts involved sourcing and targeting JMS Queues and Informatica CDC Technology.
Designed and developed a set of Informatica PowerCenter / Power Exchange mappings.

Environment: Informatica PowerCenter 8.1.1, Informatica PowerExchange, JMS, Informatica CDC, Oracle 10g, PL/SQL, UNIX

Lead ETL (Informatica) Developer

Confidential

Responsibilities:

Led a team of 3 ETL developers.
Designed and developed a series of complex Informatica mappings.
Responsible for approximately fifty percent of development and the majority of ETL design.
Source data was also extracted from an internally built Sybase system.
Developed complex SQL overrides (Source Qualifier and Lookup overrides) involving subquery logic.

Environment: Informatica PowerCenter 8.1.1, Oracle 10g, Sybase, UNIX, TSO/ISPF

Confidential

Senior Data Warehouse Consultant, Charlotte, NC

Responsibilities:

Accepted a short-term contract providing maintenance/production support at the tail end of a long-term project.
Duties required expertise with Informatica. Strong Oracle skills also required.

Environment: Informatica PowerCenter 8.1, Oracle 10g, DB2 UDB, Microsoft server, Cybermation

Confidential

Senior Data Warehouse Consultant, Valley Forge, PA

Responsibilities:

Joined Confidential in the early phases of the Data Warehouse life cycle.
Initial phases involved fact gathering communications from within the business community, identification of source attributes, data profiling, and analysis of the legacy Data Warehouse.
The project ultimately evolved into a pivoted data model.
Subsequent phases involved complex ETL (Informatica) design, development, implementation, testing.

Environment: Informatica PowerCenter 7.1.3, Oracle 10g, DB2 UDB, Solaris/UNIX, AQT

Confidential

Senior Data Mining/Data Warehouse Consultant, Charlotte, NC

Responsibilities:

Duties centered upon supporting and maintaining a 2.2 terabyte Data Warehouse via Informatica. Responsibilities included analysis, design, on-call support, trouble shooting, release update testing.
Duties required expertise with Informatica PowerCenter. Strong Oracle 9i skills also required.

Environment: Informatica PowerCenter 7.1, Oracle 9i, HP-UX, TOAD

We provide IT Staff Augmentation Services!

Applications System Engineer Resume

Charlotte, NC

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship