Data Architect

  • location: Rockville, MD
  • type: Temp to Perm
  • salary: $45 - $50 per hour
easy apply

job description

Data Architect

job summary:
Randstad Technologies, a global and national leader in the IT staffing and services industry is seeking a Data Architect to work in Rockville, MD. If this sounds like the kind of career move you have been wanting to make, and if you meet our qualifications, we want to talk with you!

You must have extensive experience with database modeling, architecture, and design with knowledge of SQL and Cloud.

Create, modify, analyze logical data models, physical data models, entity relationship (ER) diagrams and data flow diagrams. Leverage expertise in Oracle PL/SQL for defining data migration scripts. Leverage expertise in implementing metadata management, preferably with Smartlogic Semaphore. Apply advanced technical and analytical research techniques to determine solutions based on client requirements with an IT services/solutions-based scope. Design, develop, test, implement, administer, and troubleshoot Extract, Transform, and Load (ETL) mappings and workflows in a large Master Data Management (MDM) environment. Leverage expertise in ETL tools to create structure and value out of complex and ambiguous technical challenges with little guidance. Leverage expertise in structured and unstructured data, streaming and batch data processing, ETL, data wrangling, data ingest, and data access.

Basic Qualifications:

  • 6+ years of experience with databases
  • 5+ years of experience with procedural language Structured Query Language (SQL) stored procedures
  • 3+ years of experience with one or more of the following technologies: Informatica PowerCenter, MDM, and data quality
  • 2+ years of experience with ETL tools and processes
  • 1+ years of experience with scripting
  • 1+ years of experience in working with data toolsets, including data warehouse, data marts, data lake, 3NF, and dimensional models, modeling tools, and profiling tools
  • 1+ years of experience with extracting and summarizing data from a variety of data source types
  • BA or BS degree
Clearance: Clearable/FDA Public Trust

Additional Qualifications:

  • Experience with Smartlogic Semaphore a plus
  • Experience with Agile and Scrum methodologies preferred
  • Knowledge of data modeling and design patterns and applying them
  • Knowledge of IT processes, including QA, release management, and production support
  • Ability to meet project deadlines and test, troubleshoot, and resolve system problems under tight deadlines
  • Possession of excellent analytical and problem solving skills
Knowledge or experience with any of the following is a plus:

  • Data Architecture
  • Data Management
  • Data Analytics
  • Ontology Design
  • NoSQL (DynamoDB, Cassandra, MongoDB)
  • AWS (DynamoDB, Lambda, RDS, RedShift)
  • Apache Spark
  • Python
  • Apache Solr
  • DevSecOps
  • Data Modeling
  • Highly proficient in core DBA skills spanning multiple releases like Oracle 10g, 11g and 12c
  • Data warehouse and/ or ETL Experience with WebLogic installation
  • Experience with Performance tuning (DB, SQL, PL/SQL)
  • Experience in writing and modifying UNIX Shell Scripts
  • Certified Oracle Administrator
  • Oracle Forms
  • Experience with Oracle 11g Exadata and Exalogic architecture, Oracle 10g/11g/ 12c
Education

Bachelor's degree from an accredited college in a related discipline, or equivalent experience/combined education, with 6-7 years of professional experience; or 5 years of professional experience with a related Master's degree. Considered an emerging authority.

 
location: Rockville, Maryland
job type: Contract
salary: $45 - 50 per hour
work hours: 8am to 5pm
education: Bachelors
 
responsibilities:
You must have extensive experience with database modeling, architecture, and design with knowledge of SQL and Cloud.

Create, modify, analyze logical data models, physical data models, entity relationship (ER) diagrams and data flow diagrams. Leverage expertise in Oracle PL/SQL for defining data migration scripts. Leverage expertise in implementing metadata management, preferably with Smartlogic Semaphore. Apply advanced technical and analytical research techniques to determine solutions based on client requirements with an IT services/solutions-based scope. Design, develop, test, implement, administer, and troubleshoot Extract, Transform, and Load (ETL) mappings and workflows in a large Master Data Management (MDM) environment. Leverage expertise in ETL tools to create structure and value out of complex and ambiguous technical challenges with little guidance. Leverage expertise in structured and unstructured data, streaming and batch data processing, ETL, data wrangling, data ingest, and data access.

 
qualifications:
  • 6+ years of experience with databases
  • 5+ years of experience with procedural language Structured Query Language (SQL) stored procedures
  • 3+ years of experience with one or more of the following technologies: Informatica PowerCenter, MDM, and data quality
  • 2+ years of experience with ETL tools and processes
  • 1+ years of experience with scripting
  • 1+ years of experience in working with data toolsets, including data warehouse, data marts, data lake, 3NF, and dimensional models, modeling tools, and profiling tools
  • 1+ years of experience with extracting and summarizing data from a variety of data source types
  • BA or BS degree
Clearance: Clearable/FDA Public Trust

 
skills:
  • 6+ years of experience with databases
  • 5+ years of experience with procedural language Structured Query Language (SQL) stored procedures
  • 3+ years of experience with one or more of the following technologies: Informatica PowerCenter, MDM, and data quality
  • 2+ years of experience with ETL tools and processes
  • 1+ years of experience with scripting
  • 1+ years of experience in working with data toolsets, including data warehouse, data marts, data lake, 3NF, and dimensional models, modeling tools, and profiling tools
  • 1+ years of experience with extracting and summarizing data from a variety of data source types
  • BA or BS degree
Clearance: Clearable/FDA Public Trust


Equal Opportunity Employer: Race, Color, Religion, Sex, Sexual Orientation, Gender Identity, National Origin, Age, Genetic Information, Disability, Protected Veteran Status, or any other legally protected group status.

easy apply

get jobs in your inbox.

sign up
{{returnMsg}}

related jobs


    Data Analyst/Developer

  • location: Washington, DC
  • job type: Contract
  • salary: $40 - $45 per hour
  • date posted: 9/19/2019