W-2 Jobs Portal

  • W-2 Open Positions Need to be Filled Immediately. Consultant must be on our company payroll, Corp-to-Corp (C2C) is not allowed.
Candidates encouraged to apply directly using this portal. We do not accept resumes from other company/ third-party recruiters

Job Overview

  • Job ID:

    J36993

  • Specialized Area:

    ETL

  • Job Title:

    Information Technology

  • Location:

    Woodland Hills,CA

  • Duration:

    8 Months

  • Domain Exposure:

    Healthcare, Banking & Finance, IT/Software

  • Work Authorization:

    US Citizen, Green Card, OPT-EAD, CPT, H-1B,
    H4-EAD, L2-EAD, GC-EAD

  • Client:

    To Be Discussed Later

  • Employment Type:

    W-2 (Consultant must be on our company payroll. C2C is not allowed)




Job Description
Job Description:
  • Lead a skilled ETL development team in delivering best practice solutions to support data warehousing and business reporting activities
  • Ensure that best practices are implemented for data movement,data quality, data cleansing, and other ETL-related activities
  • Develop and ensure adherence to locally defined standards for all developed components
  • Maintain "common code" libraries, so objects can be shared for all environments (Dev, Test, and Production)
  • Document designs and architect data maps, develop data quality components and establish and/or conduct unit tests
  • Participate in requirements, design, and development reviews when needed
  • Conduct or participate in meetings with owners of key system components to fully understand current data and systems environments
  • Assist in production support by resolving source data issues and refining transformation rules
  • Analyze source system data and work with technical and business representatives to determine strategies for handling data anomalies that are identified
  • Design ETL processes and develop source-to-target data mappings, integration workflows, and load processes that assist in implementing enterprise-class data warehousing solutions
  • Use the Informatica platform to extract, transform, and load data through development, testing, and integration of ETL routines, using ETL tools and external programming/scripting languages as necessary
  • Assist in writing unit test cases when necessary
  • Provide data analysis and technical documentation for both source and target mappings
  • Identify problems, develop ideas, and propose solutions within differing situations requiring analytical, evaluative, or constructive thinking in daily work
  • Prepare and present ideas and recommendations to colleagues and upper management
  • Apply creative thinking to identify possible reporting solution alternatives
  • Other duties assigned as needed
  • Experience with CDC (Change Data Capture) using Informatica Power
Qualifications:
  • Must have legal right to work in the US
  • Strong written and oral communication skills required
  • Minimum 2 years’ experience as a supervisor of a development team, preferably an ETL development team
  • Minimum 3 years’ experience developing ETL code with Informatica’s PowerCenter software
  • High level of SQL language proficiency with common database platforms is mandatory
  • Experience working with SQL Server SSIS, stored procedures using T-SQL, and SQL optimization is a plus
  • Working knowledge of BI architecture and data warehousing concepts
  • Knowledge and experience with other Informatica products, such as PowerExchange CDC
  • Knowledge and experience with Erwin data modeling is a plus
  • Able to critically think and be solution-oriented
  • Strong interpersonal skills and able to work easily with client personnel
  • Great organizational, time management, and problem solving skills

Apply Now
Equal Opportunity Employer

QUANTUM TECHNOLOGIES LLC is an equal opportunity employer inclusive of female, minority, disability and veterans, (M/F/D/V). Hiring, promotion, transfer, compensation, benefits, discipline, termination and all other employment decisions are made without regard to race, color, religion, sex, sexual orientation, gender identity, age, disability, national origin, citizenship/immigration status, veteran status or any other protected status. QUANTUM TECHNOLOGIES LLC will not make any posting or employment decision that does not comply with applicable laws relating to labor and employment, equal opportunity, employment eligibility requirements or related matters. Nor will QUANTUM TECHNOLOGIES LLC require in a posting or otherwise U.S. citizenship or lawful permanent residency in the U.S. as a condition of employment except as necessary to comply with law, regulation, executive order, or federal, state, or local government contract