Technical Lead (ETL, SSIS, SQL)

Full Time

    Job Description

    HTC Global Services wants you. Come build new things with us and advance your career. At HTC Global you'll collaborate with experts. You'll join successful teams contributing to our clients' success. You'll work side by side with our clients and have long-term opportunities to advance your career with the latest emerging technologies.

    At HTC Global Services our consultants have access to a comprehensive benefits package. Benefits can include Paid-Time-Off, Paid Holidays, 401K matching, Life and Accidental Death Insurance, Short & Long Term Disability Insurance, and a variety of other perks.

    Job Requirements:

    • 7+ years work experience developing high-performing data systems, adhering to established best-practices.
    • Strong SQL development skills, creating complex queries, views, and stored procedures.
    • Solid understanding of SQL best practices
    • Experience interfacing with business stakeholders to understand data and analytics needs and deliver solutions.
    • Experience with ETL tools such as SSIS, Azure Data Factory and more
    • Experience in a variety of data technologies such as SQL Server, DB2, MongoDB
    • Strong experience with relational data structures, theories, principles, and practices
    • Experience in Agile Scrum and / or Kanban project management frameworks
    • Experience in creating data specifications, data catalogs, and process flow diagrams.
    • Good knowledge of applicable data privacy practices and laws
    • Experience developing REST or SOAP services preferred
    • Experience developing data solution in cloud infrastructures; Azure preferred.
    • Experience working with Power BI is a plus
    • Experience working in a Dev-ops or Data-ops environment a big plus.
    • Hired candidate will serve as a Technical lead and mentor and help other team members.
    • Very strong Life Insurance background is required and expereince with SQL/SSIS is also required.

    Primary Skills:

    • Data warehousing Technical Lead, Design/ Architect (ETL/ Data), Data Modelling, Data Analysis
    • Development Tool Exposure: ETL (SSIS, Azure Data Factory, Informatica, DataStage, BODI)Reporting (OBIEE, BOXI, QlikView, Tableau, Power BI)
    • Databases: Oracle, SQL Server, Vertica
    • Programming Languages: PL/SQL (Oracle Programming), TSQL (SQL Server Programming)
    • Operating Systems: DOS, Windows, Unix
    • Domain Exposure Life Insurance, General Insurance, Pharmaceuticals, Wealth Management
    • Configuration Management: VSS, SVN, GIT
    • Documentation: MS Excel, MS PPT, MS Word