Previous Job
Informatica Power Center/ETL Developer
Ref No.: 18-00025
Location: Newark, New Jersey
Position Type:Contract
Experience Level: 6 Years
Start Date / End Date: 06/04/2018 to 02/01/2019
 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