Job Description :
Description:
Responsibilities:
- Analyze functional and non-functional business requirements and translate into technical data requirements and create or update existing logical and physical data models
- Create data models (logical) and DB designs (physical), that depict the business areas and systems in the customer portal to ensure the integrity of the business data is being maintained; incorporate applicable standard data elements; ensure solutions are accessing the system of record for shared or enterprise data; and ensure adherence to technical DB design standards in accordance with the approved Data Modeling and DB Design Standard
- Refine existing data models of company''s business areas and systems
- Facilitate data modeling sessions, ranging from information gathering to model validation
- Create the data architecture sections of system design document for development efforts
- Provide requirements analysis support to development teams and educate project and development teams on the proper usage of the data structures
- Analyze data access and modification requirements to ensure efficient data retrieval/ingestion and optimal DB design
- Perform DB design, review DB design from development team, and generate initial data definition language, as needed
- Design and develop a data migration strategy and source to target mapping to migrate the data out of the legacy systems into the Cassandra customer DB
- Provide optimal design for structured and non-structured data using SQL and NoSQL databases
- Enhance DB performance from physical DB design perspective
- Provide technical advice and prepare technical documentation on data architecture related trends, issues, and tools and provide input into the agency-wide data architecture standards
- Provide solutions to adhere to company policy on Cloud based deployments.
- Ability to think outside the box and implement non-standard solutions.

Requirements:
- BS in Computer Science or equivalent experience
- Data modeling, including reverse and forward engineering
- Data collection, curation, preparation and transformation
- Data warehousing, reporting and business intelligence
- Relational and non-relational databases
- Data validation processes and software quality assurance
- Experience with data-driven business
- Experience with Cloud based solutions
- Clear verbal and written communication; demonstrated ability to collaborate with peers from a variety of disciplines
- Oracle, Cassandra, XML, JSON. Ability to analyze data sources
- Breadth and depth of skill to build and deliver scalable data and reporting solutions
- Deep knowledge and experience with the Cassandra, related software tools, and performance optimization
- Desire, initiative and resourcefulness to learn new tools, frameworks, languages
             

Similar Jobs you may be interested in ..