Sr. Etl Developer Resume Profile
Columbus, OH
PROFESSIONAL SUMMARY:
- About 7 years of strong experience in working with large scale Data Warehouse implementations using Informatica PowerCenter 9.5/9.1/8.x, Oracle, SQL Server on UNIX and Windows platforms
- Strong understanding of OLTP and OLAP systems, Kimball, and Inmon methodology models, Dimensional modeling using Star and Snowflake schema.
- Extensive experience in Extraction, Transformation, and Loading ETL data from various data sources into Data Warehouse and Data Marts using Informatica PowerCenter tools Repository Manager, Designer, Workflow Manager, Workflow Monitor, and Informatica Administration Console .
- Experience in gathering reviewing business requirements and refining user's information needs in order to convert them in robust system designs.
- Strong experience in creating Informatica mappings, mapplets, sessions, workflows, worklets and performance tuning for faster data load.
- Expertise in extracting the data from Sources to Targets- Staging Area, Data Marts /Data Warehouses.
- Experienced in designing slowly changing dimensions and fact tables for data management pertaining to historical data.
- Experience in creating complex mappings using various transformations like filter, router, sorter, aggregator, joiner, lookup connected and unconnected , update strategy using Informatica Power Center Designer and processing tasks using Workflow Manager to move data from multiple sources into targets.
- Experience in implementing incremental loads and change data capture.
- Profound knowledge in implementing different types of Caches for Lookup's- Static , Dynamic and Persistent
- Implemented Performance Tuning Techniques on Mappings, Sessions and Targets.
- Implemented Pre-Session and Post-Session shell scripting to run workflows using pmcmd command.
- Experience in working with Tools- TOAD, SQL Developer and SQL Plus.
- Used various sources like Oracle10g, SQL Server2008, DB2, Flat files, and XML in creating reports.
- Good experience in writing UNIX Shell scripts, SQL Scripts for development, automation of ETL process, error handling, and auditing purposes. Experience in using Ctrl-m scheduling tool to organize and schedule jobs.
- Well experienced in doing Error Handling and Troubleshooting of invalid mappings using various log files.
- Excellent team player and self-starter with good ability to work independently and possess good analytical, problem solving and logical skills and ability to work independently and manage business expectations with a delivery-focused approach
Technical Skills:
ETL | Informatica 9x/8x |
Tools | Erwin, SQL Developer, Unix shell scripting, Toad, Putty, Tivoli, Ctrl-m |
EAI | JCAPS e Gate , e Xchange e Insight, SAP XI and MQ |
Languages | Java, C, PERL |
B2B protocols | EDIFACT, Rosettanet, X12 |
SAP technologies | IDOC, ALE BAPI |
J2EE Suite | Servlets, JDBC, JMS XML |
RDBMS | Oracle 11g/10g, MS SQL Server 2005/2000,MS Access |
Web Development | HTML, DHTML, Java Script |
XML technologies | XML, XSL |
Front end tools | VB 6.0 |
Operating Systems | Windows 95/NT/2000, UNIX |
PROFESSIONAL EXPERIENCE:
Confidential
Sr. ETL Developer
Responsibilities:
- Analyzed the business requirements and functional specifications.
- Designed the ETL Specifications Document Source to Target mapping document based on the requirements from Business Users.
- Implemented complex business rules by creating robust Mappings, Mapplets, Sessions, Workflows, and Worklets using Informatica PowerCenter.
- Created Informatica Mappings to build business rules to load data using transformations like expression, union, source qualifier, aggregator, router, joiner, lookup transformations.
- Implemented slowly changing dimensions SCD Type 1 2 mappings to update Slowly Changing Dimension Tables.
- Used Session parameters, Mapping variable/parameters and created Parameter files for imparting flexible runs of workflows based on changing variable values.
- Modified existing mappings for enhancements of new business requirements.
- Debugged the sessions by utilizing sessions log files and monitored workflows and collected the performance data.
- Made use of post session success and failure commands in the session task to execute scripts for cleanup and updates.
- Worked with Static and Persistent Cache in lookup transformation for better throughput of Sessions.
- Integrated heterogeneous data sources like Oracle, DB2, SQL Server and Flat Files Fixed delimited into Staging Area.
- Used pre-session and post-session variable assignment to transport variable values across sessions and worklets.
- Used Incremental Aggregation technique to load data into Aggregation tables for improved performance.
- Used SQL and PL/SQL to write Stored Procedures, Functions, Packages, Cursors, Triggers, Views, and Indexes in distributed environment.
- Used Informatica Debugger to test the mappings and fixed the bugs.
- Interacted with BA Functional users to resolve the open issues and defects. Prepared test data for system Integration testing.
- Identified and resolved performance bottlenecks in various levels like sources, targets, mappings and sessions.
- Tuned performance of Informatica session for large data files by increasing block size, data cache size, sequence buffer length and target based commit interval.
- Created shell scripts to dynamically generate the parameter files, and running workflows.
- Used PMCMD command to automate the Power Center sessions and workflows through UNIX.
- Involved in UAT along with users to understand the data and to make any modifications if suggested by the user.
- Provided production support in diagnosing session problems, fix mappings for minor business changes etc.
Environment: Informatica Power Center 9.1, Erwin, Oracle 10g/11g ,Flat files, TOAD, SQL, PL/SQL, Windows XP, Ctrl-m, HP Quality Center
Confidential
Informatica Developer
Responsibilities:
- Developed Mapping design documents per business requirements.
- Developed Informatica ETL mappings as per the business logic.
- Assisted in creating fact and dimension tables implementation in Star Schema model
- Extensively used many transformations Source Qualifier, Sorter, Normalizer, Joiner, Router, Update Strategy, Look Up, Union, Filter, etc.
- Designing and creation of complex mappings using SCD type II involving.
- Used Constraint Based loading target load ordering to efficiently load tables with PK-FK relation in the same mapping.
- Created post-session and pre-session shell scripts and mail-notifications and developed SQL Scripts to validate all mappings business functionality for unit testing
- Extensively used Mapping Variables Parameters, Workflow Variables and Session Parameters.
- Involved in Migrating the code from development to production environments.
- Involved in performance tuning of the Mappings, SQL statements, Query optimization for Optimum Performance and used Informatica Debugger
- Performed unit testing at various levels of the ETL and actively involved in team code reviews.
- Extensively used performance tuning techniques to tune ETL jobs and attended Daily production support calls
Environment: Informatica 8.1.1, DB2, Oracle 10g, SQL PL/SQL, TOAD, UNIX shell Scripts
Confidential
ETL Developer
Responsibilities:
- Designed and created logical/physical data model based on business requirements
- Worked on development of Informatica mappings and workflows to load the Participant and Position data, and Various Fixed value, Rate table, constants, and quota feeds to True comp targets
- Design and developed the transaction load process from different data sources SQL Server, Oracle, CSV, Excel into Truecomp Comp and Custom Stage tables
- Extensively worked on Transaction Assignment process for the transactions
- Extensively worked on assignment of various rule elements to Variables and comp plans.
- Involved in tuning of the SQL queries SQL Server , Oracle in order to increase the performance at both Informatica database level.
- Developed Batch scripts to kick off the Informatica batch load process , pre-processing and various modes of pipeline
- Developed various store procedures, functions and packages as per business need.
- Identified the bottleneck for slowly running workflows.
- Worked on performance improvement for sales data load and achieved the exceptional results by reduction of the load time from 65 minutes to 15 minutes.
- Developed various adhoc queries SQL Server, Oracle and reports for all start team on short notice.
- Involved in the data base recovery activities for production failures
- Performed various adhoc data loads using Informatica and SQL Loader.
Environment: Informatica PowerCenter 8.6, Cognos 7, Oracle 10g, SQL, PL/SQL Developer, UNIX.
Confidential
Integration Consultant
Responsibilities:
- Was responsible for identifying the components involved in the integration solution.
- Developed business logic for transformation of messages.
- Created the required JCAPS components for the solution.
- Prepared test plans carried out unit integration testing of the solution.
- Prepared documentation for the integration solution.
- Ensured timely deliverables solution, documentation knowledge transfer to AM team for maintenance.
Environment: JCAPS e Gate, Oracle, Java, MQ, JMS, SAP ALE IDOC , XML XSD