Information Technology

Employment TYPE

Contract

LOCATION

Raleigh, North Carolina

DATE POSTED

July 15, 2020

INDUSTRY

Information Technology

POSITION(S)

1

SALARY

Negotiable

Job# J776

ETL Developer

About The Opportunity

NC DHHS is seeking an ETL Developer to be responsible for the development, management, performance, and optimization of the Extract, Transform, and Load processes; including aiding in implementation, maintenance and optimization the associated solutions

Job Description

    Primary Purpose of the Position
  • The Extract, Transform, Load (ETL) Developer is responsible for the development, management, performance, and optimization of the Extract, Transform, and Load processes; including aiding in implementation, maintenance and optimization the associated technical solutions. This position will partner with key data stakeholders, IT leadership, project managers and architecture leads for the purpose of supporting the Department’s Business Intelligence Data Platform (BIDP) needs.
  • The ETL Developer is responsible for:
  • Working with Data Architects, Analysts, and Scientist to aid in BIDP data modeling efforts
  • Implement new ETL based technologies within the BIDP environment
  • Preform ETL workload testing
  • Conducting ETL optimization, troubleshooting and debugging, report regularly on health and performance of ETL environment and jobs
  • Maintain ownership of release activities interacting with ETL projects
  • Perform import and export ETL jobs across various ETL projects and servers
  • Assist in discovering, evaluating, and qualifying new technologies around BIDP ETL functions
  • Partner with BIDP stakeholders to establish and maintain policies, procedures, operational standards around the ETL functions
  • Help business in leveraging the BIDP through the ETL process
  • Strong knowledge and hands-on experience with ETL tools (AWS Glue preferred)
  • Experience in data modeling
  • Knowledge of compliance frameworks PCI, SOX, SOC 2, ISO 27001 and the ability to apply their requirements and concepts to a complex environment
  • Knowledge and hands-on expertise with Structured Query Language (SQL)
  • Strong interpersonal communication and ability to solve complex problems
  • Experience in debugging
  • Hands-on experiences with databases e.g., SQL, MYSQL, Oracle, etc.
  • Strong technical experience, knowledge, and understanding of micro-services architecture
  • AWS, Azure or GCP background (preferably all three), high-level programming or sys admin experience (preferred)
  • Experience with enterprise level cloud-based development, deployment, and auditing, including: PAAS, IAAS, and SAAS. (preferred)
  • Proficiency in scripting languages e.g., Python, Perl, Bash, JSON, etc.

Required Skills

  • Strong knowledge and hands-on experience with data pipeline tools Required
  • Experience in data modeling Required
  • Knowledge of compliance frameworks PCI, SOX, SOC 2, ISO 27001 and the ability to apply their requirements and concepts to a complex environment Required 5 Years
  • Experience in supporting a data warehouse in identifying and revising reporting requirements Required
  • Knowledge and hands-on expertise with processing confidential data and information according to guidelines Required
  • Strong interpersonal communication and ability to solve complex problems Required
  • Hands-on experiences with databases e.g., SQL, MYSQL, Oracle, Redshift (preferred), etc. Required 5 Years
  • Experience in model design, segmentation techniques, and ETL Frameworks Required
  • Knowledge and understanding of micro-services architecture Required
  • Strong analytic skills, including mining, evaluation, analysis, and visualization Required
  • AWS, Azure or GCP background (preferably all three) Required 5 Years
  • Experience with enterprise level cloud-based development, deployment, and auditing, including: PAAS, IAAS, and SAAS. (preferred) Required 3 Years

Duration

12 Months

Please Contact me to discuss the hiring process!

Sushil Singh

Sr. Executive Recruiter
Contact: (310) 929-8421 Ext: 107
Email: sushil.singh@staffactory.com

Hi! My name is Sushil Singh. Helping consultants with getting their desired job is what makes me feel alive. I build a unique relationship with each of my consultants and work on their profile as per their needs. I believe that my consultants are my assets and this motivates me to serve them in an even better manner. Hence, I work towards the success of every consultant I work with.