Lead Informatica Architect/Developer Resume

SUMMARY

He is a Senior Consultant with over 15 years of experience leading and supporting successful projects.
He has successfully played team lead roles in various projects including 5 years of Architecting, Designing, Developing, Maintaining, and Mentoring the staff of a multi - million federal data warehouse project.
He has developed data warehouses and data marts for clients in major industries such as Health Care, Government, Energy and Telecommunications.
Comprehensive knowledge, strong development and administration experience with Informatica PowerCenter versions 6, 7, 8, and 9.
He has expertise in Architecting, Installing, Configuring, and Administration of Informatica products.
He has created over 300 mappings using Informatica PowerCenter 6, 7, & 8 versions.
He has developed various ETL strategies and implemented them.
He has extensive Experience in Database design for data warehouses and posses strong Knowledge of Ralph Kimball’s Dimensional modeling methodology, designing Star schemas.

TECHNICAL SKILLS

Operating Systems: Sun Solaris, AIX, HPUX, linux, WinNT, Win2K, Windows XP and MS-DOS

Languages: C, C++, Java, PERL, TCL, K-shell, B-shell, SQL, PL/SQL, XML, and PERL

Databases: Oracle, SYBASE, SQL Server 2K, Access, Teradata, TOAD 10.2 for Oracle

Applications: Designer 2000, Forms 4.5, Report Writer 2.2, Power Builder 5.0

Data Model Tools: ERWIN, Designer 2000

Software Tools: Informatica Power Center 9.x, 8.x, 7.x, & 6.x, Informatica Power Exchange for Salesforce.com, Informatica Power Exchange for Hyperion Essbase, DQXI for Informatica, Informatica PowerExchange for Hadoop, Microsoft DTS.

BI Tools: Microsoft Analysis Services, Business Objects

Productivity Tools: Microsoft PowerPoint, Microsoft Word, Microsoft Excel, Microsoft Visio, Internet Browsers, Adobe Acrobat

PROFESSIONAL EXPERIENCE

Confidential

Lead Informatica Architect/Developer

Responsibilities:

Greatly enhanced the Performance of existing fact table and dimensions data load. Decreased processing time from 2+ hours to approximately 30 minutes.
Created summary reports to run on daily basis to capture possible data gaps.
Developed mappings to maintain Type-II and Type-III dimensions.
Developed strategies to minimize data duplication and to capture data changes.
Recommended changes and assisted the team members in Dimensional modeling. Modeled Patient’s Order Fact table with 8 dimension tables, 4 bridge tables, and many supporting tables.
Suggested and facilitated the use of oracle partitioning where necessary along the SQL Tuning and mapping enhancements to improve the performance of the existing reports and data loads processing.

Confidential

Lead Informatica Architect/Developer

Responsibilities:

Confidential . Confidential was a senior member supporting the new development & Enhancements of the Provider Data Repository System and various other subsystems within the Enterprise Data Warehouse system.
As POC team member for Hadoop Implementation, configured Informatica PowerExchange for Hadoop Distributed File System, HDFS, for conducting data transfer to and from Informatica and HDFS. Successfully configured Informatica for writing into Hive database table.
More details in full version of the resume.

Technologies: Informatica PowerCenter 9.x.x, Oracle 11, TOAD, UNIX shell scripting, and Microsoft Office Products.

We provide IT Staff Augmentation Services!

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship