Job vacancy KPG 99 Inc. - Data warehouse(DW) Developer - job vacation at Quincy, MA

KPG 99 Inc. is currently hiring the following: Data warehouse(DW) Developer at Quincy, MA

Dice is the leading database for technology professionals, managing over 7 million profiles in the United States. The platform helps technology professionals manage their careers and employers connect with highly skilled tech talent.



Dice provides insights, data and career opportunities for technology professionals while putting state-of-the-art tools in the hands of recruiters and employers seeking tech talent.

------------------------------------------------------------------
Position: Data warehouse(DW) Developer

Location: Quincy, MA

Duration: 6+ Month

MOI: Phone and F2F (Only Local Consultant)

Job Description

• The Data Warehouse Developer will be responsible for analysis, design, coding, and testing of moderate to extremely complex data warehouse development. 
• The DWD will analyze and develop data warehouse schematic solutions to support business requirements as outlined by a Business Analyst. 
• The role will also support existing warehouse infrastructure and provide input on best practices and potential efficiencies. 
• The DWD will be expected to work on multiple assignments concurrently and be required to complete work by aggressive due dates. 
• The role uses a range of their expert technical skills based on keen knowledge of data warehouse concepts and must be highly proficient with Oracle SQL. 
• The DWD is expected to participate in all meetings they are invited to as part of the project management office and create and deliver deliverables and/or review materials as expected.

DUTIES:

• Design and Develop ETL solutions in an Oracle Exadata environment based on specifications
• Determine appropriate sourcing and storage of data from multiple source systems
• Codes Oracle ETL scripts that will extract data from an operational database as well as other external data sources and populate the staging and target data warehouse schemas
• Documents code and processes for distribution to all interested parties
• Documents design using industry standards including ERWIN diagramming
• Provides query writing support and tuning expertise to analysts and end-users
• Develops shell scripts for production job automation
• Work in a 24x7 environment which requires on-call rotation

QUALIFICATIONS:

1. 5+ years of experience in database architecture and development including analyzing, designing, documenting, coding, testing and implementing primarily SQL code
2. Thorough knowledge of data warehouse principles and techniques, specifically dimensional data architecture modeling
3. Exceptional Oracle SQL skills and PL/SQL skills
4. Hands-on experience with set-based operations, analytic functions, and query hints
5. Command of data warehouse modeling concepts is required
6. Strong problem solving and analytical skills
7. Strong ERD modeling
8. Proficiency with Linux and shell scripting
9. Experience working with a large, multi-terabyte data warehouse
10. The ideal candidate must demonstrate that they have relevant experience, creativity, a keen problem-solving ability.
11. Excellent interpersonal skills for collaboration and facilitation work with a broad range of people while keeping projects on track.

EXPERIENCE that will distinguish candidates:

• BS in Computer Science or related degree, or equivalent experience
• Medicaid or other healthcare or claims processing experience
• AWS (Cloud) Experience
• Informatica ETL experience.

--

BEST Regards,

Sandeep Singh Bora

IT Recruiter, KPG99 INC

D. 609-663-8133 Ext. 147

W. E.

A. 3240 E State St EXT, Hamilton, NJ 08619

Certified Minority Business Enterprise(MBE)

Tip: Three simple etiquettes - Always reply (even if you wish to opt-out), be courteous and no SMS lingo - makes you look professional. - provided by Dice

If you are interested, please register online through the following page: Registration. 

Recruitment does not cost you anything, and only qualified applicants will be processed