Lead Etl Architect Resume
El Segundo, CA
SUMMARY
- I am Informatica professional with 9+ years of job experience in Analysis, Design and Development using Data Warehousing, with Informatica Power Center 8/9.6.1, and with DB Systems i.e. Oracle, SQL Server and Teradata. Also have 4.5 Years of experience working with Informatica MDM and Data Modeling technology as well.
- Experience in designing the complete ETL architecture along with the physical Data Base/Model Design solutions for clients like Pfizer and Confidential .
- Prepared the Logical, Universal and Physical Entity Relationship Diagrams (ERD).
- Prepared Data Model using Erwin Modeling (Erwin 7.3) and Toad Data Modeler.
- Rewarded for Designing the architecture of Error/Reject capture and reprocessing them along with source.
- Strong Experience in Designing technical documents/Updating functional documents, Source to Target Matrix, developing mappings, sessions, workflows and preparing unit test results.
- Experience in onsite - offshore model.
- Hands on Experience in designing MDM solutions for clients like Pfizer and Confidential . by applying various Match and Merger rules and then flowing them to for further processing in ETL for report needs.
- Performed all phases of development including Extraction, Transformation, Loading (ETL) data from Heterogeneous sources into Data Warehouses and Data Marts using Power Center (Designer, Workflow Manager, and Workflow Monitor) and Teradata Utilities.
- Extensive experience in extraction, transformation and loading of data directly from different heterogeneous source systems like Flat files, Oracle, SQL Server. Extensively worked on Informatica Designer Components - Source Analyzer, Warehousing Designer, Transformations Developer, and Mapping Designer.
- Hands on experience with complex mappings from varied transformation logics like Unconnected and Connected lookups, Router, Aggregator, Joiner, Update Strategy and re-usable transformations. Strong Experience on Workflow Manager Tools - Task Developer, Workflow & Work let Designer.
- Knowledge of dimensional modeling/data modeling (star schema and snowflake schema) and Teradata specific LDM's.
- Good knowledge of Teradata Financial Services Logical Data Model (Knowledge of Foundation, Banking) did analysis for PI and SI Extended Logical Data Model and Physical Data Model.
- Created reusable transformations and mapplets to reduce the complexity in mappings and to handle repetitive tasks.
- Experienced as Teradata DBA and used Teradata Performance Monitor, Viewpoint.
- Involved in preparing test plans and cases for unit testing based on requirements.
- Hands on Experience in Testing, Debugging, Validation and Performance Tuning of data warehouse.
- I have worked on various domains i.e. Telecom, Product, Retail and Banking and Life Science (Pharma) domain.
- I have Strong experience in Data warehousing, Data Integration, Data Migration from Dev to QA and then to Prod.
- I have worked on OPTIMIZING Query and Look-up Performance.
- I have worked on Performance Tuning by observing the Performance bottlenecks at
- Around 6 years of experience of working with Oracle, Teradata, and UNIX.
- Around 2 year of experience of working with SQL Server.
- Good understanding of Requirement Specification and preparing Development Estimations.
- Extensively worked with transformations, mappings and sessions.
- Performed Deployment/Infrastructure/Amin for Informatica Power Center.
- Strong experience in creating and managing JOBs and JOB Plans or APPs in UC4 and Autosys.
TECHNICAL SKILLS
ETL Tools: Informatica 8/9.6 (Power Center), Oracle Data Integrator 11g 11.1.1.6.0
MDM Tool: Informatica MDM 9.0
Data Modeling: Erwin 7.3, Toad Data Modeler
RDBMS: Oracle 10g, 11g, 12C, SQL Server 2008/12, Teradata, DB2, Nateeza
Scheduling tools: UC4, CA Work Load Automation DE, CronTab
Operating Systems: Windows, UNIX/LINUX. HP-UX 10.2, 11, SUN/Solaris 5-10
GUI Applications: TOAD, MS Office
Defect Tracking: HP Quality Center, IBM Rational Clear Case
Specialty Skills: Informatica P/C Admin activities, Strong SQL TuningProject Estimation/Planning skill worked on Accenture Internal Estimator Tool, Documentation and Team building
PROFESSIONAL EXPERIENCE
Confidential, El Segundo, CA
Environment: Informatica Power Center 9.0.1, Oracle 11g, Teradata, Nateeza, Informatica MDM
Lead ETL Architect
Responsibilities:
- Currently I am supporting all these 3 application as part of production support phase since May 2014, Mean while also I do enhancements on exiting jobs in production whenever it is required.
- Worked to gather functional requirements for
- Various Cost Comparison Reports for all products over various vendors over the years
- Weekly and Monthly Forecasting Reports to find out Need to Produce, Produced till date and yet to produce.
- Have prepared Technical Design Documents as per Mattel Standards for business sign off.
- Lead the team as an architect and prepared the complete Physical Model of LTVQA and INTERIM VQA solutions and developed a robust Logical and Physical Model
- Created Data dictionary using ERWIN modeler.
- Have designed the Flow Diagrams and updated the STM for INTEIRM and Long Term VQA by continuously following up with client.
- Prepared the Architecture of Tracking all the data from source those are either having error or not valid as per business requirement.
- Have prepared the Unit Test Case documents to capture all the business rules and requirements.
- Did conduct peer code review for ETL codes to ensure standard practices are followed by each individual, few as per the client specific rest as per normal standards we follow in day to day process.
- Have prepared small small scripts to process files One-by-One from source to staging area to pick the file and further processing and then to move the file from staging to archive folder to archive the files after the completion of its ETL process.
- Have created the Jobs than Defined Job Plans and Master Job Plan in UC4 Scheduling to schedule the jobs as per the business requirement.
- Took Complete Ownership of Migrating each and every objects (DB Objects, DB permissions, Informatica Shared Folder Objects, Informatica mappings, sessions and workflows, UNIX parameter files. Temporary files and scripts to move file from source to stage and archiving the files after their successful completion.
- Enforced ETL standards to various ETL objects like Shortcuts and Naming Standards, Mapping, Session and Workflow Level Standards and Log Mechanism.
- Used Mapping and Session Parameters and Variables for incremental read and other extract and load process.
Confidential, Madison, New Jersey
Environment: Informatica Power Center 9.0.1, Oracle 9 (TOAD), Teradata
Informatica MDMToad Data Modeller
Responsibilities:
- Worked partly to update (10-15% update) the functional design documents by gathering the functional things from client over calls/meetings.
- Have prepared the initial massive technical design documents (more than 100 pages) for signed off.
- Designed the complete Logical and Physical Data Model for Pfizer PACE, GP solutions.
- Designed Entity Relationship Diagrams of specific database platforms, convert physical model from one database platform to another, create an ER Diagram directly from your database (Reverse Engineering feature)
- Did Automatic generation of SQL code for selected objects (SQL code generation is not available in Logical and Universal Model.
- Build Automatic migration of PK attributes to child entities.
- Have designed the flow diagrams, process diagrams, requirement traceability matrix, updated the source to target matrix by continuously following up with client.
- Worked on 6 key Interfaces (MTP, HRP, GREENSTONE, DIRECT SALES, SPAP AND RPU)
- Prepared the Main UNIX Scripts of more than 1000 lines with CONFIG file, PACE LIBRARY file to call the workflows and populate mails for success, failure or partial failure with reconciliation details.
- Prepared the architecture of log mechanism with team. This is highly identified and awarded and later it is identified as best and implemented the same across other releases to make it centralize.
- Have prepared the Unit Test Case documents to capture all the business rules and requirements.
- Taking care of issues and change requests from onsite team.
- Fixing the new changes in developed mappings.
- Have prepared the Deployment Guide Documents which is followed by Deployment Team during deploy the code from one environment to another.
- Have given Various KT session to new joiners to team, to TEST Team to prepare their test script for functional test.
- During test cycles have updating regularly the defect status (closed, ready to retest etc.) in Quality Center for the team, assigning the defects to respective primary developer and attending daily defect calls status with onshore and client to update the defect in summary.
- Currently working as a production support.
- Took interviews (Internal and External) for my team as well as other teams across Pfizer.
- Given 2 Informatica training sessions to laterals (1 session is of 5 days)
Environment: Informatica Power Center 8.6, Oracle 11g, HP-UX, HP Quality Center 10Teradata, Tidal.
Confidential
ETL Developer & Tester
Responsibilities:
- Involved in MTP Activities.
- Involved in executing the various test cases.
- Taking care of issues and change requests from onsite team.
- Fixing the new changes in developed mappings.
- Involved in validating mappings and workflows.
Environment: Informatica 8.1, Oracle 10g Release 2, Teradata UNIX, Autosys.
Confidential
Responsibilities:
- This ETL will directly connect to source application RMS to extract price change information.
- This interface is scheduled to run in existing AUTOSYS event handler and schedule.
- Source and Target database is ORACLE 10g Release 2.
- Have prepared the Technical Design Documents for signed-off following to its corresponding Functional Design Documents.
- Developed mappings to meet the requirements as per design document.
- Taking care of issues and change request from onsite team.
- Worked on fixes in UNIX scripts for log updates.
- Fixing the new changes in developed mappings.
- Involved in Unit testing to ensure the development as per the business functional.
Confidential
Environment: Informatica 8.6, Oracle 10g, UNIX, Test Director, Control-M., Dimension
ETL Developer
Responsibilities:
- Involved in creating Data Flow Mapping Document.
- Worked in mapping designer and developed various transformation rules.
- Involved in post release support.
- Involve in check-in the latest code (INFA, DB-Objects and UNIX Scripts) in Dimension and assign the proper BR to those codes.
- Have prepared the Deployment Guide Documents for Deployment team.
- Have prepared the unit test case documents to capture mail formats and all business validations, business rules with expected and actual scenarios.
- Project # 6
Confidential
Environment: Informatica 7.1, Business Object 6.0, Windows XP, SQL Server 2003.
ETL Developer
Responsibilities:
- Developed mappings, workflows to meet the requirements as per design document.
- Taking care of issues and change request from onsite team.
- Extensively worked in source qualifier, joiner, filter, router, Lookup, update strategy and expression transformation.
- Updating the existing Source to Target Matrix as per new business requirement and uploading to share point.
- Have prepared Unit Test Plans to support our code test as per the Source to Target Matrix to test each and every column and scenarios.
- Prepared production support documents like Migration checklist and Inventory documents.
- Worked on database objects to add indexes and creating Materialized Views to make our ETL process performance better.
Confidential
Environment: Informatica7.1, Crystal Reports 8.0, UNIX, Oracle 10g and Autosys.
ETL Developer
Responsibilities:
- Updating the existing Technical Design Documents as per the new requirement and sending them to client for signed-off.
- Have supported to the Malaysia team for development support and importing Informatica objects from one server to another server.
- Developed new mappings for sales force separately to separate and downstream the data to different servers
- Designed the Data Flow Mapping document.
- Involved in preparation of production support documents like check list documents, Inventory list documents etc.
- Have prepared migration template to migrate various mappings from one environment to another environment.
- Worked on code enhancement to union various departmental sales data and error reprocessing mechanism.
- Worked on database objects to add indexes and creating Materialized Views to make our ETL process performance better.