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

QjQzYUY5c1ZkeVIyaFBzRE1MZ1ZQSDRBdGc9PQ==
  • 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

Experis

Motion Graphic Designer Job at Experis

 ...Our client, a leader in the technology industry, is seeking a Motion Graphic Designer to join their team. As a Motion Graphic Designer, you will be part of the AR/VR Digital Support Solutions team supporting the Customer Insights Content Producer. The ideal candidate will... 

HomeWell Care Services

Caregiver In Home Job at HomeWell Care Services

 ...Services - Want to make a difference in the lives of senior citizens? Caregivers assist agency clients with daily living tasks...  .... This translates to approximately 6 months of full-time work or 12 months of part time work. Exceptions to this requirement are for recently... 

Pape' Kenworth

Journeyman Truck Technician / Mechanic Job at Pape' Kenworth

 ...PAPE KENWORTH SPARKS, NV JOURNEYMAN TRUCK TECHNICIAN / MECHANIC : Do you love working on equipment and turning wrenches? Are you looking to grow your skills as a mechanic? Are you looking for not just another job, but a career? Pape Kenworth, the premier... 

AnthroMed Education

K-8th Grade School Social Worker Job at AnthroMed Education

 ...K-8th Grade School Social Worker Position Overview: We are looking for a compassionate School Social Worker to join our team and inspire positive change in the lives of K-8th grade students in Chicago, Illinois for this upcoming 2024-2025 school year.In this position... 

Western Ag Transport

CDL A Live Haul Truck Driver-local route Job at Western Ag Transport

 ...We are hiring Class A CDL Truck Drivers for a local position in Fremont, NE, with a $2,500 sign-on bonus for qualified candidates. This family-owned transport company specializes in agricultural freight and values its employees. ~ Requirements include a CDL-A license,...