We provide IT Staff Augmentation Services!

Senior Etl Developer Resume

2.00/5 (Submit Your Rating)

DetroiT

SUMMARY:

  • 8+ years of experience on Data stage(11.x,9.x), Informatica Powercenter, Informatica PowerExchange/ Power Connect in all phases of Analysis, Administration, Design, Development, Implementation and support of Data warehousing applications using Informatica Power Center 9.x & 8.x, SQL, PL/SQL, MS SQL, Teradata, DB2, Oracle, and Unix.
  • Full life - cycle project delivery experience from product definition to implementation including: requirements and specification writing, design documentation, unit and system testing, optimization and performance analysis, quality assurance, and release into a production environment.
  • Expertise knowledge in domains like Telecom, Finance, Health Care, Pharma, Manufacture Systems.
  • Created Functional, Technical Design and Data mapping documents by Interacting with Customers subject matter expert (SME). In Addition participating in requirement gathering, Analysed the requirements.
  • Experienced in creating entity relational & dimensional relational data models using Kimball Methodology i.e. Star Schema and Snowflake Schema.
  • Strong in using workflow tasks like Session, Control Task, Command tasks, Decision tasks, Event wait, Email tasks, Pre-sessions, Post-session and Pre/Post commands
  • Designed Data Mart for Reporting using Star Schema & Multi-dimensional Analysis.
  • Extracted Data from multiple operational sources of loading staging area, Data Warehouse and data marts using CDC/ SCD (Type1/Type2/Type3) loads.
  • Knowledge in Data Analyzer tools like data stage,Informatica PowerExchange (PowerConnect), Informatica B2B, Informatica Data Quality (IDQ) and Informatica Data Explorer (IDE).
  • Experience in Informatica change management like migration from Informatica 7.x to Informatica 8.x and 8.x to 9.x and Version control to track the modification in Informatica Power Center.
  • Experience in pulling data from ERP systems i.e. SAP from different modules like HR, SD, MM through Informatica R3 power connect connection establishment and extracted Data sources for Attribute & Text tables for SD, MM, FI & CO modules.
  • Well acquainted with session partitioning and Performance Tuning of sources, targets, mapping and sessions to overcome the bottlenecks in mappings. Troubleshooting and problem solving applications with Informatica Debugger.
  • Excellent working ethics to meet deadlines in fast-paced environment and function under high-pressures with extremely short deadlines. Collaborate on multi-disciplinary (e.g. business and technical) teams.
  • Solid Organizational skill and ability to work without supervision to achieve project goals.

TECHNICAL SKILLS:

ETL: Data stage(11.x,9.x),Informatica PowerCenter 9.x, 8.x, B2B DX, DT, Informatica IOD, IDQ(IDQ 8.6.1), IDE,cognos, Data Mart, OLAP, OLTP

Databases: Oracle 11g/ 10g/ 9i, MS SQL Server, DB2, Teradata and MS Access

Environment: Windows 200/ XP/ 98, UNIX, Linux

PROFESSIONAL EXPERIENCE:

Confidential, Detroit

Senior ETL Developer

Responsibilities:

  • Worked with different sources such as SQL, Flat files and XML sources.
  • Created and Imported/Exported various Sources, Targets, and Transformations using Data Stage(11.x,9.x) Designer.
  • Involved in fixing invalid Mappings, testing of Stored Procedures and Functions, Unit and Integration Testing of data stage Sessions, Batches and the Target Data.
  • ETL Design and preparing Technical specifications for the Data stage mappings.
  • Performance tuning of targets, sources, mappings and sessions using various components like parameter file, variables and partitioning concepts.
  • Was also involved in development of Unix scripts for doing some basic operations like merging of files, removing header from files, etc.
  • Responsible in fixing issues with complex mappings.
  • Design and implement the error handling process for the existing data warehouse.
  • Worked closely with the DBA team for production and apps team to schedule the maintenance activities for better results in production.
  • Experience in Create, backup, restore for Data stage Repositories.
  • Setup and maintain ETL administration best practices and procedures.
  • Maintain all necessary updates and/or patches for the ETL environments.
  • Monitors and tunes ETL repository and system for performance improvements
  • Ability to perform root cause analysis, performance monitoring and application related issues
  • Write Repository Queries in support of developments and Production statistics
  • Developed Mappings for the Category, Specification, Code, Type areas.
  • Responsible to design, develop and test the software (Data stage, PL SQL, UNIX shell scripts) to maintain the data marts (Extract data, Transform data, Load data)
  • Providing solutions to improve efficiency (e.g., reduce costs while maintaining or improving performance levels).
  • Optimized SQL queries for better performance using Hints, Indexes and Explain Plan.
  • Join, Router, Look up and Update transformation rules (business rules).
  • Developed schedules to automate the update processes and Data stage Sessions/ Batches.

Environment: Data stage 11.x,9.x, (IOD, B2B, IDQ, IDA (Source Analyzer, Warehouse Designer, Mapplet Designer, Mapping Designer and Transformation Developer) SQL, PL/SQL, XML, MS SQL, Oracle 10g, DB2, TOAD, HPSM, OBIEE, Windows 2000, Linux, and AIX UNIX.

Confidential, Philadelphia, PA

Senior ETL Developer

Responsibilities:

  • Created Functional, Technical Design and Data mapping documents by Interacting with Customers subject matter expert (SME). In Addition participating in requirement gathering, Analyzed the requirements.
  • Worked with Informatica Data Quality 8.6.1 (IDQ) toolkit, Analysis, data cleansing, data matching, data conversion, exception handling, and reporting and monitoring capabilities of IDQ 8.6.1.
  • Identified and eliminated duplicates in datasets thorough IDQ 8.6.1 components of Edit Distance, Jaro Distance and Mixed Field matcher, It enables the creation of a single view of customers, help control costs associated with mailing lists by preventing multiple pieces of mail
  • Co-ordination with client side IT Team and business users.
  • Creating the Technical design specifications based on Client functional specs.
  • Design data mappings to extract Data from SAP using ABAP, IDOC, BAPI’s & set up Business Content mappings i.e. Listener, Send Request, Processing & Cleanup to load into EWD for upstream Cognos Reporting System.
  • Identified, activated, created Processing Mappings for BCI’s and extracted Data sources for Attribute & Text tables for SD, MM, FI & CO modules.
  • Outage Handling (Escalation Procedure, Running metadata queries and procedures, checking database, creating outage log)
  • Performed migration of mappings and session from Dev to Test repository, taking backup and restoring of Informatica Repository, upgrades and security issues.
  • Involved in migration of Informatica objects in all phases (DEV, INT and PRD) of project and trained developers to maintain system when in production.
  • Regular monitoring of the informatica server environment on AIX UNIX Server.
  • Experience in Applying Informatica Latest Hot fixes/Patches.
  • Developed IDQ work benches by using Data sources, Operational Components and Data Sinks.
  • Developed the IDQ Plans for Profile Demo data, Pre-Standardization Scorecard, Standardize Generic Data and Standardize Name, Address Data.
  • Developed mappings using various transformations like Update strategy, Lookup, Stored Procedure, Router, Filter, Sequence Generator, Joiner, Aggregator, Expression, SQL transformation.
  • Worked with different sources such as Oracle, Flat files and XML sources.
  • Using Workflow manager for Workflow and Session Management, database connection management and Scheduling of jobs.
  • Responsible for writing complex SQL queries in Informatica Mapping and developing stored procedures using PL/SQL.
  • Performance tuning of targets, sources, mappings and sessions using various components like parameter file, variables and partitioning concepts.
  • Worked closely with the DBA team for production and apps team to schedule the maintenance activities for better results in production.
  • Designed Data Mart for Reporting using Star Schema & Multi-dimensional Analysis.
  • Was also involved in development of Unix scripts for doing some basic operations like merging of files, removing header from files, etc.
  • Responsible in fixing issues with complex mappings.
  • ETL Design and preparing Technical specifications for the Informatica mappings.
  • Design and implement the error handling process for the existing data warehouse.

Environment: Informatica Power Center 9.x, 8.x (IOD, B2B, IDQ, IDA (Source Analyzer, Warehouse Designer, Mapplet Designer, Mapping Designer and Transformation Developer) SQL, PL/SQL, XML, MS SQL, Oracle 10g, DB2, TOAD, HPSM, OBIEE, Windows 2000, Linux, and AIX UNIX.

Confidential, NJ

BI Application Support, Senior ETL Developer

Responsibilities:

  • Created Functional, Technical Design and Data mapping documents by Interacting with Customers subject matter expert (SME). In Addition participating in requirement gathering, Analyzed the requirements.
  • Ensures proper configuration of the Power Center Domain components.
  • Experience in Grids, nodes, Repository services and Integration services.
  • Ensures proper application of the licensing files.
  • Involved in Informatica server and Server Administration such as Installing, Creating and configuring Repository, Folders, Users and User Groups and ODBC in Informatica Power Center 8.6.
  • Outage Handling (Escalation Procedure, Running metadata queries and procedures, checking database, creating outage log)
  • Involved in migration of Informatica objects in all phases (DEV, INT and PRD) of project and trained developers to maintain system when in production.
  • Regular monitoring of the informatica server environment on AIX UNIX Server.
  • Experience in Applying Informatica Latest Hot fixes/Patches.
  • Developed IDQ work benches by using Data sources, Operational Components and Data Sinks.
  • Developed the IDQ Plans for Profile Demo data, Pre-Standardization Scorecard, Standardize Generic Data and Standardize Name, Address Data.
  • Generated Data profile (SWOT) Reports by using IDE.
  • Performed migration of mappings and session from Dev to Test repository, taking backup and restoring of Informatica Repository, upgrades and security issues.
  • Developed mappings using various transformations like Update strategy, Lookup, Stored Procedure, Router, Filter, Sequence Generator, Joiner, Aggregator, Expression, SQL transformation.
  • Worked with different sources such as Oracle, Flat files and XML sources.
  • Using Workflow manager for Workflow and Session Management, database connection management and Scheduling of jobs.
  • Responsible for writing complex SQL queries in Informatica Mapping and developing stored procedures using PL/SQL.
  • Development of work breakdown structures, charts, tables, graphs, major milestone calendars and diagrams to assist in analyzing problems and making recommendations.
  • Worked closely with the DBA team for production and opps team to schedule the maintenance activities for better results in production.
  • Designed Data Mart for Reporting using Star Schema & Multi-dimensional Analysis.
  • Responsible in fixing issues with complex mappings.
  • ETL Design and preparing Technical specifications for the Informatica mappings.
  • Design and implement the error handling process for the existing data warehouse.

Environment: Informatica Power Center 8.6 (IDQ, B2B (Source Analyzer, Warehouse Designer, Mapplet Designer, Mapping Designer and Transformation Developer) SQL, PL/SQL, Oracle 10g, XML, MS SQL Server, DB2, TOAD, Cognos, Windows 2000, and Linux.

Confidential, Detroit

ETL Developer

Responsibilities:

  • Developed number of Complex Informatica Mappings, Mapplets and Reusable Transformations for the Marketable Security & Derivative Systems to facilitate one time, Daily, Monthly and Yearly Loading of Data.
  • Developed mappings using various transformations like update strategy, lookup, stored procedure, Router, Filter, sequence generator, joiner, Aggregator, Expression, SQL transformation, Transaction Control transformation.
  • Worked with different sources such as Oracle, flat files and XML sources.
  • Involved in fixing invalid Mappings, testing of Stored Procedures and Functions, Unit and Integration Testing of Informatica Sessions, Batches and the Target Data.
  • Developed Mappings for the Category, Specification, Code, Type areas.
  • Created, configured, scheduled and monitored the sessions and workflows on the basis of run on demand, run on time using Informatica Power Center Workflow Manager.
  • Involved in Production Support by performing Normal Loads, Bulk Loads, Initial Loads, Incremental Loads, Daily loads and Monthly loads.
  • Modifying the existing Informatica code to accomplish the change requests for Dimension, Fact & Aggregate Tables.
  • Mappings were designed to the utmost performance by optimizing transformations logic.
  • Writing documentation to describe program development, logic, coding, testing, changes and corrections.

Environment: Informatica Power Center 8.1, DB2, Oracle 9i, Windows 2000, and UNIX.

Confidential

ETL Developer

Responsibilities:

  • Created and Imported/Exported various Sources, Targets, and Transformations using Informatica Power Center Designer.
  • Developed number of Complex Informatica Mappings, Mapplets and Reusable Transformations for the Sales and Marketing Systems to facilitate one time, Daily, Monthly and Yearly Loading of Data.
  • Created ER Diagram representation including existing source systems by using Ervin Tool.
  • Involved in fixing invalid Mappings, testing of Stored Procedures and Functions, Unit and Integration Testing of Informatica Sessions, Batches and the Target Data.
  • Experience in Create, backup, restore for Informatica Repositories.
  • Setup and maintain ETL administration best practices and procedures.
  • Maintain all necessary updates and/or patches for the ETL environments.
  • Monitors and tunes ETL repository and system for performance improvements
  • Ability to perform root cause analysis, performance monitoring and application related issues
  • Handle user access/ security role requests for new developers and projects
  • Write Repository Queries in support of developments and Production statistics
  • Developed Mappings for the Category, Specification, Code, Type areas.
  • Responsible to design, develop and test the software (Informatica, PL SQL, UNIX shell scripts) to maintain the data marts (Extract data, Transform data, Load data)
  • Providing solutions to improve efficiency (e.g., reduce costs while maintaining or improving performance levels).
  • Optimized SQL queries for better performance using Hints, Indexes and Explain Plan.
  • Join, Router, Look up and Update transformation rules (business rules).
  • Developed schedules to automate the update processes and Informatica Sessions/ Batches.

Environment: Informatica Power Center 8/ 7.1, Oracle 9i, TOAD, SQL, PL/SQL, and UNIX.

We'd love your feedback!