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

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

Selby Jennings

Private Equity Associate Job at Selby Jennings

 ...A leading Private Equity firm based out of Charlotte, NC is looking to add an Associate to their team this Summer. The firm specializes in business services, industrial, and consumer sectors within the emerging lower-middle market and will start deploying capital out of... 

Apex Systems

Senior Principal Modeling & Simulation Engineer Job at Apex Systems

 ...As a Modeling & Simulation Engineer , you will participate in unique multi-disciplinary research across integrated product teams consisting of Guidance, Navigation and Control (GNC), Signal Processing, Electronic Warfare, and missile-and-sensor-level countermeasure... 

Mack & Associates, Ltd.

Marketing Executive Assistant Job at Mack & Associates, Ltd.

 ...Exceptional organizational, writing, and editing skills, coupled with a meticulous attention to detail. Proficiency in Microsoft Suite, Mac applications, Google Suite, and Deltek Vision is highly desirable. Strong experience with document management systems and... 

Speedgoat

Systems Integration Technician Job at Speedgoat

Speedgoat develops and sells complete software and hardware development platforms for real-time simulation and testing. Responsibilities As Systems Integration Technician , you take the overall responsibility for the assembling, integration, and testing of our ...

Midwest Logistic Systems

Midwest Logistics Systems Dedicated nighttime truck driver Job at Midwest Logistic Systems

 ...thinking and cultivates leadership. Any applicant may request a reasonable accommodation to complete a job application, pre-employment testing, or job interview or to otherwise participate in the hiring process consistent with the Americans with Disabilities Act (ADA) by...