ETL Informatica Developer

Overview

On Site
Depends on Experience
Contract - W2
Contract - 12 Month(s)
No Travel Required

Skills

Auditing
Business Analysis
Business Analytics
Business Process
Customer Relationship Management (CRM)
Cloud Computing
Communication
Cost-benefit Analysis
Data Governance
Data Integration
Data Modeling
Data Quality
Data Science
Data Warehouse
Database
Extract
Transform
Load
Forms
Git
HIPAA
High Availability
Informatica
Informatica PowerCenter
Management
Mentorship
Microsoft Azure
Network
Python
Reference Data
SQL
Scheduling
Snow Flake Schema
Stored Procedures
Testing
Web Services
Workflow
Writing

Job Details

Job Tittle: ETL Informatica Developer (IICS/ Snowflake must have)

Job Location: Dallas, TX

Duration: 12+ Months

10+ and W2 Only

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.

CANDIDATE SKILLS AND QUALIFICATIONS

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

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

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

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

Expertise in Azure Cloud and Snowflake Cloud Datawarehouse

Strong knowledge in SQL Queries and Query optimization

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

Development experience in high transaction/high availability systems.

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

Must have informatica PowerCenter/IICS development experience.

Knowledge and experience of managing reference data systems

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

Experience in Python with data science libraries

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

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

Strong organizational and time management skills.

Data warehouse development experience

Experience with Snowflake

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.

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

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

Experience with Git hub integration with snowflake and load data.

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.