Employee Log-In
Call Today 800.319.9955
We provide the BEST quality service.
Client Specific IT Solutions for Business & Government

Our Quality Commitment

View All Jobs   Job Search   Post Resume   Candidate Login  
ETL Data Warehouse Developer Rensselaer, NY 
Posted:  9/20/2018
Category:  Developer
Job Type:  Temp to Perm
Minimum Experience:  9
Required Education:  BS/BA Degree
Job Description

Tidal is looking for its next passionate, highly skilled, self-motivated, experienced ETL Data Warehouse Developer to join our team as we continue to partner with New York State of Health (NYSoH) to provide comprehensive health coverage to more than 4.3 million New Yorkers. Our team provides NYS with innovative and agile health benefit exchange (HBE) solutions that deliver the functionality required to comply by the Patient Protection and Affordable Care Act and provide the flexibility needed to easily scale up to support future requirements.
Here’s what You’ll Do:
Analyze – Data requirements, complex source data, and the data model and determine best methods in extracting, transforming and loading data into data staging, and warehouse.
Collaborate – Work closely with functional teams to understand requirements regarding ETL design flows and data integration. Collaborate on definition, development, and maintenance of standards and processes.
Design – Develop ETL solutions using data warehouse design best practices. Create, update and maintain Online Analytical Processing (OLAP) system form OLTP or Staging database.
Document – Create Program Code, Unit Test and Peer Review, and other technical documentation
Improve – Support continuous improvement in Data Warehouse solutions and processes.
Leverage – Support client data exchange and integration needs by leveraging technical expertise in database applications, ETL processes, and automation.
Manage – Foundational data administration tasks such as scheduling, troubleshooting, issue identification and backups.
    •Bachelor’s degree in Computer Science, or related discipline

    •Nine (9) years of Information Technology experience

    •Five (5) years of experience in Middleware, Data Warehouse, Data Mart and Data Integration applications

    •Three (3) years experience with data warehousce solution designs supporting data stores such as ODS, EDW and DataMart

    •Three (3) years experienced developing ETL solutions supporting star schema and snowflake designs using Kimball Design Methodogy

    •Five (5) years of  IBM Infosphere DataStage experience.

    •Three (3) years experience creating DataStage parallel and sequence jobs using standards.

    •Strong understanding of OLAP business intelligence applications

    •Strong understanding of reporting and database environments, processes, and associated applications

    •Competencies leveraging data visualization tools for senior management and enterprise data visualization

    •Ability to translate business requirements into specifications that will be used to implement required reports and dashboards

    •Extensive experience writing and tuning complex SQLs, with insight on database indexes and procedures.

    •Minimum of three (3) years experience with Agile Methodology

    •Three (3) years or more experience Unix Shell scripting

    •Experience working in AIX environment

    •Scheduling Tools (i.e.; Autosys) experience

    •Two (2) years Healthcare Industry experience.

 Here are the Bonus Points:
    •Experience with database design/modeling tools (preferably ERWIN), modeling techniques (multidimensional, logical and physical models).

    •Experience with IBM Infosphere DataStage version 11.5.

    •Hands-on experience with data architecture and data analysis skill sets

    •Strong analytical, problem solving and communication skills, including mapping of business need or issue to development of application requirements or procedural initiatives.

    •Strong understanding of reporting and database environments, processes, and associated applications.

    •Well-developed knowledge of operational systems, processes and budgeting/forecasting concepts and activities

    •Proven ability to ensure effective forms of documentation essential for support of overall technical and user needs.

    •Ability to work in complex matrix organization

    •Good written and oral communication skills

Here are the Attributes for Success:
    •Track record in data sourcing platform and file processing automation.

    •Well-developed ability to ensure the integrity of data flow and data availability into a Data Warehouse.

    •Hands on. Passionate. Persistent. Creative. A Doer. A Team Player.

Job Requirements

For Additional information:
Casey Ryan

Login to Apply
User ID: 
Forgot password? 

Other Options
   Apply for this job
  Email this job
   Return to search results

Bookmark and Share

Return to search results | Email this job to a friend

Bookmark and Share
*Logged in members may also add jobs to their job cart