Informatica Consultant

Informatica ConsultantComtech 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 DescriptionJob Title: Informatica Cloud ConsultantJob Location: Santa Clara, CADuration: Long TermJob Description:Require to remap Informatica on cloud connectors from SQL server to AWS Aurora DBWork with users and business SMEs to define technical specifications to develop migration requirements, and technical documentationPromote and apply Informatica development best practicesWork with business analysts and process owners on the development of test cases and scriptDevelop/Modify Mappings in Informatica CloudPost deployment support and defect resolutionsExperience with Agile/Scrum methodologyExcellent oral, written communication and presentation skillsInformatica ON CLOUD experience integrating Cloud sources such as SFDC, Strong SQL development skills using MySQLExperience on AWS Aurora DB would be an advantage5+ years of experience with Informatica PowerCent2+ years of experience with Informatica Cloud5+ years of experience developing data integration (ETL) processes in a Data Warehouse environment using Informatica PowerCente2+ years of experience building jobs, mappings in Informatica Cloud for Cloud Application Data Replication/ Extractions or Data Integration5+ years of experience with SQL development, Stored Procedures, Functions and Data Modeling5+ years of experience in Unit Testing, Data TestingStrong understanding of Data Warehouse and Business Intelligence conceptStrong Data Issue troubleshooting skillStrong understanding of the Software Development Life CycleExcellent oral and written communication skillStrong teamwork and problem solving abilitiesExperience in AWS, Aurora MySQL, Cloud formation, DevOps set up (Preferred)Experience with BI Tools – Microstrategy (Preferred)