Outscal Logooutscal logo

ETL Developer, SME

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

Job Summary

Job Description

AVER is seeking an ETL Developer, SME to support development, testing, and deployment of Informatica ETL solutions. Responsibilities include utilizing Informatica PowerCenter, developing requirements, assisting with system improvements, enhancing data processing with Informatica and Data Lake Pipelines, providing Informatica administration, solving data integration requirements, testing ETL solutions, optimizing ETL processes, improving collaboration between business data owners and the Informatica team, automating workflows, and implementing Informatica best practices. The role requires experience with structured and unstructured data, Informatica PowerCenter development and administration on Linux, upgrades/patches, production job support, REST APIs, JSON, Python & Unix Shell scripting, SQL, PL/SQL, and PowerShell. The candidate will provide weekly status updates and other reporting as needed. This is a remote position supporting a government agency requiring U.S. citizenship and Public Trust clearance.
Must have:
  • 10+ years Informatica ETL experience
  • Informatica PowerCenter development & testing
  • Informatica PowerCenter administration on Linux
  • SQL, PL/SQL, PowerShell
  • REST API, JSON, Python & Unix Shell scripting
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 ETL Developer, 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

Paytm - DevOps - Lead DevOps

Paytm

Noida, Uttar Pradesh, India (Hybrid)
5 Months ago
ByteDance - Site Reliability Engineer, Traffic Infrastructure

ByteDance

Singapore (On-Site)
4 Months ago
ByteDance - Site Reliability Engineer (Cloud) - Infrastructure Engineering

ByteDance

Singapore (On-Site)
4 Months ago
Zeta - Senior Site Reliability Engineer

Zeta

Bengaluru, Karnataka, India (On-Site)
5 Months ago
Saviynt - Technical Lead, Professional Services

Saviynt

Atlanta, Georgia, United States (Remote)
5 Months ago
Inkittt - Product Analyst

Inkittt

San Francisco, California, United States (Hybrid)
1 Month ago
Hero Gaming - Business Intelligence Developer

Hero Gaming

Marbella, Andalusia, Spain (On-Site)
1 Day ago
SuperPlay - Senior Game Economist

SuperPlay

Tel Aviv District, Israel (On-Site)
18 Hours ago
Warner Bros Games - Senior Data Engineer

Warner Bros Games

Atlanta, Georgia, United States (Hybrid)
1 Month ago
Miniclip - Senior Analytics Engineer

Miniclip

Lisbon, Lisbon, Portugal (On-Site)
2 Days ago

Get notifed when new similar jobs are uploaded

Similar Skill Jobs

PwC - ETIC-Data Testing-Senior Associate

PwC

Cairo, Cairo Governorate, Egypt (On-Site)
5 Months ago
Nielsen Holdings - Sr. Data Engineer - (Big Data, Spark, Scala, Python, AWS, RDBMS, SQL) (copy)

Nielsen Holdings

Bengaluru, Karnataka, India (Hybrid)
5 Months ago
Wolters Kluwer - Lead Product Software Engineer -  Lead Cloud Data Engineer

Wolters Kluwer

Coppell, Texas, United States (Hybrid)
5 Months ago
ByteDance - Student Researcher (Doubao (Seed) - Foundation Model - Speech & Audio) - 2025 Start (PhD)

ByteDance

Seattle, Washington, United States (On-Site)
4 Months ago
ByteDance - Research Scientist, Foundation Model, Speech & Audio

ByteDance

Seattle, Washington, United States (On-Site)
4 Months ago
Saviynt - Technical Lead, Field Engineering

Saviynt

Bengaluru, Karnataka, India (Hybrid)
5 Months ago
NVIDIA - Senior Performance Software Engineer

NVIDIA

Taipei City, Taiwan (On-Site)
2 Months ago
prizepicks - Senior Back End Engineer

prizepicks

(Remote)
1 Week ago
Warner Bros Games - Staff Software Engineer - DevOps

Warner Bros Games

Bengaluru, Karnataka, India (Hybrid)
3 Weeks ago
ION - Principal Technical Consultant - Endur

ION

London, England, United Kingdom (On-Site)
5 Months ago

Get notifed when new similar jobs are uploaded

Jobs in United States

Salesforce - Sales Development Representative (New Grad)

Salesforce

Illinois, United States (On-Site)
2 Weeks ago
Nagarro - Principal Engineer - Senior Salesforce Architect

Nagarro

Boston, Massachusetts, United States (Hybrid)
4 Months ago
Second Dinner - Senior Software Engineer II, Backend

Second Dinner

United States (Remote)
6 Days ago
Sony Pictures Animation - Production Coordinator - Features

Sony Pictures Animation

Los Angeles, California, United States (On-Site)
1 Day ago
Meta - ASIC Engineer, Design Verification

Meta

Austin, Texas, United States (Remote)
4 Months ago
Onward Search - Inside Sales Representative

Onward Search

Cranbury, New Jersey, United States (On-Site)
2 Days ago
Windranger Labs - Senior Fullstack Engineer

Windranger Labs

El Paso, Texas, United States (Remote)
1 Day ago
The Walt Disney Company - Senior Secretary, Development

The Walt Disney Company

Burbank, California, United States (On-Site)
2 Days ago
The Walt Disney Company - Senior Software Engineer - Scala

The Walt Disney Company

New York, New York, United States (On-Site)
1 Month ago
Twitch - Senior Manager - Corporate Communications

Twitch

San Francisco, California, United States (On-Site)
6 Days ago

Get notifed when new similar jobs are uploaded

Data Analyst Jobs

PwC - Senior Associate_Snowflake Developer_Data & Analytics_Advisory_PAN  India

PwC

Kolkata, West Bengal, India (On-Site)
5 Months ago
Google - Data Scientist, Extended Workforce Solutions

Google

Hyderabad, Telangana, India (On-Site)
3 Months ago
Luxoft - Senior Data Ops Engineer

Luxoft

(Remote)
4 Months ago
Varonis  - BI Developer

Varonis

Herzliya, Tel Aviv District, Israel (On-Site)
4 Months ago
Riot Games - Principal Analytics Engineer - Product Insights

Riot Games

Los Angeles, California, United States (On-Site)
2 Days ago
Communix - Business Analyst

Communix

Tel Aviv-Yafo, Tel Aviv District, Israel (On-Site)
1 Day ago
ION - Junior Consultant - Risk Advisory, Italy

ION

Milan, Lombardy, Italy (On-Site)
5 Months ago
Google - Senior Data Insights Lead, People with Disabilities

Google

São Paulo, State Of São Paulo, Brazil (On-Site)
3 Months ago
PwC - Manager-Data Engineer|Pune

PwC

Pune, Maharashtra, India (On-Site)
5 Months ago
Meta - Marketing Science Partner (Financial Services)

Meta

Menlo Park, California, United States (On-Site)
4 Months ago

Get notifed when new similar jobs are uploaded

About The Company

United States (Remote)

United States (Remote)

United States (Remote)

United States (Remote)

United States (Remote)

United States (Remote)

United States (Hybrid)

United States (Hybrid)

United States (On-Site)

United States (On-Site)

View All Jobs

Get notified when new jobs are added by AVER LLC

Level Up Your Career in Game Development!

Transform Your Passion into Profession with Our Comprehensive Courses for Aspiring Game Developers.

Job Common Plug