We provide IT Staff Augmentation Services!

Etl Developer Resume

SUMMARY

  • 8 years of total IT experience for BI/DW projects for Health - care, Bank, Energy, and Manufacturing companies.
  • Experience 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 Techn ical, 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

PROFESSIONAL EXPERIENCE

Confidential

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.

Hire Now