We provide IT Staff Augmentation Services!

Sr. Etl Developer Resume

Newark, NJ

SUMMARY:

  • 7+ years of Strong data warehousing experience with extensive knowledge in SDLC: Data Analysis, Design, Development, Implementation and Testing using Data Extraction, Data Transformation and Data Loading (ETL) using Informatica Power center 9.5/9.1.1/8.6/8.1/7.1.
  • Possess strong Documentation skill and knowledge sharing among Team, conducted data modeling review sessions for different user groups, participated in requirement sessions to identify requirement feasibility.
  • Extensive experience in Relational and Dimensional Data modeling for creating Logical and Physical Design of Database and ER Diagrams using multiple data modeling tools like ERWIN, ER Studio.
  • Experience in BI / Data warehouse projects involving Informatica and Cognos suite of products.
  • Experience in working with data warehouses and data marts using Informatica Power center (Designer, Repository Manager, Workflow Manager, and Workflow Monitor).
  • Understanding & Working knowledge of Informatica CDC (Change Data Capture).
  • Worked as a Technical Team Lead to help my team members resolving any issue related to coding, testing, performance tuning in developing Informatica mappings and workflows.
  • Proficient in designing and developing complex standard and re - usable mappings and mapplets using various transformation logics by utilizing the expression, filter, joiner, lookup, router, rank, normalizer, aggregator.
  • Expertise in unit testing at various levels of the ETL as well as SQL, UNIX etc.
  • Developed Strategies for Extraction Transformation Loading (ETL) mechanism.
  • Extensive experience in analyzing the Dimensional Data modeling, Star Schema/Snowflake Schema, modeling, FACT & Dimensions tables, Physical & logical data.
  • Experience in developing OBIEE/Siebel Analytics Repository (.rpd) - three layers (Physical Layer, Business Model & Presentation Layer).
  • Experience in customizing reports, dashboards, filters and charts in Oracle Answers.
  • Extensive work with PL/SQL, performance tuning of Oracle.
  • Experienced with Informatica Power Exchange (5.x/8.x/9.x) for Loading/Retrieving data from mainframe systems.
  • Good experience with configuring Data Warehouse Administration Console (DAC) for creating execution plans, metadata management and monitoring the Informatica ETL Process.
  • Configured and registered the custom workflows in DAC.
  • Worked with Data warehouse Administration Console (DAC) to schedule and run full and Incremental ETL loads, to schedule the Informatica jobs, and to customize Execution Plans.
  • Experienced Oracle Apps (Oracle E-Business Suite).
  • Experience in Data Modeling experience using ERWIN 3.x
  • Experience with Sybase as the target for the data marts.
  • Extensive Unix Shell Scripting knowledge.
  • Extensive experience with relational databases (Sybase 15.x, Oracle 8i/9i/10g, Teradata v2 R6, SQL Server 2000/2005).
  • Strong understanding in the principles of Data ware housing using Fact Tables, Dimension Tables, star schema modeling and snowflake schema modeling, Slowly changing dimensions, foreign key concepts, referential integrity.
  • Maintained outstanding relationship with Business Analysts and Business Users to identify information needs as per the business requirement Experience working with Onside-Offshore model.

SKILL SET:

ETL Tools: Informatica Power Center 9.1/8.6.1.1/7.1.2/6.2/6.1/5.1 , Power Mart 5.0/4.7, Dataware House Builder, Abintio.

Operating Systems: Windows XP/2000/NT/98/95, Windows 2003 server, Unix, MSDOS

RDBMS: Oracle 11g,10g/9i/8i/8.0, MS-SQL Server 2005/2000/7.0/6.5

Data Modeling: Erwin 4.1.4/3.5.2

Data Base Tools: SQL Loader, Toad 4.0.3, MS Visio, MS Access

Reporting Tools: Business Objects XI/6.x/5.x, OBIEE 10.x/9.x; Power play and Transformer.

Scripting: UNIX Shell Scripting

Web Technology: Web Technology HTML, Java script

Languages: SQL, PL/SQL, C, C ++, Java 1.2, XML.

PROFESSIONAL EXPERIENCE:

Confidential, Newark, NJ

Sr. ETL Developer

Responsibilities:

  • Coordinating with source system owners, day-to-day ETL progress monitoring, Data warehouse target schema Design (Star Schema) and maintenance.
  • Designed Informatica mappings by translating the business requirements.
  • Worked with Business analysts and the DBA for requirements gathering, business analysis and designing of the data warehouse.
  • Developed mappings for customers, Investments and Risk analysis.
  • Developed reusable Transformations.
  • Widely used Informatica client tools -- Source Analyzer, Warehouse designer, Mapping designer, Transformation Developer and Informatica Work Flow Manager.
  • Used look up, router, filter, joiner, stored procedure, source qualifier, aggregator and update strategy transformations extensively.
  • Assisted in adding Physical conceptual data model using Erwin 4.0.
  • Analyzed business process workflows and assisted in the development of ETL procedures for moving data from source to target systems.
  • Done extensive bulk loading into the target using Oracle SQL Loader.
  • Used workflow manager for session management, database connection management and scheduling of jobs.
  • Assisted the team in the development of design standards and codes for effective ETL procedure development and implementation.
  • Extensive performance tuning by determining bottlenecks at various points like targets, sources, mappings and sessions.
  • Involved in the design, development and testing of the PL/SQL stored procedures, packages for the ETL processes.
  • Developed UNIX Shell scripts to automate repetitive database processes and maintained shell scripts for data conversion.
  • Involved in the process design documentation of the DW Dimensional Upgrades. Installed, and Documented the Informatica Power Center setup on multiple environments.

Environment : Informatica Power Center 9.5, Work Flow Manager/Monitor, Erwin 4.0, Oracle 10g/9i, SQL, PL/SQL, TOAD, SQL * Loader, UNIX /LINUX Shell Scripting, DB2, Microsoft SQL Server 2012, Tivoli Scheduling Tool, OBIEE.

Confidential, Chantilly, VA

Sr. ETL Developer

Responsibilities:

  • Interacted with business analysts, architects and application developer to analyze the data model and gathered the requirements.
  • Involved in Code reviews and determining Informatica standards for Mappings/Sessions/ Workflows.
  • Created reusable transformations and mapplets and used them in mappings.
  • Implemented the slowly changing dimensions (SCD) type1 and type2 to maintain current information and history information in the dimension tables.
  • Used Informatica Power Center Workflow manager to create sessions, batches to run with the logic embedded in the mappings.
  • Created complex mappings in Power Center Designer using Aggregate, Expression, Filter, and Sequence Generator, Update Strategy, SQL, Union, Lookup, Joiner, XML Source Qualifier, Unconnected lookup transformations.
  • Created shell scripts to kick off Informatica workflow/s and PL/SQL procedures.
  • Created Database Triggers, Stored Procedure, Functions and Packages.
  • Extensively used debugger to trace the errors.
  • Extensively tested the code and documented the Unit Test Cases.
  • Assisted the testers in system and integration testing and preparing the test cases and test plan.
  • Taking the backup of the repository at regular interval depending on the amount of work done.
  • Extensively used UNIX scripts for automation of ETL process.
  • Extensively worked on tuning mappings and reducing processing times.
  • Worked with DBA to identify source and target bottle necks.
  • Analyzed existing requirements and consolidated the reports for effective and efficient reporting.
  • Involved in production support for the data warehouse Informatica jobs.
  • Involved in bug fixing. Debugged the issues during QA level.

Environment: Informatica Power Center 9.5, Sybase 15.x, CA Scheduling, DBArtisian 9.0, YART1.0, UNIX /LINUX Shell Scripting, Tortoise SVN, Putty, Toad, OBIEE.

Confidential, Virginia Beach, VA

Sr. DW ETL Informatica Consultant

Responsibilities:

  • Interacting with Business Analysts to understand the requirements
  • Analyzing the requirements and preparing design.
  • Involved in ETL designing and coding. Extensively used ETL to load data from Oracle database, SQL server, and Flat files to Teradata Data Warehouse.
  • Reviewed the logical model with Business users, ETL Team, DBA’s and testing team to provide information about the data model and business requirements.
  • Involved in production support for the Data Warehouse Informatica jobs.
  • Modified the existing mappings and workflows as per requirement changes and migrated them back to production environment.
  • Created robust and complex workflow and Worklets using Informatica Workflow Manager and troubleshot data load problems
  • Wrote SQL Queries, Triggers and Shell Scripts to apply and maintain the Business Rules.
  • Translated business requirements into Informatica mappings/workflows
  • Used Source Analyzer and Warehouse designer to import the source and target database schemas, and the Mapping Designer to map the sources to the target.
  • Used Informatica Designer to create complex mappings using different transformations like Source Qualifier, Expression, Lookup, Aggregator, and Update Strategy, Joiner, Filter and Router transformations to pipeline data to Data Warehouse/Data Marts.
  • Developed Mappings to extract data from ODS to Data Mart, and monitored Daily, Weekly and Monthly Loads.
  • Designed and developed unit test cases for system integration testing.
  • Involved with the users in the creation of test scripts for the user acceptance testing
  • Developed some scripts to take weekly backups of certain tables using korn shell and import/export utilities.
  • Worked on tuning some individual mappings and oracle queries that causing performance bottlenecks.
  • Written documentation to describe program development, logic, coding, testing and changes made.
  • Created and monitored Sessions/Batches using Informatica Server Manager/Workflow Monitor to load data into target Oracle database.
  • Worked with mapping variables, Mapping parameters and variable functions like set variable, Count Variable, Setminvariable and Setmaxvariable.
  • Monitored incremental and full load of data extraction through Data Warehouse Administration Console (DAC) and Informatica.

Environment: Informatica Power Center 9.5/9.1, Teradata 13 1, SQLServer 2005, Tidal, Mercury Quality Centre 10.1, DAC, PL/SQL, OBIEE 10g, Toad, UNIX Shell Scripts.

Confidential, Richmond, VA

Sr. ETL Consultant

Responsibilities:

  • Interacted with business analysts, architects and application developer to analyze the data model and gathered the requirements.
  • Analyzed existing requirements and consolidated the reports for effective and efficient reporting.
  • Extensively worked on tuning mappings and reducing processing times.
  • Involved in Code reviews and determining Informatica standards for Mappings/Sessions/Workflows.
  • Met with end users to gather requirements.
  • Translated business requirements into Informatica mappings/workflows .
  • Created various transformations such as Normalizer, Union, Aggregator, Update Strategy, Look Up, Joiner, Filter and Router Transformations.
  • Involved in Performance tuning. Identified and eliminated bottlenecks (source, target, and mapping).
  • Proficient experience in working on conceptual, physical and logical data models(3NF) using various Data Modeling tools like Erwin, MS Visio, Power Designer.
  • Created shell scripts to kick off Informatica workflows and PL/SQL procedures.
  • Used DAC (Data warehouse Administration Console) for both incremental and full loads.
  • Created Database Triggers, Stored Procedure, Functions and Packages.
  • Extensively used debugger to trace the errors.
  • Extensively tested the code and documented the Unit Test Cases.
  • Created UNIX scripts for automation of ETL process.
  • Assisted the testers in system and integration testing and preparing the test cases and test plan.
  • Trained on building Conceptual, Logical and Physical data model
  • Taking the backup of the repository at regular interval depending on the amount of work done.
  • Worked with DBA to identify source and target bottle necks.
  • Involved in bug fixing. Debugged the issues during QA level.

Environment: Informatica Power Center8.6.1/9.1, SQL Server 2005, Control M, Oracle 10g, PL/SQL, Business Objects XIR2, DAC, Toad, Linux, UNIX Shell Scripts.

Confidential, Deerfield, IL

Sr. Informatica Developer

Responsibilities:

  • Designed and developed slowly changing dimensional model for reference tables.
  • Extensively used ETL to load data from sequel server database, Flat files to Data Warehouse
  • Used Informatica Power Connect to directly source and integrate enterprise data.
  • Used Informatica Designer to create complex mappings using different transformations like filter, Router, lookups, stored procedure, joiner, update strategy, expressions and aggregator transformations to pipeline data to Data Warehouse/Data Marts.
  • Modified the existing mappings and workflow as per requirement changes and migrated them back to production environment
  • Created robust and complex workflow and workletsusing Informatica workflow manager and troubleshooting data load problems.
  • Created Database Triggers, Stored Procedure, Functions and Packages.
  • Extensively worked in the performance tuning of programs.
  • Pmcmd commands of Informatica in UNIX scripts.
  • Designed and developed a process to load Historical data.
  • Prepared estimates and tracked each and every task and strictly adhered to the estimated deadlines.
  • Extensive knowledge in promoting packages (code) across development, test, preproduction and production environment using tools like Computer Associate Harvest package.
  • Extensive knowledge in promoting packages (code) across development, test, preproduction and production.
  • Preparation of Test Data/Unit Testing /Integrated testing and generated various test cases.
  • Involved in different Team review meetings.
  • Worked along with UNIX team for writing UNIX shell scripts to customize the server scheduling jobs.
  • Communication with the client for weekly status report.

Environment: Informatica PowerCenter8.1, SQL server 2005, Autosys, Oracle 10g, PL/SQL, Toad, Business Objects 6.0, Windows NT, UNIX Shell Scripts.

Confidential

ETL Analyst

Responsibilities:

  • Extensively used ETL to load data from Oracle database, Flat files to Data Warehouse.
  • Involved in production support for the data warehouse Informatica jobs.
  • Modified the existing mappings and workflows as per requirement changes and migrated them back to production environment.
  • Automated Reports and generated documents using Scheduler.
  • Created robust and complex workflow and work lets using Informatica workflow manager and troubleshoot data load problems.
  • Wrote SQL Queries, Triggers and Shell Scripts to apply and maintain the Business Rules.
  • Translated business requirements into Informatica mappings/workflows
  • Used Source Analyzer and Warehouse designer to import the source and target database schemas, and the Mapping Designer to map the sources to the target.
  • Used Informatica Designer to create complex mappings using different transformations like Source Qualifier, Expression, Lookup, Aggregator, and Update Strategy, Joiner, Filter and Router transformations to pipeline data to Data Warehouse/Data Marts.
  • Involved in Performance tuning. Identified and eliminated bottlenecks (source, target, and mapping).
  • Developed Mappings that extract data form ODS to Data mart and Monitored the Daily, Weekly and Monthly Loads.
  • Created and monitored Sessions/Batches using Informatica Server Manager/Workflow Monitor to load data into target Oracle database.

Environment: Informatica Power Center 7.1.2, Oracle 9i, PL/SQL, Toad, OBIEE, DAC, Windows NT, UNIX Shell Scripts.

Hire Now