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

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

BayMark Health Services

Part-Time Dispensing Nurse LPN/RN Job at BayMark Health Services

Part Time Dispensing Nurse LPN/LVN Health Care Resource Centers is looking for a detail oriented and empathetic Licensed Practical Nurse / Licensed Vocational Nurse to dispense prescribed medications as part of a treatment team in partnership with Physicians and Nursing...

Midwest Logistic Systems

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

 ...Route and detention pay. ~$5,000 sign-on bonus for experienced drivers. ~ Safety and performance bonuses of up to $600 per quarter....  ...procedures, qualification requirements, training program, pay packages and benefits. If you have any questions about becoming an MLS driver... 

World Explorer Travel

Travel Agent Job at World Explorer Travel

Are you looking for an exciting side hustle with lots of perks? The Travel industry is booming and we are expanding our team. No experience is required. We have free daily online training and great mentors ready to help you. If you are a stay at home mom, college student... 

The Butcher's Daughter - Nolita

Sous Chef Job at The Butcher's Daughter - Nolita

 ...Overview: As a Sous Chef at The Butcher's Daughter you will work closely with the Executive Chef to ensure the highest standards of culinary excellence and operational efficiency. You will assist in menu development, food preparation, and kitchen management, contributing... 

Andersen Group Realty of Keller Williams Realty Boston North...

Real Estate Assistant Job at Andersen Group Realty of Keller Williams Realty Boston North...

Who We're Looking For:Were looking for an exceptional Real Estate Assistant/Listing Coordinator who is highly organized, detail-oriented, and experienced in providing top-tier administrative support to executives or in similar roles. You should be proactive, discreet,...