Creating ETL mappings to extract data from multiple legacy systems;
Transforming and loading the data into the Enterprise Data Warehouse using Informatica;
Developing complex ETL programs using Informatica Power Center Transformations such as Informatica Aggregator, Sorter, Router, Filter, Joiner, Lookup, mapplet, SQL transformation, Stored Procedure and other transformations;
Setting up batches and work flow sessions to run these mappings;
Designing Informatica mappings and data model structural changes;
Designing and creating transformer models;
Developing and optimizing complex SQL programs and writing SQL queries, stored procedures, database triggers, cursors, database constraints, in-line views, PL/SQL records and tables;
Understanding business challenges and translating them into process/technical solutions;
Creating documents related to the ETL process; and
Producing change control documentation.
Bachelor’s Degree in Computer Science or a related technical field and 5 years of progressive experience in the job offered or a related role working in an Agile environment using Informatica Power Center, SQL Developer, SQL Server, PL/SQL, and SQL;
5 years of experience with either TFS or JIRA defect tracking tools; and
5 years of experience with either ESP or TIDAL scheduling tools.
Current assignment through Modis, Inc.’s Jacksonville, FL headquarters to a worksite in Omaha, NE, but must be willing to travel and/or relocate within commuting distance of various unanticipated worksites throughout the U.S. for long or short-term projects.