We provide IT Staff Augmentation Services!

Data/etl Architect Resume

CA

SUMMARY:

  • 16 + years of experience in Software Development and Database Design in the areas of Commercial and Business Applications as a Project manager, Architect, Technical Lead, & and Application Developer.
  • Extensive knowledge in wide range of RDBMS software specifically built for DW&BI initiatives like Teradata, Oracle and DB2 UDB
  • Extensive knowledge in managing complex IT projects with a cross - functional team of business, development, quality assurance, usability engineering and production support teams.
  • Focused experience in Information Technology with a strong background in Database development, Data warehouse ETL process using SSIS, Informatica PowerCenter 9.6/8.x/7.x (Workflow Manager, Workflow Monitor, Administrator console, Source Analyzer, Data Warehousing Designer, Mapping Designer, Mapplet Designer, Transformation Developer), Informatica Data Quality and Power Mart 5.1 Data Mart.
  • Extensive experience in Financial (GECCF, Confidential and Confidential ), and Bio-Pharmaceutical ( Confidential and, Confidential ), Government /Federal ( Confidential ) and Semiconductor ( Confidential ) domain.
  • Coordinating and monitoring the project progress to assure the flow and completion of work on schedule.
  • Dimensional Data Modeling experience using Data modeling, Erwin 4.5/4.0, Star Join Schema/Snowflake modeling, FACT & Dimensions tables, Physical & logical data modeling.
  • Extensive experience Data Analysis, User Requirement Gathering, User Requirement Analysis, GAP Analysis and Source Systems Analysis.
  • Data Analysis, Data Cleansing, Data Reconciliation, Data Discrepancy, Data Scrubbing & Data Validations.
  • Excellent experience in SQL Tuning and Application Tuning.
  • Hands on experience in Writing the PL/SQL Stored Procedures, Functions.
  • Experience in BO universe and creating reports.
  • Extensively worked on terabyte size of databases
  • Excellent Experience in writing the Shell Scripting (sh, ksh)
  • Good understanding of Siebel Analytics RPD and reports.
  • Conversant with all phases of Software development cycles involving Systems Analysis, Design, Development, testing and Implementation and user co-ordination.
  • Documentation, Training end-users, Enhancements and Support of the Application in a live production.
  • Ability to handle multiple tasks, decisive with strong leadership qualities, flexible in work schedules, adept in conducting knowledge transition sessions and possess good communication skills.

TECHNICAL SKILLS:

Operating System: Windows 9x, Windows NT, 2000 Server, LINUX

Hardware: IBM PC

Language: ASP, Visual Basic 6.0, Java

Data Modeling: Erwin, Rational Data Architect, Microsoft Visio

ETL: Informatica PowerCenter 9x/8x/7x,MM,MDM Power connect 7.1, SSIS

Tools: Visual InterDev 6.0, Erwin, Toad, VSS

BI: Business Objects, Siebel Analytics, SSAS

RDBMS: Oracle 9i, Teradata, SQL Server 7.0/2000, MS Access 98

AREAS OF EXPERTISE:

  • Data Warehouse Architecture
  • Business Analysis
  • Project Management
  • Business Requirements Gathering
  • Business/ Technical Impact Analysis
  • IT Strategy and User Defined Documentation
  • Use Case Development
  • Process Flow Design
  • Technical Design Specifications
  • Develop Functional Specifications
  • Data Analysis
  • User Interface Design
  • QA Analysis & User Acceptance Testing
  • Application Training Documentation
  • Customer Relationship Management
  • Financial Analysis
  • Supply Chain Management
  • Onshore-Offshore Global Delivery Model
  • Technical Assessments

PROFESSIONAL EXPERIENCE:

Confidential, CA

Environment: Informatica 9.5/9.1/10.1 , Informatica MDM, DQ, Oracle, Hadoop MapR, Hive and Spark.

Data/ETL Architect

Responsibilities:

  • Understand requirement definition document (RDD) provided by the business.
  • Working with the SME to understand the RDD and requirements.
  • Design ODS system to stage the data to Hadoop system.
  • Designed ETL Design specification documents to develop Informatica mappings.
  • Developed Informatica mapping, Workflow and Worklet.
  • Building and maintaining the metadata repository.
  • Loading and scheduling the sources to update the metadata.
  • Design and Developed data quality mappings
  • Oracle query and Informatica mappings, workflows performance tuning
  • Setup the Informatica mapping to load the data into Hadoop hive database.

Confidential, TX

Environment: Informatica 9.5/9.1, Informatica Metadata Manager, Oracle, SSIS, Erwin Micro Strategy.

Data/ETL Architect

Responsibilities:

  • Build brand new data warehouse environment including newly acquired Informatica and Microstrategy
  • Working with the SME to collect all the requirements across the departments.
  • Understand requirement definition document (RDD) provided by the business.
  • Dimensional Data Modeling to deliver Multi-Dimensional STAR schemas
  • Worked on Logical & Physical Data modeling, which involved Identifying the facts & dimensions, grain of the fact, aggregate tables etc., for Dimensional Models by using Erwin.
  • Designed ETL Design specification documents to develop Informatica mappings.
  • Extensively worked on Informatica mapping, Workflow, worklet.
  • Worked on informatica Master Data Management (MDM).
  • Worked on setup Informatica CDC process.
  • Building and maintaining the metadata repository.
  • Working as Informatica administrator and perform all the duties by implementing and managing the roles and privileges of the users.
  • Develop SSIS package for certain dataset
  • Converting SSIS package into Informatica mappings and workflows
  • Developing a prototype for the master data management by using Informatica MDM.
  • Worked on Oracle stored procedure to meet business requirement.
  • Analyzing the source and target system data architecture.
  • Design and implement the data reconciliation process.
  • Oracle query and Informatica mappings, workflows performance tuning
  • Designed and Developed Error handling processes.
  • Defined the Best practice document for Informatica.
  • Analyze and Resolve data issues which are identified during the UAT phase.
  • Adapted ETL Best Practices and followed the ETL naming conventions.

Confidential, CA

Environment: Informatica Power Center 9.5/9.1, Oracle, Toad, Informatica Power Exchange net weaver.

ETL/Data Architect

Responsibilities:

  • Understand requirement definition document (RDD) provided by the business and understand the manual reporting.
  • Dimensional Data Modeling to deliver Multi Dimensional STAR schemas
  • Logical & Physical Data Modeling, which involved Identifying the facts & dimensions; grain of the fact; aggregate tables, etc for Dimensional Models
  • Designed ETL Design specification documents to develop Informatica mappings.
  • Extensively worked on Informatica mapping, Workflow, worklet
  • Worked on Oracle stored procedure to meet business requirement.
  • Analyzing the source and target system data architecture.
  • Design and implement the data reconciliation process.
  • Designed to extract the data from JD Edwards
  • Designed and Developed Error handling processes.
  • Defined the Best practice document for Informatica.
  • Analyze and Resolve data issues which are identified during the UAT phase.
  • Adapted ETL Best Practices and followed the ETL naming conventions.
  • Working with Qlicview reporting team during the data reconciliation process.

Confidential, TX

Environment: Informatica Power Center 9.5/9.1, SSIS, SSAS, SQL Server, Toad, Informatica Power

ETL Architect/Data Architect

Responsibilities:

  • Understand system business rules, analyze and System design and work on project proof of concepts.
  • Designed ETL Design specification documents to develop Informatica mappings and SSIS Packages.
  • Dimensional Data Modeling to deliver Multi Dimensional STAR schemas
  • Logical & Physical Data Modeling, which involved
  • ER Modeling - Developing Entity Relationship Diagrams (ERD)
  • Normalizing the tables to 3NF/relationships to arrive at effective Relational Schemas
  • Implementation of Business Rules in the Database using Constraints & Triggers
  • Identifying the facts & dimensions; grain of the fact; aggregate tables, etc for Dimensional Models
  • Developing Snowflake Schemas by normalizing the dimension tables as appropriate
  • Worked on Informatica BCI configuration and presenting the proof of concepts of Informatica BCI adaptability
  • Analyzing the source and target system data architecture.
  • Design and implement the data reconciliation process.
  • Designed to extract the data from SAP ECC, BW and SAP extractor by using Informatica power exchange net weaver.
  • Designed and Developed Error handling processes.
  • Co-ordination with multiple teams for resolving data issues.
  • Communicating with the offshore team to get the work status of the team members
  • Assigning the work to the offshore team based on the team band width.
  • Defined the Best practice document for Informatica and SSIS ETL development.
  • Design the job scheduling by using Control-M scheduling tool.
  • Risk analysis and setting the mitigation plan.
  • Resolving data issues and set up issues during UAT phase.
  • Build cube for the reporting by using SSAS
  • Adapted ETL Best Practices and followed the ETL naming conventions.
  • Involved in informatica performance tuning.
  • Involved in Designing the Process-flow workflow for Incremental Load.

Confidential, TX

Environment: Informatica Power Center 8.6, SSIS, Oracle 11g, SQL Server, Toad, UNIX, Power Exchange

ETL Lead/Architect

Responsibilities:

  • Understand system business rules, analyze and System design (ETL Design) and Development.
  • Designed ETL Design specification documents which will be later used by the ETL Development team.
  • Extensively used all SSIS tools and various transformations - Lookup, Derived column, Data conversion, Aggregate, Conditional split, SQL task, Script task and Send Mail task etc to generate SSIS packages.
  • Analyzing the source and target system data architecture.
  • Designed and Developed Error handling processes.
  • Co-ordination with multiple teams for resolving data and environmental set up issues.
  • Defined the Best practice document for ETL development.
  • Risk analysis and setting the mitigation plan.
  • Resolving data issues and set up issues during UAT phase.
  • Adapted ETL Best Practices and followed the ETL naming conventions.
  • Communicating with the offshore team to get the work status of the team members
  • Designed logical model to develop the cube and refresh strategy by using SSAS.
  • Assigning the work to the offshore team based on the team band width.
  • Involved in SQL query performance tuning.
  • Involved in Designing the Process-flow workflow for Incremental Load.

Confidential, CA

Environment: Informatica Power Center 8.6, Oracle 10g, ModelN, XML, Toad, Agile, UNIX

Informatica Lead/Architect

Responsibilities:

  • Understand system requirement, business rules, analyze and System design (Informatica Design) and Development.
  • Designed ETL Design specification documents with the help of Data modeling team. These ETL Design specifications were later used by the ETL Development team to create Informatica maps.
  • Extensively used all Informatica Client tools and various transformations -Lookup, Filter, Expression(reusable), Router, Joiner, Update Strategy, Aggregator, Stored Procedure, Sorter, Sequence Generator,Normalizer, Mapplets to generate Informatica ETL’s.
  • Worked on the strategy to load the data into complex xml target.
  • Analyzing the source and target system data architecture.
  • Worked with Data Modelers to Design Data structure for loading extracted data.
  • Designed Informatica mapplets and worklets to utilize the reusability feature of Informatica.
  • Designed and Developed Error handling processes.
  • Co-ordination with multiple teams for resolving data and environmental set up issues.
  • Defined the Best practice document for Informatica ETL development.
  • Designed Informatica mapplets and worklets to utilize the reusability feature of Informatica.
  • Designed to extract the data from SAP to oracle database by using the informatica Power Connect.
  • Risk analysis and setting the mitigation plan.
  • Resolving data issues and set up issues during UAT phase.
  • Adapted ETL Best Practices and followed the ETL naming conventions.
  • Communicating with the offshore team to get the work status of the team members
  • Assigning the work to the offshore team based on the team band width.
  • Provide the project status report to the client on every weekend.
  • Involved in informatica and Oracle query performance tuning.
  • Involved in Designing the Process-flow workflow for Incremental Load.

Confidential, MN

Environment: SSIS, Oracle 10g, Business Objects 6.5, Toad, Agile, UNIX and Windows XP.

Technical Lead

Responsibilities:

  • Was part of the CORE team during the Analyze, Architect, Design, Build, Test, Deploy and Operate phases.
  • Interacted with business analysts, architects and application developer to analyze the data model and gathered the requirements.
  • Analyzed existing requirements and consolidated the reports for effective and efficient reporting.
  • Used ETL (SSIS) to develop jobs for extracting, cleaning, transforming and loading data into data warehouse.
  • Involved in the Migration of Databases from SQL Server 2005 to SQL Server 2008.
  • Prepared the complete data mapping for all the migrated jobs using SSIS.
  • Created databases and schema objects including tables, indexes and applied constraints, connected various applications to the database and written functions, stored procedures
  • Designed SSIS Packages to transfer data from flat files to SQL Server using Business Intelligence Development Studio.
  • Extensively used SSIS transformations such as Lookup, Derived column, Data conversion, Aggregate, Conditional split, SQL task, Script task and Send Mail task etc.
  • Used Execution Plan, SQL Profiler and Database Engine Tuning Advisor to optimize queries and enhance the performance of databases.
  • Extensively worked on tuning mappings and reducing processing times.
  • During Architect Phase, translated the business requirements to the technical design documents. Developed the Architecture Logical and Physical views. Devised the Change Control procedures from the ETL perspective. Assisted the Data Architect in the Volumetric analysis and requirement.
  • Involved in Designing the Process-flow workflow for Incremental Load.
  • Involved in SQL query performance tuning. And reduced nearly 2 hours of production window.
  • Involved in Data profiling, Data Cleansing and Testing.

Confidential, CA

Environment: Informatica Power Center 8.6, Teradata V2R5, DB2 UDB, XML, Business Objects 6.5, Agile, UNIX and Windows XP.

Informatica Architect/Lead

Responsibilities:

  • Participated in requirement review for FCAT enhancements and validated feasibility of requirements with respect to implementation.
  • Wrote functional and technical documents such as Functional Designs and Technical Designs. Some examples of functionalities documented are ‘Financial consultant commission’, ‘Converting server utilization time into cost’ etc.
  • ETL Architecture, Data Modeling
  • Dimensional Data Modeling to deliver Multi Dimensional STAR schemas
  • Design & Implementation of Data Mart; DBA coordination
  • Logical & Physical Data Modeling, which involved
  • ER Modeling - Developing Entity Relationship Diagrams (ERD)
  • Normalizing the tables to 3NF/relationships to arrive at effective Relational Schemas
  • Implementation of Business Rules in the Database using Constraints & Triggers
  • Identifying the facts & dimensions; grain of the fact; aggregate tables, etc for Dimensional Models
  • Developing Snowflake Schemas by normalizing the dimension tables as appropriate
  • Involved in prioritizing the enhancement task.
  • Coordinating with the offshore team and allocating the tasks to the team.
  • Used Agile methodologies for the project development
  • Involved in configuring the power exchange to bring the data from Siebel CRM system.
  • Developed Informatica mappings and workflows.
  • Configured and worked on pushdown optimizer
  • Involved and developed B2B Data Transformation.
  • Developed unix shell scripts to send email to the users about the job status.
  • Involved in developing BO universe and multiple reports.
  • Developed BTEQ script to accomplish the business rules and to improve the performance.
  • Wrote UNIX BTEQ scripts to manage and collect statistics daily
  • Documented Enterprise Integration Standards and Best Practices to be used within development team. This provided pointers on integration techniques to use, naming conventions to follow, how to reduce network overload and maximize performance etc.
  • Handled production support activities and troubleshoot the issues during the production runs.
  • Involved in informatica and Teradata performance tuning. And reduced nearly 6 hours of production window.

Confidential, NJ

Environment: Informatica Power Mart 7.2, Siebel Sales Analytics 7.2.1, XML, Agile, SQL ServerErwin 4.5 and Windows 2000.

Onsite Informatica Lead/ Architect

Responsibilities:

  • Collaborate with client business leaders, executives, SMEs, information technology and business users on full life cycle engagements.
  • Wrote functional and technical documents such as Functional Designs and Technical Designs.
  • Responsible for Conceptual data modeling; logical and physical data modeling
  • Responsible for Dimensional Data Modeling to deliver Multi Dimensional STAR schemas
  • Coordinating with the business users
  • Extensively worked in Oracle SQL, PL/SQL, Query performance tuning, Created DDL scripts, Created database objects like Tables, Indexes, Synonyms, and Sequences etc., closely worked with DBAs to create Physical Databases.
  • Designed and developed mapping, transformation logic and processes in Informatica for implementing business rules and standardization of source data from multiple systems into the data warehouse to reduce the cost of the project adopted agile methodologies .
  • Maintained source and target mappings, transformation logic and processes to reflect the changing business environment over time.
  • Provide project leadership to an onsite team of 4 employees, including: Production timetable; status reporting and client/project team co-ordination.
  • Developed Informatica mappings and workflows, worklets and sessions
  • Developed Reports and RPD in Sales analytics
  • Creating user Id in Siebel analytics and granting the user level permission
  • Handled production support activities and troubleshoot the issues during the production runs.
  • Involved in informatica performance tuning.

Confidential, CA

Environment: Informatica Power Mart 7.2, OBIEE (Seibel Analytics), Oracle 10g, Toad, Erwin 4.5

Technical Lead/Informatica Architect

Responsibilities:

  • Conducted focus group sessions and interviewed subject matter experts to understand the requirement of the of the business partners.
  • Coordinating and monitoring the progress of project to assure the flow and completion of work on schedule.
  • Build ETL Design specifications which helps as LLD for the development of the mappings
  • Dimensional Data Modeling to deliver Multi Dimensional STAR schemas.
  • Data Reconciliation, Data Discrepancy and Generated the Data Audit Reports.
  • Ensured the Business Rules and Data Validation.
  • Created the Informatica Workflows, Worklets, Mappings and Sessions
  • Created number of reusable transformation according to the same business needs. Majority of the transformations used are Normalizer, Joiner, Filter, Aggregator, Router, Sequence Generator etc.
  • Created PL/SQL Stored Procedures, Function to accomplish the business rules
  • Involved in Designing the Process-flow workflow for Incremental Load.
  • Created Indexes, Views and Materialized Views to improve the performance.
  • Involved in writing the test cases and documentation

Hire Now