Remote Informatica Developer - Data Integration

Aver, Llc; Washington (District of Columbia); Remoto; USD 115.000 - 130.000; Tempo pieno

Descrizione del lavoro

AVER, LLC is seeking an Informatica Developer to design, develop, test, and implement data extraction from hundreds of source tables, loading into a target data schema as part of our DHS-centric FSM ERP modernization program.

You will collaborate with cross-functional teams, run SQL in AWS Postgres, create Power BI visuals, and apply Agile practices with Jira while supporting federal government customers from Washington, DC, with remote/ad hoc on-site per client needs.

Competenze

• 3+ years of experience in SQL, data extraction, loading, migration, analysis, and conversion
• 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 working with government systems (i.e., SharePoint, ServiceNow) and stakeholders
• Excellent communication, organizational, analytical, and problem-solving skills
• Prior experience supporting Federal government customers

Mansioni

• Extract and load data 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

Conoscenze

SQL

Informatica Power Center

Informatica Developer

Power BI

PostgreSQL

Jira

Data visualization

Formazione

Bachelor's degree (Data Science, Statistics, CS, IS or related)

Strumenti

AWS Postgres

Descrizione del lavoro

AVER, LLC is seeking an Informatica Developer to design, develop, test, and implement data extraction from hundreds of source tables, loading into a target data schema as part of our DHS-centric FSM ERP modernization program.

You will collaborate with cross-functional teams, run SQL in AWS Postgres, create Power BI visuals, and apply Agile practices with Jira while supporting federal government customers from Washington, DC, with remote/ad hoc on-site per client needs.