ETL Architect Resume

OBJECTIVE

Seeking a position where around 15 years of Advanced and Lead Informatica Power center Development Experience, Extensive Informatica Administration and ETL Architect expertise and knowledge will add to organization value.

SUMMARY

Fifteen years of extensive experience in Information Technology with special emphasis on ETL design, development and Administration supporting building of Data Warehouses/Data Marts in support of BI projects.
Worked on all the phases of the Data warehouse life cycle that involves gathering requirements from business users, source to target ETL design dcouments creation, development, analysis & testing of the data in the Data warehouse.
Practical understanding of the Data modeling (Dimensional & Relational) concepts like Star - Schema Modeling, Snowflakes Modeling, fact and dimension tables. Implemented Kimball and Inmon Methodologies based on the Clients Data warehouse usage and reporting needs.
Strong database, data warehousing and ETL background under Oracle, Teradata, SQL Server and Informatica Power Center 5.1/6.2/7.1/8.1/8.6/9.1/9.5/9.6. Excellent understanding of data marts and multi-dimensional models, Legacy data, People soft HRMS data and SAP data and Business process integration using Web Methods.
Mastery over the ‘ETL process’ with many years of experience in Extraction of the data from various source systems ranging from various RDBMS to flat files, Transformations using various kinds of transformations and Loading the transformed data into the Data Warehouse followed by the analysis of the loaded data with the help of OLAP tools.
Strong Business Intelligence and OLAP experience under Cognos Report Net, Cognos PowerPlay, Business Objects 5.1/6.1/10i, OBIEE and Crystal Reports 8.5/10.
Extensive client/server development experience using Visual Basic 6.0, C, Pro*C, Power Builder 5.0, Transact-SQL and PL/SQL under UNIX operating system.

TECHNICAL SKILLS

ETL Tools: Informatica Power Center/Power Mart 5.1/6.2/7.1/8.1/8.6/9.1/9.6 , Power Exchange 8.x.

ERP: People Tools 8.42.15, EPM 8.8, HRMS 8.4, SAP.

OLAP & Reporting Tools: Cognos series 8, Business Objects, Crystal Reports.

Data/Object Modeling Tools: Erwin 4.1/4.5/7.2, Oracle Designer, Power Designer 10.

RDBMS: Oracle 8i/9i/10g/R12, DB2 8.1/8.5, SYBASE, Teradata, MS Access 2000, Netezza, SQL Server 2000/2005.

Operating Systems: MS Windows 98/NT/2000/XP, UNIX (AIX, HP)

Languages: Java, C++, C, UNIX Shell Scripting, SQL, PL/SQL

Internet Technologies: XML, HTML, DHTML, XSLT, UML, JavaScript, Perl.

We provide IT Staff Augmentation Services!

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship