the smart solution for Washington DC jobs

Informatica ETL Developer (w/Netezza)

Company: Interpro Inc.
Location: Washington
Posted on: December 9, 2018

Job Description:

Interpro has been in the IT consulting/staffing business since 1993 and our employees work at a range of clients across the country. We have excellent opportunities to build your resume:NO THIRD PARTIES PLEASEDesign, Develop and Provide support in all aspects of data movement for a data warehouse environment residing on Netezza, with emphasis on the Extract-Transform-Load (ETL) process using Informatica. --- Ability to administer ETL system and upgrade to new releases--- Develop data warehouse process models, including sourcing, extracting, transforming and loading as per business requirements.--- Design Extract-Transform-Load (ETL) Workflows for data migration from various sources to data warehouse using batch or incremental loading strategies.--- Document database design including data modeling, metadata and business process flow for the new business integration requirements.--- Create data model and reverse engineer data warehouse using CASE tools like ER Studio.--- Create test plans and scripts for data warehouse testing, ranging from unit to integration testing.--- Ensure delivered Data warehouse code is running and conforms to specifications and design guidelines.--- Create Informatica mappings, transformations, stored procedures and functions to implement the data process flow defined by the business rules.--- Document technical ETL specifications for data warehouse. Perform periodic code reviews and test plans to ensure data quality and integrity.--- Navigate on the host server for file management, file cleanup and configuration tasks. Maintain Informatica on UNIX and Windows environments. Write Shell scripts, PL/SQL scripts and SQL scripts--- Prior Experience in Upgrading Informatica Power Center versions. --- Excellent communication skills with knowledge of ETL field, tools and technologies, implementations and solutions, as well as specific experience with the Informatica ETL tool--- Excellent motivational skills required to ensure good team synergy and collaboration of cross functional teams. A strong facilitation and "positive" attitude will be mandatory.--- Strong experience in Data Quality, Source Systems Analysis, Business Rules Validation, Source Target Mapping Design, Performance Tuning, and High Volume Data Loads--- Excellent ability to multi-task.--- Demonstrated proficiency with a database SQL language for user-defined database extracts or updates statements.--- Proficient in Netezza 7.1--- Proficient on all Informatica 10.x Platform tools (Power Exchange, Power Center)--- Proficient use of CASE tools (Embarcadero ER Studio preferred) 7-10 years of prior software development experience required. - provided by Dice Informatica ETL, Netezza 7.1

Keywords: Interpro Inc., Washington DC , Informatica ETL Developer (w/Netezza), IT / Software / Systems , Washington, DC

Click here to apply!

Didn't find what you're looking for? Search again!

I'm looking for
in category

Other IT / Software / Systems Jobs

Senior Software Engineer - UI with Security Clearance
Description: Job Description: An Identity Access Management IdAM program is seeking an experienced front end web developer to provide user interface design expertise in support of a mission critical enterprise (more...)
Company: Leidos
Location: Chantilly
Posted on: 12/18/2018

ETL Developer/Data Analyst Position in Harrisburg, PA
Description: Position Details: Job title : ETL Developer/Data Analyst Location : Harrisburg, Pennsylvania Duration : 6 Months Job Description: Client is looking for ETL Developer/Data Analyst staff augmentation
Company: vTech solution inc
Location: Harrisburg
Posted on: 12/18/2018

Junior Software Developer
Description: Revature is the fastest growing employer of emerging technology talent in the US and we are currently looking to hire over 100 new Software Engineers. Our Software Engineers design, analyze and build (more...)
Company: Revature
Location: Charlottesville
Posted on: 12/18/2018

Senior Software Engineer (IDAM) with Security Clearance
Description: Integrity Applications Incorporated IAI is a software and system engineering company headquartered in Chantilly, Virginia with offices Nationwide. IAI has been selected as one of the best companies (more...)
Company: Integrity Applications Incorporated
Location: Reston
Posted on: 12/18/2018

Corporate Support Technical Advisor with Security Clearance
Description: Position Title Technical Advisor Level 2 Position Description The successful candidate will work as a member of the team and be aligned to a specific customer organization. The Corporate Support Technical (more...)
Company: Hire Velocity, LLC
Location: Chantilly
Posted on: 12/18/2018

SharePoint/Internet Technologies Developer II
Description: OGSystems - Company Overview Why be a government contractor when you can be a government innovator Come work for an organization that has creativity, innovation, and drive rooted throughout its DNA. (more...)
Company: OGSystems
Location: Chantilly
Posted on: 12/18/2018

CNE & Wireless/RF Engineer
Description: CNE Wireless/RF Engineer Overview Every day at Perspecta, we enable hundreds of thousands of people to take on our nation's most important work. We're a company founded on a diverse set of capabilities (more...)
Company: Perspecta
Location: Chantilly
Posted on: 12/18/2018

Software Developer (Ruby on Rails) - Senior with Security Clearance
Description: Are you a talented Software Developer looking for the next step in your career Check out PSS Clearance Requirements TS/SCI with Polygraph Applicants selected will be subject to a government security (more...)
Company: Preferred Systems Solutions, Inc. (PSS)
Location: Reston
Posted on: 12/18/2018

GEOINT Radar Engineer / Systems Engineer Technical Specialist
Description: GEOINT Radar Engineer / Systems Engineer Technical Specialist Overview Every day at Perspecta, we enable hundreds of thousands of people to take on our nation's most important work. We're a company founded (more...)
Company: Perspecta
Location: Chantilly
Posted on: 12/18/2018

Mid- Level Java Developer - Top Secret (TS) Clearance Required (Sterli
Description: Java Developer - Top Secret TS Clearance Required br br Location - Washington, DC moving to Crystal City on 1/1/19 br br INTEGRITYOne Partners IOP is seeking a Java Developer to work on (more...)
Company: Helios HR
Location: Sterling
Posted on: 12/18/2018

Log In or Create An Account