We provide IT Staff Augmentation Services!

Etl Developer Resume Profile

4.00/5 (Submit Your Rating)

NJ

Summary

  • 8 years of Strong experience in performing ETL operations like Data Extraction, Data Transformation and Data Loading with Informatica Power Center/Power Mart 9.x/8.x/7.x.
  • Worked intensively with Informatica Powercenter Designer. Strong knowledge on Source Analyzer, Warehouse designer, Transformation Developer, Mapplet Designer and Mapping Designer.
  • Experienced in Data Warehousing concepts, Dimensional modeling like Star Schema, Relational modeling, Snowflake Schema, 3NF and database architecture for OLTP and OLAP applications, Data Analysis and ETL processes.
  • Specialized in data analysis, data migration, database system implementation, DWBI Development and testing methods.
  • Developed tactical and strategic plans to implement technology solutions and effectively manage client expectations. Exposure to full project life cycle development for implementation and integration.
  • Hands on experience in performance tuning in informatica and oracle.
  • Created perfect star schema to accommodate OBIEE requirements. Designed Type II slowly changing dimensions as a base for accurate historical reporting.
  • Modeling and Implementing FACT tables and Slowly Changing Dimension scheme Type II for most of the dimensions.
  • Preparing technical business solution strategy/approach using ETL technologies and present it to Design Review Board for their approvals.
  • Identify performance bottlenecks and optimize respective databases and processes for performance improvement. Experienced in analyzing query logs and explain paths.
  • Experience in UNIX Shell Scripting and Dollar Universe for scheduling the jobs.
  • Strong in database concepts with PL/SQL, Oracle and Teradata
  • Identified the Facts and Dimensions using Erwin Data modeling tool to represent the Star Schema Data Marts.
  • Extensively worked on Informatica PowerCenter Transformations such as Source Qualifier, Lookup, Filter, Expression, Router, Normalizer, Joiner, Update Strategy, Rank, Aggregator, Stored Procedure, Sorter, Sequence Generator and XML Source Qualifier.
  • Excellent interpersonal and communication skills, technically competent and result-oriented with problem solving skills and ability to work independently and use sound judgment.
  • Experienced to work in Development team, Production support teams in handling critical situations to meet the deadlines for successful completion of the tasks/projects.
  • Extensive Experience on Production Support.

Technical Skills

Data Warehousing

Informatica PowerCenter 9.x/8.x/7.x, Power Connect for Mainframe/MQSeries, PowerExchange, Informatica PowerMart 6.X/5.X/4.X, SQL Loader, Flat Files Fixed, CSV, Tilde Delimited, XML, AS/400

Dimensional Data Modeling

Dimensional Data Modeling, Star Schema Modeling, Snow-Flake Modeling, FACT and Dimensions Tables, Physical and Logical Data Modeling.

Database and Related tools Oracle 10g/9i/8i/8/7.x, MS SQL Server 2000/7.0/6.5, TeraData, Sybase ASE, PL/SQL, TOAD 8.5.1/7.5/6.2. DB2 UDB
Languages SQL, PL/SQL, C, Unix Shell Scripting and Perl
Operating Systems Microsoft Windows 7/XP/2000/9X, UNIX, Linux

PROFESSIONAL EXPERIENCE

Confidential

Role: ETL Developer

Responsibilities:

  • Design and develop ETL process using Informatica tool to load data from wide range of sources such as Flat Files and Oracle Database.
  • Responsible for migrating the folders or mappings and sessions from development to test environment and Created Migration Documents to move the code from one Environment to other Environment.
  • Based on the Business logic, Develop various mappings mapplets to load data from various sources using different transformations like Source Qualifier, Filter Expression, Lookup, Router, Update strategy, Sorter, Normalizer, Aggregator, Joiner, SQL transformations, XML Transformation in the mapping.
  • Use connected, unconnected lookup, static and dynamic cache to implement business logic and improve the performance.
  • Extract files and manually transferred to Informatica server using FTP scripts developed using Python.
  • Worked on different OLTP data sources such as SQL Server and Flat files for data extraction.
  • Implemented Type II slowly changing dimensions using date-time stamping.
  • Created reusable transformations and mapplets to reuse while creating ETL mappings.
  • Configured and used the Debugger to troubleshoot the Informatica mappings.
  • Supported the BI team by extracting operational data from multiple sources, merging and transforming the data to facilitate enterprise-wide reporting and analysis and delivering the transformed data to coordinated data marts.
  • Extensively developed Oracle PL/SQL stored procedures using TOAD to implement different business logics and perform backend testing to verify the transactions and business logic.
  • Created and tested UNIX shell scripts to automate SQL scripts and stored procedures.
  • Extract data from DB2 database for ETL processing.

Environment: Informatica Power Center 9.1, DB2 UDB, Teradata, UNIX Scripting KSH Windows 2000, Power Exchange 9.1

Confidential

Role: ETL/ Data Warehouse Developer

Responsibilities:

  • Involved in creating Detail design documentation to describe program development, logic, coding, testing, changes and corrections.
  • Analyzed business requirements and worked closely with various application teams and business teams to develop ETL procedures that are consistent across application and systems.
  • Worked on Informatica Utilities Source Analyser, warehouse Designer, Mapping Designer, Mapplet Designer and Transformation Developer.
  • Used various transformations like Stored Procedure, Connected and Unconnected lookups, Update Strategy, Filter transformation, Joiner transformations to implement complex business logic.
  • Defined and worked with mapping parameters and variables.
  • Created and configured Workflows, Worklets, and Sessions to transport the data to target using Informatica Workflow Manager.
  • Developed ETL code, control files, metadata, and lineage diagrams for ETL programs.
  • Unit testing and System Testing of Informatica mappings and Workflows.
  • Performed the performance evaluation of the ETL for full load cycle.
  • Designed and developed transformation rules business rules to generate consolidated fact/summary data using Informatica Power Center 9.1.
  • Extensively involved in performance tuning at source, target, mapping, session and system levels by analyzing the reject data.
  • Implemented restart strategy and error handling techniques to recover failed sessions.
  • Wrote complex SQL Queries involving multiple tables with joins.
  • Maintained Development, Test and Production mapping migration using Repository Manager.
  • Extensively performed unit testing and system or integration testing.
  • Generated PL/SQL scripts and UNIX Shell scripts for automated daily load processes.

Environment: Informatica Power Center 9.1, DB2 UDB, UNIX Scripting KSH Windows 2000, Power Exchange 8.6.1, SQL, PL/SQL

Confidential

Role: Informatica Developer

  • Participated in requirement gathering meetings with business analysts and ETL architect to understand Source Data, Data Warehouse data model, Technical Metadata, etc.
  • Documented required technical metadata such as source and target definitions.
  • Worked on different OLTP data sources such as Oracle, SQL Server and Flat files for data extraction
  • Created and configured Workflows, Worklets, and Sessions to transport the data to target using Informatica Workflow Manager.
  • Various kinds of the transformations were used to implement simple and complex business logic. Transformations used are: Remote Procedure, Connected Unconnected Lookups, Router, Expressions, Source Qualifier, Aggregators, Filters and Sequence Generator etc.
  • Performed extensive data analysis to understand the existing data behavior using current and historical data. Analyzed data for policy, party, household, products data for several projects requirement.
  • Maintained Development, Test and Production mapping migration using Repository Manager.
  • Unit testing and System Testing of Informatica mappings and Workflows.
  • Generated PL/SQL scripts and UNIX Shell scripts for automated daily load processes.
  • Extensively worked in Oracle SQL Query performance tuning and created DDLs, database objects like Tables, Indexes and Sequences etc., by working closely with DBAs.
  • Developed several forms and reports in the process. Also converted several standalone procedures/functions in PL/SQL to packaged procedure for code reusability, modularity and control.
  • Worked on OBIEE reports to do Enhancements
  • Tuning of Informatica jobs with oracle as backend database

Environment: Informatica Power Center 8.6.1/8.1.1, Business Objects, Oracle 10g, SQL Plus, PL/SQL, TOAD 7.1, UNIX, OBIEE

Confidential

Role: ETL Developer

Responsibilities:

  • Analyzed business requirements and worked closely with various application teams and business teams to develop ETL procedures that are consistent across all application and systems.
  • Documentation of technical specification, business requirements, functional specifications for the development of Informatica mappings to load data into various tables and defining ETL standards.
  • Worked on Informatica Power Center 8.6.1 tool - Source Analyzer, warehouse designer, Mapping Designer Mapplets, and Transformations.
  • Created and configured Workflows, Worklets, and Sessions to transport the data to target using Informatica Workflow Manager.
  • Extensively involved in performance tuning at source, target, mapping, session and system levels by analyzing the reject data.
  • Maintained Development, Test and Production mapping migration using Repository Manager.
  • Extensively performed unit testing and system or integration testing.
  • Generated PL/SQL scripts and UNIX Shell scripts for automated daily load processes.
  • Extensively worked in Oracle SQL Query performance tuning and created DDLs, database objects like Tables, Indexes and Sequences etc., by working closely with DBAs.
  • Developed several forms and reports in the process. Also converted several standalone procedures/functions in PL/SQL to packaged procedure for code reusability, modularity and control.
  • Designed tables, indexes and constraints using TOAD and loaded data into the database using SQL Loader.
  • Worked on OBIEE reports to do Enhancements.
  • Tuning of Informatica jobs with oracle as backend database

Environment: Informatica Power Center 8.6.1/8.1.1, Business Objects, Oracle 9i, SQL Plus, PL/SQL, TOAD, UNIX, Windows XP

Confidential

Role: Informatica Developer

Responsibilities:

  • Involved in complete understanding of business requirement and involved in analyzing the sources to load in Oracle warehouse.
  • Designed Sources to Targets mappings from Oracle, Excel/Flat files to Oracle using Informatica Power Center.
  • Created Mappings, Mapplets and Transformations using the Designer and developed Informatica sessions as per the business requirement.
  • Responsible for developing complex Informatica mappings using different types of transformations like UNION transformation, Connected and Unconnected LOOKUP transformations, Router, Filter, Aggregator, Expression and Update strategy transformations for Large volumes of Data.
  • Created mappings, which include the Error Handling Logic being implemented to create an error, ok flags and an error message depending on the source data and the lookup outputs and in the designer to implement Type 2 SCD.
  • Developed and Implemented Informatica parameter files to filter the daily data from the source system.
  • Fine-tuned the mappings by analyzing data flow and Worked with Memory cache for static and dynamic cache for the better throughput of sessions containing Lookup, Joiner and Aggregator transformations.
  • Responsible for migrating the folders or mappings and sessions from development to test environment and Created Migration Documents to move the code from one Environment to other Environment.
  • Performs insert, update, delete, and upset operations for large volume incremental loads using Teradata MultiLoad, FastLoad.
  • Worked with Stored Procedure Transformation for time zone conversions.
  • Generated Reusable Transformations, Mapplets and used them extensively in many mappings.
  • Administrated Workflow Manager to run Workflows and Worklets.
  • Involved in performance tuning on Informatica mappings.
  • Used workflow manager for creating, validating, testing and running the Sequential and Concurrent batches and sessions and scheduling them to run at specified time with required frequency.
  • Created database Triggers, Stored Procedures, Exceptions and used Cursors to perform calculations when retrieving data from the database.
  • Unit testing and System Testing of Informatica mappings and Workflows.
  • Implemented Error Handling Logic, which involves testing of incorrect input, values for the mappings and the means of handling those errors.
  • Used Shell Scripts which compares the incoming file with the existing file and creates a log file with differences and the changed values are loaded into the target.

Environment: Informatica Power Center 7.1.3, UNIX scripting, Oracle 8.1.7.4, Teradata, Quality Center 9.0, Toad, PL/SQL Stored Procedures, Triggers, Packages

Confidential

Role: Informatica Developer

Responsibilities:

  • Involved in translating business requirements to integrate into existing DataMart design.
  • Developed ETL jobs to extract information from Enterprise Data Warehouse.
  • Extensively used ETL to load data from different relational databases, XML and flat files.
  • Used ETL, Informatica Repository Manager to create repositories and users and to give permissions to users.
  • Debugged the mappings extensively, hard coding the test data ids to test the logics going instance by instance.
  • Performed various transformations, aggregations and ranking routines on the data to be stored in the application reporting mart.
  • Handled the Migration process from Development, Test and Production Environments.
  • Implemented Type 2 slowly changing dimensions to maintain dimension history and Tuned the Mappings for Optimum Performance.
  • Used ETL, Informatica Designer to design mappings and coded it using reusable mapplets.
  • Developed workflow sequences to control the execution sequence of various jobs and to email support personnel.
  • Involved in unit testing and documenting the jobs and work flows.
  • Worked on Parameterize of all variables, connections at all levels in UNIX.
  • Created test cases for unit testing and functional testing
  • Set Standards for Naming Conventions and Best Practices for Informatica Mapping Development.
  • Used database objects like Sequence generators and Stored Procedures for accomplishing the Complex logical situations.
  • Created various UNIX shell scripts for Job automation of data loads.
  • Created mappings, which include the Error Handling Logic being implemented to create an error, ok flags and an error message depending on the source data and the lookup outputs.
  • Extensively involved in the analysis and tuning of the application code SQL .

Environment: Informatica Power Center 7.1.2, DB2, Teradata, TOAD, XML, Windows NT, Erwin, OBIEE, UNIX Sun Solaris

We'd love your feedback!