Senior Software Engineer

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.

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

1. 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.
2. 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.
3. 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.
4. 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.

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