Informatica Developer II

  • Full-time

Company Description

“We’re not in the shipping business; we’re in the information business” -Peter Rose, Expeditors Founder

Global supply chain management is what we do, but at the heart of Expeditors you will find professionalism, leadership, and a friendly environment, all of which foster an innovative, customer service-based approach to logistics.

  • 17,000 trained professionals
  • 300+ locations worldwide
  • Fortune 500
  • Globally unified systems

Job Description

Seeking an Informatica Developer to join ETL team to build and maintain Enterprise Data Warehouse that serves the reporting and analytical needs for business and IT consumers. This position will be responsible for SDLC of Data Integration projects that involves, but not limited to, preparing the detailed technical design documents from functional requirement documents, design and develop ETL framework, setting up the DB application schemas and developing database code, unit and system testing of end-to-end integration, release management and production support as needed.

Responsibilities:

  • Understand the business requirements and translate them into Detailed Design Technical documents
  • Create the end-to-end solution for ETL transformational jobs that involve writing the Informatica workflows and mappings, procedures and functions and UNIX shell scripting 
  • Promote the fully tested and qualified code into upper environments
  • Troubleshoot the bottlenecks on source, integration and target phases and fine tune code or environments appropriately

Qualifications

Minimum Qualifications:

  • 2 years of experience in Data Integration projects working on ETL framework for Data Warehouse projects preferably using Informatica 9.x
  • Hands-on experience creating mappings, mapplets, sessions, workflows, and worklets
  • 2 years of experience in DB2 database development for data warehouse projects

Desired Qualifications:

  • Informatica Cloud Knowledge (IICS), hands-on experience using Informatica with web-based/cloud sources and targets and big data technologies is a plus
  • Performance tuning techniques on mapping and session levels (DTM buffer/block size configurations, partitioning, etc.)

Additional Information

Expeditors offers excellent benefits:

  • Paid Vacation, Holiday, Sick Time 
  • Health Plan: Medical, Prescription Drug, Dental and Vision
  • Life and Long Term Disability Insurance 
  • 401(k) Retirement Savings Plan 
  • Employee Stock Purchase Plan
  • Training and Personnel Development Program

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

Successful candidates must pass a background check.

 

Applicants are required to be eligible to lawfully work in the U.S. immediately; employer will not transfer or sponsor applicants for U.S. work authorization (such as an H-1B visa) for this opportunity.

Privacy Policy