SUMMARY

• Around 8 years of IT experience in Analysis, Design, Development, Implementation, Testing and Support of Data Warehousing using Informatica Power Center and Power Exchange.
• About 6 years of experience in Data Warehouse using Informatica PowerCenter (Repository Manager, Mapping Designer, Workflow Manager, Star & Snowflake Schemas, using ETL tool Informatica on Oracle, Teradata, SQL Server).
• Experience on Snowflake over AWS, Performance optimization for queries/tables, Snowflake Tasks, streams and stored procedures.
• Strong experience in installation/upgrade of Informatica and configuration of Informatica PowerCenter 10x / 9.5.1
• Working knowledge of Informatica Power Exchange to support Data Integration requirements.
• Extensively worked on transformations such as Source Qualifier, Joiner, Filter, Router, Expression, Lookup, Aggregator, Sorter, Normalizer, Update Strategy, Sequence Generator and Stored Procedure transformations.
• Extensively experience in developing Informatica Mappings / Mapplets using various Transformations for Extraction, Transformation and Loading of data from Multiple Sources to Data Warehouse and Creating Workflows with Worklets & Tasks and Scheduling the Workflows.
• Extensively involved in Informatica performance issue and Database performance issue.
• Expertise in error handling, debugging and problem fixing in Informatica.
• Experience working with SQL Server Integration Services (SSIS)
• Experience in using Oracle 10g/9i/8i, Teradata 13, MS SQL Server 2005, SQL, PL/SQL.
• Experience in building operational data stores (ODS), data marts, and enterprise data warehouses
• Worked with Dimensional Data warehouses in Star and Snowflake Schemas, Slowly changing dimensions and created slowly growing target mappings, Type1/2/3 dimension mappings.
• Proficient in transforming data from various sources (flat files, XML, Oracle) to Data warehouse using ETL tools.
• Experience in using loaders like SQL*LOADER, Fastload, Multiload, TPUMP to load Data from external files Database.
• Extensive experience in writing PL/SQL programming units like Triggers, Procedures, Functions and packages in Unix and windows environment.
• Exposure to on - shore and off-shore support activities
• Excellent verbal and communication skills, has clear understanding of business procedures and ability to work as an individual or as a part of a team.

TECHNICAL SKILLS

Operating System: UNIX, Linux, Windows Server 2008 R2

Development: PL/SQL, UNIX shell script

Tools: TOAD, Oracle SQL Developer, Visio, Tidal, Autosys

Databases: Oracle 11g/10g/9i/8i, Teradata 15/14/13, DB2, Snowflake, SQL Server

Reporting Tools: Business Objects, Tableau

ETL Tools: Informatica 10.x/9.x/8.x, SSIS

Methodologies: Kimball, STAR and snowflake, ER-modeling

PROFESSIONAL EXPERIENCE

Confidential, Richmond, VA

ETL Developer

Responsibilities:

• Analysis current state of EDW data and come up with Design and Integration of salesforce accounts, membership, contract, customer, events and opportunity data into Confidential EDW using Python replacing the ICS.
• Developed the Leads Datamart integrating the Leads, Events, Opportunities from salesforce and other Engaged activities like Sales, Appraisal, Credit from various Marts in EDW.
• Developed the logic using Customer Interactions to view the customer journey using Customer mart data from Reltio MDM.
• Collaborate with external auction vendors like Manheim and internal Confidential data analytics team on understanding the auctions data requirements and develop a process to integrate Sales, MMR pricing and online vehicle exchange (OVE) data by using REST API calls.
• Partner with Repairpal.com and integrated vehicle repair orders and claims data into Confidential EDW environment by using REST API calls and uploading JSON formatted data into Repairpal ESP claims API.
• Analysis and design the data integration of customer reviews from Qualtrics.com web survey for survey questions and answers with the formatting of horizontal and vertical table structures.
• Collaborate with Marketing team on understanding requirements and integrate Confidential customer email notifications data for number of online clicks
• Write/analyze functional requirements based on obtained business requirements and designed solutions to aligned with existing EDW target state.
• Implement data integration best practices and conventions, code review, design testing strategy and elaborate test data sets.
• Conversion of existing data marts stored procs from Teradata to Snowflake.
• Created BTEQ scripts for Teradata and used utilities Fast Load, Multiload, TPT updates.
• Optimizing queries for performance and tunned tables in Snowflake.
• Used Snowflake Tasks to schedule procedures and Streams to load data real time.
• Designing and implementing validation stored procedures for data loads
• Extraction of data from source like flat files, XML, JSON, SQL Server, Sybase and Teradata databases.
• Develop ICS mappings and mapping configuration tasks to integrate salesforce data into EDW system
• Created Informatica mappings, sessions, workflows and reusable components to process data from XML files and relational data.

Environment: Informatica (IICS), Snowflake, AWS S3, Informatica PowerCenter 10.1, REST API, Webservices, Teradata 15.0, SQL Server Service Now. Git and GitHub.

Confidential, Portland, OR

Informatica Developer

Responsibilities:

• Analysis, Design and document the ETL solution and mapping documents for processing of the Data Integration and POU mart in Finance DWH.
• Design, Implemented end to end DWH cycle for POU (point of Usage) mart which is also a source for downstream application, Oracle - Demantra (Demand planning tool).
• Development of Informatica mapping, workflows, and reusable components for maplets, worklets.
• Need to implement the Data Quality rules requested by business in the incoming transformation stages.
• Deployments of the jobs in various environments DEV, TUT, UAT
• Worked with Admin team for informatica upgrade from 8.6 / 9.1
• Unit testing and integration testing for all the developed jobs and Validate testing results and preparing the test results documents for SOX evidence.
• Responsible to develop the required shell scripts for input and output file and archival management.
• Performance tuning of mapping and also SQL queries used in stored procedures with explain plan and other pre and post SQL, SQL overrides.
• Designed and implemented a swap view procedure to make the fact available while loading, making it available to reporting layer.
• Implemented parallel execution using multiple instance execution.
• Develop scripts of data loading reconciliation stats and make them available in operational reports.
• Working with large tables with 60 million rows and DWH of size 20 TB.
• Extensively working with Tivoli job creation and scheduling and adding calendars according to the client requirement
• Conversion of existing EPM custom DataStage server jobs to Informatica mappings, workflows.
• Write/analyze functional requirements based on obtained business requirements and design ETL/DQ solutions aligned with informational architecture and data governance.
• Developed mapping that extracts data from sources like EPIC HCCL, McKesson, PeopleSoft and LDGL (DB2).
• Implement data integration best practices and conventions, code review, Design testing strategy and elaborate test data sets.
• Worked with Confirmed, Role playing dimensions, When Merging POU Fact with McKesson data.

Environment: Informatica 9.5/9.1/8.6, Power Exchange, IDQ 9.5, Teradata 14/13, Oracle 11g, DB2 8.4, IBM AIX UNIX, SQL Developer, SQL Assistant for TD, Cognos 10 report studio, Oracle Golden gate replication, ERWIN 7.0, IBM Tivoli, EPIC, McKesson.

Confidential

ETL Developer / Admin

Responsibilities:

• Create the mapping specification templates for extracting data for different Applications.
• Built jobs to Extract, Transform and Load data from and various databases using Informatica Power Center.
• Maintaining the Audit Repository database trimming, shrinking and backup
• User/project creation, user security management and LDAP sync.
• Applied hot fixes for informatica and involved in infrastructure upgrades for power center
• Created shell scripts to FTP the files from enterprise systems.
• Deployment groups creation and migration of workflows from lower to higher environments.
• Involved in admin tasks like analyzing Table Space requirement, load balancing and Performance
• Prepared test data for data driven tests for testing the application dynamically.
• Reviewed computer logs (UNIX logs & Shell Scripts), reported program-processing errors.
• Worked with testing team to understand the validation requirements to design mappings.
• Responsible for overseeing the Quality procedures related to the project and also unit testing
• Wrote the complex SQL queries to retrieve the data from different sources to validate.
• Designed and developed efficient Error Handling methods and implemented throughout the mappings.
• Amending the system as per faults founds or user requests.
• Developed database objects PL/SQL Packages, Procedures, and Functions.
• Used Informatica Tool to integrate Data from Legacy Data providers and third party vendors for the large volumes of data.
• Wrote UNIX shell scripts and ran as Pre-Session, Post-Session scripts.
• Developed Business Objects Universe, Reports for various Balance Scorecards, Reports for monthly, Quarterly, Yearly, Charts, Bar Graphs, Drill Down reports and Trend Reports.
• Used Autosys to schedule the jobs.
• Assisted in updating the logical model with all related entities, attributes and relationship with each entities based on the rules provided by the business manager using Erwin 4.0.

Environment: Informatica Power Center 8.x /7.1.3, Erwin 4.0, Windows 2000, Oracle 9i/10g, SQL Server 2000, PL/SQL, DB2, Flat file, TOAD, Sun OS Unix, Linux, Autosys, Business Objects XI.