About the job
Job Title: Informatica Cloud Consultant
Location: Santa Clara, CA
Duration: Long Term
Job Description:
- Remap Informatica Cloud connectors from SQL Server to AWS Aurora DB.
- Collaborate with users and business Subject Matter Experts (SMEs) to establish technical specifications for migration.
- Document migration requirements and technical specifications thoroughly.
- Champion and implement Informatica development best practices.
- Collaborate with business analysts and process owners to create test cases and scripts.
- Develop and modify mappings in Informatica Cloud.
- Provide post-deployment support and resolve defects as they arise.
- Experience with Agile/Scrum methodologies is preferred.
- Possess excellent oral and written communication skills.
- Experience integrating cloud sources such as Salesforce with Informatica ON CLOUD, alongside strong SQL development skills using MySQL.
- Familiarity with AWS Aurora DB is a plus.
- 5+ years of experience with Informatica PowerCenter.
- 2+ years of experience with Informatica Cloud.
- 5+ years of experience in developing ETL processes in a Data Warehouse environment using Informatica PowerCenter.
- 2+ years of experience in creating jobs and mappings in Informatica Cloud for Cloud Application Data Replication/Extractions or Data Integration.
- 5+ years of experience in SQL development, including Stored Procedures, Functions, and Data Modeling.
- 5+ years of experience in Unit Testing and Data Testing.
- Strong understanding of Data Warehouse and Business Intelligence concepts.
- Proficient in troubleshooting data issues.
- Comprehensive understanding of the Software Development Life Cycle (SDLC).
- Strong teamwork and problem-solving abilities are essential.
- Experience with AWS, Aurora MySQL, CloudFormation, and DevOps setup is preferred.
- Familiarity with BI Tools such as MicroStrategy is a plus.
