We provide IT Staff Augmentation Services!

As Etl Developer Resume

SUMMARY

  • Having 2.5 years of experience in Software Development, Implementation and Designing, Project activities.
  • Currently associated with Tata Consultancy Services, BANGALORE as System Engineer.
  • Enriching experience in Banking and Investment Banking domain.
  • Extensive experience in writing SQL and PLSQL in ORACLE 10G/11G/12C and loading through Informatica Power center
  • Substantial knowledge in Unix and C++
  • Worked on SVN, Crucible& Jira
  • Worked on Scheduling tool like Autosys & Control M
  • Involved in all phases of the SDLC (Software Development Life Cycle) from analysis, design, development, testing, implementation and maintenance with timely delivery against aggressive deadlines.
  • Possess excellent technical, communication, interpersonal, relationship management and analytical skills
  • Understanding the technical & functional specifications.
  • Identifying areas for business improvement.
  • Preparing PowerPoint presentations and Excel spreadsheets for business meetings.
  • Can manage a flexible work schedule to accommodate different time zones.
  • Designing, developing, testing, troubleshooting and debugging of the applications.
  • Develop a strategy the team will use to reach its goal
  • Manage the flow of day - to-day operations
  • Handling technical coding for development, SIT and UAT for the project.
  • Managing smooth implementation and testing of the application at client location within deadlines.
  • Handling various technical aspects like project documentation, system design & integration, coding of modules, monitoring critical paths & taking appropriate actions.
  • Preparing and executing the unit test plan & cases.
  • Designing and executing test plans, test cases and test scripts / procedures, Program specification
  • To ensure that business requirements and functional specifications are tested and fulfilled.
  • Delivering and implementing the project as per scheduled deadlines; extending post-implementation and maintenance support to the technical support team and client.
  • Defining best practices for project support and documentation.
  • Providing post-implementation, enhancement and maintenance support to client for application.
  • POC on new tools and oracle advanced feature.
  • Utilized Agile Scrum practices to help the team increase their velocity.
  • Implemented Issues Tracking in Version One to effectively track impediments against user stories.
  • Expertise in Client-Server application development using Oracle 11g/10g PL/SQL, SQL *PLUS, TOAD and SQL*LOADER.
  • Created Tables, Views, Constraints, Index (B Tree, Bitmap, Clustered and Function Based).
  • Design, develop, and maintain PL/SQL standalone procedures, standalone functions, packages, triggers, standard views, unique indexes, non-unique indexes, cursors, tables, and other PL/SQL creations.
  • Effectively made use of Table Functions, Indexes, Table Partitioning, Collections, Analytical functions, Materialized Views .
  • Developed materialized views for data replication in distributed environments.
  • Experience in Oracle supplied packages, Dynamic SQL, Records and PL/SQL Tables.
  • Partitioned large Tables using range partition technique.
  • Loaded Data into Oracle Tables using SQL Loader and using exchange partition.
  • Basic Knowledge of Data Warehousing Concepts.
  • Strong experience in Data Warehousing and ETL using Informatica.
  • Extensively worked on data extraction, Transformation and loading data from various sources like Oracle database, Flat file etc. files.
  • Created reusable transformations and used them in different mappings.
  • Created Workflows and used various tasks like Control, Decision and Session in the workflow manager.

TECHNICAL SKILLS

Operating Systems: Windows

Languages: SQL, PL-SQL and Unix

ETL tool: Informatica Power Center (9.5.1,9.6,10.1s)

Back Ends/Databases: Oracle10g/11g

Reporting Tools: OBIEE interface

Upload Tool: SQL loader

Scheduling Tool: Autosys,Control-M appview.

Others: Toad 7.2, IIS, PL SQL Developer, SQL Developer,putty.

PROFESSIONAL EXPERIENCE

Confidential

As ETL developer

Responsibilities:

  • Facilitated requirements gathering and design sessions of DB objects with Architects.
  • Familiarized with the customer needs, specifications, design targets, the development process, design standards, techniques and tools to support task performance
  • Create PL/SQL packages, stand-alone procedures, stand-alone and table functions.
  • Provide status reporting of team activities against the program plan or schedule.
  • Design, develop and maintain oracle database schemas, tables, standard views, materialized views, synonyms, unique indexes, non-unique indexes, constraints, triggers, implicit cursors, explicit cursors, cursor for loops, cursors, and other database objects.
  • Design, develop and maintain oracle database schemas, tables, standard views, materialized views, synonyms, unique indexes, non-unique indexes, constraints, triggers, sequences, implicit cursors, explicit cursors, cursor for loops, cursors, and other database objects.
  • Design and develop Oracle PL/SQL batch and real time processes for loading data from internal and external systems using SQL Loader and External tables.
  • Use Dynamic SQL and Execute Immediate functionality to perform DDL in PL/SQL blocks.
  • Created partitioned tables and partitioned indexes to improve the performance of the applications.
  • Created materialized views required for the application.
  • Created Shell Scripts for invoking SQL scripts and scheduled them using Unix jobs and Flow files.
  • Experience in all the phases of Data warehouse life cycle involving Requirement Analysis, Design, Coding, Testing, and Deployment..
  • Used Informatica Power Center 10.1 for extraction, transformation and load (ETL) of data in the data warehouse.
  • Extensively used Transformations like Router, Aggregator, Normalizer, Joiner, Expression and Lookup, Update strategy, sorter and Sequence generator.
  • Developed complex mappings in Informatica to load the data from various sources.
  • Also involved in troubleshooting existing ETL bugs.

Hire Now