ETL Developer

at Apex Systems Inc

location Glen Allen, Virginia

Updated on Jan 10, 2019

Contract Position
10 month(s)

  • Referral Bonus

    $500

    approx.
  • Signing Bonus

    $500

    approx.

Pay Rate $42.00 per hour

Experience 3-7 Years

Eligibility Green Card, US citizen

Industry

Information Technology Services

Travel

Not Specified

Job ID

PATDC646072

Working Remotely Allowed

No

JOB DESCRIPTION

In person interview required.

Primary Skills: Amazon Web Services (AWS), ETL

Scope
The primary responsibility of this role is to support a project within Cyber-security to deliver an automated dashboard which shows the availability (up time %) for all products within the CTR catalogue. 
The focus will be full life-cycle Business Intelligence implementation:  Customer engagement and requirements gathering, BI data model design, building ETL processes, and data visualization. 
The challenge will be the data is in multiple sources, each service defines availability differently, and there needs to be a data normalization exercise, so we can view all the products uptime % in one dashboard.

Requirements:
Define/measure availability for each product/service 
Determine where the source data currently sits and how to access it
Map data and normalize
Move data to repository (probably AWS flagship)
Design data models and port into BI tool
Create dashboard 

ETL Specialist
The ETL specialist determines and implements strategy for efficient ETL processes for BI data solutions. This will include leveraging ETL Tools, AWS Services and Databases.  This person understands and implements a variety of diverse BI acquisition techniques. Ensures compliance with all standards, and that the project deliverables are consistent with long-term infrastructure plans. It is the ETL specialist’s responsibility to:
Understand the data structure in both the source and the target BI systems
Create source/target mappings
Apply business rules as transformations
Design and develop efficient reusable data transformations
Define testing strategy include unit tests, end to end integration and user acceptance testing
Define and develop processes to monitor production data for quality, accuracy and timeliness
Design data cleanup and archival processes
Adapt ETL processes to accommodate changes in source systems and new business user requirements
Define and capture metadata and rules associated with ETL processes
Experience with AWS (S3, Redshift, Glue, Lambda)
Experience with ETL Tools (Talend)

Note: Candidate must be authorized to work without sponsorship

Similar Jobs

BRILLIANT FEATURES

Earn money by referring your friends to their next dream job, or find a job for yourself and the Referral Bonus becomes a Signing Bonus. Full time or Contract.

  • Make Money

    We’ll give you between several hundred and several thousand dollars for every successful referral.

  • Help Your
    Friends

    Job applications with personal recommendations are twice as likely to get hired.

  • 100% Free

    Absolutely zero sign up and subscription fees. We want to pay YOU!

  • Signing Bonuses

    All jobs on iEndorseU come with a Signing Bonus if you find a job for yourself

  • No credit card needed

    We pay you directly through Paypal, so keep your personal information…personal.

  • Sponsor others

    Get others to download our app and we will pay you $100 whenever they next get a job through our platform.

All the ways to make money from us