ETL Ab Initio Developer

ETL Ab Initio Developer

Charlotte, NC 28217

6 Months

No C2C at this moment, any visa is okay. Thanks!

Ab Initio suite of tools including AI Co-op Version 3.0 or above, GDE, Metadata Hub and Express?IT

Data warehousing concepts including dimensional modeling to build and maintain Data Marts

Hands-on experience in SQL databases, preferably Teradata and Netezza

This role is a team contributor reporting to the Senior Manager, Data Audit Strategy within Charter BI. The ETL Developer is responsible for auditing the data within the Charter Business Intelligence environment to examine the quality of the data and its fitness for usage. The developer will create, modify, and maintain Data Quality Measures (DQMs) to ensure that Business Intelligence data gaps, anomalies, and issues are detected properly and being communicated appropriately.

Perform ETL/ELT implementation and support of a complex, mission-critical Business Intelligence data warehouse application implemented in Teradata and Netezza databases.

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.

Coordinate with the Business Intelligence vertical teams and Data Integrity Management team to help identify audit check requirements for data reconciliation and data quality.

Utilize data warehousing concepts including data modeling and dimensional modeling 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.

Use the Ab Initio Express?IT template to define rule-based data quality checks.

Deep background in Teradata SQL and relational data base design and development.

A very good understanding of translating business requirements into data quality reports.

Detailed knowledge of UNIX shell and/or Perl and has ability to write and implement scripts.

Liaise with Production Operations team to define the data quality job flows using Tidal or Appworx