Etl Developer Resume Profile
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.