ETL Tester Resume Cincinnati, Ohio - Hire IT People

SUMMARY:

9+ years of IT experience.
7 years of experience on Informatica Power Center.
Good knowledge in SCD, Update Strategy, and Data - Model.
Have a good knowledge in SQL, Queries, Stored Procedures and Functions.
Able to handle and solve Incident, Problem, Request and Change Management process on ITIL.
Good experience in UNIX commands(AWK, SED commands), UNIX Shell scripts, SQL Scripts.
Excellent Analytical and problem solving skills with strong background.

PROFESSIONAL EXPERIENCE:

Confidential

ETL Tester

Responsibilities:

Involved in developing UNIX shell scripts required for and processing job.
Performed UTC (Unit Test Cases); created SQL query to verify source and target data according to the logic of ETL process.
Created transformations such as Lookup, aggregate, expression, filter and update strategy.
Wrote test cases in HP Quality Center and to executed them for validation.
Used workflow manager to load data, monitored and analyzed loading statistics.

Environment: Informatica 9x, Oracle 11g, & Unix, SQL

Confidential, Cincinnati, Ohio

Software Support Engineer

Responsibilities:

Analyzed, troubleshot and resolved problems using Unix Shell script SQL, PL/SQL.
Regularly monitored 50 workflows( 35 from Production and 15 from DW), Analyzed log files from workflows, and log files from SAP process; if any issue occurred.
Regularly created SQL queries per customer requirements.
Major part of the support was dedicated to Web based Applications.
Wrote test cases for ETL process in HP Quality Center and executed them for validation.
Coordinated regularly with network, Oracle, Citrix, and SAP team for ticket related issues.
Did migration job from one repository to another rep. (informatica power center 9.6.1).
Frequently analyzed XML files to accomplish ETL process tasks.
Performed root cause analysis & created accompanying documentation.
Regularly monitored Informatica workflows and troubleshot when there was any issue for Production & Data-Warehouse
Validated connections between one server to another; if any issue occurred.
Took job responsibilities included L2 and L3 level support of GE users across the USA.
Resolved P3, P2, and P1 tickets for multiple Applications (in Production ) expeditiously and professionally on ITIL.
Involved in reviews and meetings & teleconferences with clients.
Coordinated with SAP, Citrix, Network and Oracle team because of various issues.

Confidential, New Jersey

Application Support Engineer

Responsibilities:

Analyzed log files from Informatica workflow (Informatica 8.1 ) & error messages from Application, troubleshot and resolved problems using Unix Shell script SQL, PL/SQL.
Used Unix scripts to control the loading process.
Supported existing systems.
Tested applications as per unit test cases.

Environment: SQL Dev, Oracle and UNIX

Confidential

Application Support Engineer

Responsibilities:

Worked with Unix Shell Scripts, and functions etc..
Used SQL queries to retrieve data, and then call UNIX, and format data for output ( as a batch process).
Created SQL quires to support customers.