Snowflake DBT Lead Developer

$67,000 - $93,800/Yr

Infosys - Hartford, CT

Full-time - Mid Level

Hartford, CT

10,001+ employees

Professional, Scientific, and Technical Services

About the position

Infosys is seeking a Snowflake DBT Lead Developer to design and implement scalable ETL processes while ensuring high customer satisfaction. The role involves interfacing with clients, validating architecture, conducting code reviews, and leading teams to develop optimized code deliverables. This position is crucial for contributing to clients' digital transformation journeys.

Responsibilities

• Design and implement highly distributed, scalable, and performant ETL processes.
• Interface with clients for quality assurance and issue resolution.
• Understand requirements and create/review designs.
• Validate architecture and ensure high service levels to clients.
• Participate in project estimation and provide inputs for solution delivery.
• Conduct technical risk planning and perform code reviews.
• Lead and guide teams towards developing optimized high-quality code deliverables.
• Manage continual knowledge management and adherence to organizational guidelines.

Requirements

• Bachelor's degree or foreign equivalent from an accredited institution.
• At least 4 years of experience in Information Technology.
• At least 4 years of experience in DBT Development using Snowflake.
• At least 4 years of experience in Azure Data Factory, Azure Blob storage, and ADLS.
• Expertise in creating end-to-end data pipelines including ingestion, extraction, transformation, loading, and validation.
• In-depth knowledge of Unix Shell scripting and SQL.

Nice-to-haves

• Basics of Healthcare domain to understand business requirements.
• Experience with Lean / Agile development methodologies.
• Hands-on experience in implementing Google Cloud Services.
• Experience in Analysis, Design, Development, Implementation, Testing, and Support of Data Warehousing and Data Integration Solutions.

Benefits

• Medical/Dental/Vision/Life Insurance
• Long-term/Short-term Disability
• Health and Dependent Care Reimbursement Accounts
• Insurance (Accident, Critical Illness, Hospital Indemnity, Legal)
• 401(k) plan and contributions dependent on salary level
• Paid holidays plus Paid Time Off