Description

You will design and implement data integration solutions to load critical business data into Salesforce.

Responsibilities

• Create Informatica mappings using Oracle database objects to facilitate data loads into Salesforce.
• Develop and manage connections to retrieve data from diverse source systems.
• Participate in all SDLC phases, including requirements gathering, architecture design, development, testing, and data migration.
• Troubleshoot and analyze error logs and job results to resolve data issues.
• Document implementation instructions, data flow diagrams, and operational procedures for production deployments.
• Support off-hours production deployments to assist the DevOps team with ETL code issues.

Required Skills

• 5-7 years of ETL experience specifically using Informatica IICS.
• 5-7 years of practical SQL experience on relational databases.
• Strong proficiency with Oracle database objects and troubleshooting.
• Experience importing and exporting objects using IICS.
• Ability to analyze and resolve complex data issues within relational databases.
• Professional English communication skills, both written and spoken.
• Bachelor's degree or equivalent graduate level education.

Preferred Skills

• Experience with Salesforce Developer Console and SOQL.
• Proficiency with Salesforce Data Loader and promoting code between environments.
• Knowledge of data modeling, business reporting, and Microsoft Excel.
• Experience with MSDOS batch files for IICS job conditions and IICS server configurations.

Key Skills

Education

Any Gradute