Informatica Administrator(Remote)

Position Informatica Administrator Location Remote Duration Long Term Top Must-Have Skills middot At least 8 to 10 years hands experience in Informatica ETL tools Informatica Engineer for Test Data Management Team (TDM) Required experience within Powercenter middot Sound knowledge understanding the relational databases bases
– Oracle ,Teradata, DB2 and SQL server middot Solid experience in Informatica workflow performance tuning and trouble shooting middot Experience writing Informatica workflows and guiding team members in project implementations middot Hands on experience using Informatica power center and database client tools i.e.

Toad and SQL developer Candidate Requirements middot Mainframe Data experience ndashVSAM and IMS file layouts
– Nice to Have middot Capability to develop complex SQL queries and ETL tool transformations logic middot Good understanding in writing regular expressions and database metadata definitions middot Writing automation shell scripts in add-on advantage middot Good understanding SDLC life cycle of Waterfall and Agile implementations middot Capable to prepare project estimations and release plans middot Good understanding HIPPA, PCI,PII and PHI compliance ndash sensitive data middot Good understanding in relational database ,data warehouse architecture and Logical design and dataflow diagrams middot Ability to prepare project Design artifacts and code review check lists middot Coordinate and manage onsite, offshore teams on project deliverable middot Some experience with IBM Optim to assist with conversions from one product to another middot Nice to have ndash experience with Imperva Camouflage DegreesCertificationsYears of Overall Experience Required middot High School Degree and Bachelor degree (computer science, software engineering, or relevant field) or equivalent work experience required.

middot 8+ years of experience required middot At least 8 to 10 years hands experience in Informatica ETL tools Day to Day Responsibilities middot Responsible for planning, discovery, design, development, and maintenance of test data using appropriate test data management tools and techniques.

middot This role will develop test data management strategies and plans to provide right sized, production like, reusable and secured test data per test data requirements middot Discover, generate, profile, transform, enrich, cleanse, extract, subset, mask, load, validate, refresh, reset, archive, purge test data and resolve defects of test data using Informatica Information Lifecycle Management (ILM), Test Data Management (TDM), automation tools and SQL scripts.

middot Implement the development of the test data management strategy and focus specifically on maximizing test data reuse, safety, initial state repeatability, profiling, catalog and versioning.

middot In designing test data management strategy, they will have a thorough understanding of data governance which subsets data quality, information life cycle management (data modelling, data development and admin), metadata, master data management and data security.

middot This role will implement the strategy via developing, coding and executing test data discovery, architecting, sub setting, masking, provisioning and maintenance solutions using automated test data architect, profiling, cleansing, validation, sub setting and privacy.

The post Informatica Administrator(Remote) first appeared on Oregon Job Market.

from Oregon Job Market https://ift.tt/3rfHGE8
via IFTTT