IICS ETL Lead


Job Description IICS ETL Lead Onsite Implementation: Bahwan CyberTek Location: Cambridge, MA (Right now remote)
Job Description :
Ability to define and design the best architecture to install Informatica Intelligent Cloud Services (IICS) Secure Agent components and subsystems for a multi-server platform capable of scaling with growing number of components and applications
• Proven ability to architect and build high volume, mission critical cloud native applications.
• Demonstrated success in building RESTful API Integration using IICS.
• Strong understanding across Cloud and infrastructure components (server, storage, network, data, and applications) to deliver end to end Cloud Infrastructure architectures and designs.
• Experience in IICS Application Integration components like Processes, Service Connectors and process object.
• Build Service connectors for Real Time integration with Third party applications.
• Build Business Services using JSON file to call web services.
• Experience in Integrating Informatica cloud with other applications like Salesforce, Workday, ServiceNow
• Experience in installing Add-on connectors and drivers for IICS
• Expertise in using methodologies for data extraction, transformation and loading data using various transformations like Expression, Router, Filter, Lookup, Update Strategy, Union, and Aggregator.
• Strong technical experience building data integration processes by constructing mappings, tasks, taskflows, schedules, and parameter files.
• Ability to write scripts for File watching and File transfer protocols.
• Experience leveraging and writing architectural patterns, best practices and guidelines for enterprise applications.
• Experience in RDMBS (SQL Server, Oracle), including complex SQL constructs and DDL generation.
• Strong knowledge on either DOS scripting or Shell scripting.
• Communicate project status with management
• Ability to learn new technology and quickly adapt to technology changes
• The qualified candidate will display excellent problem solving, analytical, communication, coordination and task management.
Skills Qualifications
• 3 years of hands on experience with Informatica IICS
• 5 years of hands on experience with Informatica PowerCenter
• Extensive experience working with various data sources (SQL and Oracle database, flat files (csv, delimited), Web API, XML,
• Advanced SQL skills required. Solid understanding of relational databases and business data; ability to write complex SQL queries against variety of data sources (OLTP, Data Warehouse) .
• Knowledge of Informatica Architecture
• User interface design skills working knowledge of data modeling (conceptual, logical and physical) as well as database design
• Solid experience with Business Intelligence/Analysis and Data Warehousing
• Solid understanding of relational and dimensional data models

Job Requirements:
  • Prepare test cases and test plans
  • Producing test plans and test cases
  • Writing test cases/scripts, test case automation and test execution
  • Prepare test strategy and design test cases
  • Drive test execution of application/function test cases
  • Execute test cases based on the release test plan
  • Translate requirements to test scenarios and test cases
  • Assisting test automation, automated test execution, creation of test cases, and exploratory testing
  • Maintain test automation frameworks and test cases
  • Assist in the development of test related documentation to include test strategies, test plans, test cases, test scripts and reports
  • Created test cases and other testing artifacts
  • Review all test plans and test results
  • Develop automation test cases in order to test repeatable processes
  • Converting business requirements to test cases
  • Identify and develop test scenarios and/or test cases
  • Use cases and testing requirements
  • Manage testing workload against testing requirements
  • Identify and manage test cases for automation
  • Develop and improve test plans, test cases, execution reports, and design documentation for test automation
  • Maintain regression test suites and other test case repositories
Posted
01/06/2022
Type
Full time
Salary Range
$93,000.00 - 144,000.00
per Year
Salary range estimated by
Location
Cambridge, MA 02140, US
Apply Now