Create/maintain the data architecture to increase the robustness, performance, and scalability of systems. Provide oversight and direction for the design and development of the data infrastructure. Responsible for the development of logical data models and semantic data layer(s) needed to support business and analytic requirements. Maintain quality of data in the application systems ensuring: integrity of data, the correction of any data problems, data currency, and the established design procedures to purge/archive old data. Participate in the data governance program. Create streamlined, scalable integration solutions to support downstream environments. Track progress and communicate effectively with key stakeholders to ensure successful completion of the project within targeted time, cost, and quality. Interact with business partners, 3rd party vendors to highlight the right information, risks, open issues, and the impact on data architecture related projects. Experience with relational databases and knowledge of query tools and/or statistical software required. Experience in ANSI-SQL.Proficient Data modeling tools like ERWIN or ER Studio. (more…)
The Informatica Administrator will be a member of an ETL Administration team responsible for fulfilling a combination of production support and Informatica application administration tasks. The Informatica Administrator will work individually and as part of the team to render Informatica Administration support for the activities rendered by the program. The production support position will utilize knowledge of the Informatica ETL tool and the associated program environment.
Design, Develop and Provide support in all aspects of data movement for a data warehouse environment residing on Netezza, with emphasis on the Extract-Transform-Load (ETL) process using Informatica. • Ability to administer ETL system and upgrade to new releases • Develop data warehouse process models, including sourcing, extracting, transforming and loading as per business requirements. • Design Extract-Transform-Load (ETL) Workflows for data migration from various sources to data warehouse using batch or incremental loading strategies. • Document database design including data modeling, metadata and business process flow for the new business integration requirements. • Create data model and reverse engineer data warehouse using CASE tools like ER Studio. (more…)