Clinical Programmer (SAS)
at Katalyst Healthcares Life Sciences
Lawrenceville, NJ 08648, USA -
Start Date | Expiry Date | Salary | Posted On | Experience | Skills | Telecommute | Sponsor Visa |
---|---|---|---|---|---|---|---|
Immediate | 10 Nov, 2024 | Not Specified | 10 Aug, 2024 | 3 year(s) or above | Eclinical,Computer Science,Etl Tools,Shell Scripting,Sas Programming,Ecs | No | No |
Required Visa Status:
Citizen | GC |
US Citizen | Student Visa |
H1B | CPT |
OPT | H4 Spouse of H1B |
GC Green Card |
Employment Type:
Full Time | Part Time |
Permanent | Independent - 1099 |
Contract – W2 | C2H Independent |
C2H W2 | Contract – Corp 2 Corp |
Contract to Hire – Corp 2 Corp |
Description:
Responsibilities:
- Leverage technical expertise to define feasible solutions and understand limitations.
- Can create/develop prototypes for new solutions as applicable.
- Create best practices for data loading, transformation, and extraction.
- Develop data architecture, data modeling, and ETL mapping solutions within structured data warehouse environment.
- Develop and implement ETL routines according to the Data Warehouse (DWH) design and architecture.
- Support the development and validation required through the lifecycle of the DWH, maintain user connectivity and provide adequate security for data warehouse.
- Monitor the DWH systems performance and integrity; provide corrective and preventative maintenance as required.
- Maintain data integrity and traceability across the transformation lifecycle from the Source to Target.
Requirements:
- 8+ years of experience with any ETL tool.
- Minimum 5+ years of experience in SQL language.
- Minimum 3+ years of experience with cloud technologies.
- Minimum 3+ years of experience in SAS programming.
- Minimum 5+ years of experience in shell scripting.
- Good to have experience with ECS (eClinical Solution) ETL tool.
- 8+ years of experience with ETL tools such as Informatica, Data Stage or eClinical Solutions.
- 2+ years of experience with programming ETL Tools. eClinical is the preferred tool.
- 5+ years of experience with SQL language and experience with shell scripting.
- 3+ years of experience with cloud technologies and SAS Programming.
- Bachelor’s Degree (Computer Science preferably).
Responsibilities:
- Leverage technical expertise to define feasible solutions and understand limitations.
- Can create/develop prototypes for new solutions as applicable.
- Create best practices for data loading, transformation, and extraction.
- Develop data architecture, data modeling, and ETL mapping solutions within structured data warehouse environment.
- Develop and implement ETL routines according to the Data Warehouse (DWH) design and architecture.
- Support the development and validation required through the lifecycle of the DWH, maintain user connectivity and provide adequate security for data warehouse.
- Monitor the DWH systems performance and integrity; provide corrective and preventative maintenance as required.
- Maintain data integrity and traceability across the transformation lifecycle from the Source to Target
REQUIREMENT SUMMARY
Min:3.0Max:8.0 year(s)
Information Technology/IT
IT Software - Other
Software Engineering
Graduate
Proficient
1
Lawrenceville, NJ 08648, USA