Randstad Data Integration Developer in Rolling Meadows, Illinois

Data Integration Developer

job details:

  • location:Rolling Meadows, IL

  • salary:$50 - $60 per hour

  • date posted:Wednesday, November 28, 2018

  • job type:Temp to Perm

  • industry:Professional, Scientific, and Technical Services

  • reference:658465

job description

Data Integration Developer

job summary:

Senior Data Integration Developer

  • Collaborate with internal customers, prospects and stakeholders, understand and translates business use cases and/or requirements into data analysis and data mapping and consequently data integration routines which involves moving, cleansing and transforming large amount of data between multiple systems.

  • Identifies data sources, provides data flow diagrams and documents source to target mapping and process.

  • Collaborate with the Data Architect to recommend optimal data models for data ingestion and BI developer for analytic reports

  • Facilitate the development of data integration efforts by leading small teams of 1-2 junior developers in addition to hands on design and development of large complex ETL jobs.

  • Design, implement and maintain database objects (tables, views, indexes, etc.) and database security.

  • Validate data integration routines by developing and executing test plans and scenarios including data design, tool design, data extract/transform, networks, and hardware.

  • Maintain the data warehouse performance by optimizing batch processing through parallelization, performance tuning etc.

  • Establish methods and procedures for tracking data quality, completeness, redundancy and improvement.

  • Work with the Data Architect to establish processes for governing the identification, collection and use of corporate metadata to assure metadata is accurate and valid in the business intelligence environments.

  • Ensure data quality through creation of audit controls, proactive monitoring and data cleansing techniques

Requirements:

  • 7+ years of experience in Data Warehousing and Business Intelligence (experience in a MPP considered a plus).

  • Must have worked in a multi-terabyte environment

  • 5+ Years in BI development leveraging the Microsoft SQLServer or PDW/ASP data environments.

  • 5+ years in SSIS and use of Stored Procedures.

  • 6 months to 1 Year experience in Azure Data Ware house, Azure Data Factory, SQL VMs

  • Strong understanding data modeling (i.e. conceptual, logical and physical model design, experience with Operation Data Stores, Enterprise Data warehouses and Data Marts).

  • Deep understanding of relational database design concepts and SQL programming

  • Experience guiding/mentoring developers with lesser experience.

  • Requires strong analytical, conceptual and problem-solving abilities .

  • Strong experience with business intelligence and data warehousing design principles and industry best practices.

  • Bachelor's degree - preference in computer/information sciences or business/commerce.

Work Traits:

  • Strong communications skills - oral and written

  • Self-starter with strong work ethic

  • Flexible and resilient, handle various demands planned and unplanned

  • Proven ability to handle multiple tasks and projects simultaneously.

  • Problem solver and desire to close issues, pragmatic and realistic with solutions

  • Professional demeanor, working with senior level managers and vendors

  • Ability to work independently under minimal supervision and meet deadlines.

  • Strong sense of accountability, adaptability, flexibility and a sense of urgency.

  • Demonstrated ability to establish priorities, organize and plan work to satisfy established timeframes.

  • Passionate about continuously improving organizational practices.

  • Ability to learn and apply new technologies quickly and self-directed.

  • Ability to prioritize and multi-task across numerous work streams

location: Rolling Meadows, Illinois

job type: Contract

salary: $50 - 60 per hour

work hours: 9am to 5pm

education: Bachelors

responsibilities:

Senior Data Integration Developer

  • Collaborate with internal customers, prospects and stakeholders, understand and translates business use cases and/or requirements into data analysis and data mapping and consequently data integration routines which involves moving, cleansing and transforming large amount of data between multiple systems.

  • Identifies data sources, provides data flow diagrams and documents source to target mapping and process.

  • Collaborate with the Data Architect to recommend optimal data models for data ingestion and BI developer for analytic reports

  • Facilitate the development of data integration efforts by leading small teams of 1-2 junior developers in addition to hands on design and development of large complex ETL jobs.

  • Design, implement and maintain database objects (tables, views, indexes, etc.) and database security.

  • Validate data integration routines by developing and executing test plans and scenarios including data design, tool design, data extract/transform, networks, and hardware.

  • Maintain the data warehouse performance by optimizing batch processing through parallelization, performance tuning etc.

  • Establish methods and procedures for tracking data quality, completeness, redundancy and improvement.

  • Work with the Data Architect to establish processes for governing the identification, collection and use of corporate metadata to assure metadata is accurate and valid in the business intelligence environments.

  • Ensure data quality through creation of audit controls, proactive monitoring and data cleansing techniques

Requirements:

  • 7+ years of experience in Data Warehousing and Business Intelligence (experience in a MPP considered a plus).

  • Must have worked in a multi-terabyte environment

  • 5+ Years in BI development leveraging the Microsoft SQLServer or PDW/ASP data environments.

  • 5+ years in SSIS and use of Stored Procedures.

  • 6 months to 1 Year experience in Azure Data Ware house, Azure Data Factory, SQL VMs

  • Strong understanding data modeling (i.e. conceptual, logical and physical model design, experience with Operation Data Stores, Enterprise Data warehouses and Data Marts).

  • Deep understanding of relational database design concepts and SQL programming

  • Experience guiding/mentoring developers with lesser experience.

  • Requires strong analytical, conceptual and problem-solving abilities .

  • Strong experience with business intelligence and data warehousing design principles and industry best practices.

  • Bachelor's degree - preference in computer/information sciences or business/commerce.

Work Traits:

  • Strong communications skills - oral and written

  • Self-starter with strong work ethic

  • Flexible and resilient, handle various demands planned and unplanned

  • Proven ability to handle multiple tasks and projects simultaneously.

  • Problem solver and desire to close issues, pragmatic and realistic with solutions

  • Professional demeanor, working with senior level managers and vendors

  • Ability to work independently under minimal supervision and meet deadlines.

  • Strong sense of accountability, adaptability, flexibility and a sense of urgency.

  • Demonstrated ability to establish priorities, organize and plan work to satisfy established timeframes.

  • Passionate about continuously improving organizational practices.

  • Ability to learn and apply new technologies quickly and self-directed.

  • Ability to prioritize and multi-task across numerous work streams

qualifications:

Senior Data Integration Developer

  • Collaborate with internal customers, prospects and stakeholders, understand and translates business use cases and/or requirements into data analysis and data mapping and consequently data integration routines which involves moving, cleansing and transforming large amount of data between multiple systems.

  • Identifies data sources, provides data flow diagrams and documents source to target mapping and process.

  • Collaborate with the Data Architect to recommend optimal data models for data ingestion and BI developer for analytic reports

  • Facilitate the development of data integration efforts by leading small teams of 1-2 junior developers in addition to hands on design and development of large complex ETL jobs.

  • Design, implement and maintain database objects (tables, views, indexes, etc.) and database security.

  • Validate data integration routines by developing and executing test plans and scenarios including data design, tool design, data extract/transform, networks, and hardware.

  • Maintain the data warehouse performance by optimizing batch processing through parallelization, performance tuning etc.

  • Establish methods and procedures for tracking data quality, completeness, redundancy and improvement.

  • Work with the Data Architect to establish processes for governing the identification, collection and use of corporate metadata to assure metadata is accurate and valid in the business intelligence environments.

  • Ensure data quality through creation of audit controls, proactive monitoring and data cleansing techniques

Requirements:

  • 7+ years of experience in Data Warehousing and Business Intelligence (experience in a MPP considered a plus).

  • Must have worked in a multi-terabyte environment

  • 5+ Years in BI development leveraging the Microsoft SQLServer or PDW/ASP data environments.

  • 5+ years in SSIS and use of Stored Procedures.

  • 6 months to 1 Year experience in Azure Data Ware house, Azure Data Factory, SQL VMs

  • Strong understanding data modeling (i.e. conceptual, logical and physical model design, experience with Operation Data Stores, Enterprise Data warehouses and Data Marts).

  • Deep understanding of relational database design concepts and SQL programming

  • Experience guiding/mentoring developers with lesser experience.

  • Requires strong analytical, conceptual and problem-solving abilities .

  • Strong experience with business intelligence and data warehousing design principles and industry best practices.

  • Bachelor's degree - preference in computer/information sciences or business/commerce.

Work Traits:

  • Strong communications skills - oral and written

  • Self-starter with strong work ethic

  • Flexible and resilient, handle various demands planned and unplanned

  • Proven ability to handle multiple tasks and projects simultaneously.

  • Problem solver and desire to close issues, pragmatic and realistic with solutions

  • Professional demeanor, working with senior level managers and vendors

  • Ability to work independently under minimal supervision and meet deadlines.

  • Strong sense of accountability, adaptability, flexibility and a sense of urgency.

  • Demonstrated ability to establish priorities, organize and plan work to satisfy established timeframes.

  • Passionate about continuously improving organizational practices.

  • Ability to learn and apply new technologies quickly and self-directed.

  • Ability to prioritize and multi-task across numerous work streams

skills: Senior Data Integration Developer

  • Collaborate with internal customers, prospects and stakeholders, understand and translates business use cases and/or requirements into data analysis and data mapping and consequently data integration routines which involves moving, cleansing and transforming large amount of data between multiple systems.

  • Identifies data sources, provides data flow diagrams and documents source to target mapping and process.

  • Collaborate with the Data Architect to recommend optimal data models for data ingestion and BI developer for analytic reports

  • Facilitate the development of data integration efforts by leading small teams of 1-2 junior developers in addition to hands on design and development of large complex ETL jobs.

  • Design, implement and maintain database objects (tables, views, indexes, etc.) and database security.

  • Validate data integration routines by developing and executing test plans and scenarios including data design, tool design, data extract/transform, networks, and hardware.

  • Maintain the data warehouse performance by optimizing batch processing through parallelization, performance tuning etc.

  • Establish methods and procedures for tracking data quality, completeness, redundancy and improvement.

  • Work with the Data Architect to establish processes for governing the identification, collection and use of corporate metadata to assure metadata is accurate and valid in the business intelligence environments.

  • Ensure data quality through creation of audit controls, proactive monitoring and data cleansing techniques

Requirements:

  • 7+ years of experience in Data Warehousing and Business Intelligence (experience in a MPP considered a plus).

  • Must have worked in a multi-terabyte environment

  • 5+ Years in BI development leveraging the Microsoft SQLServer or PDW/ASP data environments.

  • 5+ years in SSIS and use of Stored Procedures.

  • 6 months to 1 Year experience in Azure Data Ware house, Azure Data Factory, SQL VMs

  • Strong understanding data modeling (i.e. conceptual, logical and physical model design, experience with Operation Data Stores, Enterprise Data warehouses and Data Marts).

  • Deep understanding of relational database design concepts and SQL programming

  • Experience guiding/mentoring developers with lesser experience.

  • Requires strong analytical, conceptual and problem-solving abilities .

  • Strong experience with business intelligence and data warehousing design principles and industry best practices.

  • Bachelor's degree - preference in computer/information sciences or business/commerce.

Work Traits:

  • Strong communications skills - oral and written

  • Self-starter with strong work ethic

  • Flexible and resilient, handle various demands planned and unplanned

  • Proven ability to handle multiple tasks and projects simultaneously.

  • Problem solver and desire to close issues, pragmatic and realistic with solutions

  • Professional demeanor, working with senior level managers and vendors

  • Ability to work independently under minimal supervision and meet deadlines.

  • Strong sense of accountability, adaptability, flexibility and a sense of urgency.

  • Demonstrated ability to establish priorities, organize and plan work to satisfy established timeframes.

  • Passionate about continuously improving organizational practices.

  • Ability to learn and apply new technologies quickly and self-directed.

  • Ability to prioritize and multi-task across numerous work streams

Equal Opportunity Employer: Race, Color, Religion, Sex, Sexual Orientation, Gender Identity, National Origin, Age, Genetic Information, Disability, Protected Veteran Status, or any other legally protected group status.