Amazon Web Services (AWS), Case Management, Cloud Computing, Computer Science, Cross-Functional, Data Mapping, Data Migration, Database Extract Transform and Load (ETL), Identify Issues, Informatica, Java, Maintain Compliance, Microsoft SQL Server, Multiplatform/Cross-Platform, Oracle, Oracle Database, PostgreSQL, Reconciliation, Relational Databases (RDBMS), Salesforce.com, Systems Engineering, Test Plan/Schedule, Time Management
Junior ETL Developer
Location: Washington, DC (Remote)
Duration: 11 months
Day to Day Responsibilities:
- Support data migration and integration for a cloud-based case management platform using Pega, AWS, Informatica, and relational databases.
- Design, develop, test, and execute ETL processes to migrate data from legacy Oracle and Microsoft SQL Server environments into Pega-based applications.
- Support integrations across platforms such as MuleSoft and Salesforce.
- Work closely with cross-functional teams to deliver migration activities on schedule while ensuring compliance with PGLD and RIM requirements.
Must Have:
- Hands-on experience with Oracle, PostgreSQL, and SQL Server.
- Strong understanding of data mapping, validation, reconciliation, and troubleshooting.
- Familiarity with Java-based applications and services.
- Bachelor's degree in Computer Science, Information Systems, Engineering, or a related field.
- Federal or regulated-environment experience is preferred.
Education:
- Bachelor's degree and 2 year of experience required.