Informatica IICS/PowerCenter Engineer( Snowflake & ETL) Job at Dutech Systems, inc, Austin, TX

aS9ldUwyOFFzSTZnYXRaWmxRSjk5YUZ0aXc9PQ==
  • Dutech Systems, inc
  • Austin, TX

Job Description

Skills:

Informatica PowerCenter, Informatica IICS, Snowflake, ETL Development, SQL, Data Warehousing, Data Modeling, Tableau, Oracle, SQL Server, Python, Data Integration, GitHub Actions, CI/CD, MuleSoft, REST APIs, Java, JavaScript, Agile, JIRA, Healthcare Data, PII/PHI, Business Intelligence, Technical Documentation.

We are seeking an experienced Senior Data Engineer to join our team. The ideal candidate will have extensive experience in Informatica PowerCenter/IICS, Snowflake, ETL development, data warehousing, and data integration. This role involves designing, developing, and optimizing data pipelines, supporting business intelligence initiatives, and collaborating with cross-functional teams to deliver scalable data solutions.

Key Responsibilities

  • Design, develop, and maintain ETL workflows and mappings using Informatica PowerCenter and IICS.
  • Acquire, integrate, and transform data from multiple sources including Oracle, SQL Server, Excel, Access, and PDF files.
  • Develop and optimize complex Snowflake SQL scripts, views, and data models.
  • Support Tableau and business intelligence reporting initiatives through efficient data integration.
  • Collaborate with architects, analysts, and stakeholders to design scalable data solutions.
  • Perform data validation, testing, and quality assurance activities.
  • Create and maintain technical documentation, data mappings, and process diagrams.
  • Participate in Agile sprint planning, standups, reviews, and retrospectives.
  • Develop automation solutions to improve data processing efficiency and reliability.
  • Assist with troubleshooting, performance tuning, and production support activities.
  • Ensure compliance with data security, privacy, and governance standards.

Required Qualifications

  • 8+ years of experience with Informatica PowerCenter and/or Informatica Intelligent Cloud Services (IICS).
  • 8+ years of experience in ETL development and data integration projects.
  • 8+ years of experience with Snowflake and advanced SQL development.
  • Strong experience with data warehousing and dimensional data modeling.
  • Experience integrating data from Oracle, SQL Server, Excel, Access, and PDF sources.
  • Strong analytical, problem-solving, and system analysis skills.
  • Experience creating technical documentation, process flows, and data models.
  • Ability to deliver scalable software and data platforms across enterprise environments.
  • Experience following software development best practices and coding standards.

Preferred Qualifications

  • Experience working in Healthcare, Government, or HHS environments.
  • Experience handling PII and PHI data.
  • Experience with Python scripting and automation.
  • Experience with Tableau or other BI/data visualization tools.
  • Experience with JIRA and Agile methodologies.
  • Knowledge of REST/SOAP web services.
  • Experience with Java and JavaScript development.
  • Experience building CI/CD pipelines using GitHub and GitHub Actions.
  • Experience with MuleSoft integration development.
  • Exposure to AI-enabled tools such as Snowflake Cortex, Snowflake Intelligence, or Informatica CLAIRE.

Job Tags

Contract work

Similar Jobs

Howler Creative Studio

Junior Web & Brand Designer Job at Howler Creative Studio

 ...Freelance Web & Brand Designer (Part-Time, As Needed) Location: Cincinnati, OH (can work from home or with me) Type: Freelance / Independent Contractor (1099) Hours: Flexible, As Needed (Typically 520 hours per week) Compensation: $2025/hour depending on experience... 

LiveHappy Initiative

Business Advisor | Personal & Professional Growth | Remote & Flexible (Denver) Job at LiveHappy Initiative

 ...for individuals who enjoy applying their business experience in a more flexible, purpose-...  ...with backgrounds in business strategy, consulting, marketing, sales, or client-facing...  ...performance-based structure (not a salaried or entry-level position)~ Ability to follow... 

Performacentric

Web Designer Job at Performacentric

 ...practical AI implementation to help clients solve real business problems and achieve measurable results. We are seeking a talented Web Designer who combines strong visual design skills with front-end development expertise and a solid understanding of modern digital... 

Bose Corporation

Art Director/Graphic Designer Job at Bose Corporation

 ...of creative ideas while delivering best-in-class assets across product marketing, partnerships, events, retail environments, and...  ...and collaborations Experiential activations and events Photography, video, and visual storytelling direction Contribute to pitch... 

Department of Education

Education Programs Consultant Job at Department of Education

 ...Job Description and Duties Under general supervision of the Education Administrator I of the Teacher and Leader Policy Office, in the Professional Learning Support Division and working cooperatively with program units throughout the Department, the Education Programs...