Careers at HiLabs

Be a part of a team that harnesses advanced AI, ML, and big data technologies to develop innovative, cutting-edge healthcare technology platform.
Job Title: ETL Architect/Sr. ETL Developer
Job Location: Onsite - Bethesda, Maryland (US)
Job summary:

We are looking for senior ETL developer/Architect to build end to end business data warehousing solutions, troubleshoot and resolve support issues. The ideal candidate must possess an excellent background in Teradata development with production support experience. This position requires leading an ETL team, create functional requirements and technical specifications as well as design, develop, test, document, implement, manage, and maintain solutions, utilizing technologies like Teradata, Informatica, SQL Server, Snowflakes, etc. The candidate must possess excellent written and verbal communication skills with the ability to collaborate effectively with domain and technical experts in the team.



Responsibilities:
    • Analyze complex business requirements, functional specifications, design and write technical specifications for design and development
    • Design develop detailed ETL specifications based on business requirements
    • Assist in designing potential technical solutions, implement highly efficient highly scalable ETL processes
    • Understand Data Models Conceptual Logical and Physical Dimensional Relational Data Model
    • Identifies data sources and works with source system team and data analyst to define data extraction methodologies
    • Act as a lead in providing application design guidance and consultation, utilizing a thorough understanding of applicable technology, tools, and existing designs.
    • Provide coding direction to less experienced staff or develop highly complex original code
    • Act as an expert technical resource for modelling, simulation, and analysis efforts
    • Loading data from various data sources and legacy systems into Teradata production and development using Teradata in-built utilities
    • Interact with stakeholders, users for requirement clarification, design, and development of ETL Process
    • Lead one or more simultaneous Data Warehouse projects for BI and data warehousing initiatives
    • Work along with ETL/Data Analysts and EDW Architects in designing/enhancing ETL architecture
    • Perform hands on development and mappings using Informatica Power center
    • Responsibilities include full lifecycle project management, solution design, and overall ETL design and development


Desired Profile:
    • BE / B. Tech / ME / M. Tech in CS or other branches of engineering
    • Experience in ETL application development and implementation experience using Teradata, Snowflakes and Informatica and/or other tools
    • Strong knowledge in different data base technologies like Oracle, SQL server
    • Teradata Development with Production support experience preferred.
    • Hands on experience in Teradata, strong knowledge in writing SQLs, working with BTEQ, MLOAD and FLOAD
    • Proficient in ETL Informatica, Defines develops documents and maintains Informatica ETL mappings
    • Thorough understanding of DWH and BI Dashboard Reporting concepts
    • Experience in the Healthcare Domain will be an added advantage
    • Strong working experience in Oracle, PL/SQL, BTEQ, Unix shell scripting, workload analysis and management, security implementation, performance monitoring & management
    • Must be an expert in script development using BTEQ
    • Must have experience in shell scripting
    • Must have experience in performance tuning, query optimization
    • Must have experience in building data warehouse and/or DataMart
    • Must have experience with database design, data modelling, dimension modelling concepts, ETL, data development, data integration, data distribution, data quality and analytics
    • Should have worked in Agile development and scrum methodology
    • Should have experience in Onshore offshore coordination
    • Should have worked with job scheduling tool - Control M
    • Experience in converting specifications to programs and data mapping in an ETL Informatica environment
    • Provide High Level and Low-Level Architecture Solution/Design to the project
    • Strong expertise with PL/SQL and T-SQL, Experience writing complex SQL statements and analyzing SQL Tuning/performance is a must
    • Excellent communication and interpersonal skills, and Excellent teamwork.
    • Outstanding analytical skills, and Excellent troubleshooting skills
    • Candidate must be able to work under minimal supervision, must be a self-starter and lead aspects of project work as needed
    • Good to have Abintio, Erwin, and DataStage experience


Company Profile

HiLabs Inc. is focused on eliminating the $3.1T that bad data costs the United States every year. HiLabs is combining cutting-edge, explainable AI with healthcare-specific business ontologies to vastly improve data quality for its customers. This unique and valuable approach has earned HiLabs business with the Centers for Medicare & Medicaid Services (CMS) and three of the five largest US health plans. HiLabs approach has also led to rapid 300% year over year revenue growth. HiLabs core platform, MCheck has performed analysis on over 15 billion records, covering over one-third of the US insured population. HiLabs is headquartered in the Washington, DC Metropolitan Area with a thriving R&D center in Pune, India. HiLabs India Private Limited is a subsidiary of HiLabs Inc. HiLabs team includes healthcare experts with decades of experience, technologists, data scientists, AI/ML engineers, and solutions architects from the world's top universities, business schools, and engineering institutes such as Yale, Harvard, Duke, Georgia Tech, and several IITs.

Why join us

Besides our competitive salary and benefits package, attractive performance bonuses, and Employee Stock Options Plan, there are myriad reasons why you should work with us.

Hilabs Benefits

Competitive base salary, attractive performance bonus/accelerator incentive policies, comprehensive benefits package that includes employee stock options and financial contribution for your ongoing professional and personal development medical coverage for you and your loved ones, 401k, PTOs, smart mentorship, and an excellent collaborative environment of highly qualified, multidisciplinary professionals from the world's top medical schools, business schools, and engineering institutes

India Benefits:
  • Mediclaim and accidental insurance
  • Trainings and workshops to support continuous learning
  • Considerate leave policy and paid holidays to help achieve a better work-life

US Benefits:
  • 401K Plan
  • Medical benefits
  • Paid Time Off to help achieve a better work-life balance
Thank you for reviewing this opportunity with HiLabs! If this position appears to be a good fit for your skillset, we welcome your application.