Snowflake DBT Lead Developer

$67,000 - $93,800/Yr

Infosys - Hartford, CT

Full-time - Mid Level

Hartford, CT

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 through quality assurance and issue resolution. The role involves interfacing with clients, understanding requirements, validating architecture, and leading teams in developing optimized code deliverables. The 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 transfer and adherence to organizational guidelines.

Requirements

• Bachelor's degree or foreign equivalent required 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
• 401(k) plan and contributions dependent on salary level
• Paid holidays
• Paid Time Off