• Informatica ETL Developer

    Randstad USJersey City, NJ 07308

    Job #1775076690

  • Informatica ETL Developer

    job details:

    • location:Jersey City, NJ

    • salary:$58 - $68 per hour

    • date posted:Tuesday, September 14, 2021

    • job type:Contract

    • industry:Finance and Insurance

    • reference:869483

    job description

    Informatica ETL Developer

    job summary:

    • Informatica ETL developer must have prior hands-on experience delivering successful data warehousing projects (Informatica specific) as well as broad background and experience with IT application development.

    • This individual is responsible for working with other teams to deliver the artifacts and the code.

    • This person must have 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.

    • Data modeling and understanding of key business elements.

    • SQL programming experience

    • 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.

    location: Jersey City, New Jersey

    job type: Contract

    salary: $58 - 68 per hour

    work hours: 9am to 5pm

    education: Bachelors

    responsibilities:

    • Informatica ETL developer must have prior hands-on experience delivering successful data warehousing projects (Informatica specific) as well as broad background and experience with IT application development.

    • This individual is responsible for working with other teams to deliver the artifacts and the code.

    • This person must have 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.)

    qualifications:

    • Experience level: Experienced

    • Minimum 10 years of experience

    • Education: Bachelors

    skills:

    • Informatica

    Equal Opportunity Employer: Race, Color, Religion, Sex, Sexual Orientation, Gender Identity, National Origin, Age, Genetic Information, Disability, Protected Veteran Status, or any other legally protected group status.

  • You Can Also Try Searching