Informatica Consultant

Comtech LLC

Santa Clara (CA)

On-site

USD 120,000 - 150,000

Full time

14 days+

Get more replies from employers

Send a job-specific resume in minutes.

Job summary

A tech solutions provider in Santa Clara, CA is seeking an experienced Informatica Cloud Consultant. The role involves remapping Informatica on cloud connectors and working with business users to define technical specifications for migration projects. Candidates should have over 5 years of experience with Informatica PowerCenter and strong skills in SQL development, AWS, and cloud integration. Excellent communication and teamwork abilities are essential. This is a long-term position offering opportunities for professional growth.

Qualifications

5+ years of experience with Informatica PowerCenter and 2+ years with Informatica Cloud.
Strong understanding of Data Warehouse and Business Intelligence concepts.
Excellent communication skills, both oral and written.

Responsibilities

Remap Informatica on cloud connectors from SQL server to AWS Aurora DB.
Work with users to define specifications and documentation.
Promote Informatica development best practices and provide post-deployment support.

Skills

Informatica ON CLOUD experience

Strong SQL development skills

5+ years of experience with Informatica PowerCenter

2+ years of experience with Informatica Cloud

5+ years of experience developing ETL processes

Experience with AWS Aurora DB

Excellent oral and written communication skills

Strong teamwork and problem solving abilities

Tools

AWS

Microstrategy

Job description

Comtech is a woman-owned small business founded in 1998 and headquartered in Reston, VA. We offer IT solutions across the disciplines of program/project management, applications development, infrastructure, Cyber security, and enterprise content/data management services. We have developed our methodologies and processes based on the IT Infrastructure Library (ITIL) v.3 Framework across enterprise infrastructure operations. These methodologies and processes are reinforced through our organization’s externally accredited certifications, which include ISO 9001:2008 Quality Management System (QMS), ISO/IEC 20000-1:2011 IT Service Management Systems (SMS, corporate ITIL certification), ISO 27001:2005 Information Security Management System (ISMS), and CMMI-DEV Level 3"

Job Description

Job Title: Informatica Cloud Consultant

Job location: Santa Clara, CA

Duration: Long Term

Job Description:

Require to remap Informatica on cloud connectors from SQL server to AWS Aurora DB
Work with users and business SMEs to define technical specifications to develop migration
requirements, and technical documentation
Promote and apply Informatica development best practices
Work with business analysts and process owners on the development of test cases and script
Develop/Modify Mappings in Informatica Cloud
Post deployment support and defect resolutions
Experience with Agile/Scrum methodology
Excellent oral, written communication and presentation skills
Informatica ON CLOUD experience integrating Cloud sources such as SFDC, Strong SQL development skills using MySQL
Experience on AWS Aurora DB would be an advantage
5+ years of experience with Informatica PowerCent
2+ years of experience with Informatica Cloud
5+ years of experience developing data integration (ETL) processes in a Data Warehouse environment using Informatica PowerCente
2+ years of experience building jobs, mappings in Informatica Cloud for Cloud Application Data Replication/ Extractions or Data Integration
5+ years of experience with SQL development, Stored Procedures, Functions and Data Modeling
5+ years of experience in Unit Testing, Data Testing
Strong understanding of Data Warehouse and Business Intelligence concept
Strong understanding of the Software Development Life Cycl
Excellent oral and written communication skill
Strong teamwork and problem solving abilities
Experience in AWS, Aurora MySQL, Cloud formation, DevOps set up (Preferred)
Experience with BI Tools – Microstrategy (Preferred)