Job Title: Ab Initio Developer

Location: Reston, VA (Hybrid, 1 day onsite per week)

Duration: 12 Months Contract to Permanent

Our client has an urgent need for an Ab Initio Developer to provide hands-on work designing and implementing data integration solutions for data warehouse and business intelligence systems.

Job responsibilities:

• Work with Business Analysts and Product team to gather data requirements
• Design and Build a CDC pipeline to move the data into Cloudera Hadoop platform
• Transform the data to create a consumable data layer for various application uses
• Support Data pipeline with bug fixes, and additional enhancements
• Document Technical design , Operational Runbook etc

Required Skills

• 7+ Years of IT Experience predominantly in Data Integration/ Data Warehouse area
• 6+ years of ETL Design and Development experience using Ab Initio
• 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
• Rigor 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