Data Warehouse Developer (Oracle, Db2)

Chandra Technologies Inc Madison , WI 53701

Posted 3 weeks ago

Hourly Rate: $50 W2; $57 CTC/1099

Job Description:

The candidate will be responsible for assisting in ETL design, development, testing, maintenance, metadata, and implementation of data warehouse initiatives. Understand user requirements, and implement solutions that ensure requirements can be achieved through high quality deliverables. Develop ETL mapping specifications for loading information into the data warehouse and for ensuring reliability of information loaded. Seek continuous improvement in performance & tuning of data warehouse and ensure security of data. Works with other IT technical teams and Business users to understand requirements, and recommend & implement solutions. Closely supervised with some latitude for independent judgment. Typically requires up to three years of experience or equivalent education.Ideal candidate will have skills and experience in the following areas:Moderate experience in data warehousing process design, development, performance & tuning using the Informatica data warehousing tool suiteDeveloping skills in the architecture of data warehouse and data integration strategies and solutionsKnowledge in data warehouse best practice standardsKnowledge in relational data base technologies; e.g. Oracle, DB2, SQL ServerModerate skills working with relational and dimensional data modelsModerate skills working with slowly changing dimensionsStrong data management and data analysis using SQLStrong verbal and written communication skills, including facilitation of meetings with customers and technical staffKnowledge and skills in the project development life cycle process (i.e., planning, analysis, design, coding, testing, implementation, support)Demonstrated knowledge and skills in requirements gatheringEffective interpersonal relations skills, ability to effectively collaborate with others and work as part of a teamSkills in navigating a large organization in order to accomplish resultsAbility to initiate and follow through on complex projects of both short and long term durationExcellent organizational and time management skills.Excellent analytical and problem solving skillsAbility to work independently, assume responsibility for job development and training, researching and resolving questions and problems, requesting supervisor input and keeping supervisor informedProficiency with MS Office suite, MS Visio, and MS Outlook

Requirements

Required Skills:

  • Respond to customer requests (verbally and in writing) (3 Years)
  • Expertise in implementation of large complicated models and processes (2 Years)
  • Experience in Technical Writing and Documentation (3 Years)
  • Ability to develop and implement quality assurance processes and procedures including test/use cases (3 Years)
  • Ability to navigate and query a relational database (Oracle) to both develop reports and to perform data validation using common tools including SQL/PLSQL (3 Years)
  • Data Warehouse- Experience in data warehouse design and development (3 Years)
  • Data Warehouse- Experience in requirements gathering for data warehouse (3 Years)
  • Data Warehouse- Performance tuning (3 Years)
  • Informatica (3 Years)
  • Develop design specifications (3 Years)
  • Knowledge of Kimball data warehouse and business intelligence lifecycle methodology (2 Years)
  • Business Objects or other BI tools (3 Years)
  • Develop Test Plans, Test Cases, and Test Procedures (3 Years)
  • Identify defects (3 Years)

Preferred Skills:

  • Demonstrated experience in the design and utilization of performance measures and reports (3 Years)
  • State of Wisconsin Privacy Regulations
  • Data analysis (3 Years)
  • DB2 (2 Years)
  • Dashboarding/Business Objects Xcelsius (2 Years)
  • In-Depth Knowledge of System Development Life Cycle Deliverables for each Phase of Development (3 Years)
icon no score

See how you match
to the job

Find your dream job anywhere
with the LiveCareer app.
Mobile App Icon
Download the
LiveCareer app and find
your dream job anywhere
App Store Icon Google Play Icon
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
Senior Data Management Developer 1212 Deming Way (5151)

UW Health Partners

Posted 3 days ago

VIEW JOBS 10/27/2020 12:00:00 AM 2021-01-25T00:00 Join the #1 hospital in Wisconsin! We are seeking a Senior Data Management Developer to: * Partner on the creation of standards, templates, procedures, and technical frameworks for the department. * Design data warehouse workflows and mappings to extract, transform, and load data into staging areas and dimensional target tables. * Contribute to a culture of continuous learning and strong trusted-advisor relationships. Education: Minimum - Bachelor's degree in Healthcare, Information Systems, Engineering, Business, Data Science, or related field (relevant work experience may be considered in lieu of educational requirement). Preferred - Master's degree in Healthcare, Information Technology, Data Science, or related field strongly preferred. Work Experience: Minimum - Five (5) years relevant experience in the following: Full software development life cycle frameworks. Database technologies including traditional RDBMS such as Oracle and SQL Server as well as MPP appliances such as Netezza, Teradata, or Exadata. Advanced SQL coding with an emphasis on data transformation functions. Transformation tools such as Informatica PowerCenter, Microsoft SSIS, IBM Data Stage, etc. Experience in the health care field, specifically with systems such as Epic Clarity or CDW Preferred - Three (3) years of data or analytics experience. Experience in healthcare provider or payer strongly preferred. Licenses and Certifications: Preferred - Certified Data Management Professional (CDMP) - DAMA.org, Certified Business Intelligence Professional (CBIP) - TDWI.org, Certified Informatica Professional Epic Data Model or CDW Certifications. Required Skills, Knowledge, and Abilities: * Demonstrates professional standards surrounding data access, data security, data sensitivity, and data confidentiality. * Advanced verbal and written communication skills. * Advanced interpersonal relations skills, ability to effectively collaborate with others and work as part of a team. Physical Requirements: Sedentary: Ability to lift up to 10 pounds maximum and occasionally lifting and/or carrying such articles as dockets, ledgers and small tools. Although a sedentary job is defined as one, which involves sitting, a certain amount of walking and standing is often necessary in carrying out job duties. Jobs are sedentary if walking and standing are required only occasionally and other sedentary criteria are met. Work Schedule: Full-time, 40 hours per week. Monday through Friday, between the hours of 8:00 am - 5:00 pm. Hours may vary based on the operational needs of the department. UW Health Administrative Facilities - UW Health has administrative locations throughout Madison and beyond where thousands of employees provide vital support to our clinical areas. These locations are home to departments such as Access Services, Compliance, Human Resources, Information Services, Patient Medical Records, Payroll and many others. Learn more about this opening UW Hospital and Clinics benefits UW Health values and embraces diversity and is proud to be an Equal Employment Opportunity, Affirmative Action employer. All qualified applicants will receive consideration for employment without regard to race, religion, color, national origin, sex, gender identity or expression, sexual orientation, age, status as a protected veteran, among other things, or status as a qualified individual with disability. UW Health Partners Madison WI

Data Warehouse Developer (Oracle, Db2)

Chandra Technologies Inc