ETL Architect

Position :- ETL Architect Location:- CLEVELAND, Vermont (Remote) Proficiency with ETL tools like Informatica Power Center, Informatica Data quality Experience with the integration of data from multiple data sources. Must have worked in SAP source/target system in data Migration/Integration Profile source data and determine all source data and metadata characteristics; Design and execute a Data Quality Audit/Assessment. Design and execute the data quality mappings that will cleanse, de-duplicate, and otherwise prepare the project data Implement data quality processes including transliteration, parsing, analysis, standardization, and enrichment at point of entry and batch modes. Deploy mappings that will run in a scheduled, batch, or real-time environment. Analyze and provide data metrics to management to help prioritize areas for data quality improvement Participate in improvement of master data management process and support transactional systems and processes The Data Quality Lead (IDQ Lead) must document at a functional level how the procedures work within the data quality applications. Use Informatica Data Quality to profile the project source data, define or confirm the definition of the metadata, cleanse and validate the project data, check for duplicate or redundant records, and provide data-consuming parties with concrete proposals on how to proceed with solution development. As per business requirements, document all mappings, mapplets, and rules in detail and hand over documentation to the customer. Collaborate with various business and technical teams to gather requirements around data quality rules and propose the optimization of these rules if applicable, then design and develop these rules with IDQ Utilize Informatica Developer, Informatica Power Exchange, Informatica Metadata Manager, and Informatica Analyst to design and develop custom objects and rules, reference data tables and create/import/export mappings.