*Description for Internal Candidates   Data Integration and ETL (Extract, Transform, Load): Utilize Informatica IICS to design, develop, and implement data integration solutions. Design and implement ETL processes to move and transform data between various systems and databases. Ensure data accuracy, consistency, and integrity during the integration process. Collaborate with stakeholders and business analysts to understand data requirements and translate them into effective ETL workflows. PL/SQL Development: Develop and maintain PL/SQL code to support database management, data processing, and reporting needs. Create and optimize database structures, tables, views, stored procedures, and functions using PL/SQL. Conduct performance tuning activities on PL/SQL code and database queries to enhance system performance. Collaborate with developers, database administrators, and business users to understand requirements and develop effective PL/SQL solutions. Shell Scripting and Automation: Create and maintain shell scripts to automate data integration, database management, and administrative tasks. Develop and maintain system-level scripts to support data processing, file manipulation, and job scheduling. Documentation and Collaboration: Create and maintain technical documentation, including data integration workflows, scripts, and database structures. Collaborate with cross-functional teams to gather requirements, propose solutions, and provide technical guidance. Participate in meetings and communicate project progress, challenges, and recommendations. Provide support, troubleshooting, and issue resolution to stakeholders and users.

Requirements:

Proven experience in IICS, PL/SQL development, and shell scripting. Strong understanding of data integration concepts, ETL methodologies, and database management. Proficiency in SQL and performance optimization techniques. Familiarity with scripting languages Knowledge of cloud-based data integration tools and technologies. 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 ETL (Extract, Transform, Load):Utilize Informatica IICS to design, develop, and implement data integration solutions.Design and implement ETL processes to move and transform data between various systems and databases.Ensure data accuracy, consistency, and integrity during the integration process.Collaborate with stakeholders and business analysts to understand data requirements and translate them into effective ETL workflows.PL/SQL Development:Develop and maintain PL/SQL code to support database management, data processing, and reporting needs.Create and optimize database structures, tables, views, stored procedures, and functions using PL/SQL.Conduct performance tuning activities on PL/SQL code and database queries to enhance system performance.Collaborate with developers, database administrators, and business users to understand requirements and develop effective PL/SQL solutions.Shell Scripting and Automation:Create and maintain shell scripts to automate data integration, database management, and administrative tasks.Develop and maintain system-level scripts to support data processing, file manipulation, and job scheduling.Documentation and Collaboration:Create and maintain technical documentation, including data integration workflows, scripts, and database structures.Collaborate with cross-functional teams to gather requirements, propose solutions, and provide technical guidance.Participate in meetings and communicate project progress, challenges, and recommendations.Provide support, troubleshooting, and issue resolution to stakeholders and users.

Requirements:

Proven experience in IICS, PL/SQL development, and shell scripting.Strong understanding of data integration concepts, ETL methodologies, and database management.Proficiency in SQL and performance optimization techniques.Familiarity with scripting languagesKnowledge of cloud-based data integration tools and technologies.Excellent problem-solving skills and attention to detail.Effective written and verbal communication skills.Ability to work collaboratively in a team environment.