Data warehouse Architect Resume

PROFESSIONAL SUMMARY:

Having 14+ years of experience in IT industry focused on Data warehouse Architecture, Analysis, Design, Development and Big data technologies
Have good understanding and knowledge in Healthcare domain, Retail and Insurance domains. Hands on Experience in MDM (Master data management).
Strong Knowledge on Software Development Life Cycle (SDLC) with architecture, design, planning, estimation, modeling, development, testing, implementation.
Experience in Database Design, Dimension Modeling, and Star Schema & Snowflake with Kimball methodologies.
Interacted with the business and various source systems technical architects to understand the requirements.
Hands on experience in the requirement mapping and gap analysis.
Hands on experience in dimensional modeling like conceptual data model, logical data model, and physical data model using Erwin.
Provide technical insight and assistance to the data modeler in building new design adhering to existing Data warehouse architecture and review the data model and suggest improvement ideas.
Experience in utilizing the best practices of Informatica Data Quality (IDQ) by streamlining the Cleanse process in the discovery, documentation and resolution of data quality issues.
Involved in providing the guidance in developing components to comply data compliance and data governance.
Worked intensively on understanding the data pattern and structure of the data, there by indentifying the strength and weakness of the data.
Worked in MDM to collect, standardize, harmonize and share master data to provide more accurate, complete, and consistent data across the enterprise.
Extensively worked Teradata utilities BTEQS, MLOAD, FAST EXPORT, FAST LOAD.
Worked extensively in Informatica Power center, Datastage and MDM Solutions, PL SQL and UNIX and well versed with RDBMS like Teradata, Oracle, and DB2 and OS concepts.

TECHNICALSKILLS:

Big Data Technologies: Hadoop, Map reduce, Hive, Hbase, Pig Script, Spark, Sqoop, Flume, Tableau, Elastic search

ETL Tools: Informatica Power Center 9.5.1/9/8.6.1/8.5/8.1/7. x (Source Analyzer, Mapping Designer, Mapplet, Transformations, Workflow Monitor, Workflow Manager) and Data Stage

Data Modeling: E - R Modeling, Dimensional Data Modeling, Snow Flake Modeling, Fact and Dimensions Tables, physical and Logical Data Modeling, Erwin 7.3, Microsoft Visio2007

Databases: Oracle 11g, 10g/8i/9i, IBM DB2, MS Access 2000/1997, Teradata 13.1

Languages: C, C++, SQL, SQL*Plus, PL/SQL.

Tools: &Utilities Toad, MaestroJobScheduling Console 8.4, Autosys, Serena Dimension

Environment: Windows 2003 server, Windows 95/98/NT 4.0/2000, XP, MS DOS, Sun Solaris 5.1,UNIX AIX 6.1.

Packages: MS Office (MS Access, MS Excel, MS PowerPoint, MS Word)

OLAP: Cognos Impromptu

GUI: Developer 2000 (FORMS 4.5, 6i, Reports 6i)

PROFESSIONAL EXPERIENCE:

Confidential

Data warehouse Architect

Responsibilities:

Experience in Database Design, Dimension Modeling, and Star Schema & Snowflake with Kimball methodologies.
Interacted with the business and various source systems technical architects to understand the requirements.
Hands on experience in the requirement mapping and gap analysis.
Hands on experience in dimensional modeling like conceptual data model, logical data model, and physical data model using Erwin.
Provide technical insight and assistance to the data modeler in building new design adhering to existing Data warehouse architecture and review the data model and suggest improvement ideas.
Experience in utilizing the best practices of Informatica Data Quality (IDQ) by streamlining the Cleanse process in the discovery, documentation and resolution of data quality issues.
Involved in providing the guidance in developing components to comply data compliance and data governance.
Worked intensively on understanding the data pattern and structure of the data, there by indentifying the strength and weakness of the data.

We provide IT Staff Augmentation Services!

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship