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.