Job details
Job type full-time
Full job description
Anika systems is looking for a passionate and talented etl developer to join our expanding federal teamWe are a fast-growing woman-owned small business providing innovative it solutions for federal, state, and civil government agenciesThis opportunity will be 100% remote.
Responsibilities:
Leads etl design and development of new or changing mappings and workflows with the team and prepares technical specifications.
Creates etl mappings, mapplets, workflows, and worklets using informatica powercenter 10.x and prepares corresponding documentation.
Performs source system analysis and implements versioning of the etl repository and supporting code as necessary.
Develops database triggers and sql queries as needed, utilizing industry best practices and sql tuning for optimization.
Supports back-up, recovery, and continuity plans to restore capability use and outputs within slas.
Requirements:
Bachelor’s degree and 3-5 years of experience with informatica, or equivalent education and experience
Significant experience using informatica’s b2b data transformation application
Experience designing and building on-prem data integrations with powercenter and connectors (powerexchange) with database and mainframe integration experience required
Informatica powercenter 10.x and connectors (powerexchange) – expert level
Informatica b2b data transformation application – advanced level
Sql – advanced level
Knowledge of linux shell scripting and ibm’s data studio is preferred
Us citizenship or green card required to obtain clearance
Eoe aa/m/f/vet/disability
Kkomqcwha2
