Hylise Johnson

Hylise Johnson

ETL/ DataWarehouse Developer

Desoto, Texas, United States.

About  

Experienced, highly driven, and skilled end to end ETL, SQL and data warehouse developer. Very strong SSIS and SQL skills, creating complex SSIS packages for ETL automation and complex SQL code to design and pull insights from data warehouses. Microsoft Azure Certified with experience in creating, configuring and interfacing with Azure SQL Databases, Azure Blob Storage and deploying SSIS packages in an Azure Virtual Machine environment. Proficient in using SSRS, Python Pandas and Microsoft Power BI Certified. Strong analytical and troubleshooting skills with a passion for problem solving. Great at collaborating in a team environment and fostering relationships with business partners.

Hours Available / Wk - 40 hrs

Watch Video Pitch

Employment History 

  • ETL/ DataWarehouse Developer

    Colaberry Inc.
    April 2017 - Present

    • Developing T-SQL code with the use of Complex Stored Procedures, SQL Window Functions,
    External Tables, Views, Indexes, Joins, Sub Queries, Temporary Tables, Table Variables,
    Merge Statements and CTEs.
    • Extracting data from a large variety of data sources such as Parquet files, XML files, SQL
    Databases, JSON files, Flat files, MS Excel files, and CSV files.
    • Creating complex SSIS packages using various tasks in control flow such as Execute Process
    Tasks in conjunction with Python Scripts, Execute Package Tasks, Script Tasks, XML Tasks,
    FTP Tasks, Azure Blob Download Tasks, File System Tasks, Execute SQL Tasks, Data Flow Tasks,
    Sequence Containers, and creating dynamic variables using Four Loop Containers.
    • Creating complex SSIS packages using various transformations in data flows such as Script Components, Union Alls, Sorts, Look Ups, Slowly Changing Dimensions, OLEDB Commands,
    Derived Columns, Data Conversions, and Conditional Splits.
    • Configuring and scheduling SQL server agent Jobs to automate package execution.
    • Creating, Configuring and Interfacing with Azure SQL Server and Azure SQL Databases.
    • Creating, Configuring and Interfacing with Azure Storage Account.
    • Implementing Logging and Error Handling in Packages.
    • Implementing Slowly Changing Dimension methodologies such as Merge Statements to maintain and update Dimension tables in the Data Warehouse.

Digital Credentials  

Schedule an Interview