DescriptionAVER is seeking an Informatica Developer to support the design, development, testing, and implementation of a technical solution to extract data from hundreds of source tables, separating the data by Department of Homeland Security (DHS) Component, and load data into a target data schema. This effort is part of a larger implementation of a new COTS-based Enterprise Resource Planning (ERP) system for a complex Financial Systems Modernization (FSM) program. As part of our team, you'll be a strategic thinker, data developer/analyzer, and play a vital role in driving change.
Responsibilities Include:
- 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
Education Requirements:
- Bachelor's degree in Data Science, Statistics, Computer Science, Information Systems or a related field
Experience Requirements:
- 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
Desired Requrements:
- 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
Location:
- Washington, DC
- REMOTE, ad hoc on site maybe required per client
Security Requirements:
- Ability to obtain and maintain government clearance (Public Trust)
- This role supports a government agency which requires U.S. citizenship
Compensation Package:
At AVER, we believe our people are the foundation of our success and are committed to providing meaningful work, competitive compensation, and a supportive environment where employees can grow while making a direct impact on critical Government missions. AVER offers a competitive total compensation package designed to support our employees both professionally and personally. Eligible employees receive a comprehensive benefits package that includes health and wellness coverage, paid time off and holidays, retirement benefits, and opportunities for career growth.
Target Salary: $115,000.00 - $130,000.00 /yr
