We provide IT Staff Augmentation Services!

Dw / Etl Developer Resume

Peapack, NJ

SUMMARY:

  • More than 8 Years of IT experience in software analysis, design, development, maintenance for various software applications, and experience in providing Business Intelligence solutions in Data Warehousing and Decision Support Systems using Informatica PowerCenter, Oracle PLSQL as ETL (Extraction, Transformation and Loading) Tool
  • Conversant with all phases of software development cycle involving System analysis, design, development, testing, implementation and support.
  • Experience in writing requirements specs, ETL specs, data mappings, Visio for ETL design process, ETL execution plan, test cases and test scripts etc.
  • Experience in Data Modeling and Process Modeling for Warehouse environments using ER Studio, Erwin and MS - Visio.
  • Strong knowledge of Data Warehousing concepts and Dimensional modeling like Star and Snowflake Schemas.
  • Experience in conducting gap analysis on existing data warehouse environments.
  • Strong experience in ETL methodologies using Informatica Power Center suite ( Designer, Work Flow Manager/Monitor, Repository Manager).
  • Worked on Performance Tuning, identifying and resolving performance bottlenecks in various levels like sources, targets, mappings and sessions.
  • Extensively worked on developing and debugging Informatica mappings, mapplets, sessions and workflows.
  • Strong experience in database programming using SQL, Stored procedures/Functions, Packages, Recursive PL/SQL routines, Database triggers, Views, Materialized views, SQL Loader.
  • Strong experience in advance PLSQL development using collections, bulk processing, autonomous transactions, Ref Cursors, pipelined table functions.
  • Good knowledge in optimization and tuning of database queries.
  • Strong experience of key Oracle performance related features such as Query Optimizer, Execution Plans, Hints and Indexes.
  • Strong experience in integration of various data sources with Multiple Relational Databases like Oracle, SQL Server, DB2, MS Access, Flat files and XML files.
  • Well experienced in Import/Export of repository/metadata, Schemas, DB objects between different environments (Dev/QA/Prod).
  • Strong experience in developing and maintaining Unix Shell scripts.
  • Ability to work on multiple projects simultaneously and switch roles of analyst, designer/modeler, developer, tester and production support.
  • Excellent programming and problem analysis skills proven under high-pressure environments. Well developed Interpersonal, Analytical and Communication Skills.

TECHNICAL SKILLS:

ETL Tools: Informatica Power Center 9.5/9.1/8.5/8.1/7.1.4 , Power Mart 8.5, Oracle Warehouse Builder (OWB)11g/10g(r2)/10g/9i, Oracle Data Integrator(ODI), MS SQL Server Integration Services 2008(SSIS)

Databases: Oracle 11g/10g/9i, SQL Server 2008/2005/2000 , UDB DB2, MySQL

Big Data: Apache Hadoop, HDFS, HIVE, Sqoop, HUE, HQL.

Database Tools: Toad, SQL Developer, Oracle Enterprise Manager (OEM)

OLAP Tools: Cognos Powerplay, Cognos Impromptu, Oracle BI(Discoverer 10g), Business objects.

Languages: SQL, PL/SQL, Java, Visual Basic 6.0/5.0, C++

Scripting: Java Script, VB Script, UNIX Shell

Web Tools: HTML, XML, XSLT, ASP 2.0/3.0

ER Studio, Erwin and MS: Visio

Operating Systems: Windows XP/2000/NT/98/95, Unix, Linux

PROFESSIONAL EXPERIENCE:

Confidential, Peapack , NJ

DW / ETL Developer

Responsibilities:

  • Review project requirements, plan development modules, create mapping documents, Process flow documents, test plans, test cases and execution plans.
  • Interact with Data Modelers and Business Analysts to understand the requirements and the impact of the ETL on the business.
  • Designed and developed Informatica ETL to extract data from various sources to meet requirements.
  • Created Informatica Mappings to build business rules to load data using transformations like Filter, Router, Expression, Lookup (connected and unconnected), Aggregator, Sequence Generator, Update Strategy, Joiner, Normalizer, Sorter and Union.
  • Extensively worked on Facts and Slowly Changing Dimension (SCD) tables.
  • Design and develop ETL logic for soft delete and archive data to Audt tables.
  • Design and develop reconciliation framework which is used across all the data warehousing projects.
  • Implemented Informatica recommendations, methodologies and best practices.
  • Worked on complex Source Qualifier queries, Pre and Post SQL queries in the Target.
  • Used shortcuts to reuse objects without creating multiple objects in the repository and inherit changes made to the source automatically.
  • Implemented performance tuning logic on Targets, Sources, Mappings and Sessions to provide maximum efficiency and performance.
  • Worked on a POC for ingesting data from oracle into cloudera HDFS and HIVE tables using Sqoop.
  • Created HIVE external tables and loaded data into HIVE and queried data using HQL.
  • Well versed with HUE (Hadoop User Experience) to query, visualize and analyze data in Hadoop eco system.
  • Have a good understanding of bigdata/Hadoop eco system.
  • Create and manage AutoSys Jils for Scheduling processes.
  • Used SVN as source control software.
  • Used HP Quality Center to log and track defects and bugs in source code/ Application.
  • Created Run Book document for Production Support.

Environment: Informatica Power Center 9.5, Big data Lake, Apache Hadoop, HIVE, Sqoop, HUE, HQL, Oracle 11g, Oracle Exadata, PL/SQL, SQL Server, TOAD 11.6, Autosys R11.3.5, SVN, Cognos, Unix.

Confidential, Philadelphia, PA

Senior DW Developer

Responsibilities:

  • Interact with project management/business users, external data vendors and translate requirements, business rules into technical requirements/documents use cases and test cases.
  • Data Modeling (Dimensional) and Process Modeling using ER Studio and MS-Visio.
  • Created Informatica mappings to build business rules to load data.
  • Use various transformations like: Source Qualifier, Sequence Generator, Expression, Filters, Routers, Connected & Unconnected Lookups Aggregate, Joiner, Sorter, Stored Procedure and etc.
  • Worked extensively with the connected lookup Transformations using dynamic cache.
  • Create Mapplets and used them in different Mappings.
  • Created Workflows and Worklets and scheduled them using Workflow Manager.
  • Tuned Informatica mappings for better performance using different techniques to provide maximum efficiency and complete performance.
  • Design and develop the logic for handling slowly changing dimension table loads by flagging the record using update strategy for populating the desired.
  • Used SQL*Loader as an ETL tool to load data into the staging tables.
  • Created reusable utility Packages and Procedures to automatically drop and recreate indexes, manage partitions (roll in/ rollout).
  • Develop autonomous transact procedures to log progress of load programs/processes.
  • Partitioned the fact tables to enhance the performance and for better data management.
  • Use Sql Execution plans/plan table and fine tune slow running Sql queries by analyzing tables, creating indexes and passing oracle hints.
  • Involved in Data set up for Testing and participated in Data validation, Unit Testing and Regression Testing
  • Create sql scripts to validate the functionality of each component or unit being developed.
  • Used Microsoft Visual Source Safe as source control software.
  • Create and manage AutoSys Jils for Scheduling processes.
  • Used HP Quality Center to log and track defects and bugs in source code/ Application.
  • Support existing and new ETL applications/processes in production environments.

Environment: Informatica Power Center 9.1, Oracle 11g, PL/SQL, SQL*loader, SQL Developer, Microsoft-Visio, Microsoft VSS, Autosys, Unix and Windows XP

Confidential, Baltimore, MD

DW Developer

Responsibilities:

  • Coordinated with business users and business analysts on a regular basis to discuss the business requirement documents and transformed them into technical specification documents.
  • Integrating all the ETL components from the subject areas and designed the overall load strategy and dependencies for loading those subject areas.
  • Design, code, test, debug, document and maintain tables, indexes, views, materialized views, stored procedures and packages.
  • Developed mappings to load Fact and Dimension tables for Type 1 and Type 2 dimensions and Incremental loading and unit tested the mappings.
  • Extracted data from XML files and loaded into Oracle tables.
  • Monitor scheduled, running, completed and failed sessions and workflows.
  • Involved in debugging the failed mappings and developing the error handling methods.
  • Work on Mapping Variables, Mapping Parameters, Workflow Variables and Session Parameters.
  • Used Informatica reusability at various levels of development.
  • Created ETL process to generate XML files from Oracle tables using Informatica.
  • Handled errors using Exception Handling extensively for the ease of debugging and displaying the error messages in the application.
  • Tune Informatica sessions by implementing database partitioning, increasing block size, data cache size, sequence buffer length, target based commit interval and SQL overrides
  • Worked extensively on Ref Cursor, External Tables and Collections.
  • Extensively involved in using hints to direct the optimizer to choose an optimum query execution plan.
  • Created sql wrapper scripts and batch files for scheduling the jobs in windows task scheduler.
  • Created processflow models using MS-Visio.
  • Used Microsoft Visual Source Safe as source control software.
  • Used HP Quality Center to log and track defects and bugs in source code/ Application.
  • Used HP Project and Portfolio Management center for managing, migrating code into higher environments.

Environment: Informatica PowerCenter 8.5, Oracle 11g, PL/SQL, SQL*loader, SQL Developer, Business Objects, Microsoft VSS, UC4, Unix and Windows XP

Confidential, South Brunswick, NJ

DW Developer/ADWH / MKWH

Responsibilities:

  • Analyze business requirements by understanding functional documents, meeting with business stake holders and create technical documents like ETL documents, detailed mapping documents, unit test plans and progress reports.
  • Integrate all the ETL components from the subject areas and designed the overall load strategy and dependencies for loading those subject areas.
  • Use Informatica PowerCenter8.5 to translate Business Requirements into ETL Mappings.
  • Use transformations like router, aggregator, lookup, source qualifier, joiner, expression, aggregator and sequence generator transformations in extracting data in compliance with the business logic developed.
  • Effectively used Informatica parameter files for defining mapping variables, workflow variables, FTP connections and relational connections.
  • Pre and post session assignment variables were used to pass the variable values from one session to other.
  • Extensively worked with Informatica performance tuning involving source level, target level and map level bottlenecks.
  • Used Debugger for debugging mappings.
  • Manage process control tables for the newly developed Informatica objects.
  • Use various tasks like Session task, Event Wait task, Decision task, Email task, Command task.
  • Analyze SQL queries using execution plans and optimize/tune by creating indexes, passing hints.
  • Develop Complex Informatica Mappings, Mapplets and Reusable Transformations to facilitate daily, monthly and yearly loading of data.
  • Develop Oracle Stored Procedures to generate ODS organization hierarchy for learning management system and use Informatica Stored Procedure transformation to call in a mapping.
  • Create unit test plans, test cases and reports on various test cases for testing the developed code.
  • Work on integration testing to verify load order, time window and lookup with full load.

Environment: Informatica PowerCenter 8.5, Oracle 9i/10g, SQL Server 2005, PL/SQL, TOAD, Cognos 8, Embarcadero ERStudio 6.5, Microsoft-Visio, Microsoft VSS, Control-M, Unix and Windows XP

Confidential, NY

DW Developer/Broadband & SOAP

Responsibilities:

  • Interact with project management/business users and translate requirements, business rules into technical requirements/documents use cases and test cases.
  • Extract, transform, and load data (ETL) from source systems into reporting environments using Informatica Power Center 8.1, UNIX scripts.
  • Develop strategy for data acquisition, CDC and archiving old data from active tables.
  • Use various transformations like: Source Qualifier, Sequence Generator, Expression, Filters, Routers, Connected & Unconnected Lookups Aggregate, Joiner, Sorter, Stored Procedure and etc.
  • Design and Develop pre-session, post-session routines for Informatica sessions to drop and recreate indexes and key constraints for Bulk Loading
  • Use Informatica Data Profiling to profile and understand the source data
  • Optimized/Tuned mappings for better performance and efficiency
  • Monitor scheduled, running, completed and failed sessions. Involved in debugging the failed mappings and developing the error handling methods.
  • Work on Mapping Variables, Mapping Parameters, Workflow Variables and Session Parameters.
  • Create and test Power Exchange Data maps for Oracle CDC capture.
  • Business Rules, Processing Flow and details of sessions, workflows, pre dependencies, post dependencies, exception error processing methodology.
  • Create sql scripts to validate the functionality of each component or unit being developed.
  • Design and create tables, views, materialized views, stored procedures and packages.
  • Migration of Informatica mappings, sessions and Autosys Jils from development to production environment
  • Create and run AutoSys Jils for Scheduling processes
  • Support existing and new ETL applications/processes in production environments, work on remedy tickets by business users and first level production support.

Environment: Informatica Power Center 8.1, Oracle 9i/10g, Autosys, PL/SQL, TOAD, Embarcadero ERStudio 6.5, Microsoft-Visio, Unix and Windows 2000/XP

Confidential, Huntsville, Alabama

DW Developer /Enterprise Data Warehouse (EDW)

Responsibilities:

  • Review project requirements, plan development modules, create mapping documents, Process flow documents, test plans, test cases and execution plans.
  • Participate in gathering user requirements, work on Work requests and trouble tickets created by the business users and BI team manager.
  • Designing mapping documents which includes details of field to field mapping between sources and target, Business Rules, Processing Flow and details of sessions, workflows, pre dependencies, post dependencies, exception error processing methodology’s
  • Use Informatica Power Center 7.1 and PLSQL to load ERP data from Oracle Applications(ERP)s, MS SQL Server into the target EDW Oracle 10g database
  • Extensive use of Transformations like Lookup, Joiner, Rank, Normalizer, Update Strategy, Expression, Aggregator and Source Qualifier in the Informatica Designer.
  • Use Connected and Unconnected Lookups in various complex mappings.
  • Fine tune Transformations and Mappings for better performance, Use Debugger for debugging mappings
  • Create Workflows and Worklets and schedule them using Workflow Manager.
  • Analyze session logs, bad files and error tables for troubleshooting mappings and sessions
  • Defined email objects for notifying the developers and managers for success and failures of workflows
  • Debugging invalid mappings using break points, testing of stored procedures and functions, testing of Informatica sessions, batches and the target Data
  • Design and developed the logic for handling slowly changing dimension tables load by flagging the record using update strategy for populating the desired.
  • Defined and tested the migration procedure for Informatica process that involved unit testing, integration testing and QA before moving to Production.
  • Work with Oracle support by creating Oracle TARs when necessary.
  • Design, code, test, debug, document and maintain tables, indexes, views, materialized views, SQL Loader scripts, stored procedures and packages.
  • Analyze and tune slow running SQL queries by creating indexes and passing oracle hints.
  • Use Oracle Enterprise Manager (OEM), DBMS JOB for oracle job scheduling and cron jobs for UNIX job scheduling.
  • Develop UNIX Scripts to perform scheduled/periodic operations on day to day basis including ftp, data extraction, loading, and stored procedure execution

Environment: Informatica Power Center 7.1, Oracle 9i/10g, Oracle ERP/Applications, Oracle Discoverer10g, PL/SQL, SQL*Loader, Toad, SQL Server, Windows, UNIX.

Hire Now