We provide IT Staff Augmentation Services!

Etl/team Lead Resume

San, JosE

SUMMARY:

  • 10 Years of experience in Information Technology at various phases in Techno - Functional roles.
  • Strong Data Warehousing experience using Informatica 7.4/8.1/8.6/9.1/9.5 , Teradata, Oracle 9i/10g/11g, PL/SQL, ASP, UNIX Shell Scripting, Dollar Universe ($U). Oracle OCA certified professional.
  • Good knowledge of Logical/Physical Data Modelling, Star Schema and Snow Flake Schema.
  • Experience in performance tuning with Informatica as well as ORACLE PL/SQL.
  • Designed and developed both simple and complex mappings from varied transformation logic like Unconnected and Connected lookups, Router, Filter, Expression, Aggregator, Joiner, Update Strategy and more.
  • Competent in Database development using SQL, PL/SQL, Stored Procedures, Stored Functions, Packages, and Triggers.
  • Experience in data analysis and reporting tool Siebel Analytics and OBIEE used for financial/business decisions.
  • Effective communicator with strong team-building, management skills and ability to coordinate cross-functional teams to accomplish objectives and meet critical deadlines in a fast paced, high-growth and diverse environment.
  • Core competency in software development life cycle which includes Analysis, Design, Development, Testing, Debugging and Implementation to production support.
  • Has high degree of conceptualization and creative approach to problem solving.
  • Project risk management.
  • Possess strong Analytical, Leadership skills and an influential team player.
  • With strong Analytical, Leadership skills have received multiple commendations from CISCO and TCS clients

TECHNICAL SUMMARY:

Operating Systems: Unix(AIX), Sun Solaris, Windows 2000/NT/XP, LINUX, DOS

ETL Tools: Informatica 9.5/9.1/8.6/8.1/7.4 , Informatica Power Exchange

Languages: PL/SQL, SQL, C, C++, ASP, Unix shell scripting, XML

Databases: Oracle 11g/10g/9i, Teradata, SQL Server 2005, My SQL.

Software Tools, Web Servers and source management.: Toad, SQL *Plus, SQL Loader, Visual Studio 2005.

PROFESSIONAL EXPERIENCE:

ETL/Team Lead

Confidential, San Jose

Responsibilities:

  • Translated business processes into mappings for building Data Ware house by using Informatica 9.5
  • Worked extensively on Data modelling design.
  • Interacted with clients for requirement gathering, design walk-through and successful implementation of code. Extensively used most of the transformations like FILTER, Router, Joiner, Lookup (Connected & Un-Connected), Aggregator, Expression, Normalizer and Update Strategy.
  • Designed workflows with Flat file extracts from Teradata to Oracle load (Fast exports and relational connections).
  • Trained and mentored medium size team for deliverables.
  • Extensively used performance tuning techniques for daily SLA target.
  • Developed packages and stored procedures using PL/SQL. Worked with analysts and data source systems experts to map requirements to ETL code.
  • Optimized SQL statements and PL/SQL blocks by analysing the execution plan.

Environment: Informatica 9.5, PL/SQL, Teradata, Shell Scripting, Oracle 10g/11g,OBIEE 10G Windows 2000/XP -Intel Pentium, UNIX, $U Universe, Kintana, PVCS.

Technical Lead

Confidential, Santa Clara

Responsibilities:

  • Worked extensively on Data modelling/functional design with Architectures/cross-functional team.
  • Developed, maintained, troubleshoot, enhanced and documented project components.
  • Extensively implemented Advanced PL/SQL logic for Mediation track.
  • Designed Baby Bear IT-ENG migration based on SOA orchestration, R12 and ORACLE BRM technology.
  • Conducted peer-reviews and lead reviews and provided appropriate feedback.
  • Planned delivery with good size team members.

Environment: PL/SQL, Shell Scripting, Oracle 10g/11g, SOA orchestration, Oracle BRM, R12

ETL/Team Lead

Confidential, San Jose

Responsibilities:

  • Involved in design and development of Business Requirements in liaison to business users and Technical teams by gathering requirement specification documents and identifying data sources and targets.
  • Participated actively in user meetings and collected requirements from users.
  • Used Informatica Power Centre 8.6/9.1/9.5 for extraction, transformation and loading (ETL) of data in the Data Warehouse and used velocity methodology.
  • Performed ETL into ORACLE Data Warehouse using Informatica Mappings including transformations Aggregator, Joiner, Lookup (Connected & Un-connected), Filter, Update Strategy, Stored Procedure, Router, Expression, SQL and Sorter
  • Involved in design and development of ad-hoc data load or business critical code enhancement
  • Created workflows and tested mappings in development, test and production environment.
  • Developed re-usable transformations, mappings and mapplets confirming to the business rules. Used Debugger to test the mappings and fix the bugs.
  • Actively involved in Performance improvements of Mapping and Sessions and fine-tuned all transformations

Environment: Informatica 8.6/9.1/9.5, PL/SQL, Teradata, Shell Scripting, Oracle 10g/11g,OBIEE 10G, Windows 2000/XP -Intel Pentium, UNIX, $U Universe, Kintana, PVCS.

Sr. ETL Developer

Confidential, San Jose

Responsibilities:

  • Designed and developed the ETL Mappings for data extractions, data transformations, data staging and aggregation for sales.
  • Worked on Informatica Power Centre 8.6/8.1 - Used Source Analyzer and Warehouse designer to import the source and target database schemas and the Mapping Designer to map the sources to the target, Mapplets and Transformation Developer.
  • Translating the data through Informatica into an XML by following the mapping documents
  • Developed standard and re-usable mappings and mapplets using various transformations.
  • Scheduled Extraction and Load processes.
  • Extracted fact tables for the timely basis sales, sub averages, totals etc.
  • Involved in performance tuning of the Informatica mapping using various components like Parameter files, Variables and Dynamic Cache.
  • Developed system test cases to check for the consistency of the data.
  • Written Unix Shell scripts to validate the metrics and verify the records.
  • Responsible for creating the test bed systems and loading the entire production database dump into the test bed.

Environment: Informatica 8.6/8.1, PL/SQL, Shell Scripting, Oracle 10g/9i, Windows 2000/XP -Intel Pentium, UNIX, $U Universe, Kintana, PVCS.

ETL Developer

Confidential, San Jose

Responsibilities:

  • Gathering business requirements of application from client.
  • Documenting and analyzing the business rules to eliminate redundant and inefficient processes. Data modelling as per the client requirement.
  • Developed Mappings using different transformations like Source Qualifier, App Multi-Group Source Qualifier, Application Source qualifier, Expression, Lookup, Router, Update Strategy, Union, Stored procedure (unconnected), Aggregator, Joiner, Sequence Generator .
  • Created re-usable objects (mapplets & Sequence Generator).
  • Worked on mapping parameters for incremental loading.
  • Worked on Advance Oracle PL/SQL functionality.
  • Development and maintenance of application modules. Ensuring good performance of logic built. Interaction with clients for clarification or recommending solution to issues incurred.
  • Preparing Unit Test Plans and Integration Test Plans. Sharing the case plans with Testing team and client to ensure proper designing of application.
  • Performed regression and functional testing to ensure proper implementation of the Change Requests and Enhancements.
  • Internal Quality Checks and External Quality checks were done for all the deliverables before delivery to the client.
  • Supported Testing, UAT and BAT cycle of application
  • Leading the development and deployment activity. Handling the Knowledge transition plan to support team. Engagement in production support activities.

Environment: Informatica 8.1, PL/SQL Shell Scripting, Oracle 10g/9i, Windows 2000/XP -Intel Pentium, UNIX, $U Universe, Kintana, PVCS.

Confidential

Informatica/ETL Developer

Responsibilities:

  • Creation of complex Informatica mappings (Using Transformations like Lookup, Router, Union, transformation, etc).
  • Supervision on the testing of ETL code to give the quality work to clients.
  • Preparation of test plan and test case for Informatica mappings.
  • Preparation of high level documents for the mappings like ETL Document, Data Dictionaries
  • Responsible for all deliverables, reviews and functional understanding.
  • Did automations of manual source file conversions through Informatica and manual excel macros which saved a lot of time for the project.
  • Knowledge of various quality practices with in the Project viz. Technical Documentations, Unit Test Documentation and Code Review tools and database comparator tools for testing
  • Created and modified existing Excel Reports as per the Business requirement.
  • Created and modified SAS plots for reporting purpose
  • Involved in daily reconciliation of data between source system and Data Warehouse

Environment: Informatica Power Centre 8.1/7.1.4, PL/SQL Shell Scripting, Oracle 9i, TOAD, Windows 2000/XP -Intel Pentium, UNIX, $U Universe, Kintana, PVCS.

Confidential

Developer

Responsibilities:

  • Responsible for design, implementation and maintenance of different modules in the system.
  • Involvement in reframe of database architecture. Rebuilding the data modelling design.
  • Handling the critical server side uploads. Server files need to be uploaded in the system with SQL Loader tool. Tallying data and upload at run time. Analysis of issue and debugging the root cause for unsuccessful uploads.
  • Consulting with clients, recommending and developing modules based on clients' needs. Ensuring the feasibility of enhancement with existing functionality.
  • On time resolution of bugs encountered while testing. Preparing Unit Test plans and sharing the same with testing team and clients for suggestion to ensure proper development of logic built.
  • Documentation of Low level design. Maintenance of high level changes of application.
  • Support during UAT and BAT cycle.

Environment: ASP, Oracle PL/SQL, Shell Scripting, Oracle 9i, TOAD, Windows 2000/XP -Intel Pentium.

Confidential

Developer

Responsibilities:

  • Requirement gathering and understanding the business knowledge. Responsible for architectural database design and building of schema objects.
  • Preparing ERD diagrams and demonstration for clients to dig into functionality for mapping the requirements. Suggestions and recommendations provided to client for developing the application more end-user friendly.
  • Responsible for developing the application modules as per the business and design requirement. Maintain the development coding standards. Tackling technology development with functionality requirement. Worked on Advance PL/SQL, Stored Procedures, Functions and Packages
  • Interaction with client on application related issues and modifying the application development as per suggestions.
  • Documenting and analyzing the business rules to eliminate redundant and inefficient processes and practices.
  • Debugging and creating test case plans for application. Performing Unit testing of application and through checking of functionality satisfaction.
  • Supporting the testing team during the Testing cycle period of application.
  • Documenting the low level design of application. Selective retesting of new enhancements to ensure existing functionality is not hampered with new enhancement.
  • Preparing weekly status report for client update.

Environment: ASP, Oracle PL/SQL, Shell Scripting, Oracle 9i, Windows 2000/XP -Intel Pentium.

Confidential

Developer

Responsibilities:

  • Understanding the functionality of application and designing respective modules as per the requirement.
  • Developing the application as per client’s requirement.
  • Designing application as per the client specific coding standard. Analysing the impact of newly developed modules with existing functionality.
  • Debugging the developed modules.
  • Performing Unit testing and integration of new developed system with existing application.
  • Extensively worked on Stored Procedures, Functions and Packages.
  • Documentation of High Level Design.
  • Consulting with project leads and developing solutions as per project requirement.
  • Performing Code Reviews with Tech lead

Environment: ASP, Oracle PL/SQL, Shell Scripting, Oracle 9i, Windows 2000/XP -Intel Pentium.

Hire Now