Informatica SME

1 Month ago • 10 Years + • Data Analyst • Administrative

Job Summary

Job Description

AVER is seeking an Informatica SME to support development, testing, and deployment of Informatica ETL solutions at an enterprise level. Responsibilities include utilizing Informatica PowerCenter, developing requirements, assisting with system improvements, enhancing data processing with Informatica and Data Lake Pipelines, providing Informatica administration and technical support, solving data integration requirements, testing ETL solutions, optimizing ETL processes, improving collaboration between business data owners and the Informatica team, automating workflows, and managing the Informatica repository and security. The role requires experience with structured and unstructured data, Informatica PowerCenter development and administration on Linux environments, REST API, JSON, Python & Unix Shell scripting, and SQL, PL/SQL, and PowerShell. The position is remote and requires US citizenship and the ability to obtain a Public Trust clearance.
Must have:
  • 10+ years Informatica ETL experience
  • Informatica PowerCenter development & testing
  • Informatica PowerCenter administration (Linux)
  • Experience with structured & unstructured data
  • SQL, PL/SQL, PowerShell, REST API, JSON, Python
Good to have:
  • Microsoft Data Factory
  • Informatica IDQ
  • Cloud migration experience

Job Details

Description

AVER is a fast-growing SDVOSB that has achieved significant revenue growth over the past 5 plus years with much of our work focused on Data Analytics, Mission Support, IT Modernization and Biometrics. AVER is seeking an Informatica SME, who is a technical expert to support development, testing, and deployment of Informatica Extract, Transform and Load (ETL) solutions at an enterprise level spanning application development, SharePoint, and data services. Join a collaborative team who values AVER’s mission, focus, and culture of delivering exceptional client service with great people and transformative technology solutions that ensure Government mission success.  
 
Responsibilities Include:   
  • Utilize three main components of the ETL product including Informatica PowerCenter, Informatica PowerCenter Repository, and Informatica PowerCenter Server
  • Develops requirements from a project's inception to its conclusion for a particular IT subject matter area
  • Assist project members with analysis and evaluation and with the preparation of recommendations for system improvements, optimization, development, and/or maintenance efforts across information systems architecture
  • Use databases and creates data modeling and changes to SQL statements in Oracle
  • Enhance data processing with Informatica and Data Lake Pipelines, improve data management with Oracle Exadata, SQL Server, and Azure SQL
  • Provide Informatica administration, and provide technical support of existing mappings
  • Solve existing and evolving data integration requirements using the Informatica tool set
  • Apply the correct ETL design to push data to required targets
  • Test Informatica ETL solutions and ensure data quality remains intact during any data transformation operation
  • Provide solutions to optimize ETL processes, mappings and functions to improve data quality, data security and data consistency
  • Improve the collaboration between business data owner and CIO Informatica team to enhance operational data integration
  • Automate web service Informatica workflows per project requirement
  • Provide a means for the Informatica Group to improve its ability to scale and support growing data volumes and workloads
  • Develop a plan for implementation of Informatica ETL best practices
  • Implement Informatica solutions to integrate and analyze metadata from disparate systems
  • Determine, document and develop a plan on how to manage the Informatica repository and Security Management at all levels including Informatica tool, repository and server
  • Execute performance tuning techniques at all levels of the Informatica installation
  • Assist the Quality Assurance team during testing and validation of ETL mappings within the Informatica environments
  • Plan and execute the transformation of data based on requirements using Informatica built-in transformations
  • Provide the ability within the Informatica tool set to access data from various heterogeneous sources including structured, unstructured and semi structured data source (RDBMS, XML, Flat Files, Legacy Applications, etc.)
  • Provide weekly status updates in a government-specified format and any other reporting/documentation needed per the government’s request
Education Requirements:  
  • Bachelor’s degree in Computer Science, Information Systems, or related field
 Experience Requirements:    
  • Informatica (ETL) SME with 10+ years of technical analysis experience, including the following skills:
  • Experience working with structured and unstructured data when extracting and loading data into targets
  • Experience in Informatica PowerCenter Development and Unit testing
  • Experience in Informatica PowerCenter administration on Linux environments
  • Experience in Upgrading/patch Informatica environment
  • Experience in support and trouble shoot the production jobs
  • Experience in REST API, JSON, Python & Unix Shell scripting
  • Experience in SQL, PL/SQL, PowerShell
 Desired Requirements:  
  • Experience as an Extract, Transform and Load (ETL) subject matter expert
  • Experience with Microsoft Data Factory
  • Experience with Informatica IDQ and Cloud migration preferred
Location:  
  • REMOTE (Local to Washington D.C.)
Security Requirements:  
  • Must be able to obtain and maintain a government clearance (Public Trust)
  • This role supports a government agency that requires U.S. citizenship
About Us: 
AVER, LLC is a Data & Digital Transformation company committed to delivering exceptional client service through the use of transformative technology solutions and a team of highly skilled professionals. Our focus is on enabling Government mission success in the domains of Homeland Security, Biometrics, Law Enforcement, and Healthcare. As a verified Service-Disabled Veteran-Owned Small Business (SDVOSB), we prioritize building trusted partnerships with our clients and people, providing a customer-centric experience.
 
AVER is an Equal Opportunity Employer/Veterans/Disabled  
 

Similar Jobs

Revolgy - Junior Cloud Ops Engineer (Intern)

Revolgy

(Remote)
3 Months ago
CloudLinux - Senior Python Developer with Security Expertise

CloudLinux

Sofia City Province, Bulgaria (Remote)
2 Weeks ago
ByteDance - Network Data Operations Engineer

ByteDance

Singapore (On-Site)
5 Months ago
RoofStack - Senior Platform Engineer

RoofStack

İstanbul, İstanbul, Türkiye (On-Site)
2 Months ago
Nielsen Holdings - Software Engineer (Java/Scala, SQL, AWS, Spark on Kubernetes)

Nielsen Holdings

Bengaluru, Karnataka, India (Hybrid)
5 Months ago
Meta - Marketing Science Partner (Financial Services)

Meta

San Francisco, California, United States (On-Site)
5 Months ago
Zazz - Data Engineer

Zazz

(Remote)
3 Months ago
Meta - Global Sales Analytics Lead

Meta

San Francisco, California, United States (Remote)
5 Months ago
Amanotes - Product Data Analyst

Amanotes

Ho Chi Minh City, Ho Chi Minh City, Vietnam (On-Site)
3 Weeks ago
GoMotive - Senior Applied Scientist

GoMotive

India (Remote)
3 Weeks ago

Get notifed when new similar jobs are uploaded

Similar Skill Jobs

Interactive Brokers - Senior Python Developer – Compliance Technology

Interactive Brokers

Mumbai, Maharashtra, India (Hybrid)
6 Months ago
CloudHire - Wordpress Full Stack Developer

CloudHire

Karnataka, India (Remote)
3 Weeks ago
Easybrain - Senior Data Engineer

Easybrain

Cyprus (On-Site)
9 Months ago
Next Level Business Services - MDM IDQ Developer/ Solution Architect - Full Time Only

Next Level Business Services

New York, New York, United States (On-Site)
5 Months ago
Rackspace Technology - Sr. Data Engineering Delivery Architect (Azure Data Services)

Rackspace Technology

United States (Remote)
5 Months ago
Epic Games - Senior DevOps Programmer

Epic Games

Montreal, Quebec, Canada (On-Site)
2 Weeks ago
NVIDIA - Senior Hardware Validation Engineer

NVIDIA

Canada (On-Site)
1 Month ago
Saviynt - Technical Lead, Professional Services - NA

Saviynt

Bengaluru, Karnataka, India (Hybrid)
5 Months ago
ByteDance - Student Researcher (Doubao (Seed) - Foundation Model - Speech & Audio) - 2025 Start (PhD)

ByteDance

Seattle, Washington, United States (On-Site)
5 Months ago
Payactiv - Database Developer

Payactiv

Milpitas, California, United States (On-Site)
6 Months ago

Get notifed when new similar jobs are uploaded

Jobs in United States

Next Level Business Services - Talend Developer

Next Level Business Services

Scottsdale, Arizona, United States (On-Site)
5 Months ago
ION - FX Implementation Specialists

ION

Boston, Massachusetts, United States (On-Site)
6 Months ago
ByteDance - Research Scientist Intern (Traffic Infrastructure Global Engineering)

ByteDance

San Jose, California, United States (On-Site)
2 Weeks ago
Nintendo - Intern - User Experience

Nintendo

Redmond, Washington, United States (On-Site)
5 Months ago
The Walt Disney Company - Dishwasher/Steward - Part Time

The Walt Disney Company

Florida, United States (On-Site)
2 Weeks ago
Xsolla - Director of B2C Marketing

Xsolla

Los Angeles, California, United States (Hybrid)
1 Month ago
Onward Search - Director of Accounting

Onward Search

Los Angeles, California, United States (Hybrid)
1 Month ago
The Walt Disney Company - Principal Product Designer

The Walt Disney Company

Glendale, California, United States (On-Site)
1 Month ago
Samsung Semiconductor - Staff Engineer, Embedded Firmware

Samsung Semiconductor

San Jose, California, United States (On-Site)
2 Weeks ago
InMobiInMobi - Sr. Sales Manager, Performance

InMobiInMobi

San Mateo, California, United States (On-Site)
3 Months ago

Get notifed when new similar jobs are uploaded

Data Analyst Jobs

ByteDance - Data Analyst - Corporate Information System

ByteDance

Singapore (On-Site)
2 Weeks ago
Epic Games - Data Engineer

Epic Games

London, England, United Kingdom (On-Site)
3 Months ago
Spyke Games - Data Scientist

Spyke Games

İstanbul, Türkiye (On-Site)
6 Months ago
ByteDance - Risk Data Analytics Business Partner - E-Commerce - Seattle

ByteDance

Seattle, Washington, United States (On-Site)
5 Months ago
Sporty Group - Senior Casino Business Insights Analyst

Sporty Group

(On-Site)
8 Months ago
ION - Data Associate - KYC6

ION

Budapest, Hungary (On-Site)
6 Months ago
Next Level Business Services - Markit EDM

Next Level Business Services

Pittsburgh, Pennsylvania, United States (On-Site)
5 Months ago
Epic Games - Data Analyst - Product Analytics

Epic Games

Montreal, Quebec, Canada (On-Site)
3 Months ago
Rackspace Technology - Data Engineer II

Rackspace Technology

Vietnam (Remote)
2 Weeks ago
Ubisoft - Fraud & Analyst Assistant Intern

Ubisoft

Paris, Île-de-France, France (On-Site)
3 Weeks ago

Get notifed when new similar jobs are uploaded