ETL Developer

Found in: Appcast US C2 - 2 weeks ago

Piscataway, United States Robert Half Full time
  • Provides development and production support for the Business Intelligence infrastructure including data warehouses, data marts, data models, data services, views, and reports.
  • The position is primarily focused within a Clinical Research environment (HIPAA compliant environment).
  • Responsible for analysis, planning, design, development, implementation, and maintenance in support of departmental standardized ETL and report processes, as well as, integration with both internal and external data partners.
  • With minimal supervision, this position develops processes to assist in clinical research efforts.
  • Involved with ingesting data from a variety of university data sources.
  • Adapts and helps lead standard methodologies for ETL development.
  • Working with the research leads and other technical teams, this position designs and develops ETL workflows to reshape the data into consumable formats for research and reporting needs.
  • Acts as an Honest Broker within the Clinical & Research environment that keeps sets of confidential information but distributes parts of those set to other entities who should not have access to the entire set.
  • Perform file management of sensitive data into and out of the CRDW environment with the approval of the Data Governance Committee. Maintain status of data inventory and file transfers.
  • Understands and adheres to specific compliance standards.
  • Performs other related duties as assigned.
  • Current experience using ETL Tools/software (for example only: Informatica, ODI, Data Quality and native PL/SQL)
  • Proficient in SQL
  • Experience with Data Modeling in a Data Warehouse environment.
  • Current experience with Oracle and MS SQL Server databases.
  • Experience with Perl or Shell Scripting, R, SAS is also desirable.
  • Prefer proven experience with the EPIC data model and/or related experience with healthcare data.
  • EPIC Caboodle Developer Certifications preferred.
  • Customer service mindset, profession courtesy, respect and consistent positive communications to team members and clients is essential to delivering great work experiences.
  • Experience with data modeling for research, reporting & analytics.
  • Aptitude for leveraging big-data technologies.
  • Ability to understand complex, integrated state of the art business intelligence and report data modeling.
  • Ability to understand complex user authentication and data access authorization security models.
  • Excellent written, oral, and interpersonal skills and the ability to foster working relationships with users and peers.
  • Excellent technical documentation, analytical and research skills.
  • Skills to create and maintain ETL workflows/processes for a myriad of data sources including cloud sources, creating source to target specifications from client requirements and completing development of ETL processes using Oracle PL/SQL, Informatica, R, SAS or any other ETL tools.
  • Knowledgeable in reporting tools, decision support systems, data modeling, data design and ETL processing, preferably experienced in EPIC data model and other Healthcare data.
  • Experience with data mapping analysis and design
  • Familiar with Data Warehouse concepts and experience with Star Schema
  • Extensive knowledge of data structures, database solutions, and best practice data management principles
  • Strong analytical and problem solving skills

  • IBM Infospere Developer

    1 week ago

    Piscataway, United States Tata Consultancy Services Full time

    Experience developing and supporting IBM Infosphere Master Data Manager out-of-the-box and customization code - Experience resolving technical incidents An ability to configure matching processes ETL Datastage experience will help. Must have experience with implementation. Excellent English oral and written communication skills. Good analytical abilities,...

  • Junior SQL Developer

    Found in: beBee S US - 2 weeks ago

    Piscataway, United States Pozent Corporation Full time

    Junior SQL Developer A highly successful utility company is seeking a talented Junior SQL Developer (1-3 years) to join their team. This is a contract & Full Time position. Candidates requiring visa sponsorship will be considered for this position. This role is located in Piscataway NJ Responsibilities include Analysis design development testing ...

  • Junior SQL Developer

    Found in: beBee jobs US - 2 weeks ago

    Piscataway, New Jersey, United States Pozent Corporation Full time

    Junior SQL Developer A highly successful utility company is seeking a talented Junior SQL Developer (1-3 years) to join their team. This is a contract & Full Time position. Candidates requiring visa sponsorship will be considered for this position. This role is located in Piscataway NJ Responsibilities include Analysis design development testing and...

  • IBM Infosphere Developer

    1 week ago

    Piscataway, United States Diverse Lynx Full time

    Job Title: IBM Infosphere Developer Location: Piscataway, NJ Duration: Full-Time Skill: IBM InfoSphere DataStage Job Description: Experience developing and supporting IBM Infosphere Master Data Manager out-of-the-box and customization code - Experience resolving technical incidents An ability to configure matching processes ETL Datastage experience will...

  • Data Engineer – Spark, Hadoop

    Found in: beBee S US - 2 weeks ago

    Piscataway, United States QData Full time

    Role Duties Designs and builds solutions to move data from operational and external environments to the business intelligence environment using Ab Initio software and DataStage (formerly Ascential) - IBM's WebSphere Data Integration Suite. Skills include designing and developing extract transform and load (ETL) processes. Experience includes the full...

  • Data Engineer – Spark, Hadoop

    Found in: beBee jobs US - 1 week ago

    Piscataway, New Jersey, United States QData Full time

    Role Duties Designs and builds solutions to move data from operational and external environments to the business intelligence environment using Ab Initio software and DataStage (formerly Ascential) IBM's WebSphere Data Integration Suite. Skills include designing and developing extract transform and load (ETL) processes. Experience includes the full lifecycle...

  • Data Engineer

    Found in: beBee S US - 2 weeks ago

    Piscataway, United States QData Full time

    Mandatory Skills Data Engineer Data Integration Required skills Informatica Unix Informatica DIH. Candidates should have overall 10+ year of experience. Designs and builds solutions to move data from operational and external environments to the business intelligence environment using Ab Initio software and DataStage (formerly Ascential) - IBM's...

  • Data Engineer

    Found in: beBee jobs US - 2 weeks ago

    Piscataway, New Jersey, United States QData Full time

    Mandatory Skills Data Engineer Data Integration Required skills Informatica Unix Informatica DIH. Candidates should have overall 10+ year of experience. Designs and builds solutions to move data from operational and external environments to the business intelligence environment using Ab Initio software and DataStage (formerly Ascential) IBM's WebSphere Data...