Sr Ab Initio Data Engineer

Sr Ab Initio Data Engineer

Location:

Reston, VA
Type: 12 mos contract
Compensation:
Contractor Work Model:
Hybrid
Local candidates only who reside in the DMV - drivable distance

We are looking for a Senior Ab Initio developer with many years of data integration, data warehouse project experience. No

SQL/Mongo

DB, AWS experience is highly preferred, must be a self starter and should be able to work with minimum supervision.

The Senior Data Engineer is responsible for orchestrating, deploying, maintaining and scaling cloud OR on‑premise infrastructure targeting big data and platform data management (Relational and No

SQL, distributed and converged) with emphasis on reliability, automation and performance. This role will focus on developing solutions and helping transform the company's platforms deliver data-driven, meaningful insights and value to company.

• 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 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

Education Level: Bachelor's Degree in Computer Science, Information Technology or Engineering or related field

• Total of 10+ Years of IT Experience predominantly in Data Integration/ Data Warehouse area
• Must have at least 5 years of ETL Design and Development experience using Ab Initio
• 1-2 years of Data Integration project experience on Hadoop Platform, preferably Cloudera
• AbInitio CDC (Change Data Capture) experience in a Data Integration/ETL project setting is great to have
• Working knowledge of HDFS, Hive, Impala and other related Hadoop technologies
• AbInitio integration with AWS S3 and Redshift and/or other AWS database services
• 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

System One, and its subsidiaries including Joulé, ALTA IT Services, and Mountain Ltd., are leaders in delivering outsourced services and workforce solutions across North America. We help clients get work done more efficiently and economically, without compromising quality. System One not only serves as a valued partner for our clients, but we offer eligible employees health and welfare benefits coverage options including medical, dental, vision, spending accounts, life insurance, voluntary plans, as well as participation in a 401(k) plan.

System One is an Equal Opportunity Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex (including pregnancy, childbirth, or related medical conditions), sexual orientation, gender identity, age, national origin, disability, family care or medical leave status, genetic information, veteran status, marital status, or any other characteristic protected by applicable federal, state, or local law.

: #851-Rockville-S1