We provide IT Staff Augmentation Services!

Etl Developer Resume

Scottsdale, AZ

SUMMARY:

  • 8 years of total IT experience for BI/DW projects for Health - care, Bank, Energy, and Manufacturing companies.
  • E xperience on Informatica Power Center 9.1/8.6/8.1, BODS, SSIS 2012/2008/2005 with good understanding of business needs and Extraction, Transformation and Loading large data from various data sources i.e SQL Server, Oracle, DB2, SAP.
  • Worked extensively on Power Center Client tools (Designer, Repository Manager, Workflow Manager, Workflow Monitor).
  • Worked extensively on Informatica Transformations (Active, Passive, Connected & Unconnected).
  • Designed mappings, mapplets, created sessions and workflows to load data, and monitored workflow progress.
  • Experience in identifying and resolving performance bottlenecks at various levels like sources, mappings and sessions.
  • Performed testing using DVO. Wrote ETL test cases, test plan and Technical Documentation.
  • Experience in resolving Production issues, Exception-handling, performance tuning and Email Alerts.
  • Scheduled and monitored jobs.
  • Worked on Trillium for data cleansing and data profiling.
  • Experience in writing SQL, PL/SQL, shell scripts.
  • Knowledge of Conceptual, logical and physical data modelling, ER modelling and tools like Erwin, and Visio.
  • Familiar with Scrum, Agile methodologies, MDM , OLAP and OLTP database schemas.
  • 4 years of experience in BI Reports - Cognos, OBIEE 10/11g, SSRS 2012/2008/2005.
  • Experience working with off-shore team; provided 24/7 tech support.
  • Diverse background with fast Learning and creative analytical abilities with good Technical, Communication and Interpersonal skills.

TECHNICAL SKILLS:

ETL Tools: Informatica PowerCenter9.1/8.6/8.1, SSIS 2005/2008/20012 , Ab initio 3.0.

RDBMS: Oracle10g/9i, SQL Server 2000/2005/2008 , DB2

BI Tools: Cognos 8.0/10.1, Tableau, SSRS, BI Publisher 11g/10g

Operating System: UNIX, Linux, Windows NT/2000/XP/7

Defect Management tools: HP Quality Center 9x/11, Remedy 7x, ClearCase

Languages: SQL, PL/SQL, Visual Basic, Shell Scripting

Modeling Tools: MS Visio, Erwin

EXPERIENCE:

Confidential, Scottsdale, AZ

ETL Developer

Responsibilities:

  • Worked on Informatica Power Center 9.1
  • Worked with DBAs and Business Analysts to analyze and gather business requirements.
  • Designed complex mappings, mapplets, created sessions and workflows to load data, and monitored workflow progress.
  • Designed mappings using various types of transformations such as Active, Passive, Connected and Unconnected.
  • Worked on CDC (change Data Capture) to capture insert, update, and delete activity applied to tables.
  • Implemented Source Qualifier, SCDs(1/2/3), Joiner, Filter, Router, Rank, Expression, Lookup, Aggregator, Sorter, Normalization, Update Strategy, Sequence Generator, Stored Procedure transformations, Union, etc.
  • Wrote SQL, PL/SQL scripts. Created/Edited korn shell scripts for pre or post-session.
  • Wrote BRDs, ETL Technical Specification Docs, Test Plan, ETL Test Cases, Migration Plan Doc.
  • Performed testing from source to target using DVO (Data Validation Option), performance tuning and Exception-handling. Worked on data integration and data staging levels.
  • Scheduled and monitored jobs using Control-M.
  • Worked on data cleansing and data profiling using Trillium.
  • Worked on Tickets and provided tech support to resolved production issues. Worked with QA team to follow up on testing.
  • Participated on Daily/Weekly team meetings on the Project.

Environment: Informatica PowerCenter 9.1, SAP ECC6.0, MS SQL server 2008, SSIS 2008, Oracle, Toad, DVO, PL/SQL, MS Visio, UNIX, Quality Center 11, Remedy, Windows, SharePoint, TFS, Control-M for scheduling, ClearCase, Trillium.

Confidential

Developer (Informatica)

Responsibilities: .

  • Worked with Business Analysts, DBAs to analyze and gather business requirements.
  • Designed complex mappings, mapplets, created sessions and workflows to load data, and monitored workflow progress.
  • Implemented various types of transformations such as Active, Passive, Connected and Unconnected.
  • Set mapping parameters, variables, breakpoints, exception-handling, and email alerts.
  • Worked on performance turning to identify performance bottlenecks.
  • Worked on change Data Capture to capture insert, update, and delete activity applied to tables.
  • Did testing from source to target using DVO.
  • Wrote complex SQL, PL/SQL scripts.
  • Worked on Trillium for data cleansing and data profiling.
  • Wrote shell script after each successful run of session to update/insert/select for different scenarios either in Pre or Post session command.
  • Worked on 3 rd party tool control-M to schedule jobs.
  • Wrote detailed ETL designed Technical Specs Document, ETL test cases, test plan; followed up with QA team.
  • Created various Reports, Dashboard, Graphs, Charts using Business Objects BI suite XI3.1.
  • Participated in daily and weekly team meetings.

Environment: Informatica PowerCenter 9.1/8.6, Oracle , Toad, SAP, SQL, PL/SQL, SQL Server 2008, Trillium, Visio, Windows, TFS, Linux, Quality Center, Sharepoint, VSS, Business Objects XI3.1, VB, Ctl-M for scheduling jobs.

Confidential

Developer

Responsibilities:

  • Analyzed and gathered business requirements and wrote technical specifications document.
  • Designed complex mappings, mapplets, created sessions and workflows to load data, and monitored workflow progress.
  • Designed mappings using various types of transformations such as Active, Passive, Connected and Unconnected.
  • Worked on CDC (Change Data Capture) to capture insert, update, and delete activity applied to tables.
  • Implemented Source Qualifier, Joiner, Filter, Router, Rank, Expression, Lookup, Aggregator, Sorter, Normalization, Update Strategy, Sequence Generator, Stored Procedure transformations, Union, etc.
  • Wrote SQL, PL/SQL scripts. Created/Edited shell scripts for pre or post-session.
  • Wrote BRDs, ETL Technical Specification Docs, Test Plan, ETL Test Cases, Migration Plan Doc.
  • Performed testing from source to target using DVO (Data Validation Option), performance tuning and Exception-handling.
  • Scheduled and monitored jobs.
  • Worked on Tickets and provided tech support to resolved production issues. Worked with QA team to follow up on testing.
  • Participated on Daily/Weekly team meetings on the Project.
  • Worked with QA team and data analysts to follow-up.
  • Participated in daily/weekly team meetings.

Environment: PowerCenter 8.1, SQL, PL/SQL, Oracle, MS SQL server 2008/2005, SSIS, TOAD, UNIX, Remedy, VB, OBIEE

Confidential

ETL Developer

Responsibilities:

  • Analyzed ETL requirements. Created sources, targets, and transformations.
  • Wrote SQL, PL/SQL Scripts.
  • Designed ETL mappings using various transformations i.e. Joiner, Connected Lookup and unconnected Lookup, Rank, Router, Filter, Aggregator and Sequence Generator transformations, Source qualifier, etc..
  • Tested ETL package from Source to Target.
  • Wrote technical documentation, ETL test cases, test plan. Worked on tickets.
  • Worked with the QA team, DBA and data analysts.
  • Participated in Daily/Weekly team meetings.

Environment: Informatica Power Center 8.1, Oracle, SQL Server 2005, SSIS, SQL, PL/SQL, VISIO, Toad, Windows, UNIX, Quality Center, Remedy, Visual Basic.

Confidential

Developer SSIS/SSRS

Responsibilities:

  • Analyzed business requirements, and wrote technical specifications document.
  • Designed ETL package to load data in a desired target.
  • Wrote SQL queries, stored procedures.
  • Proficiently implemented transformations, tasks, containers, source, target, Break - points to do extract-transform-load in a package.
  • Provided technical support to resolve production issues and schedule jobs.
  • Wrote Technical Requirements Document, BRDs, Migration Plan, Unit Test and Developer Testing Document.
  • Created various style of Reports i.e. drill-down, linked reports, parameter, matrix reports.
  • Worked with QA team and business analysts to follow-up and participated in daily/weekly team meetings.

Environment: MS SQL Server 2000, DTS, Oracle, Excel, Access, SSRS, SQL, Visual Basic

Hire Now