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
• Create and enhance data solutions enabling seamless delivery of data and is responsible for collecting, parsing, managing and analyzing large sets of data across different domains for analysis.
• Use different Data warehousing concepts to build a Data warehouse for internal
  departments of the organization.
• Designs and develops data pipelines, data ingestion and ETL processes that are scalable,
  repeatable and secure for stakeholder needs.
• Build Data architecture to support data management strategies to support business
  intelligence efforts for various stakeholders.
• Leads the design of the logical data model and implements the physical database structure
  and constructs and implements operational data stores and data marts.
• Support deployed data applications and analytical models by being a trusted advisor to Data
  Scientists and other data consumers by identifying data problems and guiding issue
  resolution Data Pipeline Management.
• Develops real-time and batch ETL data processes aligned with business needs, manages and
  augments data pipeline from raw OLTP databases to data solution structures.
• Document’s data flow diagrams, security access, data quality and data availability across all
  business systems.

Minimum Education Requirement:

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.