Report this job

---

What is the problem? *

Incorrect company
Incorrect location
Job is expired
Job may be a scam
Other

Job Title: Snowflake & IICS Technical Lead

Location: Chattanooga, (Remote)

Full-Time

Job Description:

MUST HAVE:

1. Need a strong lead resource with overall 14+ years of experience Have hands on Snowflake for minimum 2 years and should have used IICS cloud for implementation (minimum 4 years)
2. Preferred to have Snowflake certified resources
3. Played a key role in Snowflake migration implementation - Extract data from legacy applications and load into Snowflake by using Informatica Cloud (IICS) as ETL tool

Technical/Functional Skills:

1. Customer is seeking a experienced Snowflake IICS Technical Lead with a strong sense of Technical skills to lead the team for implementing a major Snowflake migration program for Regulatory work
2. Have hands on Snowflake for minimum 2 years and should have used IICS cloud for implementation (minimum 4 years)
3. Experience in developing ETL using Informatica technologies like IICS.
4. Experience in Snowflake - Data Model, Stored Procedure, and Advanced functions.
5. Technical experience in Informatica Intelligent Cloud Services (IICS).
6. Experience with Enterprise level Data Warehousing
7. Experience in Data Modeling.
8. Strong hands-on in SQL/PLSQL with related analytical skills.
9. Experience in the Migration of Data warehouse from on-premises to the cloud (Snowflake preferred).
10. Experience in designing technical solutions and demonstrate to end-users.

Preferred to have Snowflake certified resources

Roles & Responsibilities:

• Domain expertise Healthcare experience
• Design, develop and maintain Informatica cloud data integration processes using the appropriate data load technique, including performance optimization. Assesses the compatibility, Analyzes cost effectiveness and feasibility
• Analyzes the impact of changes on existing ETL/ELT processes and systems
• Debug and tune data integration processes; analyze data warehouse architecture
• Design, develop and maintain Snowflake database objects (tables, views, stored procedures, etc.) and SQL scripts
• Participate in code reviews and ensure that all solutions are aligned to pre-defined architectural and requirement specifications
• Provide L2 and L3 support of ETL/ELT processes to ensure timely completion and availability of data in data warehouse for reporting use. Analyzes and resolves problems and provides technical assistance as is necessary. Implements corrective actions
• Participate in the fulfillment of ad-hoc data requests from business owners
• Participate in design reviews and provide input to the design recommendations; provide input to information/data flow, understand, and comply with Project Life Cycle Methodology in all planning steps