Informatica Developer

IDC Technologies; Pittsburgh (Allegheny County); On-site; USD 90,000 - 120,000; Full time

Job summary

IDC Technologies is seeking a Senior Developer based in Pittsburgh, PA, responsible for the development, support, maintenance, and implementation of complex project modules. You will develop ETL mappings using Informatica to extract data from diverse sources like Oracle and SQL Server.

The ideal candidate has strong skills in PL/SQL and performance tuning, with proficiency in Unix and shell scripting. This role requires excellent analytical and problem-solving abilities.

Qualifications

• Strong experience in developing complex Informatica ETL mappings and workflows.
• Proficient in PL/SQL programming and performance tuning techniques.
• Experience in Unix environments and shell scripting.

Responsibilities

• Responsible for development and support of project modules.
• Maintain and enhance objects in PL/SQL.
• Develop complex ETL mappings from various data sources.

Skills

Informatica ETL development

PL/SQL programming

Unix and shell scripting

Analytical skills

Performance tuning

Job description

Responsibilities and Qualifications

• As a Senior Developer, you are responsible for development, support, maintenance, and implementation of a complex project module.
• Must have ability to develop complex Informatica ETL mappings and workflows extracting data from various heterogeneous source systems like flat files, XML, Oracle, SQL Server, and web services.
• Build, maintain, and enhance all objects, packages, and functions in PL/SQL to support application processes.
• Excellent performance tuning skills.
• Experience with Unix and shell scripting.
• Good experience with data conversion and reporting.
• Strong programming, analytical, and problem solving skills.
• Able to work as an independent team member, capable of applying judgment to plan and execute your tasks.
• Should be able to respond to technical queries and requests from team members and customers.

All your information will be kept confidential according to EEO guidelines.