Previous Job
Informatica ETL Developer
Ref No.: 18-00269
Location: Newark, New Jersey
Position Type:Right to Hire
Start Date: 04/16/2018

Location: Newark, NJ 07102
Hours: Monday through Friday: 8:00 AM to 4:00 PM EST
Target Start Date: ASAP
Years of Experience: 3 + years (Intermediate)
Right to hire: Yes

Scope of Work:
Project Scope:
  • Support technology modernization to move away from legacy mainframe and batch solutions to new, modern technologies and tools
  • Consolidation and standardization of data flows across the organization to new technology stack (Informatica, SQL Server, APIGEE)
  • Design, develop, implement and maintain programs 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
  • 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, 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