ETL Developer with Informatica Experience

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.