Data Warehouse Consultant - Charlotte, United States - Incubation Systems Private Limited

    Default job background
    Contract
    Description

    • Bachelor's Degree in Computer Science, Information Systems or similar
    • 10 to 15 years of Data Warehousing and Data Modeling experience.
    • Strong understanding of Normalized/Dimensional model disciplines and similar data warehousing techniques.
    • Strong experience working with ETL/ELT concepts of data integration, consolidation, enrichment, and aggregation in large volume data sets.
    • Expert in SQL and/or SQL-based languages and performance tuning of SQL queries.
    • Working knowledge of Data Pipelines, stream processing and highly scalable 'big data' data stores.
    • Experience with various data storage technologies - e.g. RDBMS (Oracle, SQL Server, etc.), columnar, tabular, document store, NoSQL
    • Experience with various ETL/ ETL tools – e.g. ODI, SSIS, Informatica Power Center, Talend, IICS, etc.
    • Experience with cloud-based data warehouses - e.g. Snowflake, BigQuery, Azure Synapse, RedShift, etc
    • Create supporting documentation, such as metadata and diagrams of entity relationships, business processes, and process flow.
    • Collaborate with business users on normalizing and aggregating large data sets based on business needs and requirements.
    • Data validation skills to verify data integrity, understand discrepancies, and resolve them with the highest sense of urgency.
    • Demonstrated ability to share findings with non-technical or business stakeholders.
    • Familiarity with Analytical/Reporting Solutions like Tableau, Power BI is a plus
    • Virtual team collaboration tools such as WebEx, Zoom etc.
    • Excellent written, verbal communication and Interpersonal skills
    • Excellent problem solving skills

    Job Type:
    Contract


    Pay:
    $ $65.00 per hour


    Schedule:

    • 8 hour shift

    Ability to Relocate:

    • Charlotte, NC: Relocate before starting work (Required)

    Work Location:
    In person