Data Engineer

Our government client is looking for an experienced Data Engineer on a hybrid 12+ months renewable contract role in Durham, NC.Position: Data EngineerAbout The RoleData Engineer:The agency requires the assistance of contract resources to serve as Data Engineers. The primary purpose of these positions is to analyze, map, build, test, and maintain database pipeline architectures using Oracle and DB2 for the agency efforts as the legacy system migrates to Salesforce. The work involves collaborating with various stakeholders to understand business requirements and translating them into efficient and scalable technical solutions for the agency program.The persons in this position will play a crucial role in designing, implementing, and optimizing data pipelines and ETL processes to support the extraction, transformation, and loading of data from various agency sources into Salesforce. They will collaborate with cross-functional teams to understand data requirements and translate them into technical solutions. The data engineers will need excellent problem-solving skills and the ability to work independently as well as part of a team. The work involves developing and maintaining data models, schemas, and databases to support data conversion needs. The work also involves monitoring and troubleshooting data pipelines to ensure data quality, completeness, integrity, and availability. This position will be implementing best practices for data governance, security, and compliance to ensure regulatory requirements are met.Responsibilities And DutiesAnalyze, Map, Build, Test, and Maintain database pipeline architectures using Oracle and DB2Collaborate with SMEs to understand and execute data conversion objectives that transforms, masks, and loads data into Salesforce objectsCreate and maintain table schemasCreate new data validation methods to ensure data accuracy, completeness, and cleanlinessEnsure compliance with data governance and security policiesRequired/Desired Experience:5 Years of Experience with Oracle Required5 Years of Experience with PL/SQL Required7 Years of Experience with SQL Required5 Years of Experience with data migrations from legacy systems Required1 Year of Experience with data cleansing Required1 Year of Experience with DB2 Highly desired1 Year of Experience with ETL processes involving Salesforce Highly desired1 Year of Experience with Talend Highly desired1 Year of Experience with GIT Highly desired1 Year of Experience with Jira Highly desired5 Years of Experience with Java Highly desired3 Years of Experience with Python Highly desired1 Year of Experience with cloud platforms (e.g. AWS and Azure) and associated services for data processing and storage Highly desired2 Years of Experience with Azure Synapse Highly desired1 Year of Experience with Azure Databricks Nice to have1 Year of Experience with Cloud Computing Nice to have1 Year of Experience with Power BI Nice to have About VectorVector Consulting, Inc., (Headquartered in Atlanta) is an IT Talent Acquisition Solutions firm committed to delivering results. Since our founding in 1990, we have been partnering with our customers, understanding their business, and developing solutions with a commitment to quality, reliability and value. Our continuing growth has been and continues to be built around successful relationships that are based on our organization's operating philosophy and commitment to ** People, Partnerships, Purpose and Performance - THE VECTOR WAYwww.vectorconsulting.com“Celebrating 30 years of service.”