Informatica Developer

Informatica Developer Posted 5 years ago 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. Apply Online Attach Resume * Submit