Job Details

Email to Friend Save Back

ETL Developer - Consultant

DALLAS-75206, TX, US
06/01/2019

-

Required Skills

SQL programming

Company

Infinity Consulting Solutions, Inc

Experience

5 to 7 Year(s)

Job Description

ETL DEVELOPER - CONSULTANT

North Dallas/Addison, TX

6+ month contract

We are hiring 2 ETL Developers for a 6+ month contract with the potential to eventually convert.

The ETL Developer will be responsible for developing and architecting ETL solutions within our Client's data intake team.

The ETL Developers must be experienced with applying all aspects of ETL architecture development to the workflows they develop including leveraging shared libraries, working with multiple data sources, applying data-driven transformations, using correct audit and control techniques to appropriately capture meta-data, implementing start/restart functionality and appropriately designing routines to auto-correct and self-manage.

What You'll Do:

Develop, deploy, maintain and debug SSIS packages.

Work with Business Analysts to aid in the design of the system.

Investigate and resolve problems of data accuracy and availability

Participate in integral testing to identify problems early.

Perform error and stress scenarios.

Participate in design and code reviews.

Identify architectural issues and propose alternative solutions.

Develop functional specifications for data acquisition, transformation and load processes.

Ensure data integration/ETL is implemented & monitored successfully to enable data quality, and on time availability.

Analyzes current business practices, processes and procedures as well as identifying
future business opportunities for leveraging SSIS or Microsoft Azure Data & Analytics PaaS Services.

Support the planning and implementation of data design services, providing sizing and configuration assistance and performing needs assessments.

Implement effective metrics and monitoring processes.

Skills/Experience You'll Need:

5+ years of relevant experience in developing and maintaining ETL routines in SSIS, Azure Data Factory or Azure Databricks.

Working knowledge of cloud-based technology and leveraging shared services in the cloud in lieu of on-prem or "lift and shift” modesl.

Excellent documentation skills when it comes to developing ETL code, workflows and transformations as well as supporting documentation on the maintenance and use.

Excellent knowledge in sources and ETL products like (SSIS, and Azure Data Factory).

Experience in business processing mapping of data and analytics solutions.

Ability to conduct data profiling, cataloging, and mapping for technical design and construction of technical data flows.

Knowledge of Azure Data Factory, Azure Data Lake, Azure SQL DW, and Azure SQL, Azure App Service is preferred.

Knowledge of Master Data Management (MDM) and Data Quality tools and processes is preferred

SQL programming, server integration, and reporting

Curiosity and passion about data, visualization and solving problems

Creativity to determine the best solution for a real-world problem with quantitative data

Experience with reporting, descriptive statistics, probability, and cleaning big datasets