Get your dream job within 2 days (HURRY UP) ENROLL NOW or Call +1 (804)-715-8126


Job Id : 8068

Jobtitle : ETL MODELER - OPT/H1B

Location : Charlotte, NC

Company Name : CapB InfoteK

Industry : Information Technology

Salary : $56,000 - $109,900  YEAR

Job type : Fulltime

Posted on: 2019-11-29

Required Skills : Data Modeling, Data Warehousing, DB2, ERWIN, ETL, OLTP, Oracle, SQL, Sybase, Teradata

Benefits : No benefits are available

Job Description :

  • Designing data warehouse tables (Dimension and Facts) logical and physical models
  • Data Modeling tools such as Erwin and/or Power Designer
  • Strong modeling background on multiple modeling approaches (relational, marts, data vault, Document, etc
  • Ability to work independently
  • Ability to analyze business ask to form model implementation
  • Ability to work on analyzing reference data needs
  • Insurance background, if possible, in not must be a fast learner
  • Designing Tables for OLTP systems (logical and physical models)
  • Experience writing SQL queries to analyze and profile data and database tools (e.g., Netezza, Oracle, Sybase, DB2, Teradata
  • Experience analyzing data for quality and integrity issues
  • Gathering and documenting business requirements and documenting Data Architecture issues
  • Enforcing Data Modeling standards and procedures
  • Experience working with very large data sets (preparing data and tables for presentation of analyses), independently and as part of a team.
  • Experience and in-depth understanding of relational database modelling and structures
  • Design and develop data transformation and loading processes for the population and ongoing management of the data models and architecture
  • Perform QC and verification of data according to specified criteria. Take the initiative in managing data problems / exceptions
  • Define and implement rules-based derived fields
  • Thoroughly document the data transformation processes used
  • Direct experience in preparing datasets for use in statistical and predictive modelling

Latest jobs for you

  • Lead Salesforce Developer

    LeadStack, Inc California City, CA

    Responsibilities: Your ability to quickly learn new features, technologies, and to communicate...

    View Job
  • Strong Appian Developer

    Simple Solutions San Ramon , CA

    Required Experience Experience in implementing projects with Appian 7.5 and above Appian ...

    View Job
  • Appian Developer

    ASK Staffing Inc San Ramon, CA

    Job Description : Analysis, design, implement, integrate and test multiple Appian BPM ...

    View Job
  • Appian Developer

    IT Trailblazers St. Louis, MO

    Job Description: Analysis, design, implement, integrate and test multiple Appian BPM ...

    View Job
  • Network Engineer (Azure networking, Palo Alto)

    VOX IT LLC San Francisco, CA

    Responsibilities: Deploy, Configure, Maintained Palo Alto firewall on Azure Cloud. ...

    View Job

Thanks For Your Feedback

We’re an equal opportunity provider.
All applicants will be considered for employment without attention to race, color, religion, sex, sexual orientation, gender identity, national origin, veteran or disability status. is not a Consulting Company/Training Company/H1B Sponsor.

Attach A Resume First