The #1 Site for IT and Engineering Jobs - search all IT and Engineering  jobs.

Informatica IICS Developer

Job Description


Position: Sr ETL Informatica Developer
Location: Washington, DC


Description:
Design, 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.

Job Requirements

 

Job Snapshot

Location US-DC-Washington DC
Employment Type Full-Time
Pay Type Year
Pay Rate N/A
Store Type IT & Technical
Apply

Company Overview

ACS Solutions

ACS Group provides services to Fortune 1000 companies across various industry verticals. With a proven track record of managing project demands while improving the efficiency, productivity and profitability of new and existing projects through process improvement, ACS Group is consistently recognized for identifying and implementing strategic solutions that create and preserve long-term business value. Learn More

Contact Information

US-DC-Washington DC
American CyberSystems, Inc.
(571)421-1005
Snapshot
ACS Solutions
Company:
US-DC-Washington DC
Location:
Full-Time
Employment Type:
Year
Pay Type:
N/A
Pay Rate:
IT & Technical
Store Type:

Job Description


Position: Sr ETL Informatica Developer
Location: Washington, DC


Description:
Design, 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.

Job Requirements

 
Sologig Advice

For your privacy and protection, when applying to a job online: Never give your social security number to a prospective employer, provide credit card or bank account information, or perform any sort of monetary transaction.Learn More

By applying to a job using sologig.com you are agreeing to comply with and be subject to the workinretail.com Terms and Conditions for use of our website. To use our website, you must agree with theTerms & Conditionsand both meet and comply with their provisions.
Informatica IICS Developer Apply now