Technical Support Manager

eNFLUENCE IT Services Pvt. Ltd
  • Chennai
  • 10-15 lakh
  • 3-8 years
  • Views
  • 09 Mar 2017

  • IT/ Information Technology

  • IT/ Technology - Hardware & Networking
Job Description

responsible for managing and monitoring Ab initio jobs in production.
monitoring and supporting Ab initio jobs providing both L1&L2 support.
experience in UNIX and SQL to create automated scripts.
Works closely with the Core dev and Support leads to ensure the stability and efficient maintenance of prod environments.
Experience in providing both technical systems support and data analysis support within the technology platform management organization.-
Good Experience configuring Ab initio products like Command Center, ACE and BRE in prod environment and supporting the deployment of new jobs for the same.
Experience in providing hands-on application level support.-
Good experience in developing automated solutions of any and all support tasks.-
Work closely with our front back offices, and business partners to analyze and resolve all issues and enquiries.-
Responsible for Identifying gaps in current technology processes and recommend changes to ensure our SLA-s are achieved.-
Identify potential areas of risk that could pose a threat to our business and perform deployments from Test to Production environment-
Documenting all issues and the steps taken to resolve the issue in our support wiki & knowledge base and Creating and documenting support procedures and operational workarounds for new issues.
The role will be responsible for development on data and ETL solutions, implementing best practices for data movement, data quality, data cleansing and other ETL-related activities.
5+ years of experience in working with Ab Initio as an ETL Tool.
Good working experience with all components of Ab Initio such as Scan, join, Partition by key, Partition by Round Robin, Gather, Merge, Interleave, Lookup etc.
Experience with various Ab initio parallelism techniques, Ab initio Graphs using Data, Pipeline & Component parallelisms
Good working experience on generic graphs, continuous flows along with experience and expertise on SQL and Unix shell scripting
Experience using any of the scheduling tools like Autosys, Control-M etc.
Knowledge of ACE, BRE and Ab Initio Command Center is huge plus
5+ years of expert level experience in Oracle and MYSQL and creating complex SQL statements along with good understanding of Database Design & Best Practices.
Works closely with project Business Analyst, Data Modeller and BI Lead to ensure that the end to end designs meet the business and data requirements
Supervise, and assist the creation of the data layer with good experience in Shell scripting.
5 years of Strong experience in database Query Tuning Advanced understanding of writing complex stored procedure, performance tuning, exception handling & experience in dealing with db transaction.
Expert level knowledge in writing complete SQL, JOINS, temp tables, cursor and performance tuning of SQL.
Good level technical knowledge of (ETL) solutions and ability to do ETL development and to supervise and guide ETL development activities of other developers.
Understands and implements best practices, tuning and optimization on database and ETL solution and serve as the lead developer of all ETL activities.

6- 8+ years of experience working with Abinitio as an ETL Tool.
5+ years of experience of hands-on work designing and implementing data integration solutions for data warehouse and business intelligence systems
5+ years using, configuring, and tuning industry leading ETL software tools in data intensive, large scale environments.
3+ years experience performing data quality and profiling in Ab Initio. This is highly preferred.
3+ years experience working on Oracle database.
5+ years hands-on design, development and support experience with Ab Initio using GDE, Co>Operating System and EME. Experience in any of the following is desired: Query>It, Conduct>It, Express>It, Continuous flows, Metadata Hub.
3+ years hands-on experience working in Unix/Linux environment, with proficiency in UNIX shell scripting (Korn/bash shell preferred.)
3+ years hands-on experience with scheduling tools, preferably, Ab Initio Control Center
3+yrs writing strong sql skills for Data retrieval from multiple sources.
Ab Initio tool setup and coordination with the SWA Ab Initio team on the configuration.
Profile & Analyze Source Data (Mainframe Extracts, Oracle tables & UNIX flat files) usage using Ab Initio Data Quality Environment (DQE).
Provide guidance to the ETL designers regarding data quality of source data
Develop required scripts, tools and methodology to perform these activities.
Coordinate with the SWA Ab Initio team on the configuration of the Ab Initio tool.
Good working experience with all components of Ab Initio such as Scan, join, Partition by key, Partition by Round Robin, Gather, Merge, Interleave, Lookup etc.
Experience with various Ab initio parallelism techniques, Ab initio Graphs using Data, Pipeline & Component parallelisms
Good working experience on generic graphs, continuous flows and PDL.
Experience and expertise on SQL and UNIX shell scripting
Knowledge of ACE, BRE and Command Center is huge plus


Job Posted By

Mahender
Delivery Head

About Organisation

eNFLUENCE IT Services Pvt. Ltd