Sr Systems Analyst (Snow Flake)

Overview

Hybrid
Depends on Experience
Accepts corp to corp applications
Contract - Independent
Contract - W2
Contract - 11 Month(s)

Skills

managing Informatica IICS/snowflake solutions
E2E implementation experience
testing
Informatica data modeling
workflow
integration capabilities and technologies
APIs
web services
Informatica ETL tools.
Data governance
data quality
data integration principles.
Azure Cloud and Snowflake Cloud Datawarehouse
SQL Queries and Query optimization
technical and non-technical level with Infrastructure
Network
Development
BA and QA
high transaction/high availability systems.
informatica PowerCenter/IICS development experience.
managing reference data systems
Provide technical mentorship to junior ETL developers
Python with data science libraries
SQL programming and writing stored procedures
functions
views
SQL queries
HIPAA regulations
handling protected health information (PHI)
personally identifiable information (PII).
Data warehouse development experience
Experience with Snowflake
designing
optimizing
documenting
implementing and supporting automation for managing Snowflake accounts
databases
access roles.
Snowflake query performance optimizations.
implementing database
Git hub integration with snowflake and load data

Job Details

Hi,

Greetings from DIA SOFTWARE SOLUTIONS LLC!

We reaching out about an exciting Direct client opportunity with one of our clients. Please review the requirements and let me know if you are interested in this position?

Direct client Req:: Need Sr Systems Analyst (Snow Flake) TX , Hybrid

PLEASE SEND THE RESUMES TO SKUMAR AT DIASOFTWARESOLUTIONS DOT COM !

Job Description:

  • Understands business objectives and problems, identifies alternative solutions, performs studies and cost/benefit analysis of alternatives. Analyzes user requirements, procedures, and problems to automate processing or to improve existing computer system: Confers with personnel of organizational units involved to analyze current operational procedures, identify problems, and learn specific input and output requirements, such as forms of data input, how data is to be; summarized, and formats for reports. Writes detailed description of user needs, program functions, and steps required to develop or modify computer program. Reviews computer system capabilities, specifications, and scheduling limitations to determine if requested program or program change is possible within existing system.

Additional job details and special considerations

  • We are seeking a highly experienced and motivated individual who specializes in Informatica Cloud Services (IICS). The ideal candidate will have deep technical expertise in multi-domain environments, enabling them to lead and deliver complex IICS implementations for our clients. This role requires a strong understanding of the Informatica toolset, including IICS and relevant business processes, along with excellent communication and client management skills.

SKILLS MATRIX

Minimum Requirements: Candidates that do not meet or exceed the minimum stated requirements (skills/experience) will be displayed to customers but may not be chosen for this opportunity.

Actual
Years
Experience

Years
Experience
Needed

Required/
Preferred

Skills/Experience

8

Required

Extensive experience in designing, implementing, and managing Informatica IICS/snowflake solutions.

8

Required

E2E implementation experience involving phases from design, realization, testing, to go-live

8

Required

Deep understanding of Informatica data modeling, workflow, and integration capabilities and technologies, APIs, web services, and Informatica ETL tools.

8

Required

Strong knowledge of data governance, data quality, and data integration principles.

8

Required

Expertise in Azure Cloud and Snowflake Cloud Datawarehouse

8

Required

Strong knowledge in SQL Queries and Query optimization

8

Required

Ability to interact at a technical and non-technical level with Infrastructure, Network, Development, BA and QA

8

Required

Development experience in high transaction/high availability systems.

8

Required

Experience with analyzing and recommending solutions for Production issues short-term and long term.

8

Required

Must have informatica PowerCenter/IICS development experience.

8

Required

Knowledge and experience of managing reference data systems

8

Required

Provide technical mentorship to junior ETL developers; establish coding standards, templates, and best practices.

8

Required

Experience in Python with data science libraries

8

Required

Experience in SQL programming and writing stored procedures, functions, views, SQL queries

8

Required

Experience working with HIPAA regulations and handling protected health information (PHI) and personally identifiable information (PII).

8

Required

Strong organizational and time management skills.

8

Preferred

Data warehouse development experience

8

Preferred

Experience with Snowflake

4

Preferred

Experience in designing, optimizing, documenting, and implementing the operational aspects that support the Snowflake cloud data platform, including cost monitoring, optimizations, and user security auditing.

4

Preferred

Experience in implementing and supporting automation for managing Snowflake accounts, databases, and access roles.

4

Preferred

Experience and understanding in proposing and implementing database and Snowflake query performance optimizations.

4

Preferred

Experience with Git hub integration with snowflake and load data.

DIA SOFTWARE SOLUTIONS LLC.

Austin, TX 78727| Direct:

DIA SOFTWARE SOLUTIONS is an Affirmative Action/Equal Opportunity Employer that supports workplace diversity. All employment decisions are made without regard to race, color, religion, sex, national origin, age, disability, veteran status, marital or family status, sexual orientation, gender identity, or genetic information. All Diasoft staff must be able to demonstrate the legal right to work in the United States. DIA SOFTWARE SOLUTIONS is an E-Verify employer

Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.

About Dia Software Solutions