SUMMARY:

• IT Professional with 9+ years of experience in analysis, design, development, implementation and troubleshooting of Data Mart/Data Warehouse applications using ETL tools like Informatica PowerCenter 10.x/9.x/ 8.x/7.x/6.x.
• Skilled in Implementing and Delivering project using industry best practice and exposed to Software Development Methodologies like Software Development Life Cycle (SDLC).
• Experience in working with Business Users to understand and analyze project requirements and to co - ordinate work efforts with multiple teams.
• Expertise in using methodologies for data extraction, transformations and loading processing in corporate-wide ETL solutions using Informatica PowerCenter 10.x/9.x/ 8.x/7.x/6.x.on UNIX and Windows platform.
• Experience in Integration of various data feeds from sources like Oracle, SQL Server and Flat Files.
• Experience in Capturing data changes with the help of SCD Type 1 and Type 2 mappings.
• Extensive experience in all phases of Data Warehouse project life cycle.
• Proficient in development of ETL (Extract, Transform, and Load) processes with a good understanding of source to target data mapping, ability to define, capture Meta data and business rules.
• Experience in designing, developing, testing, and performance tuning and debugging of existing ETL processes.
• Good understanding of Dimensional Data Modeling using Star Schema, Snowflake modeling, FACT & Dimensions tables, Physical & logical data modeling.
• Knowledge about Kimball and Bill Inmon modeling approaches.
• Experience in Implementation of slowly changing dimensions methodology to keep track of historical data.
• Experience in implementing complex business rules by creating optimized and efficient mappings with appropriate transformations.
• Knowledge in creating database objects like procedures, views, packages, functions and triggers using PL/SQL.
• Proficient with TOAD 9.6.1, Oracle SQL Developer 2.1.1.64 & Win\Unix interface.
• Experience in creating the label and Migration of code to different environments.
• Experience in ETL implementation and Production Support .

TECHNICAL SKILLS:

Dimensional Data Modeling: Dimensional Data Modeling, Star Schema Modeling, Snowflake Modeling, FACT, Dimensions Tables, Physical and Logical Data Modeling, ERWIN

Data Warehousing: Informatica Power Center 9.1.0, 8.6.1/8.5/8.1, ETL, DataMart s, OLAP, OLTP

Databases: Oracle11g/10g/9i/8i, MS SQL Server

Scheduling Tools: AutoSys, Control M, TIDAL.

Others: Java, C, XML, UNIX Shell Scripting, SQL, PL/SQL, SQL*Plus, ODBC, Quest TOAD, Rapid SQL, BMC Remedy, JIRA, Confluence

PROFESSIONAL EXPERIENCE:

Confidential - Charlotte, NC

Sr. Informatica Developer/ Production Support

Roles & Responsibilities:

• Provide development and technical support for HR and Payroll applications (PeopleSoft).
• Extensively used various transformations like Union, Filter, Router, Sequence Generator, Look Ups, Update Strategy, Joiner, Source Qualifier, Expression, Sorter, and Aggregator.
• Captured data changes with the help of SCD Type 1 and Type 2 mappings and also utilized MD5 to accomplish Dimension, Facts and error record loading.
• Worked and Implemented slowly changing dimensions Type1 (Insert else Update), and Type2 (Insert only-saving history).
• Based on the error message from logs, review Informatica mappings and stored procedures to identify the reason for batch job failure and propose an appropriate solution.
• Extensively worked with Joiner transformation using the four types of joins-Normal Join, master outer join, detail outer join, and Full Outer join.
• Responsible for supporting multiple functional high availability business applications and business users.
• Troubleshoot production data issues and failures, manage critical incidents and bridge calls, automate repetitive tasks, problem analysis, maintain knowledge base and documentation, implement process improvement methods.
• Worked with Look Up transformation using both Connected and UN - connected options.
• Worked with various look up cache like Static Cache, Dynamic Cache, Persistent Cache, and Shared Cache.
• Extensively worked with aggregate functions like Avg, Min, Max, Count, First, and Last in the Aggregator Transformation.
• Used Filter transformation at the early stages of the mapping for the performance tuning of the mapping.
• Worked on performance issues by accessing both Informatica and Oracle logs to increase process efficiency.
• Coordinate with other technology groups to resolve incidents and problems, and escalates complex problems to the next level of support as required by documented procedures.
• Perform as incident manager to ensure resolution and follow up.
• Develop and gather metrics to assist in problem analysis and resolution, support efforts to improve system monitoring tools and processes to enhance service delivery and support model for the end users.
• Participate in problem analysis and incident management procedure meetings to enhance process improvements.
• Ensure timely communication to the impacted parties during an incident.
• Provide post-implementation and system checkout support for changes to production applications and services and provide information and updates to tasks and incidents in the appropriate systems and knowledge base tools.
• Respond to inquiries, requests for support or information, and escalations from Level 1 support or other technology and business users.
• Respond to production incidents and help resolve or escalate in a timely manner.

Environments: Informatica 10.x/9.x, Oracle 11g, UNIX, SQL, SQL Server, Rapid SQL, TOAD 8.6, Erwin

Confidential - Bensenville, IL

Sr. Informatica, ETL Developer

Roles & Responsibilities:

• Lead problem analysis and resolution for critical business applications and services, technology products.
• Create ETL mappings and database objects to load source data in to PINIA (Power Information Network Integrated Analytics) warehouse and PIN Explorer DataMart.
• Coordinate with source teams from ADVENT, CTSOFT, DATA CONSULTANTS, DEALER TRACK and REYNOLDS for any data inconsistencies, transfer/FTP issues.
• Write Adhoc SQL queries to generate data from tables based on requirements.
• Modify existing mappings and workflows to accommodate changes as suggested by business.
• Informatica transformations like lookup, Joiner, Update Strategy along with others were used for data processing.
• Develop resolutions for any data cleansing or code issues that could hinder the DSS efficiency.
• Create mappings/Mapplets, reusable transformations using all the transformations like Normalizer, lookup, filter, expression, stored procedure, aggregator, update strategy, Worklets etc.
• Used Metadata Manager and Data Analyzer to generate ETL run reports which were used to understand the process performance and overall job schedules.
• Create scheduling jobs using TIDAL scheduler to start data processing and to send success/failure notification alerts.
• Coordinate weekly QA and production release activities.
• Raise CCB tickets using e-help portal for data refresh and other maintenance requests.

Environment: Informatica 9.x, Oracle 10g, UNIX, Oracle 11g, SQL, TOAD 8.6, Erwin

Confidential - Columbus, OH

ETL Developer

Roles & Responsibilities:

• Worked on the maintenance and enhancements for VMware Entitlements related data mart.
• Coordinated monthly roadmap releases to push enhanced/new Informatica code to production.
• Developed and maintained ETL (Data Extraction, Transformation and Loading) mappings using Informatica Designer 8.6 to extract the data from multiple source systems that comprise databases like Oracle 10g, SQL Server 7.2, flat files to the Staging area, EDW and then to the Data Marts.
• Created mappings using different look-ups like connected, unconnected and Dynamic look-up with different caches such as persistent cache
• Performed Impact Analysis of the changes done to the existing mappings and provided the feedback
• Create mappings using reusable components like Worklets, Mapplets using other reusable transformations.
• Participated in providing the project estimates for development team efforts for the off shore as well as on-site.
• Coordinated and monitored the project progress to ensure the timely flow and complete delivery of the project
• Worked on Informatica Source Analyzer, Mapping Designer &Mapplets, and Transformations.

Environment: Informatica 9.x, Oracle 10g, UNIX, Oracle Data Integrator, Oracle 11g, SQL, TOAD 8.6, Erwin

Confidential - Chicago, IL

ETL Developer

Roles & Responsibilities:

• Design and develop Informatica mappings to address business requirements to bring in the SOR data in to the customer data ware house using flat files from different LOB’s.
• Developed mapping to bring in new attributes to existing data load, and to set up a completely new data feeds load.
• Managed application support along with off-shore technical team.
• Prepare and update SIA documents required for new and existing feeds.
• Coordinate and validate the upgrade of all CUSTDW database environments from Oracle 10g to 11g.
• Testing of database packages developed using PL/SQL.
• Develop and deploy AutoSys jil code to all environments.
• Work on the existing issues and any development efforts queued in the CUSTDW share point website.
• Maintain and manage share point site for CUSTDW
• Co-ordinate efforts for CUSTDW BCP Cassie Hill exit project, which include partner notifications and providing any technical solutions required for smooth transmission.
• Provide weekly status updates to both business and technical teams.
• Raise work requests/change requests to move Informatica, AutoSys code from lower environments to Production and BCP.
• Provide technical reports to manager on any Informatica related production runs using Data Analyzer.
• Notify and follow up with all the partners to use common domain names service for CUSTDW so that the failover and any other database changes are transparent and require less effort in the future.
• Coordinate and support annual BCP failover activity for CUSTDW production database.
• On-call support on any production failures and emergencies.

Environment: Informatica 9.x, Oracle 10g, UNIX, TOAD 8.6, Erwin, Pac 2000, AutoSys 4.5