Data Warehouse Developer- II



Job Description

DOT is looking for a candidate that can help provide BI ETL needs for the organization. 
The candidate will be a strong technical leader working on BI Data Integration projects, gathering & documenting requirements, performing analysis, designing solutions to meet business objectives, developing specifications, developing ETL mappings using Informatica PowerCenter, testing, and implementing solutions. Understand user requirements, and implement solutions that ensure requirements can be achieved through high quality deliverables. Seek continuous improvement in performance & tuning and ensure security of data. Proven methodology experience for complex systems integration projects and demonstrated ability to achieve deliverables on time and on budget. Work with other IT technical teams and Business users to understand requirements, and recommend & implement solutions. Work with moderate supervision with some latitude for independent judgment performing a variety of complex tasks. Requires advanced skill sets and developing proficiency within discipline. Typically requires 7 - 9 years’ experience or equivalent education. 
Ideal candidate will have experience designing BI solutions, development experience in Informatica PowerCenter 
DW & BI Knowledge areas: 1. Data warehouse/data marts design and development using Kimball & Inmon methodologies 2. Oracle, DB2 and SQL Server 3. Informatica PowerCenter V10.1 4. SQL 5. Dimensional Data Modeling - Star Schemas 6. Slowly Changing Dimensions 7. Requirements gathering and documentation 8. Test plan development and testing execution 9. Project development life cycle process (i.e., planning, analysis, design, coding, testing, implementation, support 10. Excellent written and oral communications 11. Independent worker 
Informatica (8+years experience): • PowerCenter - ETL • Real Time Engine • Data Profiling • DVO - Data Validation • Metadata Manager • Rapid Prototyping • Data Masking 
Database Knowledge (8+years experience): • DB2 • ORACLE • SQL Server • Complex SQL statements

Want to apply later?

Type your email address below to receive a reminder

Apply to Job

ErrorRequired field
ErrorRequired field
ErrorRequired field
ErrorRequired field
Error
insert_drive_file
insert_drive_file
Error
Error
Error
Error