Lead Data Engineer Location: Durham NC {Hybrid} Exp: 12+ at Durham, New York, USA |
Email: [email protected] |
Role: Lead Data Engineer Location: Durham NC {Hybrid} Exp: 12+ Mandatory: Experience with Oracle database Complete Description requires the assistance of contract resources to serve as Senior Data Engineer. The purpose of this position is to analyze, map, build, test, and maintain data extraction, conversion, and migration from databases like Oracle and DB2 to target databases including Data Warehouse, and Data Lake on various cloud or on-prem database platforms. One of the primaries focuses of this position is to lead data analysis, mapping, needed transformation and extraction of data from Oracle and DB2 databases to migrate to Salesforce platform for Child welfare program. The work involves collaborating with various internal and vendor stakeholders to understand business requirements and translating them into efficient and scalable technical solutions for the Child Welfare 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 Child Welfare sources into Salesforce. This position will also support data archival for data growth management, data sub-setting to extract criteria-based data and data de-identification to help provide needed data for application validation. The Senior data engineer will need excellent problem-solving skills and the ability to work independently as well as part of a team. The work involves understanding data, relationships among data objects, designing and developing ETL to support these data workstreams.The work also involves monitoring and troubleshooting data pipelines/process to ensure data quality, completeness, integrity, and availability.SkillRequired/DesiredAmountof ExperienceExperience with Oracle databaseRequired7YearsStrong hands-on Experience with PL/SQLRequired7YearsStrong hands-on Experience with SQLRequired7YearsExperience with data conversion and migrationsRequired5YearsExperience with data analysis and cleansingRequired1YearsExperience with DB2 databaseRequired2YearsHands-on experience in coding, testing, and maintaining ETL processesRequired7YearsExperience with source code repository like Git, BitBucket, SVNRequired1YearsExperience with TalendHighly desired1YearsExperience with JavaHighly desired5YearsExperience with cloud platforms (e.g. AWS and Azure) and associated services for data processing and storageHighly desired1YearsUnderstanding and experience with the Child welfare application systemDesired0 -- Keywords: information technology procedural language Delaware North Carolina Lead Data Engineer Location: Durham NC {Hybrid} Exp: 12+ [email protected] |
[email protected] View all |
Tue Jul 30 23:04:00 UTC 2024 |