Location: Remote
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 Education Requirement: 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 subject.