Informatica SME

Data Analytics United States


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