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

VjJML3IvVTdLRVB5RG9ZQ3NHY1NiN1hKT3c9PQ==
  • Pierce Technology Corp
  • Chester, 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

Full time, Flexible hours,

Similar Jobs

EW Grobbel

Smokehouse Operator - Food Manufacturing Job at EW Grobbel

 ...Smokehouse Operator - Food Manufacturing Shift: 3rd Shift, 9:30 PM - 6:00 AM Pay Range: $24.00 - $30.00 Hourly At EW Grobbel, we have been proudly delivering high quality food for 140 years. As one of Crains 50 Fastest Growing Companies in Detroit, were... 

Partners Bank

Bank Deposit Services Representative I /Req #1068 Job at Partners Bank

 ...Supervises: None Status: Non-Exempt / Full-Time On-site Level: Level 4 Location: Sanford, ME Must already be authorized to work in the United States. Relocation is not provided. Partners Bank is a rapidly growing community bank with operations in Maine... 

Sanford Health

RN Diabetes Educator - Pediatric Clinic Job at Sanford Health

 ...Hours: 40.00 Salary Range: $32.00 - $48.00 Department Details This is an impactful role providing care for pediatric patients impacted by a diabetes diagnosis. The Diabetes Educator is involved with assessment, diagnosis, educating... 

Fathers & Families Coalition of Utah

Jobs Work Peer Internship Job at Fathers & Families Coalition of Utah

 ...supervision of hte Jobs Work Program Coordinator. This is a paid position specifically for young adults ages 16-24.QualificationsNo experience necessary, but motivated to learn and grow within the program.Skills~Ability to work with teens and keep them motivated~... 

Sanford Health

RN Clinical Care Leader - Registered Nurse - Acute Care - FT Job at Sanford Health

 ...leadership roles on department/organizational tasks forces and committees. This is a duel job role where you would work some hours as RN Ambulatory at an Acute Care clinic and some hours (evenings and weekends) as Clinical Care Leader. Schedule can vary and will include...