Direct Client Requirement: Informatica Developer

Deegit Inc; Camp Hill (Cumberland County); On-site; USD 90,000 - 120,000; Full time

Job summary

A technology services company is seeking a skilled candidate for a data architecture role in Camp Hill, PA. You will work on implementing and enhancing enterprise-level data architecture using ETL tools, specifically Informatica PowerCenter. The ideal candidate has over 5 years of experience in ETL processes, strong SQL skills, and experience in data warehousing. This role demands a technical mindset and the ability to collaborate with cross-functional teams.

Qualifications

• 5+ years of experience in developing Informatica PowerCenter ETL mappings using Designer and Workflow Manager.
• 3-5 years of hands-on experience in administration and configuration of Informatica PowerCenter Server.
• 2 years of experience using Oracle PL/SQL.

Responsibilities

• Implement, maintain, and enhance enterprise-level data architecture using Informatica Power Center.
• Develop and implement ETL processes to support sequencing and analysis efforts.
• Create technical design documents that capture mapping and document data quality rules.

Skills

Informatica PowerCenter ETL mappings

SQL

Interpersonal and communication skills

Oracle PL/SQL

Education

B.S. or higher in Computer Science or another technical field

Tools

Informatica PowerCenter

Oracle Enterprise Manager

Job description

Job Description

Camp Hill, PA and Orlando, FL

Full Time

Responsibilities

• The successful candidate will work with the Deloitte team to implement, maintain, and enhance its enterprise-level data architecture using Informatica Power Center and Power Exchange tool.
• The successful candidate will work as part of a team comprised of a project manager, business analysts, and other members of the technical staff to use test-driven development techniques to develop and implement ETL processes to support sequencing and analysis efforts. Specific responsibilities will include: Work with Business Analysts and Data Modelers to understand requirements. Design and develop sustainable database ETL applications to support those requirements. Create technical design documents that capture source to target mapping, define transformation algorithms, and document data quality rules. React to and correct day‑to‑day operational errors.
• Demonstrated results and competence developing ETL processes using Informatica Power Center and Power Exchange 9.1; the desire to think broadly about responsibilities and continually refine and improve the way they work, and be able to share that with others.
• 5+ years of full time experience with ETL tools and processes, preferably in a technical environment involving 10+ TB of data.
• 5+ years of full time experience in Informatica Server administration in the areas of backup repository, configuration setting/performance tuning, and metadata management.
• The ability to read, write, and maintain SQL. The ability to use defined business processes and data from tools such as Oracle Enterprise Manager (OEM) to identify and correct performance problems with ETL processes. Strong interpersonal and communication skills.

Required Skills

• 5+ years of experience in developing Informatica PowerCenter ETL mappings using Designer, Workflow Manager, Workflow Monitor, and Repository Manager.
• 3-5 years of hands‑on experience in administration and configuration of Informatica PowerCenter Server (v9.1) in Windows and Unix using Admin Console and Metadata Manager.
• Experience in backup repository and implementation migration to different environments.
• Experience in Informatica Velocity proven methodology and ETL industry standards.
• Troubleshoot and tune existing ETL solutions; competent to work at the highest technical level of all phases of data warehouse systems analysis/programming activities.
• 3-5 years of experience as database developer on data warehousing/database projects.
• 2 years of experience using Oracle PL/SQL.
• Ability to travel up to 15 percent.
• Must be able to work in the Camp Hill, Pennsylvania offices. Must be willing to live in or near these offices.

Desired Skills

• B.S. or higher in Computer Science or another technical field.
• 5+ years of full time experience with ETL tools and processes, preferably in a mortgage/loan or technical environment involving 10+ TB of data.
• Experience with Object-Oriented methodologies, Test-First Development, Continuous Integration, and Agile Development processes. Experience in software development using Oracle and XML. Experience with physical database modeling.