Senior Ab Initio Developer

Senior Ab Initio Developer

Total of 10+ years of IT experience predominantly in Data Integration/Data Warehouse area

Must have 5 years of ETL Design and Development experience using Ab Initio

1-2 years of Data Integration project experience on Hadoop Platform, preferably Cloudera

At least one project implementation of AbInitio CDC (Change Data Capture) in a Data Integration/ETL project

Working knowledge of HDFS, Hive, Impala and other related Hadoop technologies

Sound understanding of SQL and ability to write well performing SQL queries

Good knowledge of OLTP and OLAP data models and other data warehouse fundamentals

Rigorous in high code quality, automated testing, and other engineering best practices, ability to write reusable code components

Ability to unit test the code thoroughly and to troubleshoot issues in production environments

Must have some working experience with Unix/Linux shell scripting

Must be able to work independently and support other junior developers as needed

Some Java development experience is nice to have

Knowledge of Agile Development practices is required

Responsibilities:

1) Work with Business Analysts and Product team to gather data requirements

2) Design and Build a CDC pipeline to move the data into Cloudera Hadoop platform

3) Transform the data to create a consumable data layer for various application uses

4) Support Data pipeline with bug fixes, and additional enhancements

5) Document Technical design, Operational Runbook etc

Candidate must be on your W2. No OPT or CPT candidates.