Data Engineer - Ab Initio

Dice is the leading career destination for tech experts at every stage of their careers. Our client, Ampcus Inc, is seeking the following. Apply via Dice today!

Essential Functions:

1. Work with Business Analysts and Product team to gather data requirements
2. Design and Build AbInitio data graphs and data pipelines to extract the data from various databases/flat files/message queues
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.

Experience:

1. Total of 7+ Years of IT Experience predominantly in Data Integration/ Data Warehouse area
2. Must have at least 3 years of ETL Design and Development experience using Ab Initio
3. 1-2 years of Data Integration project experience on Hadoop Platform, preferably Cloudera
4. At least one project implementation of AbInitio CDC (Change Data Capture) in a Data Integration/ETL project
5. Working knowledge of HDFS, Hive, Impala and other related Hadoop technologies
6. Sound understanding of SQL and ability to write well performing SQL queries
7. Good knowledge of OLTP and OLAP data models and other data warehouse fundamentals
8. Rigor in high code quality, automated testing, and other engineering best practices, ability to write reusable code components
9. Ability to unit test the code thoroughly and to troubleshoot issues in production environments
10. Must have some working experience with Unix/Linux shell scripting
11. Must be able to work independently and support other junior developers as needed
12. Some Java development experience is nice to have
13. Knowledge of Agile Development practices is required

Position Title:

Data Engineer - Ab Initio