YOU ARE HERE :   Home Jobs By Category IT Software - DBA / Datawarehousing Sr. Data Warehouse Developer (SSIS Developer)

Sr. Data Warehouse Developer (SSIS Developer)

Sr. Data Warehouse Developer (SSIS Developer) ( Job Ref : BGD5AR278814 )

Geneva Consulting Group

View Company Profile

Job Summary

Job Title:
Sr. Data Warehouse Developer (SSIS Developer)
Job Location:
Other New York - New York
Category :
IT Software - DBA / Datawarehousing
Industry:
Information Technology
Work Type:
Full Time
Job Role:
Software Developer
Job Type:
Regular
Annual Salary:
Confidential
Experience Required:
10-12 Years

Key Skills Sets for This Job:

SISS ETL Data Warehouse SQL Agile

Job Description

Designs develops and implements complex Extract, Transform, and Load (ETL) procedures to feed data into the Enterprise Data Repository from disparate clinical and non-clinical data sources.

Responsibilities:

  • Must be skilled with IBM Datastage in a data warehouse environment.
  • Knowledge of Datastage modules, select and deploy and integrate appropriate modules and code in complex data environment
  • Analyzes and translates functional specifications and change requests into Datastage technical specifications
  • Create efficient loads, tune projects, manage resources for a Netezza (preferred) data appliance environment.
  • Designs, develops and implements complex Extract, Transform, and Load (ETL) procedures.
  • Develops data warehouse process models, including sourcing, extraction, transformation and loading.
  • Creates execution plans, test files and scripts for data warehouse testing.
  • Produces supporting documentation, such as metadata and diagrams of entity relationships, business processes and process flow.
  • Develops and maintains standards, including organization, structure and nomenclature, for the design of data warehouse elements (data architectures, models, tools and databases).
  • Implements business rules via stored procedures, middleware or other technologies.
  • Maps data between source systems, data warehouse and data marts.
  • Performs system analysis, data analysis or programming.
  • Selects methods, techniques or criteria for data warehousing evaluation procedures. Verifies structure, accuracy and quality of warehouse data.
  • Writes new programs or modifies existing to meet project requirements.
  • Investigates and tests new software solutions or products, as necessary.
  • Provides mentoring and coaching to team members and affiliated teams, as needed.
  • Reviews and provides guidance to the development team and recommendations to optimize the data extraction and loading using ETL jobs.
  • Develops and implements corrections and improvements according to change requests. 19. Collaborates and works with multiple technical and business units to resolve support issues.

QUALIFICATIONS

  • Bachelor’s Degree in Computer Science, Information Technology or related technical field Minimum ten (10) years of experience in the design, development, and implementation of databases/data warehouses.
  • Extensive experience with enterprise level ETL tools. Strong understanding of ETL design and development such as direct-path loading and parallel SQL.
  • Strong understanding of data warehouse concepts and architecture. Understanding of star/snowflake schema design; dimension and fact tables.
  • Strong understanding of Oracle and SQL Server database architecture
  • Understanding of data modeling and design including partitioning, indexing, constraints and optimizer statistics.
  • Experience with development methodologies such as Agile.
  • Full life cycle experience (requirements gathering through production deployment) in all aspects of Business Intelligence and Data Warehousing.
  • Analytic, process flow, problem-solving, communication, customer service, organization skills, required.
  • Knowledge of Health Industry and Healthcare Data Exchange Standards (HL7, CCD), preferred.
  • Knowledge of web services (SOAP, REST), preferred

Geneva Consulting Group

Geneva Consulting Group

Established in :

14 Vanderventer Avenue, Suite 250 Port Washington, New York - 11050, United States

Website : http://www.genevaconsulting.com/

videoVideos photo Images

RKA Jobs, LLC. has taken all reasonable steps to ensure that information on this site is authentic. Applicants are advised to research bonafides of advertisers independently. RKA Jobs, LLC. shall not have any responsibility in this regard. We also recommend that you visit Privacy Policies and Terms of use for more comprehensive information on this aspect.

Get the latest jobs
emailed to you inbox.

Already Registered !! Login

Tool to help you

  • Fast Upload

    Fast Upload

    Upload your resume and get noticed by recruiters to receive the latest job post and vacancies right away to your email.

     
  • Advanced Skill Search

    Advanced Skill Search

    Our advanced search tool select the key elements of your profile,or the choices made therein and provides you with the best results.

     
  • Resume Writing

    Scale Up for Interview

    Get the best Interview tips from our ace career advisors, to mould you best for any interview you choose to crack.

     
  • Resume Writing

    Resume Writing

    Showcase the best of you with our resume writing tips and never miss a chance to get noticed by the recruiters.

     
  • Resume Database

    Resume Database

    Connect to our resume database that holds the best of resume for you to search the finest candidate matching your requirement.

     
  • Talent Hunt

    Talent Hunt

    Step ahead, take the advantage of posting the right job with the right skills you require.

     
  • Universe Services

    Universe Services

    Fast and easy way to recruit; provided with a world class service, we give you the choice of the most economical membership plan to best suit your requirement.

     
 

Subscribe For Newsletter