Sr Application Support Analyst - Unix, SQL, and Ab Initio/ETL at DenkenSolutions Inc
Tampa, FL 33646
About the Job
Currently, we are looking for talented resources for one of our listed clients. If interested please reply to me with your updated resume or feel free to reach out to me for more details at
Title: Sr Application Support Analyst - Unix, SQL, and Ab Initio/ETL
Location: Tampa, FL
Duration: 9 Months
Job Description:
Looking for a Senior Application support Analyst with 5+ years of experience in Unix, SQL, and Ab initio (or any other ETL tool).
Need to be senior enough to work independently and self learn at times.
MUST be able to optimize SQL queries, performance tune, table structures and indexes.
MUST know basic Unix commands, command lines, how to move or add files.
AbInitio is not required as long as another ETL tool is known.
Must be able to work onsite in Tampa 2-3 days per week.
Job Purpose:
This business-critical requisition required to support daily production batches.
This requires research and identification from failed batches to resolutions at the quickest time.
This is a business sensitive position that requires attention to detail and quick turnaround. Liaise between various support team across multiple vendors to provide seamless customer experience.
Job Background/context:
(Where the position sits within the department/organization)
This reports to the application support manager lead locally and globally. Also, the responsibility is for all the job functionalities and ensure that the support teams are addressing the production issues and intimating the finance customers for any ongoing issues.
Key Responsibilities:
(Describe the main activities the job-holder will perform)
Leads 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.
5-7 years' experience in handling production support activities.
Unix shell scripting experience and understanding of Ab Initio environment (Co?Operating system). He should be 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. He should be able to analyze the existing graphs and should be able to provide impact assessment.
Should have 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 co-ordinate with other teams and come to a resolution of batch issues at the earliest.
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
Development Value:
(What opportunities to develop can the job offer a prospective candidate?)
Excellent opportunity to get involved in cutting across global functions, related analytics, reporting methodologies for a large global bank
Opportunity to learn/ add domain skill in the area of finance and primary market trading and accounting
Opportunity to directly work with a highly motivated team Person Specification
Knowledge/Experience:
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.
Relational Database SQL (Oracle) experience (5+ year). Should be capable of writing complex and efficient SQL DML statements
Experience on shell scripting would be added advantage
It is desired but not mandatory to have experience with ETL Development tools
Skills:
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
Passion for technology and self- starter
Orientation towards Disciplined development processes
Strong writing, communication, time-management, decision-making, and basic task organization skills
Ability to prioritize and manage schedules under tight, SLA's.
Qualifications:
First class degree with excellent academic qualifications. B.E/ B.Tech. in Comp science, IT, or other engineering disciplines from a reputed institute with relevant work experience. Competencies
Business Process Design - Extensive Experience
Knowledge of business process design techniques that encourage a critical, fresh look at key processes and focus on optimizing organizational performance; ability to apply this knowledge appropriately to diverse situations.
Standard Operating Procedures - Extensive Experience
Knowledge of and ability to design, implement and evaluate standard operating procedures affecting daily and strategic business operations in order to increase operational efficiency.
Process Management - Subject Matter Expertise
Knowledge of business process improvement tools and techniques and ability to understand, monitor, update, or enhance existing business or work processes.
Effective Communications - Extensive Experience
Understanding of effective communication concepts, tools and techniques; ability to effectively transmit, receive, and accurately interpret ideas, information, and needs through the application of appropriate communication behaviors.
Decision Making and Critical Thinking - Extensive Experience
Understanding of the issues related to the decision-making process; ability to analyze situations fully and accurately, and reach productive decisions.
Accuracy and Attention to Detail - Extensive Experience
Understanding of the necessity and value of accuracy and attention to detail; ability to process information with high levels of accuracy.
Managing Multiple Priorities - Extensive Experience
Ability to manage multiple concurrent objectives, projects, groups, or activities, making effective judgments as to prioritizing and time allocation.
Problem Management Process - Extensive Experience
Knowledge of and ability to bring a reported problem to successful resolution.
Operational Functions - Extensive Experience
Knowledge of major functional processes and associated operating requirements; ability to apply this knowledge appropriately to diverse situations.
About us:
At our organization, we take our mission and values to heart! We are on a mission to offer more and better jobs all over the world! Our goal is to care for you while you care for our clients and get you paid the highest pay possible. All our associates working with us are expected to embrace our RACE values: R - Results Matter, A- Approachable, C - Care, and E - Emergency i.e. work with a sense of urgency.
For more relevant job opportunities please visit our website: Denken Solutions Careers
(949) 889-0336
Title: Sr Application Support Analyst - Unix, SQL, and Ab Initio/ETL
Location: Tampa, FL
Duration: 9 Months
Job Description:
Looking for a Senior Application support Analyst with 5+ years of experience in Unix, SQL, and Ab initio (or any other ETL tool).
Need to be senior enough to work independently and self learn at times.
MUST be able to optimize SQL queries, performance tune, table structures and indexes.
MUST know basic Unix commands, command lines, how to move or add files.
AbInitio is not required as long as another ETL tool is known.
Must be able to work onsite in Tampa 2-3 days per week.
Job Purpose:
This business-critical requisition required to support daily production batches.
This requires research and identification from failed batches to resolutions at the quickest time.
This is a business sensitive position that requires attention to detail and quick turnaround. Liaise between various support team across multiple vendors to provide seamless customer experience.
Job Background/context:
(Where the position sits within the department/organization)
This reports to the application support manager lead locally and globally. Also, the responsibility is for all the job functionalities and ensure that the support teams are addressing the production issues and intimating the finance customers for any ongoing issues.
Key Responsibilities:
(Describe the main activities the job-holder will perform)
Leads 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.
5-7 years' experience in handling production support activities.
Unix shell scripting experience and understanding of Ab Initio environment (Co?Operating system). He should be 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. He should be able to analyze the existing graphs and should be able to provide impact assessment.
Should have 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 co-ordinate with other teams and come to a resolution of batch issues at the earliest.
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
Development Value:
(What opportunities to develop can the job offer a prospective candidate?)
Excellent opportunity to get involved in cutting across global functions, related analytics, reporting methodologies for a large global bank
Opportunity to learn/ add domain skill in the area of finance and primary market trading and accounting
Opportunity to directly work with a highly motivated team Person Specification
Knowledge/Experience:
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.
Relational Database SQL (Oracle) experience (5+ year). Should be capable of writing complex and efficient SQL DML statements
Experience on shell scripting would be added advantage
It is desired but not mandatory to have experience with ETL Development tools
Skills:
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
Passion for technology and self- starter
Orientation towards Disciplined development processes
Strong writing, communication, time-management, decision-making, and basic task organization skills
Ability to prioritize and manage schedules under tight, SLA's.
Qualifications:
First class degree with excellent academic qualifications. B.E/ B.Tech. in Comp science, IT, or other engineering disciplines from a reputed institute with relevant work experience. Competencies
Business Process Design - Extensive Experience
Knowledge of business process design techniques that encourage a critical, fresh look at key processes and focus on optimizing organizational performance; ability to apply this knowledge appropriately to diverse situations.
Standard Operating Procedures - Extensive Experience
Knowledge of and ability to design, implement and evaluate standard operating procedures affecting daily and strategic business operations in order to increase operational efficiency.
Process Management - Subject Matter Expertise
Knowledge of business process improvement tools and techniques and ability to understand, monitor, update, or enhance existing business or work processes.
Effective Communications - Extensive Experience
Understanding of effective communication concepts, tools and techniques; ability to effectively transmit, receive, and accurately interpret ideas, information, and needs through the application of appropriate communication behaviors.
Decision Making and Critical Thinking - Extensive Experience
Understanding of the issues related to the decision-making process; ability to analyze situations fully and accurately, and reach productive decisions.
Accuracy and Attention to Detail - Extensive Experience
Understanding of the necessity and value of accuracy and attention to detail; ability to process information with high levels of accuracy.
Managing Multiple Priorities - Extensive Experience
Ability to manage multiple concurrent objectives, projects, groups, or activities, making effective judgments as to prioritizing and time allocation.
Problem Management Process - Extensive Experience
Knowledge of and ability to bring a reported problem to successful resolution.
Operational Functions - Extensive Experience
Knowledge of major functional processes and associated operating requirements; ability to apply this knowledge appropriately to diverse situations.
About us:
At our organization, we take our mission and values to heart! We are on a mission to offer more and better jobs all over the world! Our goal is to care for you while you care for our clients and get you paid the highest pay possible. All our associates working with us are expected to embrace our RACE values: R - Results Matter, A- Approachable, C - Care, and E - Emergency i.e. work with a sense of urgency.
For more relevant job opportunities please visit our website: Denken Solutions Careers