ETL Informatica Developer Job at innovitusa, Jackson, MO

M0tNK2xoUnplRnZjMGxkNUpvOFcvWTA2UUE9PQ==
  • innovitusa
  • Jackson, MO

Job Description

Hiring: W2 Candidates Only

Visa: Open to any visa type with valid work authorization in the USA

We are seeking a highly skilled ETL Informatica Developer to design build and optimize data integration workflows for enterprise-level applications. The ideal candidate has strong expertise in Informatica PowerCenter (or IICS) SQL and data warehousing concepts with the ability to collaborate across teams to deliver reliable and scalable ETL solutions.

Key Responsibilities

  • Design develop and maintain Informatica ETL workflows mappings sessions and reusable components.
  • Analyze business requirements and translate them into robust ETL design specifications.
  • Optimize ETL processes for performance scalability and fault tolerance.
  • Develop complex data transformations cleansing logic and data validation routines.
  • Work closely with data architects analysts and application teams to integrate data across multiple systems.
  • Perform unit testing system testing and assist in user acceptance testing (UAT).
  • Troubleshoot ETL job failures identify root causes and implement permanent fixes.
  • Create/modify stored procedures views and complex SQL queries for data extraction and transformation.
  • Ensure ETL processes adhere to data governance data quality and security standards.
  • Maintain ETL job schedules and participate in on-call production support.
  • Contribute to documentation including mapping specifications technical design documents and deployment guides.

Required Skills & Qualifications

  • Bachelors degree in Computer Science Engineering IT or related field.
  • 4-8 years of hands-on experience with Informatica PowerCenter (or IICS).
  • Strong proficiency in PL/SQL or SQL (Oracle SQL Server Teradata or similar).
  • Strong understanding of data warehousing concepts (Star/Snowflake schema fact/dimension tables).
  • Experience with ETL performance tuning pushdown optimization and query optimization.
  • Experience working with large data sets and complex transformation logic.
  • Proficiency with Linux/Unix commands and shell scripting.
  • Hands-on knowledge of job scheduling tools (Autosys Control-M UC4).
  • Strong debugging analytical and problem-solving skills.

Preferred Qualifications

  • Experience with cloud-based integration tools ( Informatica IICS AWS Glue Azure Data Factory).
  • Familiarity with big data technologies (Hive Spark EMR).
  • Exposure to API integrations and real-time data processing.
  • Experience with Git CI/CD DevOps pipelines for ETL deployments.
  • Experience with data quality tools (Informatica IDQ).

Job Tags

Permanent employment, Full time,

Similar Jobs

System One

Marine Structural Engineer Job at System One

System One is currently seeking an experienced Marine Structural Engineer to be based in Houston, New York City, or Los Angeles as part of our dynamic and growing global Ports & Terminals (P&T) team, and to immediately support several major ongoing engagements with both... 

Hometown Nannies Plus LLC

NANNY / FAMILY ASSISTANT | Full-Time (40+ hours) | Live-Out | 2-month-old baby. | Flexible Schedule; Occasional Weekends /Overnights & Domestic & International Travel Required | $35/hr., Benefits: Paid Vacation, Health Insurance/Stipend, Holidays Off | START 2-15-26 Job at Hometown Nannies Plus LLC

 ...NANNY / FAMILY ASSISTANT | WESTPORT, CT Full-Time | Live-Out | $35/hr Overnight Coverage: $...  ..., Health Insurance or Stipend, Holidays Off A warm, professional family in Westport...  .../week) Flexible schedule; occasional weekends or overnights Domestic and international... 

Philips Recruiting Services

Welding Engineer Job at Philips Recruiting Services

 ...WELDING ENGINEER General Assignments Responsible for developing and supporting welding and joining equipment and the interfaces to controls and robotics systems. Conducts Weld Excellence training program, includes, Basic Welding, T-Joint Weld, Flared Bevel Weld... 

Amazon.com Services LLC

Industrial Engineer II, Amazon Industrial Robotics Job at Amazon.com Services LLC

 ...DESCRIPTION Amazon Industrial Robotics is seeking exceptional talent to help develop the next generation of advanced manufacturing facilities that will transform production at Amazon's scale. We're building revolutionary factory systems that combine cutting-edge automation... 

Spectrum

Strategic Sales Engineer II, Spectrum Business Job at Spectrum

 ...without employment-based immigration sponsorship, now or in the future. Seeking to shape enterprise connectivity? As a Sales Engineer II at Spectrum, youll design and present advanced network solutions, guide junior engineers and lead technical strategy, partnering...