We provide IT Staff Augmentation Services!

Etl Team Lead/architect Resume

Santa Ana, CA

SUMMARY:

  • Ten plus years of IT/ Engineering experience as ETL Team Lead / Architect / Senior Data Warehouse Developer
  • Technical proficiency in Data Warehousing teamed with Business Requirements Analysis, Application Design, Data Modeling, Development, Testing, Creating Report and Documentation.
  • Lead offshore teams and provided technical guidance to team members
  • Nine Plus years of Informatica PowerCenter 9.6/9.5/8.6/8.1 experience
  • Three Plus years of Business Intelligence experience using Crystal reports Enterprise XI, SSRS, Business Objects XI R2/R3 and OLAP.
  • Nine Plus years of experience using Netezza, Oracle, DB2, MS SQL Server, SQL, XML, PL/SQL, SQL*Plus and SQL*Loader
  • Nine Plus years of experience in PL/SQL Stored Procedures, Packages, .NET, C#.
  • Good understanding of Dimensional Data Modeling experience using Star Schema/Snowflake modeling, FACT & Dimensions tables, Physical & logical data modeling using ERWIN 4.5/4.0.
  • Good experience in different industries including Health Insurance, Financial, Retail and Publishing.
  • Experience in all aspects of the Software Development Life Cycle which includes Analysis, Design, Development, Testing, Implementation and Support with specific focus on development.
  • Experience in coordinating with Business Analysts, QA team, DBA team and End Users at various stages of Software life cycle.
  • Experience in Scrum, Agile Methodology.

TECHNICAL SKILLS:

Data Warehouse: Informatica PowerCenter 9.6/9.1/8.6/7.1 Business Objects Data Integrator (BODI), PowerMart 9.0/8.2, PowerConnect, OLAP, OLTP, SSIS

BI & Reporting: Crystal Report XI/9.0, SSRS, Cognos 8.0, Business Objects XI R2/R3

Data Modeling: Physical Modeling, Logical Modeling, Relational Modeling, Dimensional, ERWIN 4.5/4.0

Databases: Netezza, Oracle 12i/11g/10g, MS SQL Server 2005/2000, MySQL, Postgres, IBM DB2, PL/SQL, SQL*Loader, Developer 2000

Languages: PL/SQL, Java, C, C++, VB

PROFESSIONAL EXPERIENCE:

Confidential, Santa Ana, CA

ETL Team Lead/Architect

Responsibilities:

  • Interacted with Business Community, Business Analysts and Database Administrators to identify and analyze business requirements for new and existing projects.
  • Lead offshore team and provided technical guidance to team members
  • Lead projects in different phases of analysis, design, coding, testing and documentation.
  • Extensively worked on Data Modeling, Start Schema, Data Marts, ODS, MDM and ETL Methodologies
  • Created Technical Design Document
  • Extensive development using Informatica 9.6/9.1, testing, debugging and finally implementing requirements.
  • Performance tuning of ETL code
  • Worked extensively on PL/SQL DML and DDL statements and Stored Procedures.
  • Lead review process of Data Model, Data mapping, and testing for related projects.
  • Implemented Scrum Methodology and Software Development Life Cycle.

Confidential, Wichita, KS

Senior ETL Developer/Lead

Responsibilities:

  • Interacted with the Business Community, QA team and Database Administrators to identify and analyze the business requirements for new or existing project and data realties.
  • Performed both ETL Architect and Developer role.
  • Involved in creating Technical Design Document, coding by using Informatica 8.6, testing, debugging and finally implementing the requirement.
  • Involved in creating reports using Business Objects, Cognos.
  • Lead the review process of Data mapping and testing for related projects.
  • Mentored junior developers and people from other background.

Confidential, Lewisville, TX

Senior ETL Developer

Responsibilities:

  • Lead projects in different phases of analysis, design, coding, testing and documentation.
  • Extensively worked on Data Modeling, Data Marts, and ETL Methodologies
  • Involved in creating Technical Design Document, coding by using Informatica 8.6, testing, debugging and finally implementing the requirement.
  • Performed Code review for related projects and mentored junior developers with best practices.
  • Worked on Production support to maintain the existing code.
  • Implemented Agile Methodology and Software Development Life Cycle.

Confidential, Buffalo, NY

ETL Tech Lead

Responsibilities:

  • Interacted with the ETL Architect, End User and Business Analysts to identify and analyze the business requirements for new or existing project.
  • Worked and updated the existing Data Modeling using Erwin 4.5 to improve overall efficiency.
  • Lead the review process of Data Model, Data mapping, Data quality and testing for related projects.
  • Involved in creating Technical Design Document, coding by using Informatica 8.5, testing, debugging and finally implementing the requirement.
  • Designed and Developed PL/SQL stored procedures and packages to create generic programs.
  • Involved in Performance Tuning of the existing project and improved the functionality of the code.
  • Created simple report for upper management using Business Objects R2.
  • Created Best Practice documentation and mentored junior developers.

Confidential, Parsippany, NJ

Team Lead

Responsibilities:

  • Lead a medium Project with 3 off - shore developers and 1 on-site developer.
  • Interacted with the business community and database administrators to identify the business requirements.
  • Extensively worked on Architecture, Design, Performance tuning, Code review and Implementation.
  • Worked extensively on different framework of .NET

Confidential, Houston, TX

Informatica Developer

Responsibilities:

  • Wrote documentation to describe program development, logic, coding, testing, changes and corrections to build Monthly Data mart and Bank Card Services Data Warehouse.
  • Implemented Aggregator, Sorter, Router, Filter, Joiner, Expression, Lookup, Update Strategy, Union and Sequence Generator transformations.
  • Used Debugger to test the mapping and fixed the bugs.
  • Developed Test Cases for Unit, Integration and System testing and provided solutions for Test Reports.

Confidential

Application Developer

Responsibilities:

  • Worked on different framework of .NET
  • Instrumental in designing the database with the help of Entity Relationship diagrams and models.
  • Participated in design and development of all the tables, views in Oracle.
  • Wrote PL/SQL stored procedures/functions to build business rules, requirements.

Hire Now