Job Description

-
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 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.