Previous Job
Informatica Power Center / ETL Developer - Contract
Ref No.: 18-00297
Location: Newark, New Jersey
Our direct client is seeking an Informatica Power Center / ETL Developer to work in their Newark, NJ location. This is a 6+ month contract opportunity.

Scope of Work:
  • Design, develop and implement ETL using various Informatica technologies to load data into PGIM Data Warehouse for International line of business, UCITS
  • Consolidation and standardization of data flows across the organization to technology stack (Informatica, SQL Server, APIGEE)
  • Design, develop, implement and maintain workflows to load, aggregate, and extract data to meet a wide range of business and system requirements using Informatica
  • Perform data mappings and design of system ETL workflow solutions
  • Work with functional staff to establish and clarify requirements
  • Investigates and corrects software defects and analyzes and maintains data quality
  • Unit Testing, Integration Testing and Code Release Management for ETL Packages and Workflow
  • Prepare comprehensive documentation

Skills/Qualifications Required:
  • Master's or Bachelor's degree in Computer Science or related discipline
  • Database Administration, ETL, or Business Intelligence-related certifications preferred
  • Financial Services experience (Mutual Fund background preferred)
  • 5+ years of overall experience with an emphasis on information technology
  • 5+ years of experience with Informatica Platform and knowledge of Informatica best practices for Informatica PowerCenter and Informatica B2B Data Exchange products
  • Expert PowerCenter Developer with Data Transformation Studio, Developer Studio, DVO and B2B Data Exchange knowledge
  • Deep hands-on knowledge of Mappings, Workflows, and Applications
  • Experience with a variety of data feed types, including JSON, XML, CSV, and SOAP
  • Knowledge of the Agile software development process
  • Experience integrating large datasets from disperse systems
  • Experience developing and executing test plans to verify logic of data movement and ETL scripts
  • Experience troubleshooting and resolving data, system and performance issues
  • Superb communication (written and oral) and interpersonal skills
  • Experience with Cloud computing concepts (private, public and hybrid) a plus