Senior ETL (Informatica) Developer Resume Charlotte, NC - Hire IT People

SUMMARY

17+ years design/development experience working with Informatica PowerCenter (ETL).
Strong relational database skills (Oracle, PL/SQL, SQL Server, T - SQL, Sybase).
Experienced in Data Warehousing (concepts, design, development, revisions)
Mentoring and leadership responsibilities.

TECHNICAL SKILLS

Languages/ Informatica: PowerCenter 9.6.1, PL/SQL, T-SQLUtilities TOAD, SQL Server Management Studio, Autosys, Sybase Central v6.0.

Databases: Oracle 11g, SQL Server 2014, Sybase

Platforms: UNIX, Linux, Windows NT, IBM (Mainframe development)

PROFESSIONAL EXPERIENCE

Confidential, Charlotte, NC

Senior ETL (Informatica) Developer

Responsibilities:

Designed and developed a system which:
Reads flat files. Pipe |delimited
Loads those files to Oracle Staging tables.
Verifies that date columns are not (example) 'A' or 02/31/2017. Verifies that numericalcolumns are not (example) 'B'
Based on Business requirements, loads the data, if applicable, into error tables with descriptive error messages. Cancel if any errors exist. New files would then be requested.
Send emails to all involved to alert them of any issues.
If all is positive, transform the dates and the numerical columns. Load to the final relational tables.

Environment: Informatica PowerCenter 9.6.1, Oracle 11g,TOAD, Linux, sFTP, Agile Methodology.

Confidential, Charlotte, NC

Applications System Engineer

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.
Support responsibilities.

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

Confidential, Orlando FL

Senior ETL (Informatica) Developer

Responsibilities:

Environment: Informatica PowerCenter 9.1, Oracle 11g,LINUX