Description de l'offre
ü 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
B.E / B. tech or equivalent
Preferred Certifications / Affiliations:
Certifications from NSE/BSE/AIMR/CFA Institute/Others