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

YVhRN29hSWtnek1GTWtPaWdaT2J0dWVjZmc9PQ==
  • Pierce Technology Corp
  • Chester, PA

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

GienTech

Freelance Translator - Multi Language Job at GienTech

1. Do Translation/Review on online platform (we would provide relevant training)2. Proactively good search of reference materials during translation, raise valid queries during translating3. Do final check according to PM's requirements4. Implement feedback if any

StretchLab

Experienced Yoga/Fitness Instructor Job at StretchLab

 ..., we want to meet you! StretchLab is seeking individuals with backgrounds in personal training, massage and physical therapy, dance/yoga/Pilates instruction, or backgrounds with stretching/exercise/bodywork to join our team as a Flexologist.This is an exciting opportunity... 

NT Solutions Inc

OTR Company Driver CDL A Job at NT Solutions Inc

 ...Company OTR Driver Drive 20232026 Equipment. Were hiring Company OTR Drivers to operate 20232026 model trucks, including Volvo, Freightliner Cascadia, International, and Mack. Get steady miles, competitive pay, modern equipment, and a team that truly supports drivers... 

Mercari, inc.

Product Manager(Trust & Safety)- MercariHallo(HR領域新規事業) Job at Mercari, inc.

 ...This job requires Japanese language ability. JD is available in Japanese only. Product Manager(Trust & Safety)- MercariHallo(HR) ... 

Cloud Analytics Technologies LLC

Google Cloud ML Engineer Job at Cloud Analytics Technologies LLC

 ...and develop scalable chat Virtual Agent frameworks using Google Vertex AI (Agent Engine, ADK). Build, customize, and optimize chatbots and conversational...  ...extraction, response generation). Develop and maintain cloud-native chat Virtual Agent solutions using GCP services (...