Get your dream job within 2 days (HURRY UP)ENROLL NOW
+

ETL MODELER - OPT/H1B


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

  • SailPoint Developer - OPT/H1B/C2C

    Techginia INC Minneapolis, MN

    Job Description: We are looking for a SailPoint Lead/Developer from Information Technology & ...

    View Job
  • Oracle EBS Cloud / Lead - OPT/H1B

    keybusinessglobal.com Secaucus, NJ

    Job Description: Senior Level Technical Lead with hands-on and leadership experience managing ...

    View Job
  • AS/400 Developer - OPT

    K Anand Corporation Houston, Texas

    Job Description: Migrate AS400 servers from IBM Data center to Equinix ...

    View Job
  • Java Developer+ Master Data Services (MDS) OPT/H1B

    Xiartech Mountain View, CA

    Required Qualifications: Java experience (primary skill set) Strong Java experience and ...

    View Job
  • Embedded Developer - OPT/H1B

    Aristasys Peachtree City, GA

    Job Description: Skill Level, Years: 2-4+ Programming Languages: C/C++ OS: Android ...

    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.
OPTnation.com is not a Consulting Company/Training Company/H1B Sponsor.

Attach A Resume First