Data Warehouse Developer

Ideal candidate will have skills and experience in the following areas:

• Knowledge in data warehouse best practice standards

• Strong experience in PowerCenter to IDMC migration.

• Experience in design, development, and testing in IDMC.    

• Proficient in writing and analyzing complex SQL queries in Oracle, DB2, SQL Server.

• Hands-on experience using Control-M for job scheduling and workflow automation.

• Moderate skills working with relational and dimensional data models

• Moderate skills working with slowly changing dimensions

• Proven ability to diagnose and remediate ETL and DB Query performance bottlenecks.

• Strong verbal and written communication skills, including facilitation of meetings with customers and technical staff

• Knowledge and skills in the project development life cycle process (i.e., planning, analysis, design, coding, testing, implementation, support)

• Demonstrated knowledge and skills in requirements gathering

• Effective interpersonal relations skills, ability to effectively collaborate with others and work as part of a team

• Skills in navigating a large organization in order to accomplish results

• Ability to initiate and follow through on complex projects of both short- and long-term duration

• Excellent organizational and time management skills.

• Excellent analytical and problem-solving skills

• Ability to work independently, assume responsibility for job development and training, research and resolving questions and problems, requesting supervisor input and keeping supervisor informed

• Proficiency with MS Office suite, MS Visio, MS Outlook, and Jira