Sr Etl Informatica Developer Resume
Chicago, IL
SUMMARY
- 7+ years of IT experience in Analysis, Design, Development, Implementation, Testing and Support of Data Warehousing and Data Integration Solutions using Informatica PowerCenter and OBIEE.
- Hands - on experience across all stages of Software Development Life Cycle (SDLC) including business requirement analysis, data mapping, build, unit testing, systems integration and user acceptance testing.
- Strong experience in integration of various data sources like Oracle 9i/10g/11g, Teradata, MS SQL Server 2005/2000, DB2, Mainframe and Flat Files
- Extensively worked on Relational and Dimensional Data modeling (Star / Snowflake models), FACT & Dimensions tables, Physical & logical data modeling, Ralph Kimball Methodologies, Slowly changing Dimensions, Data cleansing and Data Staging of operational sources using ETL processes for data warehouses.
- Have extensively worked in developing ETL program for supporting Data Extraction, transformations and loading using Informatica Power Center.
- Experience in implementing the complex business rules by creating transformations, re-usable transformations (Expression, Aggregator, Filter, Connected and Unconnected Lookup’s, Router, Rank, Joiner, Update Strategy etc) and developing complex Mapplets and Mappings.
- Experience on handling slowly changing dimensions to maintain complete history.
- Experience in Informatica workflows and sessions associated with the mappings using Workflow Manager.
- Perform review of Session log files to trace causes of bottlenecks.
- Extensively worked with Informatica performance tuning involving source level, target level and mapping level bottlenecks.
- Actively involved in Performance SQL Tuning, ETL tuning and Error handling.
- Experience in Developing mapping design documents for ETL process.
- Proficient in understanding business processes/requirements and translating them into technical requirements.
- Strong experience with Oracle, PL/SQL, Stored Procedures, Packages and Triggers.
- Experience using SQL* loader to load data from flat files to the database tables in Oracle.
- Seamlessly migrated the Code from Development to Testing, UAT and Production.
- Experience with various domain areas such as Retail, Insurance & Banking.
- Performed unit testing Confidential various levels of the ETL and actively involved in team code reviews.
- Created Drill down Hierarchies and implemented Business Logics and Facts.
- Implemented Siebel Analytics security Confidential the data and object levels.
- Developed reports/dashboards Analytic views (Pivot Tables, Charts, Column Selector, and View Selector).
- Designed Dashboards with links to websites, documents and embedded contents.
- Experience on job scheduling on multiple platforms, experience with UNIX command line and LINUX.
TECHNICAL SKILLS
ETL Tools: Informatica Power center 9.5/9.1/8.6.1 , OBIEE 11g/10g
Databases: Oracle 11g/10g/9i, Teradata
Scheduling Tools: TWS (Tivoli workflow scheduler), Autosys, Crontab
Data Modelling: ERWIN, Visio Standard
Programming Skills: Oracle SQL, PL/SQL
Scripting Languages: UNIX, Shell Scripting
SQL Tools: SQL*Plus, SQL*Loader, Export/Import, TOAD
Operating Systems: Windows XP/NT/2000/2003, AIX, UNIX, Linux and Sun Solaris
PROFESSIONAL EXPERIENCE
Confidential, Chicago, IL
Sr ETL Informatica Developer
Responsibilities:
- Worked on Informatica Power Center tools- Designer, Repository Manager, Workflow Manager, and Workflow Monitor.
- Parsed high-level design specification to simple ETL coding and mapping standards.
- Developed complex Informatica mappings to load the data from various sources using different transformations like source qualifier, Look up, expression, aggregator, joiner, filter, rank and router transformations etc.
- Involved in Dimensional modelling (Star Schema) of the Data warehouse and used Erwin to design the business process, grain, dimensions and measured facts
- Extracted data from DB2 and Oracle databases
- Used Type 1 SCD and Type 2 SCD mappings to update slowly Changing Dimension Tables.
- Modified existing mappings for enhancements of new business requirements.
- Worked on different tasks in Workflows like sessions, event raise, event wait, decision, e-mail, command, worklets, Assignment, Timer and scheduling of the workflow.
- Extensively used various Functions like LTRIM, RTRIM, ISNULL, ISDATE, TO DATE, Decode, Substr, Instr and IIF function.
- Developed several Maps and Mapplets using corresponding Source, Targets and Reusable Transformations.
- Responsible for Performance Tuning Confidential the Mapping Level and Session level.
- Extensively worked with both Connected and Unconnected Lookup Transformations with various lookup caches like Static Cache, Dynamic.
- Wrote the PL/SQL procedures for data extraction, transformation and loading.
- Load balancing of ETL processes, database performance tuning and capacity monitoring.
- Used UNIX to create Parameter files and for real time applications.
- Monitoring workflows in workflow monitor and providing batch support and fixing failures.
- Prepared Detail design documentation thoroughly for production support department to use as hand guide for future production runs before code gets migrated.
- Prepared Unit Test plan and efficient unit test documentation was created along with Unit test cases for the developed code.
- Worked on ProductionsupportL1 and L2, Onsite-offshore model and on call support.
- Created and maintained Users, Groups, Roles and Privileges.
- Repository Service Backup, Recovery and Migration between Dev, UAT and Prod environments.
- Extensively used SQL* loader to load data from flat files to the database tables in Oracle.
Environment: Informatica Power Center 9.1.0/9.5, Oracle 11g/10g, SQL, PL/SQL, Toad, Putty, UNIX, Shell scripting, AIX, Crontab, AR client (capacity planning), Erwin.
Confidential, Jersey City, NJ
ETL Informatica Developer
Responsibilities:
- Involved in design, development and maintenance of database for Data warehouse project.
- Involved in Business Users Meetings to understand their requirements.
- Converted business requirements into technical documents - BRD, explained business requirements in terms of technology to the developers.
- Developed ETL Mappings and Test plans.
- The Data flow diagrams ranged from OLTP systems to staging to Data warehouse.
- Developed Test plans to verify the logic of every Mapping in a Session. The test plans included counts verification, look up hits, transformation of each element of data, filters, and aggregation and target counts.
- Developed Re usable Transformations, and Re Usable Mapplets
- Developed Complex Informatica Mappings using various transformations- Source Qualifier, Normalizer, Filter, Connected Lookup, Unconnected Lookup, Update strategy, Router, Aggregator, Sequence Generator, Reusable sequence generator transformation.
- Extensively used SCD’s (Slowly Changing Dimension) to handle the Incremental Loading for Dimension tables, Fact tables.
- Data analysis is done to see the impacts of change in source system to the existing Informatica maps, Oracle PL/SQL packages to feed data into existing Datamart.
- Designed various Mappings for extracting data from various sources involving Flat files, Oracle and SQL Server.
- Worked on Debugging and Troubleshooting of the Informatica application. For debugging utilized Informatica debugger.
- Worked on Performance Tuning to optimize the Session performance by utilizing, Partitioning, Push down optimization, pre and post stored procedures to drop and build constraints.
- Created UNIX Script for ETL jobs, session log cleanup and dynamic parameter.
- Created and scheduled Sessions, Jobs based on demand, run on time and run only once
- Monitored Workflows and Sessions using Workflow Monitor and Scheduler alert editor.
- Performed Unit testing, Integration testing and System testing of Informatica mappings.
Environment: InformaticaPowerCenter9.5/9.1, Oracle11g, Oracle Exadata, MS SQL Server 2008 R2, Erwin 8, SQL Server 2008, TOAD, PL/SQL Developer, Linux, UNIX, Shell Scripting, AIX, Putty, OBIEE 11g.
Confidential
ETL Developer
Responsibilities:
- Used Informatica Client tools like Designer, Workflow Manager, Workflow Monitor, and Repository Manager.
- Worked on Data Extraction, Data Transformations, Data Loading, Data Conversions and Data Analysis
- Used Informatica Workflow Manager for creating, running the Workflows and Sessions.
- Experience in Performance tuning and Optimization of Cache with Informatica and OBIEE.
- Experience in Development and maintenance of Informatica Repository and OBIEE repository.
- Worked on different transformations like Filter, Aggregator, Expression, Router, Lookup, Update Strategy, Sequence Generator, Rank, Union, Joiner, Source Qualifier etc.
- Developed number of Informatica Mappings, Mapplets and Reusable Transformations for loading of data.
- Performed logical & physical database design of the staging and the data warehouse databases using Erwin and Oracle.
- Formulated the business rules for changes identified in the analysis and modified Informatica maps, PL/SQL packages and Autosys flow to handle the load time of each regular cycle run.
- Used Informatica Workflow Manager for creating, running the Workflows and Sessions.
- Designed and developed the OBIEE Repository(.rpd) using OBIEE Admin tool by importing the required database objects both facts and dimensions with integrity constraints into physical layer using connection pool.
- Created Pre-session and Post-session UNIX scripts and scripts to drop and recreate Indexes
- Created business facts, dimensions and defined logical relation between them Confidential the business model and mapping layer.
- Worked on Initialization blocks and variables development to achieve security.
- According to the Dashboard Mockup, identifying the required measures and attributes and sending the required dimensions and measures to the business team.
- Created OBIEE reports, filters and prompts and developing new dashboards according to the mockup.
- Created Catalog Groups and users and set permissions for items in the presentation catalog and privileges and rights to users and groups.
- Involved in testing of the reports.
- Checking the OBIEE incident tickets in remedy tool and troubleshoot issues based on severity of the issue.
- Handling the change requests.
Environment: Informatica PowerCenter 8.5, Oracle10g, PL/SQL, OBIEE 10g, UNIX, Shell Scripting, Toad, Putty, Remedy, Control-M, Erwin, Winscp, AIX, PLSQL Developer.
Confidential
ETL Informatica Developer
Responsibilities:
- Involved in design, development and maintenance of database for Data warehouse.
- Used Informatica Designer Tool to develop mappings for Extracting, Transforming and Loading required data into data ware house.
- Extracting data from heterogeneous sources and loading into the staging table.
- Worked on Informatica Power Center tools - Source Analyzer, Warehouse Designer, Mapping Designer, Workflow Manager, Mapplets, and Reusable Transformations.
- Responsible for developing Informatica mappings & Mapplets to load data into the data warehouse.
- Data analysis to understand the business logic and design new oracle database accordingly
- Developed complex PL/SQL packages, procedures, Functions, Triggers, Dynamic SQL and Packages to process data and perform validations and calculations on data loaded in an application database.
- Involved in developing logical and physical data models that capture current state/future state data elements and data flows using Erwin.
- Performed data manipulations using various Informatica Transformations like Filter, Expression, Lookup (Connected and Un-Connected), Aggregate, Update Strategy, Joiner, Router, Sorter etc.
- Preparation of mapping specification documents for Informatica mapping.
- Worked with SQL Override in the Source Qualifier and Lookup transformation.
- Checked and tuned the performance of Informatica Mappings.
- Developed Informatica workflows and sessions associated with the mappings using Workflow Manager.
- Created and scheduled UNIX scripts to control the ETL processes
- Production Support has been done to resolve the ongoing issues and troubleshoot the problems.
- Monitored Workflows and Sessions using Workflow Monitor.
- Performed Unit testing, Integration testing of Informatica mappings.
- Effectively used Informatica parameter files for defining mapping variables, workflow variables, FTP connections and relational connections.
- Effectively used Informatica parameter files for defining mapping variables, workflow variables, FTP connections and relational connections.
- Setup folders, groups, users, and permissions and performed Repository administration using Repository Manager.
Environment: Informatica Power Center 8. 1, Oracle10g, PL/SQL, Erwin, Toad, Putty, UNIX, Shell scripting.
Confidential
ETL Informatica Developer
Responsibilities:
- Used Informatica Designer Tool to develop mappings for Extract, Transform and Load required data into data Mart.
- Extensively used ETL to load data from Flat Files, Oracle.
- Preparation of mapping specification documents for Informatica mapping.
- Created complex mappings which involved Slowly Changing Dimensions, implementation of Business Logic and capturing the deleted records in the source systems.
- Identified and created different source definitions to extract data from input sources and load into relational tables using Informatica Power Center.
- Created complex PL/SQL procedures, cursors, functions, packages, PL/SQL tables and triggers
- Created reusable worklets, Mapplets and transformations.
- Worked extensively on different types of transformations like source qualifier, expression, filter, aggregator, rank, update strategy, lookup, stored procedure, sequence generator, joiner etc.
- Developed data Mappings between source systems and warehouse components using Mapping Designer.
- Checked and tuned the performance of Informatica Mappings.
- Involved in the performance tuning of Database and Informatica mappings and stored procedures and the SQL queries inside the source qualifier.
- Involved in Unit Testing of mappings.
- Involved in Requirement Gathering and Business Analysis
- Developed data Mappings between source systems and warehouse components using Mapping Designer
- Setup folders, groups, users, and permissions and performed Repository administration using Repository Manager.
- Created, launched & scheduled sessions.
Environment: Informatica Power Center 8. 1, Oracle10g, PL/SQL, Toad, Putty, UNIX, Shell scripting, Autosys
Confidential
Application Programmer
Responsibilities:
- Involved in L1, L2 support for Oracle Applications.
- Involved in supporting and maintaining Unix shell script jobs
- Involved in Mailbox, UNIX Batch Jobs and Remedy Incident Tool monitoring and trouble shooting.
- Coded Oracle SQL to create ad-hoc reports on an as-needed basis
- Verify batch results in Autosys, log files.
- Record batch results as per standard procedures.
- Create remedy tickets in case of batch failures and assign to incident managers for resolution
- Have gained knowledge in the application
- Year End Activities - special processing such as Calendar updates, etc.
- Monthly manual run of customer statements to be sent out by mail
- Provide data fixes for known incidents (for online and batch)
- Provide clarifications to users on training issues for known issues
Environment: Informatica Power Center, Oracle 9i, PL/SQL, Toad, Putty, Remedy, UNIX, Shell scripting, Autosys.