Vacancy expired!
Hourly Rate: $71 W2; $82 CTC/1099 Job Description: The NC Department of Health and Human Services seeks contractor resources to serve as a Data Integration API and ETL developer is responsible for creating real-time, on-demand, batch and scheduled data interfaces and processing between systems and applications, both internal and external. This position will partner with key data stakeholders, IT leadership and managers, and architecture leads for the purpose of supporting the Department's data interfacing, processing, and reporting needs. Responsibilities include: Working with Data Architects, Analysts, and Data Scientists to aid in data modeling efforts. Conducting optimization, troubleshooting and debugging, and reporting regularly on health and performance of data exchange and processing jobs. Assisting in discovering, evaluating, and qualifying new technologies around application data integrations via ETL and APIs. Partnering with stakeholders to establish and maintain policies, procedures, operational standards. Helping business in leveraging the data interfaces for reporting. Configuring integrations between applications and data sources such as Oracle, AWS RedShift, Salesforce, Dynamics, etc. Designing integration solutions in ETL and SOA patterns and monitoring and maintaining interface gateways and integration life cycles. Implementing, executing, and testing ETL imports and exports. Establishing API and Service Bus management on PaaS and IaaS middleware platforms. Creating XSDs, WSDLs, and XSLT Transformations between source data formats and XML Schemas. Defining, creating and consuming web services (SOAP, REST) and micro-services. Required Skills:
- Experience in data modeling, OLAP design, and implementation of APIs and ETL processes, procedures, and execution for data cleansing, and refreshes. (7 years)
- Experience with integration via web-services, and API and ETL management. (5 years)
- Hands on implementation experience with Dell Boomi (5 years)
- Strong technical experience, knowledge and understanding of micro-services architecture. (5 years)
- Hands-on experience building integration patterns; processes; managing, deploying and supporting API's. (7 years)
- Experience with enterprise level cloud-based development, deployment, and auditing, with PAAS, IAAS, and SAAS models. (5 years)
- Experience with Oracle and PL/SQL. (7 years)
- Experience leveraging common frameworks such as message queuing, caching, complex mapping, branching, and parallel processing. (7 years)
- Strong understanding and knowledge of data formats JSON, XML, Flat Files (CSV, Fixed-Width). (7 years)
- Strong interpersonal communication skills, and ability to collaborate in problem solving. (7 years)
- Experience with troubleshooting & debugging. (7 years)
- Knowledge of compliance frameworks such as PCI, SOX, SOC 2, ISO 27001 and ability to apply their requirements and concepts to complex environments, (7 years)
- Knowledge and understanding of reports design and development in Tableau. (5 years)
- Expertise with serverless data integration service and ETL using AWS Glue. (3 years)
- Knowledge and understanding of interfacing with Amazon RedShift. (3 years)
- Proficiency in scripting languages e.g., Groovy, JavaScript, Python, Perl, Bash, JSON, etc. (3 years)
- Experience with AWS, Azure or Google Cloud Platform background (preferably all three), high-level programming or sys admin. (3 years)
Vacancy expired!