We provide IT Staff Augmentation Services!

Etl Developer Resume Profile

2.00/5 (Submit Your Rating)

Los Angeles, CA

SUMMARY

  • Over Seven years of experience in the field of Information Technology, with extensive experience in analysis, design, development, data conversion, Data Warehouse, Data Mart design, Unit testing and documentation.
  • Extensive experience on Informatica Power Center 8.6/9.1/9.5
  • Strong knowledge of Data warehousing concepts, dimensional Star Schema and Snowflake schema methodologies.
  • Experience in database design, Entity-Relationship modeling and Dimensional modelingusing ERWIN.
  • Extensively worked with Teradata utilities like BTEQ, Fast Export, Fast Load, Multi Load to export and load data to/from different source systems including flat files.
  • Expertise in implementing complex Business rules by creating robust mappings, mapplets, reusable transformations, Workflows and Worklets using Informatica Power Center.
  • Expertise in data extraction from Flat Files XML, excel, csv, fixed width, delimited, txt, Access-mdb , SQL-Serverand Oracle ERP.
  • Experience in implementing the complex business rules by creating transformation/re-usable transformationssuch as Expression, Aggregator, Filter, Connected and Unconnected Lookup, Router, Rank, Joiner, Update Strategy, Stored Procedure Transformation and developing complex Mapplets and Mappings.
  • Worked on Slowly Changing Dimensions SCD's and its implementation Type1 and Type 2 to keep track of historical data.
  • Extensive experience in databasetechnologies over 6 years Creating indexes, tables, views,CTE, triggers, complex SQL queries, Stored Procedures and performingSQL tuning
  • Proactively monitor and optimize query performance, session performance and fine tuning the mappings.
  • Experience in Installation, Configuration of Informatica Power Center.
  • Strong Quality Assurance, debuggingand performance tuningskills in ETL Process and hands on experience in troubleshooting and handling production support jobs.
  • Extensive experience in end to end ETL design, documentation, development, testing and client support Implement LINUX shell scripts for scheduling various tasks.
  • Created reports using Tableau

Technical Skills:

ETL /DW Tools

Informatica Power Center9.5/9.1/8.6 Source Analyzer, Target Designer, Mapping Designer, Mapplet Designer, Transformation Developer, Workflow Manager, Workflow Monitor

DBMS

Oracle 10g/9i/8i,Sql Server 2005,2008,2012, Teradata

BI reporting tool

Tableau

Operating Systems

Linux Red Hat , MS Windows NT/2000/XP,UNIX

Programming Languages

SQL, PL/SQL, SQL PLUS, C, Shell Script

Version Control

SVN, Share point

Other Tools

TOAD, Autosys Scheduler

Work Summary

Confidential

ETL Developer

Responsibilities:

  • Worked closely with Business Analyst and the end users for understanding existing businessmodel and customer requirements and involved in preparing the functionalspecifications based on the business requirement needs.
  • Responsible for developing, support and maintenance for the ETL Extract, Transform and Load processes using Informatica power center.
  • Worked closely with Dataarchitect to build dimensionalModels.
  • Involved in end to end ETL required to build the customer billingdatamarts.
  • Worked extensively on Informatica Power Center using SourceAnalyzer, Mappingdesigner, WarehouseDesigner.
  • Created complex mappings in Power Center Designer using Aggregate, Expression, Filter, and SequenceGenerator, UpdateStrategy, Union, Lookup, Joiner, XMLSourceQualifier and Storedproceduretransformations.
  • Developed numerousInformaticamappings to loads stage, dimension and fact tables.
  • Developed mappings to implement Slowly Changing Dimensions Type 1 2 .
  • Created reusable transformations and mapplets.
  • Worked on performancetuning of Informatica objects.
  • Used Teradata utilities fastload, multiload, tpump to load data
  • Writing BTEQ Basic Terradata Query scripts.
  • Writing PL/SQLprocedures days of supply for processing business logic in the Database.
  • Worked on SQL tools like TOAD to run SQL queries to validate the data.
  • Extensively used SQL Loader to load Data from flat files to Database tables In Oracle.
  • Worked on shellscripts to handle flatfiles which include files from source system and transferring files to downstream systems.
  • Performed Unit Testing. Involved in User Acceptance Testing.
  • Involved in Peerreviews of the Designdocument as well as code walkthrough.
  • Involved in Reviewing of Checklists and ProjectDeliverables.
  • Worked in Agile Scrum Methodologies

Environment: Informatica power center 9.1, Oracle 11g, windows 8, PL/SQL, SQL LOADER, TOAD, LINUX, Autosys Scheduler, Teradata

Confidential

ETL Informatica Developer

Responsibilities and Roles:

  • Understanding the existing business model and requirements, involved in requirements gathering and understanding business needs.
  • Involved in analyzing the requirements and created Design Documents and Data Mapping Documents.
  • Worked with Source Analyzer, Warehouse designer, Mapping, Mapplet Designer, Transformations, Workflow Manager and Monitor.
  • Developed mappings using various transformations such as the Source qualifier, Router, Filter, Sequence Generator, Aggregator, Lookup Connected Un-Connected , Stored Procedure and Expression as per the business requirement.
  • Used Mapping Parameters and Variables to implement object orientation technologies and facilitate the reusability of code.
  • Involved in performance tuning by identifying the bottlenecks at source, target, mapping, session, and database level.
  • Design and development of UNIX Shell Scripts to handle pre and post session processes and also for validating the incoming files.
  • Involved in databasedevelopment by writing PL/SQL Stored Procedures, triggers, views, joins.
  • Used Teradata utilities fastload, multiload, tpump to load data
  • Writing BTEQ Basic Terradata Query scripts.
  • Writing PL/SQLprocedures days of supply for processing business logic in the Database.
  • Carried out performance tuning both on Informatica side and database side.
  • Expertise in creating databases, tables, triggers, views, storedprocedures, functions, joins and hashindexes in Teradata database.
  • Developing the SQL scripts in TOAD and creating Oracle Objects like tables, materialized views, views, Indexes, sequences, synonyms and other Oracle Objects.
  • Developing the unit test case document and performed various kinds of testing like unit testing, regression testing and system test in Dev, QA environments before deployment.
  • Created reports using Tableau

Environment: Informatica Power Center 9.0, 8.6, Microsoft SQL Server 2012/2008, PL/SQL, SQL Developer, Oracle 10g/9i/8i, TOAD 7.0, Flat files, XML, Linux,Teradata, Tableau

Confidential

ETL Analyst

Responsibilities:

  • Responsible for designing and developing the Informaticamappings for data loads.
  • Developed Parameter files for DataIntegrity.
  • Used almost all of the transformations of Informatica including lookups, UpdateStrategy, Union, Sorter, Router and others.
  • Mapplets and ReusableTransformations were used to prevent redundancy of transformation usage and maintainability.
  • Worked with Informatica Best Practicesguidelines to minimize performance issues.
  • Scheduled, Executed and Monitored sessions by using Informatica Workflow Manager.
  • Responsible for weekly statusupdates showing the progress of developmentlifecycle.
  • Involved extensively in conducting integration, performance and UAT testing.
  • Used Teradata utilities Fastload, Multiload, Tpump to load data
  • Wrote Fastexport script to export data.
  • Wrote TeradataMacros and used Teradata analytic functions.
  • Expertise in OraclePL/SQL helped me in developingcomplex queries to validate tables for accurate data population.
  • Created Tasks such as session which contains the mapping which is built in the designer and email using Workflow manager tool like Task Developer.
  • Involved in DBI Daily Business Intelligence , Oracle 11i Upgrade, Oracle Security Patches, Application Infrastructure Upgrade, Purchasing and Contract Reporting.

Environment: Informatica, ORACLE 9i/10g/11i, Siebel, PL/SQL, SQL, Import/Export, SQL Loader, Informatica Power Center 8.6, Cognos Report Net, TOAD Quest Software, Windows XP, UNIX, Teradata

Confidential

ETL Developer

Responsibilities and Roles:

  • Responsible for design, development, enhancement of Informatica mappings.
  • Creation of Transformations like Lookup and Source Qualifier Transformations in the Informatica Designer.
  • Created various other Transformations like Aggregate, Expression, Filter, Update Strategy, Stored Procedures, and Router etc. and Fine-tuned the mappings for optimal performance.
  • Involved in creation of Stored Procedures and tested in development and staging environment
  • Tuning Informatica Mappings and Sessions for optimum performance

Environment: Informatica Power center7.x,8.6, Oracle 8i, SQL, PL/SQL, and Windows XP.

We'd love your feedback!