Tek08105

ODI Developer - 7 + Year


MTech

Highlights


  • Having 7.3 years of IT experience as an ORACLE PL/SQL Developer/ETL Developer, involved in Requirement Gathering, analysis, Design, Development, Unit Testing , Production Deployment and Support.

  • Good experience in software industry in the analysis, design, development and implementation of full life cycle Data management.

  • Expertise in SQL and PL/SQL programming, ETL development.

  • Experience of creating PL/SQL Packages, Procedures, Functions, Triggers, Views and Exception handling for retrieving, manipulating, checking and migrating complex data sets in Oracle.

  • Experience in Data warehousing and BI.

  • Having good experience on Client Interaction and Presentation Skills.Can assist in developing and implementing new technologies.

  • Ability to build effective relationships with colleagues, regional tech teams.

  • Ability to work independently in a client facing role and having aptitude for learning new subjects and mastering them and strong team player.




 

Skills
Primary Skills
  • ETL
  • ODI tools

Secondary Skills
  • SQL
Other Skills

Operating Systems

:Windows 7/10/Linux

Programming Languages

:SQL, PL/SQL, Java.

Databases

ORACLE 11g

Tools

Informatica, SQL Developer, PL/SQL Developer, ODI 12c

Projects

Project-1 - IT Industry (12 months)

    Roles & Responsibilities




    • Developed ETL programs using Informatica to implement the business requirements.

    • Communicated with business customers to discuss the issues and requirements.

    • Production Support has been done to resolve the ongoing issues and troubleshoot the problems.

    • Performance tuning was done at the functional level and map level. Used relational SQL wherever possible to minimize the data transfer over the network.

    • Effectively used Informatica parameter files for defining mapping variables, workflow variables, FTP connections and relational connections.

    • Involved in enhancements and maintenance activities of the data warehouse including tuning, modifying of stored procedures for code enhancements.

    • Effectively worked in Informatica version based environment and used deployment groups to migrate the objects.

    • Used debugger in identifying bugs in existing mappings by analyzing data flow, evaluating transformations.

    • Effectively worked on Onsite and Offshore work model.

    • Pre and post session assignment variables were used to pass the variable values from one session to other.

    • Designed workflows with many sessions with decision, assignment task, event wait, and event raise tasks, used informatica scheduler to schedule jobs.

    • Reviewed and analyzed functional requirements, mapping documents, problem solving and trouble shooting.

    • Performed unit testing at various levels of the ETL and actively involved in team code reviews.


Project-2 (8 months)

    Involved in all phases of SDLC from requirement gathering, design, development, testing, Production, user training and support for production environment.



    Created new mapping designs using various tools in Informatica Designer like Source Analyzer, Warehouse Designer, Mapplet Designer and Mapping Designer.



    Developed the mappings using needed Transformations in Informatica tool according to technical specifications.



    Created complex mappings that involved implementation of Business Logic to load data in to staging area.



    Used Informatica reusability at various levels of development.



    Developed mappings/sessions using Informatica Power Center for data loading.



    Performed data manipulations using various Informatica Transformations like Filter, Expression, Lookup (Connected and Un-Connected), Aggregate, Update Strategy, Normalizer, Joiner, Router, Sorter and Union.



    Developed Workflows using task developer, Worklet designer and workflow designer in Workflow manager and monitored the results using workflow monitor.



    Building Reports according to user Requirement.



    Extracted data from SQL Server then used Oracle for data warehousing.



    Implemented slowly changing dimension methodology for accessing the full history of records.



    Optimizing performance tuning at source, target, mapping and session level.



     


Project-3 - IT Industry (12 months)

    Roles & Responsibilities




    • Used Informatica Power Center for (ETL) extraction, transformation and loading data from heterogeneous source systems into target database.

    • Created mappings using Designer and extracted data from various sources, transformed data according to the requirement.

    • Involved in extracting the data from the Flat Files and Relational databases into staging area.

    • Mappings, Sessions, Workflows from Development to Test and then to UAT environment.

    • Developed Informatica Mappings and Reusable Transformations to facilitate timely Loading of Data of a star schema.

    • Developed the Informatica Mappings by usage of Aggregator, SQL overrides usage in Lookups, source filter usage in Source qualifiers, and data flow management into multiple targets using Router.

    • Created Sessions and extracted data from various sources, transformed data according to the requirement and loading into data warehouse.

    • Used various transformations like Filter, Expression, Sequence Generator, Update Strategy, Joiner, Router and Aggregator to create robust mappings in the Informatica Power Center Designer.

    • Imported various heterogeneous files using Informatica Power Center 8.x Source Analyzer.

    • Developed several reusable transformations and mapplets that were used in other mappings.

    • Prepared Technical Design documents and Test cases.

    • Involved in Unit Testing and Resolution of various Bottlenecks came across.

    • Implemented various Performance Tuning techniques.

    •  



     



     



     



     



     



     



     



     


Project-4 - IT Industry (8 months)

    Roles & Responsibilities




    • Development of Code based on the approved Technical Specifications.

    • Migrated data from flat files to tables using sql*loader.

    • Developed and modified PL/SQL code to make new enhancements or resolve problems, as per customer requirements.

    • Developed Stored Procedures, Functions and Packages for validating and migrating the data to target from Staging.

    • Created Views on multiple Tables.

    • Created indexes on some columns of tables to increase the application's performance.

    • Responsible for SQL tuning and optimization using explain plan and also responsible for writing test plans and unit testing for the application modules.

    • Analysing tables and indexes for performance tuning.

    • Worked with Global Temporary Tables.

    •  Created unit test case document.

    •  


Similar Talent