Job Description
Data Engineer
Location: Fairfax, VA
Why CMCI?
CMCI provides management consulting and IT services that empower enterprises to achieve their business goals in today's highly competitive market. Our goal is to seamlessly integrate into each customer's organization to fully understand their business and technology needs. This approach allows us to quickly deliver high quality solutions while achieving the highest level of customer satisfaction on time and within budget. By choosing CMCI, you are choosing a company that can deliver business outcomes and mission needs in the most cost-effective manner and without sacrificing capability. As a part of CMCI's culture of loyalty and commitment to its employees, CMCI is committed to providing a tremendous career path by promoting employees to their highest potential.
Primary Responsibilities
Assembling large, complex sets of data that meet non-functional and functional business requirements.
Collaborate across Agile teams to design, develop, test, implement, and support technical solutions in full-stack development tools and technologies.
Building required infrastructure for optimal extraction, transformation and loading of data from various data sources using AWS and SQL technologies.
Working with stakeholders including data, design, product, and executive teams and assisting them with data-related technical issues.
Develop data migration strategies and plans.
Develop scripts to extract, transform and load data.
Perform data analysis and cleansing activities to ensure data quality, as needed.
Troubleshoot and resolve issues related to data migration.
Document data migration processes, procedures, and outcome.
Requirements
Required Skills and Experience
8 years of work experience with a combination of data modeling, ETL, database operations, data services, data analytics, and data migration tools.
5 years of work experience with coding in one of mainstream programming languages: Python, Java, and SQL etc.
Hands-on experience with Oracle, PostgreSQL, SQL Server databases.
Experience in design and development of ETL process using tools like ETL tools like AWS DMS, Glue, and Athena etc.
Experience in designing data migration solutions, archival processes, and reconciliation.
Experience with data quality checks, data de-duplication and data validation processes.
Perform data migration audit, reconciliation, and exception reporting.
Experience with public cloud (AWS, Microsoft Azure).
Solid understanding of data elements and their relationships between the source and target systems.
Experience working on real-time data and streaming applications.
Clearance - Ability to obtain and maintain public trust. Must be a US Citizen.
All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability or protected veteran status.