Software Development III

Open/Additional Info Client is seeking an Informatica Developer to design and develop application integrations via Informatica IDMC APIs using Cloud Application Integration (CAI) and Cloud Data Integration (CDI) services . The candidate should have strong SQL database query knowledge working with applications. The developer should also have thorough experience in developing IDMC REST API interfaces with CDI and CAI. The candidate should also have expertise with testing REST APIs using a software tool such as Bruno or an equivalent. Additionally, the candidate should also have a strong understanding of JSON data formatting. The developer should have expertise in building ETL/ELT mappings and workflows using CDI. The candidate should have experience loading a Data Warehouse and be knowledgeable with Star Schema and 3rd normal form design. The candidate will contribute throughout the data management lifecycle process areas such as data acquisition, management, manipulation, and implement integrations between SaaS vendors, on-premise applications, and the Enterprise Data Warehouse environment. Essential duties & responsibilities are: • Work with Informatica Tech Lead, IT database administrators, systems administrators, and data warehousing development teams • Support development, migration of data through Informatica IDMC API integrations, procedure development, troubleshooting, system configuration, security administration, and account setup. • Support the lifecycle of physical data models and data maps for data warehouse system. • Aid end users and programmers regarding data warehouse related problems and issues. • Provide technical expertise to end-users who create complex queries and reports. • Coordinate, schedule, and tests upgrades to the data warehouse system. Required Qualifications: • A minimum of a bachelor's degree coupled with 5+ years' experience in the information technology arena • 5+ years' experience in Enterprise Data Warehouse, Business Intelligence, analytic computing, data analysis, and pattern identification with various forms of data. • 3+ years' experience in Informatica IICS using REST/JSON/APIs. • 2+ years' experience with Oracle RDBMS, PL/SQL & SQL Server platforms • Excellent communication and organizational skills. • Ability to perform data analysis, troubleshoot data integrity issues and strong analytical/problem solving skills. Desired Qualifications: • Prior experience with Informatica IDMC prebuilt connectors with Salesforce • Experience in documenting and mapping interaction (source-to-target, source-to-ETL mapping) between business processes, information, and data for projects which are of medium to high complexity and moderate to high risk. • Experience with SaaS vendors such as Salesforce, Workday, Unanet • Experience with Snowflake • Familiarity with development methodology such as Agile, Waterfall and Systems Engineering Position Details: Pay Rate / Range: $65 - $75 The above salary range represents the range expected for the position; however, final salary offers are based on a number of factors such as the position's responsibilities; the candidate's experience, education, and skills; location; travel required; and current market conditions. This program requires US Citizenship Benefits (Regular, Full Time Employees): Medical, Dental, and Vision offerings Weekly Direct Deposit Paid Holidays and Personal Time Off 401(k) with match Voluntary Life and AD&D, Short / Long Term Disability, plus other voluntary coverages Pre-Paid Legal and Employee Assistance Programs Northwest Federal Credit Union Membership BB&T @ Work Program ABBTECH is an EOE/Minorities/Women/Disabled Individuals/Veterans