Full-Time

Informatica Developer

Deegit

Deegit

No salary listed

Orlando, FL, USA + 1 more

More locations: Harrisburg, PA, USA

In Person

Must reside within commuting distance of Camp Hill, PA or Orlando, FL offices; on-site presence required.

Category
Data & Analytics (2)
,
Required Skills
SQL
ETL
Informatica
Oracle
Linux/Unix
Requirements
  • 5+ years of full time experience with ETL tools and processes, preferably in technical environment involving 10+ TB of data
  • 5+ years of full time experience in Informatica Server administration in the areas of back up repository, configure setting/performance tuning, and meta management
  • The ability to read, write, and maintain SQL
  • The ability to use defined business process and data from tools such as Oracle Enterprise Manager to identify and correct performance problems with ETL processes
  • 5+ years of experience 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
  • 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.
Responsibilities
  • Work with the Deloitte team to implement, maintain, and enhance enterprise-level data architecture using Informatica Power Center and Power Exchange tool.
  • 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
  • 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 their responsibilities and continually refine and improve the way they work, and be able to share that with others
Desired Qualifications
  • B.S. or higher in Computer Science or other 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 at physical database modeling
  • Informatica PowerCenter ETL mappings experience
  • Informatica PowerCenter Admin Console administration experience
  • Informatica PowerExchange development experience
  • Experience using Oracle PL/SQL

Company Size

N/A

Company Stage

N/A

Total Funding

N/A

Headquarters

N/A

Founded

N/A