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

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

Oxford Instruments Plc

Field Service Engineer I Job at Oxford Instruments Plc

 ...an exciting opportunity available for an experienced Customer Service Engineer to be a hands-on leader. We need a technical, pragmatic...  ...contracts. Keep the customer up to date and satisfied. Field Reporting: ~Initiate Field Service Reports for each customer... 

Bottega Napa Valley

Executive Sous Chef Job at Bottega Napa Valley

 ...Bottega Napa Valley is seeking an experienced Executive Sous Chef to join our team. As Executive Sous Chef, you will play a key role in supporting the Executive Chef in the day-to-day operations of the kitchen. This includes working on the line, assisting with expediting... 

Wonder Pups Pet Care

Pet Sitter Job at Wonder Pups Pet Care

HOT DIGGITY DOG, WE WANT YOU!!! Seeking to pet loving canidate with morning, evening, and weekend availabilty, 2 to 4 hours at a time, 4 or more days per week In Crestview Fl, and Baker Fl Are you looking for something fun to do part time? Ready to turn you...

Included Health

Content Writer Job at Included Health

 ...Were looking for a skilled and versatile Content Writer to join our Consumer Marketing Content & Creative Strategy team. This role plays a crucial part in executing day-to-day member communications that drive registrations, care visits, and ongoing engagement with our... 

Summerhouse Vista Shores

Director of Health and Wellness Job at Summerhouse Vista Shores

 ...more than 6500 residents nationwide. Position Summary Responsible for providing overall leadership and management of the health and well being of the residents within the community. Essential Duties and Responsibilities Ensures that community follows all federal...