Data warehouse lead

Paradigminfotech; Torrance (CA); On-site; USD 140,000 - 170,000; Full time

Job summary

You will lead design, development, testing and migration to production, and guide report/dashboard development (RPD/OBIEE) while maintaining best practices and internal standards. This is a long-term, on-site engagement requiring local CA consultants.

Qualifications

• 7+ years in ETL, Data Warehousing and SDLC.
• Proficient with Informatica ETL tool (design and development).
• Experience with OBIEE11g is a plus.
• Strong data modeling and star schema design skills.
• Ability to lead design sessions with business and BI teams.
• Knowledge of Data Quality, Metadata, and Data Lineage concepts.
• Experience with large-scale data integration (>7 TB).
• Informatica 9.5.1 and NETEZZA familiarity is desired.

Responsibilities

• Lead ETL architecture, data analysis, and dimensional modeling.
• Gather requirements and create technical design specifications.
• Develop Informatica mappings and workflows, ensure performance.
• Design OBIEE reports/dashboards and manage BI deliverables.

Skills

Informatica ETL

OBIEE11g

Data Modeling

ETL Design

Tools

Informatica 9.5.1

NETEZZA

AutoSys

OBIEE11g

Job description

Position : Data Warehouse Lead

Location : Torrance, CA(( Only local consultant in CA))

Duration : Long term

Senior resource in a Tech Lead role responsible for delivering a quality ETL work using Informatica in a Data warehousing environment that involves NETEZZA, Linux, AutoSys, Informatica9.5.1, OBIEE11g. Strong Data Modeling experiences, skilled in DW/ETL Requirement Analysis, Informatica ETL Design, Development, Testing and migration to Production.

Main responsibilities will be Leading efforts in designing and developing new ETL code that will enable downstream OBIEE Dashboards and Advanced analytics that help drive business value across different parts of TFS (Risk Management, Service Operations, Sales, Internal Audit and others) and analyzing, fixing, enhancing existing ETL code.

As an OBIEEg resource as well, the candidate will be responsible in leading our Report/Dashboard, RPD development activities for designing, documenting, developing reports, Dashboards leveraging best practices and internal development standards.

RESPONSIBILITIES

1. Lead role in designing, architecting ETL solutions, Data analysis, Dimensional Modeling and ETL Design on assigned projects.

2. Aid in gathering Requirements, conducting Business Analysis, and writing Te chnical Design Specifications.

3. Evaluate and design Conceptual /Logical and Physical Data Models; define logical views and physical data Security structures.

4. Lead the efforts to develop Informatica code, Design, Develop and modify, Informatica mappings, workflows using all necessary Transformations as applicable.

5. ETL performance tunings, Optimization, Code Quality and Standards.

6. Validates and Review the Test Plans and Test Scenarios, Test Cases; verify Test Results.

7. Perform problem determination (root cause analysis), document the source of problems and their resolution. Recognize and analyze trends in errors so as to identify and install long term solutions to problems.

8. Adheres to TFS BI documented Development Standards, Best Practices and Guidelines, ensure compatibility, scalability, and integration with other data platforms.

9. Design, document, develop OBIEE11g reports, Dashboards including RPD, Alerts, Publisher.

10. Will work on OBIEE Administration activities, Security configurations /setups, Architecture, Best Practices in leading a Development team providing guidance / training and taking care of the work reviews.

11. Will Provide creative solutions around visual representation of data for optimum usability

Charts, Graphs, Dashboard Design

QUALIFICATIONS MINIMUM

1. 7 years of experience required in related field (i.e. ETL, Data Warehousing and SDLC);

2. 7 years of experience working with Informatica ETL tool (design and development).

3. Experience with OBIEE11g is plus.

4. Strong data analysis skills, Dimensional Modeling, experiences in designing Star Schemas.

5. Ability to lead and effectively facilitate design sessions with business customers and the BI team in order to derive data requirements and data design information.

6. Need to be very good in understanding requirements for Data Quality, Metadata, Data Lineages, Operational Data Management and provide the Solutions.

7. Previous work experiences in large scale data integration and data warehouse solutions database exceeding 7 TB.

8. Extensive hands-on Experience in Informatica 9.5.1

9. Experience with NETEZZA6.0.5 is plus

10. Experience with other relational databases like Oracle, SQL Server, the operating systems Linux, scheduler AutoSys.