Sorry, this job is no longer accepting applications. See below for more jobs that match what you’re looking for!

Database Modeler

Expired Job

Hallmark Global Technologies INC Little Rock , AR 72203

Posted 3 months ago

Hi,

Looking for Database Modeler
Location: Little Rock, AR, Greenville, SC or Charlotte, NC
Duration: 3+ months


Immediate need for Database Modeler consultant for 3 month project to be based out of our Little Rock, AR, Greenville, SC or Charlotte, NC locations. Project may be extendable.
Shoulder the responsibilities of a Database Designer and ability to reverse - engineer established stack of applications. Develop Solutions to reduce data redundancy and pave way for a strong database architecture for applications that consumes data from those. Should have developed solutions on replication techniques and ETL / Transformation methodologies.

Requirements:

10-15 yrs related experience

Proven track record of database designing for business models and adopted reverse engineering methodologies

Proficient, and practical exposure, in Oracle Golden Gate application and it's replication demands for consumers Must have solutioning / architecture experience with the Oracle Golden Gate specific.

Comprehensive knowledge and experience in process improvement, normalization/de-normalization, data extraction, data cleansing, data manipulation.

Strong experience in interacting with business analysts and developers to analyze the user requirements, functional specifications and system specifications.

Proficient experience in working on conceptual, physical and logical data models (3NF) using various Data Modeling tools.

Strong understanding in the principles of Data ware housing using Fact Tables, Dimension Tables, star schema modeling and snowflake schema modeling, Slowly changing dimensions, foreign key concepts, referential integrity.

Well-acquainted in working with complex SQL queries with joins, date functions, inline functions, sub-queries, Functions, Procedures, Exception handling, Views, Packages, Triggers and Ref Cursors.

Excellent proficiency in Data Transformations and loading using Export, Import and SQL, Loader and worked on External tables.

Comprehensive knowledge and experience in process improvement, normalization/de-normalization, data extraction, data cleansing, data manipulation.

Established and maintained comprehensive data model documentation including detailed descriptions of business entities, attributes, and data relationships.

Education: Bachelor of Technology preferred

Regards,
Ravi Gavirneni
US IT Recruiter
Niktor LLC
Phone:
E-mail:

Skills:
Oracle Golden Gate, Data Transformations
Permanent


See if you are a match!

See how well your resume matches up to this job - upload your resume now.

Find your dream job anywhere
with the LiveCareer app.
Download the
LiveCareer app and find
your dream job anywhere
lc_ad

Boost your job search productivity with our
free Chrome Extension!

lc_apply_tool GET EXTENSION

Similar Jobs

Want to see jobs matched to your resume? Upload One Now! Remove
IT Architect Senior

Fidelity Information Services

Posted 2 weeks ago

VIEW JOBS 11/29/2018 12:00:00 AM 2019-02-27T00:00 JOB FIS Management Services, LLC seeks a IT Architect Senior in Little Rock, AR to define and maintain architecture principles and standards for application development, based on FIS' business requirements. Define and document principles and standards to ensure speed and quality of development, while maintaining flexibility and maintainability in anticipation of future needs. Ensure robustness of applications to meet needs for performance, efficiency, reliability, availability, scalability, and security. Work to understand, assess, and put into practice selected emerging technologies in anticipation of meeting future software business needs. Perform product evaluation, reference technology proof of concept, and industry trend analysis. Based on research and assessment, current technology standards are validated and/or refreshed and extended by newer technologies (e.g. J2EE vs. .NET). Define and maintain software architecture principles and standards for FIS application development, based on business requirements. Design and provide internal building blocks or development components that enhance the speed of development, quality, and stability of product solutions. Lead technology direction for multiple projects and lead and present architecture concepts. Work in a distributed and heterogeneous computing environment including UNIX or Windows. Work with relational or hierarchical databases including Oracle, DB2, Postgres, MySQL, and MSSQL. Design and implement applications in a shared service bureau environment. Build on-line transaction processing (OLTP), batch and reporting systems. Use unified modeling language (UML) for object modeling. Support end-to-end systems development life cycles, including waterfall, and agile methodologies for software development. Utilize solutions design and requirements definition disciplines leveraging model driven design based tools and techniques including conceptual solution component models, business process models, and use cases. Utilize API Gateway solutions including Wso2 API Manger and Apigee Edge. Develop Java/J2EE technologies. Utilize SOA and REST Services. Enforce security standards on applications using Fortify, OWASP Security Standards, and PCI Data Security Standards. Utilize UI technologies and frameworks including Spring, Hibernate, NodeJS, and JaggeryJS frameworks. Utilize development tools including Eclipse, Visual Studio, Subversion (SVN), Maven, and Git. Conduct performance tests of applications using JMeter and Dynatrace. REQUIREMENTS: Bachelor's degree or foreign equivalent in Computer Science, Computer Engineering, Computer Applications or a related field and six (6) years of progressively responsible experience in the job offered or a related occupation: working in a distributed and heterogeneous computing environment including UNIX or Windows; working with relational or hierarchical databases including Oracle, Postgres, and MSSQL; building on-line transaction processing (OLTP) systems, payment systems, batch and reporting systems, or banking channel applications; using unified modeling language (UML) for object modeling; supporting end-to-end systems development life cycles, including waterfall, and agile methodologies for software development; utilizing solutions design and requirements definition disciplines leveraging model driven design based tools and techniques including conceptual solution component models, business process models, and use cases; developing Java/J2EE technologies; utilizing SOA web services and REST Services; enforce security standards on applications using Fortify, OWASP Security Standards, and PCI Data Security Standards; utilizing UI technologies and frameworks including Spring, Hibernate, and NodeJS frameworks; and utilizing development tools including Eclipse, Subversion (SVN), Maven, and Git. 10% travel required to various and unanticipated FIS offices nationally. Fidelity Information Services Little Rock AR

Database Modeler

Expired Job

Hallmark Global Technologies INC