AbInitio Data Engineer, Cynet Systems, Reston, VA
Cynet Systems -
Reston, VA,
US
AbInitio Data Engineer
Date Posted: 2024-06-12
Job description
Job Description:
Essential Function:
Essential Function:
- 20% Lead the team to design, configure, implement, monitor, and manage all aspects of Data Integration Framework.
- Defines and develops the Data Integration best practices for the data management environment of optimal performance and reliability.
- 20% Develops and maintains infrastructure systems (e.g., data warehouses, data lakes) including data access APIs.
- Prepares and manipulates data using Hadoop or equivalent MapReduce platform.
- 15% Provides detailed guidance and performs work related to Modeling Data Warehouse solutions in the cloud OR on-premise.
- Understands Dimensional Modeling, Denormalized Data Structures, OLAP, and Data Warehousing concepts.
- 15% Oversees the delivery of engineering data initiatives and projects.
- Supports long term data initiatives as well as Ad-Hoc analysis and ELT/ETL activities.
- Creates data collection frameworks for structured and unstructured data.
- pplies data extraction, transformation and loading techniques in order to connect large data sets from a variety of sources.
- 15% Enforces the implementation of best practices for data auditing, scalability, reliability and application performance.
- Develop and apply data extraction, transformation and loading techniques in order to connect large data sets from a variety of sources.
- 10% Interprets data, analyzes results using statistical techniques, and provides ongoing reports.
- Executes quantitative analyses that translate data into actionable insights.
- Provides analytical and data-driven decision-making support for key projects. Designs, manages, and conducts quality control procedures for data sets using data from multiple systems.
- 5% Improves data delivery engineering job knowledge by attending educational workshops; reviewing professional publications; establishing personal networks; benchmarking state-of-the-art practices; and participating in professional societies.
- Bachelor's Degree.
- Computer Science, Information Technology or Engineering or related field.
- 8 years Experience in leading data engineering and cross functional team to implement scalable and fine tuned ETL/ELT solutions for optimal performance.
- Experience developing and updating ETL/ELT scripts. Hands-on experience with application development, relational database layout, development, data modeling.
- In lieu of a Bachelor's degree, an additional 4 years of relevant work experience is required in addition to the required work experience.
- ETL Design and Development experience using AbInitio ., Expert
- Data Integration project experience on Hadoop Platform, preferably Cloudera., at least one project
- some AWS cloud experience and exposure to MongoDB is a big plus.
- Knowledge and understanding of at least one programming language (i.e., SQL, NoSQL, Python)., Expert
- Knowledge and understanding of database design and implementation concepts. , Expert
- Knowledge and understanding of data exchange formats., Expert
- Knowledge and understanding of data movement concepts, Expert.
- Strong technical and analytical and problem solving skills to troubleshoot to solve a variety of problems., Expert
- Requires strong organizational and communication skills, written and verbal, with the ability to handle multiple priorities., Expert
- ble to effectively provide direction to and lead technical teams., Expert