W3Global

Technical Program Manager

Program Manager in New York, NY

Posted 2020-02-27
Description

Job Description:

DW/BI Architect

• Minimum of 10+ Year of experience Architecting Enterprise Scale BI Solutions.

• At least 8 Years of experience in Informatica Power Centre, Teradata DB.

• Must have worked on Consumption Pattern on cloud technologies like Informatica cloud.

Roles & Responsibilities:

• Provide expert guidance on DWH/ Business Intelligence (BI) skills and technologies.

• Develop scalable and maintainable BI applications to meet business objectives.

• Maintain accurate and complete technical architectural documents.

• Define BI standards, guidelines and best practices for business groups and technical teams.

• Develops strategies for data acquisitions and implementation of a database post analyzing database implementation methods as per Architecture standards

• Be able to design data models for Data Warehouses, ODS and Datamarts.

• Understanding of canonical data models, industry specific data models

• Experience in data modeling for both OLTP and OLAP systems.

• Expertise in data modeling tools (strong in ERWIN) for creating data models, reverse engineering, forward engineering.

• Experience in Teradata quires.

• Knowledge in Star and snowflake schema, different type of slowly changing dimension.

• Experience in Informatica Power center.

• Design, develop ETL jobs using Informatica Workflow Manager.

• Work experience in various type of Informatica transformation (aggregate, lookup, Rank, Join, Normalize etc.)

• Develop Informatica mapplet, worklet.

• Parallel processing of jobs, scheduling of jobs.

• Address customer queries and issues in a timely manner.

• Provide technical training on BI tools to junior staffs.

• Collaborate with BI/Teradata Administrators, Developers and Analysts for successful development of BI reporting and analysis solutions.

• Work with business groups and technical teams to develop and maintain data warehouse platform for BI reporting.

Ready to be seen?

Apply now to have the opportunity to be considered for similar jobs at leading companies in the Seen network for FREE.

Be seen in a new Program Manager job

Skip the search

Zero stress and one profile that can connect you directly to 1000s of companies.

Best-fit jobs—for you

We’ll take it from there. After you tell us what you’re looking for, we’ll show you off to matches.

Free Career Coaching

Boost your interview skills, map your tech career and seal the deal with 1:1 career coaching.

You get tech. We get you.

Join now and be seen.