We provide IT Staff Augmentation Services!

Etl Architect Resume

2.00/5 (Submit Your Rating)

Summary

  • 14+ years of total IT experience in the Business Requirements Analysis, Application Design, Data Modeling, Development, Implementations and Testing of Data warehouses and Database business systems for various Verticals like Banking ( National City Now PNC Bank ), Transport (FOSTER & WHEELER), Energy (GE POWER SYSTEMS), Financial(PRINCIPAL FINANCIAL GROUP, HP FINANCIAL SERVICES), Medical(JOHNSON & JOHNSON, PERSE TECHNOLOGIES) and Technology(UNITED PARCEL SERVICE), Insurance(SAFECO INSURACE).
  • 10+ years of ETL experience using Informatica Power Center 8.5/8.2/7.1.3/6.2/5.2/1.7, Informatica Power Mart 6.2/5.2/4.7.2 (Source Analyzer, Repository Server, Workflow Manger, Server manager, Mapping/Mapplet / Transformations / Warehouse Designers, Power Connects for ERP and Mainframes, Power Plugs), Data Junction 7.5.5(Map Designer, Process Designer, Record Layout Designer), Trillium 6.0, and Ascential DataStage 7.2/6.0/5.2 (DataStage Manager, DataStage Director, DataStage Designer, Multistage, Profile Stage).

Technical Matrix:

ETL TOOLS:

Informatica Power Center 1.7 thru 8.6 (Source Analyzer, Data warehousing designer, Mapping Designer, Mapplet, Transformations) , PMCMD, ETL Metadata.
Ascential DataStage 7.2/6.0/5.2 (DataStage Manager, DataStage Director, DataStage Designer, Multistage, Profile Stage).
Data Junction 7.5.5(Map Designer, Process Designer, Record Layout Designer)
Power Exchange, Power Analyzer.

Business Intelligence:

Business Objects 6.5/6.0/5.1/4.5,
Micro strategy 7.x/6.x,
Cognos Impromptu v7.0/6.x, Transformer v7.0/6.x, Cognos Power Play 7.0/6.x, Cognos Query (CQ)
Crystal Reports, MS Access Reports, Oracle Developer (Forms and Reports)

Data Modeling:

Dimensional modeling, Star-Schema Modeling, Snow-flake Modeling, FACT and dimension tables, Logical / Physical designs ,Data Mart, ODS.
ERWIN 4.2/4.0, Oracle Designer, Sybase Power Designer.

Databases:

Oracle 10g/ 9i/8i/7.x,
MS SQL Server 2005,2000/7.0/6.5,
DB2 UDB v9.1/ v7.2
Tera Data V2/R4.
MS Access 2000.

Operating Systems:

Windows - (Windows7,Vista,XP/2000/NT 4.0),
Unix - Sun Solaris 2.6/2.7, HP-UX, AIX 4.3.3

Programming:

SQL, PL/SQL, T-SQL, BTEQ, UNIX Shell Scripting, C, HTML,
Toad, FASTLOAD, MULTILOAD, TPUMP, SQL LOADER, MS SQLSERVER DTS PACKAGES.

Others:

Use Case Analysis, UML, Activity Diagrams, Sequence Diagrams, State Chart Diagrams, MS-Project, MS-Office, TRILLIUM (Data Cleansing tool),
Harvest (Version Control Tool)

Scheduling Tools

Autosys, Cron Scheduler, Tidal, Tivoli

Experience:

2008 to Confidential– Columbus, OH
To date ETL Architect.

Design, develop and implement ETL solutions for various PNC Bank Risk Management groups (RDM, AML, CRR and Credit Book) to publish reports for OCC, Federal Reserve and Internal Executives. The ETL solutions encompassed of developing 700+ mappings that load data from source systems to the corresponding Data warehouses and Marts

  • Provided Architectural Road Map, direction and work packets for ETL needs.
  • Created detail ETL Standards documents for Design, Development, Release Management and Production Support.
  • Design Detail ETL spec for offshore development and ensured Quality ETL Deliverables.
  • Created detail ETL Migration Processes for Informatica, Database, Scheduling, O/S and H/W teams.
  • Design and Develop Reusable Common objects shared across various Repositories.
  • Automated, Redesigned and tuned several ETL Process for optimal utilization of Time and resources.
  • Trouble Shoot, Tune and Maintain complex ETL Mappings.
  • Design and develop and Implement detail layout of ETL testing plan procedures.
  • Design Audit Balance and Control (ABC) for ETL process.
  • Provide estimations for ETL deliverables and oversee the progress for quality ETL Deliverables.
  • Created several Repository Mappings and Queries facilitating rapid analysis, trouble shooting, code verification and deployment.
  • Design and develop Meta data reports for the ETL, Business and Support teams for day to day needs.
  • Implemented Informatica PowerCenter 8 upgrade Project for the Corporate Servers.

2006 to Confidential– Columbus, OH

2008 ETL Lead

Design and implement ETL automation solution for front, middle and back offices for Office of Investments (OOI) and other Nationwide business partners. The ETL solution consisted of 1000+ mappings feeding data into EAGLE PACE database on Oracle.

  • Modeling the CIM (Common Information Model) rules into a functional star schema database design.
  • Work in close co-ordination with the SME\'s to reverse engineer database stored procedures to convert the encapsulated business logic into Informatica mappings.
  • Maintained warehouse metadata, naming standards and warehouse standards for future application development.
  • Identify and assess business needs, anticipate future data requirements and implement solutions within the data warehouse.
  • Reengineered ETL jobs and Processes to bring down the load times by more than 70%.
  • Install, Upgrade, Configure and Maintain Informatica Power Center.
  • Maintain Informatica Code via Versioning and also thru Harvest.
  • Responsible for designing ETL Process for integrating various source systems.
  • Coordinate and Implement Various Releases for the CIM.
  • Work Closely with Infrastructure team for Hardware capacity Planning.
  • Trouble Shoot, Tune and Maintain Informatica Repositories
  • Through understanding of enterprise data warehouses using Kimball methodologies.
  • Widely used Database objects like Views, Synonyms, Triggers and Global Links for reducing the load on ETL tools.
  • Tuning the ETL for Terabyte loads for Optimum Performance, Dependencies and Batch Design.
  • Generated and published Meta data reports for the data model ETL and Reporting for the business users.

2004 to Confidential- Summit, NJ

2006 date ETL - Architect
  • Modeling the business rules into a functional star schema database design.
  • Created Mapping documents that helps the ETL Team to build effective and efficient mappings.
  • Generated and published Meta data reports for the data model ETL and Reporting for the business users.
  • Install, Configure and Upgrade From Informatica Power Center 6.2 to Version 7.1.3.
  • Extensively used Mapplets and Reusable Transformations and Shortcuts.
  • Created Data Profiling for the source mappings for trapping the data related issues.
  • Responsible for Maintaining the Development, Test and Production Repositories.
  • Maintain the Project Releases for various global regions.
  • Maintained warehouse metadata, naming standards and warehouse standards for future application development.
  • Extensively used Designer (Source Analyzer, Warehouse Designer, Mapping Designer, Mapplet Designer and Transformation Developer) for creating Sources, Targets, Mappings, Reusable Transformations and Mapplets.
  • Used Filters, Routers, Lookups (Connected and Unconnected), Expressions, Update Strategy, Union Transformation, Aggregator and Sorter Transformations.
  • Tuning the Mappings for Optimum Performance, Dependencies and Batch Design.
  • Migrated mappings, sessions, and common objects from development to test and to production.
  • Optimized Informatica mappings for performance improvement at mapping, transformation and session and database level.
  • Using Informatica Repository Manager to maintain the metadata, Security and Reporting.

2003 to Confidential- Des Moines, IA

2004 ETL Architect

  • Staging the information from various sources of PFG (Principal Financial Group) and external system for the RIS FDW.
  • Understand the business rules and implement the same into a functional star schema database design.
  • Modeling and populating the business rules using mappings into the Target Data base.
  • Install and Upgrade From Informatica Power Center 6.2 to Version 7.1.
  • Created Data Profiling for the source mappings for trapping the data related issues.
  • Maintain Development, Test and Production Repositories.
  • Maintained warehouse metadata, naming standards and warehouse standards for future application development.
  • Extensively used Designer (Source Analyzer, Warehouse Designer, Mapping Designer, Mapplet Designer and Transformation Developer) for creating Sources, Targets, Mappings, Reusable Transformations and Mapplets.
  • Used Filters, Routers, Lookups (Connected and Unconnected), Expressions, Update Strategy, Union Transformation, Aggregator and Sorter Transformations.
  • Extensively used Unix scripts for invoking the Informatica Batches and Sessions and for archiving log files, source files.

2003 to Confidential,Atlanta, GA
2003 Data warehousing Consultant

  • Business Analysis and Requirements Collection for Patient, Visit, Prescription, Event, Medication and Diagnosis Subject Areas.
  • Loading the Data from Flat Files and COBOL Copybooks into the Staging area using Informatica Power Center 5.1.
  • Install and Upgrade From Informatica Power Center 5.2 to Version 6.2.
  • Created complex and Reusable Mappings to Populate the Target PCSS Star schema.
  • Extensively used XML for Metadata Exchange and Data Portability.
  • Optimized Query Performance, Session Performance and Reliability.
  • Extensively used Transformations for homogeneous and heterogeneous data joins,
  • Used data base objects like Materialized view, Sequence generators, Parallel Partitioning and Stored Procedures for accomplishing the Complex logical situations and Memory Management.
  • Handle the Migration process from Development, Test and Production Environments.
  • Set Standards for Naming Conventions and Best Practices for Informatica Mapping Development.
  • Repository Meta data Management and Reporting.
  • Identify the business rules for data migration and Perform data administration through data models and metadata.
  • Created the Star Schemas using Erwin.
  • Designed the Slowly Changing Dimension strategy for the Warehouse.
  • Migrate the Metadata changes to the Informatica repository.

2002 to Confidential,Atlanta, GA
2003 ETL Lead

  • Parsing high-level design spec to simple ETL coding and mapping standards.
  • Research Sources and identify necessary Business Components for Analysis.
  • Populated data for SCS-DWH (Supply Chain Solutions – Data warehouse) target database, which is a Source for PROD-BIA and Central NJ Data warehouse.
  • Migrated ETL tool from Informatica 5.1 to Data Junction 7.5.5.
  • Convert the Informatica Designer mapping to Data Junction Map Designer Conversions.
  • Responsible for Routing the Customer Contact and Address data from SIF database to Trillium 6.0 where Address Cleansing and Standardization was done using Converter, Parser, Geo-coder and Matcher.

2001 to Confidential,Bridgewater, NJ
2002 Lead-Data warehousing Analyst

  • Migrated from DataStage 5.2 to Informatica 5.1 for the entire mapping in FDW.
  • Used DataStage Manager for data loading and management.
  • Business Analysis and Requirements Collection
  • Using DataStage Designer designed and Created Jobs for Target Warehouse Entity for Oracle.
  • Interpret the information from various operational sources of J&J and external system to create a road map for the Data warehouse designing.
  • Maintain Development, Test and Production Jobs migration Using DataStage Administrator. Also used DataStage Manager to maintain the metadata, Security.
  • Install / Uninstall, Maintain and Document the DataStage setup on multiple environments.
  • Reverse Engineering of source data (Khalix and BMC) for mapping to Financial Data Warehouse (FDW)
  • Using Informatica Designer designed and Mappings for Target Warehouse Entity for Oracle.

Additional Professional Experience (1997 – 2001)

2001 to Confidential,Seattle, WA

2001 Lead ETL Developer

1999 to Confidential,Atlanta, GA

2000 Sr. ETL Developer 1998 to Confidential,Clinton, NJ 1999 ETL Developer

1995 to Confidential,India

1997 Analyst / Support

EDUCATION:

  • Masters in Business Administration
  • Diploma in Marketing and Sales Management
  • BS Computers and Electronics

We'd love your feedback!