IT - Informatica Systems Developer

SmartRecruiters, Inc.; San Ramon (CA); On-site; USD 90,000 - 120,000; Full time

Job summary

A leading IT consulting firm is seeking an Informatica Powercenter Programmer/Analyst in San Ramon, CA. This role involves supporting ETL program development, managing data migration, and ensuring system stability. Candidates should possess strong experience with Informatica Power Center and have skills in Red Hat Linux and Oracle 11g. Responsibilities include job scheduling and providing on-call support for production systems. This is a contract position expected to last over 6 months.

Qualifications

• Experience with Informatica Powercenter 8.6.1 or higher.
• Strong skills in debugging and modifying existing applications.
• Ability to coordinate data cleansing and migration efforts.

Responsibilities

• Support technical design and unit testing of ETL programs.
• Develop and manage new workflow processes.
• Schedule batch jobs using Informatica or UC4 Job Scheduling.
• Provide on-call support for production systems.

Skills

Informatica Power Center

Red Hat Linux

Oracle 11g

ETL development

Data migration

Job scheduling

Job description

Pyramid is a leading Information Technology Consulting services company headquartered in metropolitan Atlanta, GA with prime emphasis on the following service offerings:

• Staff Augmentation
• Lifecycle IT solutions
• Application Development & Support
• Outsourced Testing
• Mobile Development and Test Automation

Job Description

Location: San Ramon, CA

Duration: 6+ Months

Responsibilities:

• Support technical design, development and unit test of ETL programs using Informatica Power Center 8.6.1 or higher in Red Hat Linux and Oracle 11g environment.
• Develop and manage new workflow processes.
• Coordinate the data cleansing and data migration capabilities in support of the MDM initiative.
• Support stabilization of Informatica delivery projects. This includes On Call support. Support migration process of Informatica code and patches.
• Schedule batch jobs using Informatica job scheduling or UC4 Job Scheduling.

Qualifications

• The Informatica Powercenter Programmer/Analyst designs, develops, modifies, configures, debugs and evaluates application programs for functional business areas.
• Programs include interfaces, conversions, and enhancements.
• Analyzes existing applications and systems and formulates logic for new systems, devises logic procedures, logical database design, performs coding and tests/debugs programs.
• Assist in the definition, development, and documentation of deliverables, and specifications on a project-by-project basis as defined in the IT Methodology, in collaboration with business analyst and other project team members.
• Consult with business analyst and architects to understand, anticipate, and meet current and future business needs.
• Modify and configure applications/systems as specified in the requirements and/or technical design document.
• Prepares and obtains approval of system and development documentation.
• Recommends changes in development, maintenance and system standards and processes.
• Anticipate client concerns and questions and provide timely, professional, straight forward (non-technical) communications.
• Provide on call support for production systems and provide timely solutions.
• Day-to-day tasks to insure systems are up and running. Respond to ad-hoc questions and intra-departmental communications.
• Supports may include bug fixes, patches, minor enhancements, and service request.

Additional Information

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