19 Sep
ETL Informatica developer
New Jersey, Jerseycity , 07097 Jerseycity USA

Vacancy expired!

Apex Systems combines with parent company On Assignment to make it the 2nd largest IT staffing agency in the country.Apex has an opportunity for a ETL Informatica Developer for a client in Jersey City, NJ. If interested in discussing the position further, please send an MS Word version of your resume to Colin Reilly, cfreilly@apexsystems.comHere are the details:Position: ETL Informatica Developer Location: Remote to start (eventually on site in Jersey City, NJ) Rate: Negotiable Duration: 18+ Month W2 Rolling Contract (Potential to Go Perm)Day-to-Day Responsibilities:

  • This individual is responsible for working with other teams to deliver the artifacts and the code. This person must have strong professional consulting skills and the ability to communicate well at all levels of the organization. Responsibilities:
  • Exceptional Informatica Power Center expertise, version 10.x or later
  • Translate business requirements into technical requirements
  • Proven experience in designing and building integrations supporting standard data warehousing objects (type-2 dimensions, aggregations, star schema, etc.)
  • Design, Development and Test ETL Mappings, Mapplets, Workflows, Worklets using Informatica Powercenter 9.x.
  • Performance tuning of end-to-end integration processes within Informatica workflow, or in the source/target database endpoints as needed. Understand ETL Specification documents for mapping requirements and create mappings using transformations such as the Source qualifier, Aggregator, Expression, Lookup, Router, Filter, Joiner, Union, Sequence Generator, Normalizer and Update Strategy.
  • Create UNIX shell scripts to FTP and Archive files.
  • Collaborate with the team to coordinate delivery of software application.
  • RDMBS (Oracle & SQL Server) database skills, including complex SQL constructs and DDL generation.
  • Experience in Autosys Scheduling tool
  • Work in a fast paced environment, under minimal supervision providing technical guidance to the team members.
  • Provide innovative solutions to problems and drive the design/development of components.
  • Experience in technical specification design
  • Ability to provide end to end technical guidance on the software development life cycle (requirements through implementation).
  • Analytical and problem-solving skills
  • Complex Data Architecture / Data lineage methodologies.
  • Strong Data modeling and understanding of key business elements.
  • Strong SQL programming experience
  • Strong Data analysis skills
  • Determine optimal approach for obtaining data from diverse source systems.
  • Be a key contributor to initiatives that require technical expertise.
  • Communicate with technical partners and come up with solutions.
Must Haves:
  • Hands on Data warehousing experience
  • Driving and Design Development
  • Integrations supporting warehousing objects
Nice to Haves: • Financial backgroundFor this opportunity, you will also be eligible for benefits through Apex for the contract period, a W2 hourly rate, weekly pay, and direct deposit! Apex Systems Inc. is an equal opportunity employer and encourages female and minority applicants to apply.EEO EmployerApex Systems is an equal opportunity employer. We do not discriminate or allow discrimination on the basis of race, color, religion, creed, sex (including pregnancy, childbirth, breastfeeding, or related medical conditions), age, sexual orientation, gender identity, national origin, ancestry, citizenship, genetic information, registered domestic partner status, marital status, disability, status as a crime victim, protected veteran status, political affiliation, union membership, or any other characteristic protected by law. Apex will consider qualified applicants with criminal histories in a manner consistent with the requirements of applicable law. If you have visited our website in search of information on employment opportunities or to apply for a position, and you require an accommodation in using our website for a search or application, please contact our Employee Services Department at employeeservices@apexsystemsinc.com or 844-463-6178.

Vacancy expired!

Subscribe for new vacancies
Report job