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.