ETL Informatica Developer

AVER, LLC is seeking an ETL Informatica Developer to support a Financial Systems Modernization program implementing a new COTS-based ERP system. The role focuses on extracting, transforming, validating, and loading data from source tables into a target schema, while supporting requirements, analysis, testing, and migration activities for DHS components.

Responsibilities

• Extract and load data using complex programming languages and using Informatica
• Collaborate with cross-functional teams to understand and support requirements sessions
• Develop SQL in AWS Postgres database queries
• Work with Lead Informatica Developer to develop strategies for extraction and load
• Work closely with analysts to ensure requirements are flushed out and ready for development
• Create data visualizations using Power BI
• Experience and a good understanding of Agile methodology and using Jira
• Coordinate with data owners to validate data (e.g., reconciling transaction details to summary records such as commitments and obligations to General Ledger (GL) balances)
• Prepare and assist with unit and end-to-end integration migration test plans (including testing for data extraction, transformation, data loading, and data validation)
• Support development of requirements, perform data analysis, and prepare data for data conversion activities

Preferred

• At least three years of experience using Informatica Intelligent Cloud Services (IICS)
• Experienced in supporting Federal SAP S/4 Hana business application development and data migration using a requirements-driven lifecycle process
• Informatica Intelligent Cloud Services (IICS)
• SAP S/4HANA Application Development
• Requirements-Driven Lifecycle Process

Benefits

• Eligible employees receive health and wellness coverage
• Eligible employees receive paid time off and holidays
• Eligible employees receive retirement benefits
• Eligible employees receive opportunities for career growth
• REMOTE, ad hoc on site maybe required per client

Company

• Federal government IT modernization and analytics services
• Washington, District of Columbia, USA
• https://avercg.com/
• 51-200 employees

Qualifications

• Bachelor's degree in Data Science, Statistics, Computer Science, Information Systems or a related field
• 3+ years of experience in SQL, data extraction, separation, loading, migration, analysis, and conversion activities
• 3+ years of experience using Informatica Power Center
• 3+ years of experience using Informatica Developer
• Experience in SQL server programming language
• Experience in data visualization using Power BI
• Experience with working in PostGres DB environment
• Experience using Power BI and SQL to run queries and perform analysis
• Experience working with government systems (i.e., SharePoint, ServiceNow) and stakeholders
• Excellent communication (verbal and written), organizational, analytical, and problem-solving skills
• Prior experience supporting Federal government customers
• Ability to obtain and maintain government clearance (Public Trust)
• This role supports a government agency which requires U.S. citizenship
• At least three years of experience using Informatica Intelligent Cloud Services (IICS)
• Experienced in supporting Federal SAP S/4 Hana business application development and data migration using a requirements-driven lifecycle process

Required skills

• Data Migration, Informatica Developer, Informatica Intelligent Cloud Services (IICS), Informatica PowerCenter, PostgreSQL, Power BI, Public Trust Clearance, SAP S/4HANA, SQL, SQL Server, ServiceNow, SharePoint

Experience

• 3+ years