Ampcus Inc
Technical Lead
This job is now closed
Job Description
- Req#: 25-23204
- Design, develop, and maintain robust ETL pipelines using Informatica PowerCenter, DBT (Data Build Tool), and Snowflake.
- Implement data integration strategies for Data Vault architecture and Snowflake database environments.
- Perform data extraction, transformation, and loading (ETL) from DB2 and Snowflake sources.
- Write and optimize complex SQL queries for high-performance data processing and transformation.
- Translate business requirements into technical specifications through close collaboration with stakeholders in the insurance domain.
- Participate actively in the SAFe Agile framework including sprint planning, daily stand-ups, reviews, and retrospectives.
- Manage tasks, user stories, and workflows using Rally (Agile Central).
- ETL Development: Expert in developing Informatica mappings and workflows.
- DBT & Snowflake: Strong hands-on experience with DBT for SQL-based transformations within the Snowflake ecosystem.
- SQL: Advanced SQL skills for querying, data modeling, and performance tuning.
- Legacy Migration: Lead efforts to convert legacy ETL processes from Informatica to DBT.
- Data Warehousing: Proficient in Snowflake as the central data warehouse solution.
- Agile Methodologies: Experienced with SAFe Agile practices and tools like Rally for project tracking.
- Insurance Domain: In-depth understanding of insurance business processes and data requirements.
- ETL Tools: Informatica PowerCenter, DBT.
- Databases: Snowflake, DB2.
- Languages: SQL.
- Project Management: Rally (Agile Central).
- Frameworks : SAFe Agile.
Ampcus Inc. is a certified global provider of a broad range of Technology and Business consulting services. We are in search of a highly motivated candidate to join our talented Team.
Job Title: Technical Lead
Location(s): Woodland Hills, CA
(Hybrid 3 days a week)
Key Responsibilities:Ampcus is an Equal Opportunity Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, age, protected veterans or individuals with disabilities.
About the company
Ampcus Inc. is an ISO 20000, ISO 27000, ISO 9001, CMMI DEV/3 SM, and CMMI SVC/3 SM certified global provider of a broad range of Technology and Business consulting services. From strategy to execution, our disciplined yet flexible approach starts and ends with our clients. By listening hard and working harder, client goals become our goals.
Notice
Talentify is an Equal Opportunity Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability, or protected veteran status.
Talentify provides reasonable accommodations to qualified applicants with disabilities, including disabled veterans. Request assistance at accessibility@talentify.io or 407-000-0000.
Federal law requires every new hire to complete Form I-9 and present proof of identity and U.S. work eligibility.
An Automated Employment Decision Tool (AEDT) will score your job-related skills and responses. Bias-audit & data-use details: www.talentify.io/bias-audit-report. NYC applicants may request an alternative process or accommodation at aedt@talentify.io or 407-000-0000.