Senior Etl Developer Resume
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.