Tech Stack
AWSCloudETLInformaticaOracleServiceNow
About the role
- Support a client in providing data integration capabilities and utilize ETL applications to develop a modernized transaction processing platform
- Enhance reporting capabilities for customer data flows and integrate a new customer portal for transaction transparency and efficient customer onboarding
- Design and builds relational databases
- Develop strategies for data acquisitions, archive recovery, and implementation of a database
- Work in a data warehouse environment, including data design, database architecture, metadata, and repository creation
- Translate business needs into long-term architecture solutions
- Define, design, and build dimensional databases
- Develop data warehousing blueprints, evaluate hardware and software platforms, and integrate systems
- Evaluate reusability of current data for additional analyses
- Review object and data models and the metadata repository to structure the data for better management and quicker access
Requirements
- US Citizenship
- Five (5) or more years relevant experience
- Experience working with modeling tools (e.g., ER/Win, Power Designer, ERStudio or other similar tools)
- Must possess IT-I Critical Sensitive security clearance or Tier 5 (T5)
- Experience preferred with: Informatica, Oracle B2B, Ab Initio, AWS GovCloud, Oracle Integration Cloud, ServiceNow, and/or Qlik