Data Integration and Management: Utilize Informatica R360 and IICS to design, develop, and implement data integration solutions. Integrate data from various sources, both on-premises and in the cloud, to ensure data accuracy and consistency. Design and implement ETL (Extract, Transform, Load) processes to move and transform data. Identify and resolve data quality issues, perform data cleansing and standardization. Ensure compliance with data governance and security policies. PL/SQL Development: Develop and maintain PL/SQL code to support data integration and management processes. Create and optimize database structures, tables, views, stored procedures, and functions. Conduct performance tuning activities on PL/SQL code and database queries to enhance system performance. Collaborate with developers and business analysts to understand data requirements and translate them into PL/SQL solutions. Workflow and Job Management: Design, build, and schedule workflows and jobs using Informatica R360 and IICS. Manage dependencies and dependencies between various workflows and jobs. Troubleshoot and resolve issues related to job failures, data validation, and data processing errors. Documentation and Collaboration: Create and maintain technical documentation, including data integration workflows, data dictionaries, and data lineage. Collaborate with cross-functional teams to gather data integration requirements and propose appropriate solutions. Provide technical guidance and support to team members and stakeholders. Participate in meetings and communicate project progress, challenges, and recommendations.

Requirements:

Proven experience in Informatica R360, IICS, and PL/SQL development. Strong understanding of data integration concepts and methodologies. Solid knowledge of relational databases, SQL, and database performance optimization. Experience in data cleansing, transformation, and handling data quality issues. Familiarity with cloud-based data integration and ETL tools. Excellent problem-solving skills and attention to detail. Effective written and verbal communication skills. Ability to work collaboratively in a team environment. Data Integration and Management:Utilize Informatica R360 and IICS to design, develop, and implement data integration solutions.Integrate data from various sources, both on-premises and in the cloud, to ensure data accuracy and consistency.Design and implement ETL (Extract, Transform, Load) processes to move and transform data.Identify and resolve data quality issues, perform data cleansing and standardization.Ensure compliance with data governance and security policies.PL/SQL Development:Develop and maintain PL/SQL code to support data integration and management processes.Create and optimize database structures, tables, views, stored procedures, and functions.Conduct performance tuning activities on PL/SQL code and database queries to enhance system performance.Collaborate with developers and business analysts to understand data requirements and translate them into PL/SQL solutions.Workflow and Job Management:Design, build, and schedule workflows and jobs using Informatica R360 and IICS.Manage dependencies and dependencies between various workflows and jobs.Troubleshoot and resolve issues related to job failures, data validation, and data processing errors.Documentation and Collaboration:Create and maintain technical documentation, including data integration workflows, data dictionaries, and data lineage.Collaborate with cross-functional teams to gather data integration requirements and propose appropriate solutions.Provide technical guidance and support to team members and stakeholders.Participate in meetings and communicate project progress, challenges, and recommendations.

Requirements:

Proven experience in Informatica R360, IICS, and PL/SQL development.Strong understanding of data integration concepts and methodologies.Solid knowledge of relational databases, SQL, and database performance optimization.Experience in data cleansing, transformation, and handling data quality issues.Familiarity with cloud-based data integration and ETL tools.Excellent problem-solving skills and attention to detail.Effective written and verbal communication skills.Ability to work collaboratively in a team environment.