We provide IT Staff Augmentation Services!

Etl Developer Resume Profile

CAREER HIGHLIGHTS

  • 7 years of IT experience in Data warehousing and Business intelligence with emphasis on Business Requirements Analysis, Application Design, Development, testing, implementation and maintenance of Data Warehouse and Data Mart systems
  • Expertise in development and design of ETL methodology for supporting data transformations and processing, in a corporate wide ETL Solution using Informatica Power Center 9.5/9.1/8.6/8.5/8.1.1/7.1.3/7.1.1/7.0 Workflow Manager, Workflow Monitor, Source Analyzer, Warehouse Designer, Mapping Designer, Mapplet Designer, Transformation developer .
  • Experience in creation of reusable objects Mapplets Transformations using Mapplet Designer and Transformation Developer
  • Knowledge in designing and developing Data marts, Data warehouse using multi-dimensional Models such as Snow Flake Schema and Star Schema while implementing Decision Support Systems. Experience in working with FACT Dimensions tables.
  • Oracle 11g/10g/9i/8i and Teradata 14/13 for querying data using SQL and BTEQ.
  • Working knowledge on Business Objects XI R2 maintained various reports using Business Objects
  • Working knowledge in Oracle and PL/SQL Writing Stored Procedures, Functions and Triggers.
  • Extensively worked with Data Extraction, Transformation, and Loading ETL tools to extract data from various sources including Oracle, Teradata Flat files.
  • Experience in Performance tuning of Sources, Targets, Mappings and Sessions using Session Partioning Push Down Optimization
  • Worked with Oracle Stored Procedures and experienced in loading data into Data Warehouse/Data Marts using Informatica, SQL Loader. Extensive Expertise with error handling and Batch processing
  • Good understanding of Data Models Dimensional Transactional , Conceptual/Logical Physical Data Models, DWH Concepts, ER diagrams, Data Flow Diagrams/Process Diagrams.
  • Strong knowledge of Software Development Life Cycle SDLC with industry standard methodologies like Waterfall and Agile including Requirement analysis, Design, Development, Testing, Support and Implementation.
  • Experience with TOAD, SQL Developer to test, modify and analyze data, create indexes, and compare data from different schemas.
  • Experienced in UNIX Shell scripting and PL/SQL Functions Stored Procedures.
  • Worked in 24/7 production support of ETL and BI applications for large Insurance Banking data warehouses for monitoring, troubleshooting, resolving issues.
  • Excellent soft skills and able to interact effectively with other members of Business Engineering, Quality Assurance, Users and other teams involved with the Software Development Life cycle
  • Fast Learner, good communication and presentation skills, ability to quickly adapt to the technical environment

Confidential

Responsibilities:

  • As an ETL SME involved in preparation of the ETL specification document by working closely with the business team
  • Provided Guidance in Performance tuning of Informatica mappings and DB2 SQL
  • Prepared the Code Review Checklist, Standards document and Reusable components to be used across multiple projects.
  • Analysed the data and provide resolution by writing analytical/complex SQL in case of data discrepancies.
  • Created Informatica Mappings to load data and used transformations like Stored procedure transformation, Connected and Unconnected lookups, Source Qualifier, Expression, Sorter, Aggregator, Joiner, Filters, Sequence, Router and Update Strategy and XML transformation
  • Cleansed the source data, extracted and transformed data with business rules, and built reusable mappings, known as 'Mapplets' using Informatica Designer
  • Extensively worked on UNIX Shell scripting
  • Involved in Performance Tuning Both Database and Informatica and there by decreased the load time.
  • Implemented Session Partitioning and used Debugger to analyze the mappings and improve performance.
  • Implemented optimization technique like PUSH DOWN optimization from Informatica
  • Involved in Design review, code review, Performance analysis
  • Updated the schedule of the jobs to maintain business functionality in Tidal.
  • Created SQL for data migrations and handled Re-Org of DB2 tables.
  • Worked with DB team and Informatica team for migrations across multiple environments.
  • Trouble shot the defects encountered in SIT UAT and provided resolutions.

Environment: Informatica Power Centre 9.1, DB2, SQL Server, TOAD, TIDAL, UNIX, XML, Cobol

Confidential

Responsibilities:

  • Actively involved in creating design specifications and ETL design documents
  • Preparation of the shell scripts for running the Informatica programs in Autosys Scheduler.
  • Preparing UNIX scripts for triggering Teradata load utilities like Fast load and Mload.
  • Optimized the process using table driven approach
  • Implemented the reusability of mappings by creating mapping shortcuts
  • Analysed the data and provide resolution by writing analytical/complex SQL in case of data discrepancies.
  • Provided guidance in performance tuning of Informatica mappings Teradata BTEQs
  • Troubleshoot the defects encountered in SIT UAT and provided resolutions.
  • Created Informatica Mappings to load data and used transformations like Stored procedure transformation, Connected and Unconnected lookups, Source Qualifier, Expression, Sorter, Aggregator, Joiner, Filters, Sequence, Router and Update Strategy and XML transformation
  • Extensively worked on UNIX Shell scripting and BTEQs to extract the data from the warehouse
  • Involved in Performance Tuning and Data Quality Both Database and Informatica and there by decreased the load time
  • Involved in Design review, code review, Performance analysis.
  • Used Metadata Manager to eastablish the relation between metadata in the designed model

Environment: Informatica Power Centre 8.1/8.5, Oracle 10g, SQL Server, TOAD, Micro strategy, Teradata, Autosys and Solaris, UNIX.

Confidential

Responsibilities:

  • Worked on design changes according the new CR's and implement them effectively
  • Scheduling the workflows via autosys and trouble shooting
  • Creating Scripts in unix to assist Informatica loads as per the requirements
  • Migrating the code from INF 7.1 to INF 8.1
  • Developing mapping Optimizing the mapping for better performance
  • Did PLSQL coding required for loading of targets according to the business requirements
  • Worked on PLSQL objects like packages, triggers, stored procedures, functions and used oracle threads to use parallel mechanism
  • Performing debugging tuning of mapping
  • Implemented SCD type-1 and type-II for the dimension load
  • Involved in Unit Testing and System Testing
  • Upgraded the scheduling mechanism from Informatica scheduler to Control-M

Environment: PL/SQL, Informatica Power Centre 7.1/8.1, Oracle 9i, TOAD, UNIX

Confidential

Responsibilities:

  • Preparing ETL design documents as per the business requirements.
  • Used workflow Manager to create, execute and monitor sessions that perform source to target data loads.
  • Developed mappings to transform extracted data into Facts Dimension tables.
  • Designing mapping as per the ETL Specifications.
  • Designed views for SAS Reporting.
  • Developing mapping Optimizing the mapping for better performance.
  • Performing debugging tuning of mapping.
  • Part of deployment team to monitor the code moving across multiple environments Dev, QA, UAT and PROD
  • Created SQL for assisting in data loads.
  • Involved in Unit Testing and System Testing as well as preparing the low-level ETL design documents and the Unit testing documents and system testing documents

Environment: Informatica Power Centre 7.1.1, Oracle 10g/9i, TOAD and UNIX HP .

Hire Now