Deploy mappings that will run in a scheduled, batch, or real-time environment. 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 As per business requirements perform thorough data profiling with multiple usage patterns, root cause analysis and data cleansing and develop scorecards utilizing Informatica, Excel and other data quality tools Develop "matching" plans, help determine best matching algorithm, configure identity matching and analyze duplicates Build complex profiles and scripts to execute and test mappings and workflows to implement data stewardship and exception processing Build human task workflow scenarios and IDQ scorecards to support data remediation Run data quality specific ETL jobs (address standardization and validation, email cleanups, name cleanup, parsing, etc.
utilizing IDQ and other ETL tools Serve as the primary resource to team members and data stewards for training, problem resolution, data profiling etc.
Analyze and provide data metrics to management in order to help prioritize areas for data quality improvement Participate in improvement of master data management process and support transactional systems and processes Good knowledge on writing shell-scripts to invoke mappings or workflows Proficient at writing SQL queries and verifying the results Should be familiar in migrating objects from IDQ to PowerCenter or other Informatica tools Should be familiar in deploying and validating objects to different environments Good at writing test scenarios, performing unit testing, and verifying the end results with business requirements Perform both record-level and large-scale manual additions, adjustments and corrections to continuously ensure overall data quality and integrity Assist with special projects or ad-hoc reviews as needed Write code for complex system designs.
Write programs that span platforms. Code to and / or create Application Programming Interfaces (APIs) Review code developed by other Developers and provide input to and drive programming standards Consult with other Developers, Business Analysts, Systems Analysts and Project Managers Document what has to be migrated.
Job Segment Database, Developer, Information Technology, Programmer, SQL, Technology