Giga Giglet – Tech Jobs & Career Updates in the U.S.: immediate opening for -Informatica ETL Developer

Hi,

Greetings from Ampstek

We do have openings for Informatica ETL Developer - Nashville, TN please review the JD and share me your interest

NO OPT (Passport number is mandatory )

Title: Informatica ETL Developer

Location: Nashville, Tennessee

Duration: Long Term Contract

Job Responsibility:

· To have Strong 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 the 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

Thanks & Regards

Maya

Technical Recruiter

Email: maya@ampstek.com

contact no: 609-681-5818(D)