Job Description :
Role: Ab Initio Developer
Location: Chicago, IL
Duration: 6 months
Need Min 6 yrs. exp on Abinitio with ETL, with Cloud (AWS)
Data warehousing concepts including dimensional modelling to build and maintain Data Marts
Hands-on experience in SQL databases, preferably Teradata
Create, modify, and maintain Data Quality Measures to ensure that data anomalies are detected and communicated. Establish and enhance an Ab Initio-based Data Quality framework that supports technical, enrichment and statistical audits of data.
Utilize data warehousing concepts including data modelling and dimensional modelling to build and maintain Data Marts.
Build and deploy data audit checks using custom, hands-on development in the Ab Initio suite of tools including AI Co-op Version 3.0 or above and Ab Initio Graphical Development Environment (AI GDE
Use the Ab Initio Metadata Portal to input data reconciliation check requirements.
Deep background in Teradata SQL and relational data base design and development.
A very good understanding of translating business requirements into ETL logic
Detailed knowledge of UNIX shell and/or Perl and has ability to write and implement scripts.
Production exposure to implement the ETL job flows using Control-M
Aws Exp
Primary Skills
UNIX, SQL, Teradata, Ab Initio GDE, Co-Op, EME Metadata Hub
Exp/Knowledge of AWS or any other cloud platform is required.