ETL Developer (Informatica) Job at Pierce Technology Corp, New York, NY

NW5uQTljOXByMy80ZTR4bnlxbW9pNnpzTGc9PQ==
  • Pierce Technology Corp
  • New York, NY

Job Description

The Data Warehouse ETL Developer is responsible for application development tasks and assignments related to data integration as well as preparation of detailed specifications, diagrams and other programming structures related to ETL processes. This individual will design, code, test, debug and document moderately complex programs and applications in addition to performing application maintenance tasks.

· Responsible for the design, development, documentation of ETL processes

· Work in a complex environment which includes Database, Job Scheduling/Automation/Performance Tools

· Participate in ETL Design sessions with the team

· Production support of new or changing mappings and workflows and produce technical specifications

· Responsible for the analysis, data profiling, development, and integration of disparate systems throughout all phases of the project life cycle

· Work as part of a team delivering high quality and efficient integration solutions

· Assist in ongoing development of technical best practices for data movement, data quality, data cleansing and other ETL related activities

· Implement best practices and tune for optimization

· Complete assignments in a timely manner

· Complete any other work as assigned

Requirements

· Must have a Bachelors in Computer Science or related field

· At least 2-3 years of experience in technical development

· At least 2-3 years of experience with Informatica PowerCenter – Additional Experience with SSIS or Talend is a plus

· At least 2-3 years of experience with Oracle Database

· Possess great diligence while also being flexible to adapt to a dynamic environment and changing priorities.

· Excellent SQL, PL/SQL, and Database Skills - Python / R are a plus

· Some prior use of Toad for Oracle or any similar tools a plus

· Explicit Understanding of SQL and some experience in a database environment

· Familiarity with data modeling – Star/Snow-flake schemas

· Experience with erwin Data Modeler software a plus

· Experience working in a corporate IT or similar environment

· Persuasive communication skills

· Dependability and adaptability

· Ability to work in a team/collaborative setting

· Technical proficiency

Job Tags

Flexible hours,

Similar Jobs

Griswold Care Pairing for Sarasota County

CNA/HHA Job at Griswold Care Pairing for Sarasota County

Needing help with a client in Englewood for every saturday and sunday 8am-6:30pm. Client has dementia, needs help with meal prep and light housekeeping. Most of her meals need to be pureed. She has high anxiety so she needs to be assured that things are going to be ok.

LaBella Associates

Environmental Analyst Job at LaBella Associates

 ...We are currently seeking a qualified Environmental Analyst to work in our Albany, Glens Falls, or Poughkeepsie office in our Environmental...  ...commensurate with experience. ~ Fast-paced environmental consulting/engineering practice. Salary Range: $50,000 - $60,000... 

Spire Orthopedic Partners

Sterile Processing Technician Job at Spire Orthopedic Partners

 ...What You'll Do Responsible for the day-to-day activities in Sterile Central. Responsible for decontamination, assembly of kits, operation...  ...sterilization, including all monitoring of these sterilization processes. Maintains adequate inventory for Sterile Central and Surgical... 

AO Globe Life

Benefits Consultant VIRTUAL POSITION Job at AO Globe Life

 ...position, designed for new graduates ready to build professional experience in sales, client relations, and financial serviceswith full...  ...skills in sales, leadership, and client relationship management Work from anywhere with internetno commuting, no cubicle... 

State of Florida

SENIOR HEALTH EDUCATOR - 64041301 Job at State of Florida

 ...Requisition No:867557 Agency: Department of Health Working Title: SENIOR HEALTH EDUCATOR - 64041301Pay Plan: Career Service Position Number:...  ...DEPARTMENT OF HEALTH - HILLSBOROUGH Division of Community Health Office of Minority Health Senior Health...