Home       |     Overview      |     Candidate Login      |     Post Resume       |     Contact us
 
  
     
     
Search Jobs
     
Keywords,Title,Skills,Company  Location,City,State,Zip  
  Advanced Search
     
Datastage SQL PLSQL DWH MS Visio ERwin SAS 6 PowerShell MS Office Good Oral And Wri
 
Requirement id 104418
Job title Developer
Job location in Washington, WA
Skills required ETL Developer, Data Stage, Business Requirements, SQL PLSQL DWH MS Visio ERwin SAS 6 Power
Open Date 04-Mar-2020
Close Date
Job type Contract
Duration 1 Months
Compensation DOE
Status requirement ---
Job interview type ---
   Email Recruiter: coolsoft
Job Description Developer: ETL Developer, Data Stage, Business Requirements, SQL PLSQL DWH MS Visio ERwin SAS 6 Power

Responsibilities

DURATION: We are currently at the end of the year-long extension with OPM. That said, Optum is in process of seeking another year long extension. If the identified contractor performs well, they will be extended along with the Optum contract.

BACKGROUND CHECK REQUIREMENT:

*** Candidates without Federal Public Trust Clearance will not be considered *** Requires Federal Public Trust Clearance. Its similar to what we would consider a normal background check but its performed for all Federal Government positions by the OPM. Individuals who have worked / contracted previously for the Federal government would already hold this clearance level and would be able to start immediately whereas individuals who do not have this clearance level would need to wait anywhere from 2-6 weeks for the background check to be completed before starting. *** Please list whether your candidates have Federal Public Trust Clearance or not ***

LOCATION - On-site with the customer at the following location: 1900 E Street, NW, Room 4350| Washington, DC 20415-1100.

What is the specific title of the position?

Senior DataStage ETL Developer

What Project/Projects will the candidate be working on while on assignment?

This individual will be working on our Federal Office of Personel Management (OPM) Health and Insurance Data Warehouse (HIDW) project. Its an Oracle database platform with 5 silo data streams from 5 health insurance providers. Data feeds are being built using the DataStage ETL software and OPM will use the HIDW to review Federal Employee Health Benefits plan (FEHB) enrollees, and their healthcare outcomes.

*** Open to candidates who can or cannot convert without sponsorship.

TOP REQUIREMENTS:

DataStage ETL Skills
DataStage Administrative skills
Healthcare Data Modeling skills

*** What experience will set candidates apart from one another? Informatica skills and specifically having worked on a project converting from DataStage to Informatica.

Is this person a sole contributor or part of a team?

Team

If so, please describe the team?

6-10

What are the top 5-10 responsibilities for this position?

Development and design activities for DataStage ETL & Data Integration
Creation of business requirements, mapping sheets, physical and logical models
Design, Develop and Implement Data Quality solution using QualityStage
Perform DataStage Administration activities
Perform design and development of Integrated Model for multiple healthcare carriers

What software tools/skills are needed to perform these daily responsibilities? IBM DataStage and QualityStage working with an Oracle Database

What skills/attributes are a must have? • Public Trust Security Clearance • Bachelors Degree • 7+ Years of experience in data warehouse projects using DataStage with 2-3 years of team leadership experience • 5+ years in encryption of data in both windows and Linux environments. • 10+ Years development experience, must include ETL tool like DataStage • 10+ Years experience with Oracle, SQL server, SQL, PL/SQL. • 10+ Years Data warehouse Applications Development experience • 10+ Years development experience using standard Software Development Life Cycle Methodology. • 2+ years in PowerShell scripting. • Proficient in IBM DataStage 9.x/11.x Oracle, SQL and Linux • Experience working in Agile (Scrum a plus) • Experience creating data warehouse from scratch. • Available location: Washington, DC

What skills/attributes are nice to have? • Healthcare Industry Experience is a plus • Proficiency in MS Office (Word, Excel, PowerPoint, Outlook and Access) • Experience in scheduling Tool • Proficiency in MS Visio, ERWIN • Experience with SAS • Experience with Informatica PowerCenter a big
 
Call 502-379-4456 Ext 100 for more details. Please provide Requirement id: 104418 while calling.
 
Other jobs in WA: Bellevue (2), Olympia (8), Seattle (18),
 
 ETL Developer job openings in other states
Jobs List

VDOT Senior Azure ETL Developer (730968)
Create date: 11-Mar-2024
Hybrid

start date :04/01/2024

End date :06/30/2024

submission deadline : 3/14/2024

client info :VDOT

Description :

*Local Richmond, VA candidates only please
*Candidate may be required to attend a second, onsite interview. Please O.... (This job is for - job Jobs in VA Richmond Developer - (in Richmond, VA))

ETL Developer-125341
Create date: 23-Feb-2024
start date :03-11-2024

submission deadline :3/1/2024

client info :Hancock Whitney Corporation - New Orleans

Note:

* REMOTE

Description :

Project Details: The body of work is exclusively converting ETL jobs from the Informatica Powercen.... (This job is for - Jobs in FL Orlando Developer - (in Orlando, FL))

Programmer Analyst 5 - 123903
Create date: 30-Oct-2023
Start date : 11/27/2023

End Date : 1 Years from projected start date

Submission deadline : 11/06 at 10AM EST.

Client Info : ORS

Note :

* Interviews: ONSITE interviews required - please see the location address below

* Duration: 1 year with possible extension

* Position .... (This job is for - job Jobs in MI Lansing Analyst - (in Lansing, MI))

Enterprise Data Architect - FR102635
Create date: 12-Oct-2023
* Job Title: Enterprise Data Architect Data Architect,ETL,Informatica-FR102635

start date : 10/23/2023

End date :06/28/2024

submission deadline :10/13/2023

client info :OIT

Note:

* Position Location: Remote

Description : .... (This job is for - Data Architect Jobs in CO Denver Architect - (in Denver, CO))

Senior ETL Developer - 60987
Create date: 26-Jun-2023
start date : 07/01/2023

End date : 06/30/2024

submission deadline : 06/30/2023

client info : NeEDU

Note :

* Candidate Must Be Local

Description :

Knowledge and Abilities:

KNOWLEDGE:

· The entire.... (This job is for - Jobs in NE Lincoln Developer - (in Lincoln, NE))
 
 ETL Developer job openings in WA
Jobs List

1179-18-ALP Extract, Transform And Load(ETL) Consultants -SP
Create date: 29-Jun-2018
Note: Email Submission

Submission Deadline: 7/19/2018 2 PM PT
Start Date: 8/13/2018
End Date: 2/28/2019

Client: King County, Department of Information Technology

Description:

Project Description
King County Information Technology (KCIT) is building a Data Warehouse (DW) for the King ODS Jobs in WA Seattle Consultant - (in Seattle, WA))
(Developer: ETL Developer, Data Stage, Business Requirements, SQL PLSQL DWH MS Visio ERwin SAS 6 Power in Washington, WA)
     
Search Jobs
     
Keywords,Title,Skills,Company  Location,City,State,Zip  
  Advanced Search
     

    About Us     Services    Privacy policy    Legal     Contact us