ETL Developer with Informatica Experience

Trinity ERP, LLC; San Jose (CA); On-site; USD 90,000 - 130,000; Full time

Job summary

A leading technology solutions provider seeks an experienced ETL Developer with strong Informatica and SSIS skills. You will be responsible for developing robust ETL programs, collaborating with various teams, and ensuring data integrity. This full-time position offers competitive salary and opportunities for growth.

Qualifications

• At least six years’ experience in ETL programming using SSIS, DTS, Informatica, Pentaho.
• Minimum of seven years in IT development/support roles with direct ETL experience.
• Experience building EDI file sets and working in the financial industry is preferred.

Responsibilities

• Support IT management in developing ETL & EDI strategy.
• Create and manage SSIS packages, triggers, and SQL transactions.
• Lead SQL and SSIS programming initiatives and train IT staff.

Skills

ETL programming

Informatica

SSIS

SQL

EDI

Root cause analysis

Data quality assurance

Job description

ETL Developer with Informatica Experience

Experience: 5-6 Years

Job Type: Full Time

Overview:

Analyze, design, implement, and maintain client’s ETL programs. The Senior ETL Developer works with the ETL Supervisor and ETL team to accelerate development and deployment of ETL, EDI, and proprietary interfaces. Working closely with developers, data architects, analysts, and business users, the Sr. ETL Developer is tasked with implementing robust, reusable development for SSIS and ETL packages.

Responsibilities:

Principal responsibilities include:

• Support IT management in developing and implementing a comprehensive ETL & EDI strategy.
• Create and manage SSIS packages, ETL packages, triggers, stored procedures, views, and SQL transactions.
• Develop new secure data feeds with external parties and internal applications, including data warehouses and business intelligence tools.
• Maintain and enhance key systems such as the Pre-Processor, Provider Not Found, and Member Not Found interfaces.
• Perform analysis and quality assurance.
• Lead SQL and SSIS programming initiatives.
• Train IT staff on advanced SSIS, SQL, XML (X12), and EDI techniques and design patterns.
• Diagnose ETL and database issues, perform root cause analysis, and recommend corrective actions.
• Collaborate with project teams to support the design, development, implementation, monitoring, and maintenance of new ETL programs.
• Complete other duties and projects as assigned by IT management.

Minimum Years of Related Experience:

• At least six years’ experience in ETL programming using SSIS packages, DTS, stored procedures, Informatica, Pentaho, and SQL scripts.
• Minimum of seven years in IT development/support roles with at least four years of direct ETL experience.
• At least three years building EDI file sets, including data extraction, consumption, and loading from/to EDI files.
• Preferably with financial industry experience.