Informatica MDM Developer/Tester (5-7 yrs)

Responsibilities :

- Design, develop, and implement complex ETL processes using Informatica PowerCenter to extract, transform, and load data from diverse sources into an Oracle data warehouse.

- Perform advanced PL/SQL development for data manipulation, transformation, and validation.

- Optimize Oracle database performance through SQL and PL/SQL tuning, indexing, and query optimization.

- Conduct thorough data analysis to understand data sources, identify data quality issues, and support new project definitions and designs.

- Troubleshoot and resolve performance bottlenecks and data integrity issues in existing ETL processes.

- Perform Informatica Server administration tasks, including monitoring, tuning, and troubleshooting.

- Work with Solaris operating systems in relation to database and application development.

- Design, develop, and configure Informatica MDM solutions to create and maintain a single, accurate view of critical business data.

- Develop and implement data matching, merging, and cleansing rules within Informatica MDM.

- Create and maintain MDM data models, hierarchies, and relationships.

- Conduct comprehensive testing of MDM configurations, including unit testing, integration testing, and performance testing.

- Develop and execute test plans and test cases to ensure data quality and system functionality in the MDM environment.

- Perform data profiling and data quality analysis to identify and resolve data inconsistencies and duplicates.

- Collaborate with business stakeholders to gather requirements and translate them into effective MDM solutions.

- Document MDM configurations, processes, and test results.

- Work independently or as part of a team to deliver data warehouse ETL and MDM projects within defined timelines and budgets.

- Provide technical guidance and mentorship to junior team members.

- Participate in code reviews and ensure adherence to coding standards and best practices. -

- Stay up-to-date with the latest advancements in data integration and master data management technologies. -

- Communicate effectively with stakeholders, including business users, developers, and project managers.

Qualifications :

- Bachelor's degree in Computer Science, Information Technology, or a related field.

- Minimum of 5+ years of experience in ETL development using Informatica PowerCenter.

- Strong proficiency in PL/SQL and Oracle Database development and tuning.

- Proven experience in Informatica MDM development and testing.

- Experience with Solaris operating systems.

- Solid understanding of data warehousing concepts and methodologies.

- Excellent analytical and problem-solving skills.

- Strong communication and collaboration skills.

- Experience with data profiling and data quality tools.

- Experience with test plan and test case creation and execution.

Preferred Qualifications :

- Informatica MDM certification.

- Experience with other data integration and MDM tools.

- Experience with cloud-based data warehousing and MDM solutions.