Informatica SME
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