Application Support Analyst / Production Support Analyst

Job Title: ETL Application Support Analyst

Location: Tampa Florida/ 3 days in office

Duration: 06+ months’ Contract

Required Skills & Experience

B.E/ B.Tech. in Computer Science, IT, or other Engineering disciplines.

5 to 7 years of experience in handling production support activities.

5+ years of experience in Relational Database SQL (Oracle). Must be able of writing complex and efficient SQL DML statements.

5+ years of experience in Unix, SQL, and Ab Initio (or any other ETL tool).

Able to optimize SQL queries, performance tune, table structures and indexes.

Knowledgeable of basic Unix commands, command lines, how to move or add files.

Experienced with handling production support activities.

Familiar with Ab Initio architecture for issue identification and issue resolution.

Should be aware of the scheduling tool.

Hands-on experience UNIX with knowledge in scripting language to create scripts for automation of daily batch reports.

Strong design & execution bend of mind.

Thorough understanding of DWH methodologies.

Design pattern implementation, algorithms and data structure.

Ab Initio development, components usage, EME, migration process with branching.

Unix shell scripting.

Software engineering best practices.

Unix shell scripting experience and understanding of Ab Initio environment (Co-Operating system). Able to understand, analyze and write PL SQL queries on Oracle and Sybase.

Extensive knowledge of Ab Initio development, components usage, EME, migration process with branching. Able to analyze the existing graphs and should be able to provide impact assessment.

Good expertise in database level analysis to trace issues to closure.

Willingness to learn backed with solid technology understanding of distributed systems is essential. Must have the ability to coordinate with other teams and come to a resolution of batch issues at the earliest.

Desired Skills & Experience

Experience on shell scripting.

Experience with ETL Development tools.

What You Will Be Doing

Lead a critical operational support service, process, capability or initiative within an operational unit and ensures performance and/or risk indicators are met.

Establish and monitor process performance measurements and business impact. Gather and communicate performance statistics and reports to internal stakeholders and senior management.

Monitor effectiveness and efficiency of production and/or process. Determine and/or drives change and improvement efforts in production and/or processes.

Coordinate with other stake holders located across shores.

Ownership and responsibility for end-to-end production batches.

Ensure process compliance and manage expectations of the leadership.

Actively trace and track issues and document the issue resolutions.

Create monthly issue reports.

Ensure best practices are followed.