We provide IT Staff Augmentation Services!

Etl Developer Resume Profile

NY

Summary

  • 8 years of IT experience in Analysis, Design, Testing, Development and Implementation of client/server applications
  • Around 7 years of Strong experience in performing ETL operations like Data Extraction, Data Transformation and Data Loading with Informatica Power Center/Power Mart 8.6.0/8.1.0/7.1.
  • Worked intensively with Informatica Powercenter Designer. Strong knowledge on Source Analyzer, Warehouse designer, Transformation Developer, Mapplet Designer and Mapping Designer
  • Extensively used Informatica Workflow manager and Workflow monitor for creating and monitoring workflows, worklets and sessions
  • 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 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.
  • Identified the Facts and Dimensions using Erwin Data modeling tool to represent the Star Schema Data Marts.
  • Strong in database concepts with PL/SQL, Oracle and Teradata
  • Experience in UNIX Shell Scripting and Dollar Universe for scheduling the jobs.
  • Worked on report analysis and development in OBIEE.
  • Hands on experience in performance tuning in informatica and oracle.
  • Expertise in Developing Datastage jobs in Parallel Extender using different stages like Transformer, aggregator, lookup, Source dataset, external filter, Row generator, and column generator.
  • Experience in Onsite-Offshore model.
  • Oracle Certified Professional.
  • Teradata Basics Certification.
  • Exposure to full project life cycle development for implementation and integration.
  • Hands on experience in Production Support and Maintenance by resolving issues to meet all Data Warehouse service Level agreements SLAs .
  • Extensive Experience on Production Support.

Technical Skills

Data Warehousing

Informatica PowerCenter 9.0/8.6.1/8.5/8.1.1/7.1.2/7.1.1/6.1/5.1.2, Power Connect for Mainframe/SAP/Peoplesoft/MQSeries, PowerExchange, Informatica PowerMart 6.2/5.1.2/5.1.1/5.0/4.7.2, IBM Data Stage 8.0/7.5.2/7.5.1/7.0/6.0/5.2 Designer, Director, manager, Administrator, SQL Loader, Flat Files Fixed, CSV, Tilde Delimited, XML, COBOL, 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
BI Reporting Tools Business Objects and OBIEE
Languages SQL, PL/SQL, SQL Plus, C,Working knowledge of Unix Shell Scripting
Operating Systems Microsoft XP/NT/2000/98/95, UNIX, Sun Solaris 5

PROFESSIONAL EXPERIENCE

Confidential

Role: ETL Developer

Responsibilities:

  • Knowledge of Entity-Relationship concept, Facts and dimensions tables, slowly changing dimensions and Dimensional Modeling Star Schema and Snow Flake Schema .
  • Experience in designing/developing mapping using Source Qualifier, Lookup, Filter, Expression, Router, Update Strategy, Rank, Sequence Generator etc.
  • Experience in developing Workflows, Worklets, sessions and tasks to effectively manage the Load and also create and control workflows, tasks and sessions. Worked on Query Optimization and ETL performance tuning for improving the performance of the data warehouse.
  • Used Workflow Manager for creating, validating, testing and running the sequential and concurrent sessions and scheduling them to run at specified time and as well to read data from different sources and write it to target databases.
  • 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 Oracle 9i 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 8.6.1/8.1.1, DB2 UDB, Teradata ,UNIX Scripting KSH Windows 2000, Power Exchange 8.6.1, IDE8.6.0, IDQ8.6.0

Confidential

Role: ETL/ Data Warehouse Developer

Responsibilities:

  • Analyzed business requirements and worked closely with various application teams and business teams to develop ETL procedures that are consistent across application and systems.
  • Used Meta Data Manager to gather data from different applications and flat files for users to do impact analysis of the changes in the source systems.
  • Developed ETL code, control files, metadata, and lineage diagrams for ETL programs.
  • Unit testing and System Testing of Informatica mappings and Workflows.
  • 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.

Environment: Informatica Power Center 8.6.1/8.1.1, DB2 UDB, UNIX Scripting KSH Windows 2000, Power Exchange 8.6.1, IDE8.6.0, IDQ8.6.0

Confidential

Role: Informatica Developer

Responsibilities:

  • Worked closely with data modelers on Sybase Power designer for dimensional modeling Star schema .
  • Used Informatica 8.6.0 to extract, transform and load data from multiple input sources like flat files, SQL Server into Sybase ASE and IQ database.
  • Created Mappings, Mapplets and Transformations using the Designer and developed Informatica sessions as per the business requirement.
  • Worked on Source Analyzer, Warehouse Designer, Mapping Mapplet Designer and Transformations, Informatica Repository Manager, Workflow Manager and Monitor.
  • Worked with different types of partition techniques like key range, pass through, Round Robin and Hash partitioning.
  • 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 and used different tasks like Decision, Event Wait, Event Raise, Timer and E-mail etc.
  • Extensively utilized the Informatica data cleansing tool IDQ 8.5 and Data explorer IDE.
  • 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.
  • Responsible for the Folder Migration and Folder Creation and creating user accounts in the Repository Manger and management of passwords and permissions.
  • 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 8.6.1/8.1.1, Sybase ASE, UNIX Scripting KSH Windows 2000, Power Exchange 8.6.1, IDE8.6.0, IDQ8.6.0

Confidential

Role: Informatica Developer

Responsibilities:

  • Identified the Facts and Dimensions using Erwin Data modeling tool to represent the Star Schema Data Marts.
  • Analyzed Business Requirements, Analytics and strategies to improve the business
  • Coordinating offshore team, planning and review of deliverables.
  • Responsible for documenting user requirements and translated requirements into system solutions
  • Used shell scripting to check if the flat files have come in on the correct path and triggering the informatica jobs from UNIX server.
  • Evaluating the Consistency and integrity of the model and repository.
  • Designed and built Data Marts for home and business divisions.
  • Installed and configured Informatica Server and Power Center 7.2.
  • Metadata changes to the Informatica repository.
  • Responsible for Data Import/Export, Data Conversions and Data Cleansing.
  • Created Informatica mappings with SQL procedures to build business rules to load data.
  • Used Transformations for data joins, complex aggregations external procedure calls.
  • Worked on Informatica Power Center 7.2 tool - Source Analyzer, Data warehousing designer, Mapping Designer Mapplets, and Transformations.
  • 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.
  • Integrated sources from different databases and flat files.
  • Designed mappings with multiple sources using Informatica Designer tool.
  • Implemented various performance tuning concepts to enhance the jobs performance.
  • Logical and Physical Warehouse Designing using Erwin Tool.
  • Extensively used Star schema for designing the data warehouse.
  • Responsible for various discussions with end user to analyze Meta data.
  • Designed and Developed the ETL mapping and load strategy documents.
  • Designed the ETL Mapping Documents for development team members for their implementations.
  • Worked on Informatica - Source Analyzer, Data warehousing designer, Mapping Designer Mapplet, and Transformations.
  • Designed and developed Informatica mappings for data loads and data cleansing.
  • Extensively used almost all of the transformations of Informatica including complex lookups, Stored Procedures, Update Strategy and others.
  • Designed and developed the Workflow and worklets for all load process.
  • Worked on OBIEE reports to do Enhancements

.

Environment: Informatica Power Center 7.2, Power Exchange 8.6.1, IDE8.6.0, IDQ8.6.0, Teradata, TOAD, XML, Windows NT, Erwin, OBIEE

Confidential

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 7.1.3 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.
  • 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.
  • 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 7.1.3, Business Objects, Oracle 8.1.7.4, SQL Plus, PL/SQL, TOAD 7.1, UNIX, Windows XP, OBIEE

Hire Now