Informatica Developer

SDH Systems LLC

Posted 5 years ago

Job Title: Informatica Developer
Location:Plano, Tx 75093
Duration: 3 Years
Work Schedule: Full Time
Salary: $94,307.00/Annum + Company Standard Benefits
Job Duties:

  • Analyze business requirements and work with Business analyst on clarifications
  • Develop Informatica Power center ETL Mapping, Sessions and workflows and perform
    Unit testing.
  • Automated the Informatica process to update a status table in Teradata when maps are run
    successfully, following this a view will be run.
  • Develop hive scripts to perform aggregations on extracted data and load the final tables.
  • Develop complex mappings to load the data from multiple sources with functional logic as
    per business requirements.
  • Working with Source Analyzer, Warehouse Designer, Transformation designer, mapping designer and Workflow Manager to develop new Mappings & implement data warehouse.
  • Working on development of new requirements and enhancement of the existing ETL Jobs.
  • Populate or refresh Teradata tables using TPT – Fast load, Multi load & Fast export utilities for user acceptance Used SSIS and T-SQL stored procedures to transfer data from source databases to staging area and finally transfer into data warehouse.
  • Extensively used the Teradata utilities like BTEQ scripts, MLOAD and FLOAD scripts to load the huge volume of data.
  • Designing the SCD type1 and type2 mappings and key fact tables. Also designed and developed code set tables that will assist the dimension tables.
  • Create Deployment Scripts for production with Rollout/Rollback Instructions

Minimum Qualification: This position requires minimum of Bachelor s degree in computer science, computer information systems, information technology, or a combination of education and experience equating to the U.S. equivalent of a Bachelor s degree in one of the aforementioned subjects.

Apply Online