ETL Informatica Developer
54 Consulting L.L.C. - Reston, VA

This job posting is no longer available on Indeed. Find similar jobs: ETL Informatica Developer jobs - Consulting jobs

Citizens or Green Card holders only please.

54 Technologies is looking for an ETL Informatica Developer who will be responsible for integrating and cleansing data from operational systems into the Data warehousing environment that consists of a staging database as well as an integrated warehouse database. The ETL Developer is also expected to have the ability to perform administration functions of the Informatica platform as necessary to support the ETL activities.


  • Translate source to target mapping specifications into Informatica ETL logic
  • Recommend and implement appropriate Surrogate key generation and partition assignment strategies
  • Optimize the ETL process to take advantage of the Oracle 11G load and partitioning architecture
  • Work closely with the analysts, data modeling, database, infrastructure, and testing teams
  • Administer the Informatica platform as needed to support the ETL development and testing
  • Initially build the ETL modules in a development environment and promote it when appropriate to test then to production
  • Perform unit testing and support system testing


  • Experience in ETL of data from source systems into 3NF and Star Schema
  • Experience in building complex mappings
  • Experience in creating reusable Workflows, Worklets, Mappings, and Mapplets
  • Being well versed in Informatica Power Center
  • Experience with debugging and tuning tools for the ETL processes
  • Knowledgeable in Oracle Utilities such Bulk data loader and PL-SQL
  • Experience in writing Unit test plans and Unite Testing
  • Prior experience extracting data from Cache databases is highly desired