ETL Lead Architect Resume

SUMMARY

12+ years of total IT experience in the Requirements Analysis, Data Analysis, Application Design, Development and Implementations in Data warehousing business systems for various industries.
12+ years of ETL tool experience in using Designer Informatica Power center 10.x/9.x/8.x dealing with various Data sources like Redshift, Oracle, SQL Server, Netezza and Flat files
2 years of experience AWS cloud using Informatica and Redshift
1 year of Reporting tool experience in using Cognos Report net.
2 year of experience in DW reporting tool BO, MicroStrategy
Extensive experience in development of various business warehouse applications using ETL Tools Informatica 10.1,9.0.1, 8.6.1 8.1
Extensively worked on Informatica Power Center Components - Power Center Designer, Workflow Manager to create workflows and sessions, Workflow Monitor and Repository Manager.
Extensively worked on Informatica Designer Components - Source Analyzer, Warehouse Designer, Transformation Developer, Mapping Designer and Mapplet Designer.
Extensively worked on Informatica Power Center Transformations such as Source Qualifier, Lookup, Filter, Expression, Router, Normalizer, Joiner, Update Strategy, Rank, Aggregator, Stored Procedure, Sorter, Sequence Generator and XML Source Qualifier.
Expertise in different Informatica Performance Tuning issues like Source, Target, Mapping, Transformation, session to make them more efficient in terms of session performance.
Extensive experience in delivering critical solutions on various levels of project planning and execution, Quality Assurance and System/Business Analysis.
Experience with and strong expertise in developing enterprise-wide multi-dimensional data warehouses using dimensional models.
Expertise in creating derivations according to business requirement to be used by ETL for mapping source data to populate Data Warehouse and Data Mart.
Experience with ETL testing techniques and in verifying program logic and conducting unit tests and system integration tests of ETL routines.
Ability to learn and adapt to new technologies.
Self-motivated professional with excellent aptitude and communication skills.

TECHNICAL SKILLS

Operating system: Windows XP, NT, Unix, Vista

Programming languages & GUI: C,C++, VB+,Fotraan

Database & tools: Oracle10G, TOAD, DB2, Netezza,SQL Studio, SQL Server,Redshift

ETL tool: Informatica 10.1,8.6.1, Informatica 9.1

Reporting tool: Cognos Report Net 1.1, Business Objects XIR2, Microstategy

Scheduling Tool: Autosys, CronTab,Tivoli

Datamodel Tool: ER/Studio, Embercardo

Application: Guidewire, Nextgen, AWS Cloud

PROFESSIONAL EXPERIENCE

ETL Lead Architect

Confidential

Responsibilities:

Analyze the Guidewire database tables and get the requirement done with the users.
Prepare the requirement doc and get it sign off from the users.
Co-ordinate the work with offshore
Create ETL mappings and Jobs in the Datawarehouse.
Provided solutions to the complex business logics
High volume jobs have been tuned using the Informatica ETL tool.
Created the control table mapping design, error handling solutions and automation of scheduling jobs.

ETL Lead Architect

Confidential

Responsibilities:

Involved in the requirement phase of the project
Create mapping and workflow to send the agency information’s to the 3rd party to calculate the agency commission.
Supported QA team to complete the QA process
Lead the team of 5 members in the Project.

ETL Lead Architect

Confidential

Responsibilities:

Involved in Design, development and testing for data integration for the payment central system.
Involved in QA and supported the QA team
Lead the team of 6 members in the module.
Get the requirement for Cognos reports and coordinate job.
Production support for ETL and Cognos

ETL Lead Architect

Confidential

Responsibilities:

Involved in creating the requirement for a new DW build
Analyzed & provided solutions in the Informatica mappings
Involved in Design, development of Informatica mapping
Lead a team size of 12
Production support and solve the issues

We provide IT Staff Augmentation Services!

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship