SUMMARY

• 10 Years of Experience in Designing, Development, Administration & Implementation of Data Warehouse using Informatica 10.x/9.x/8.x as an ETL tool.
• Expert in Informatica Power Center, Informatica Data Quality and Informatica Intelligent Cloud Services (IICS).
• Extensively worked on Informatica tools Admin console, Repository manager, Designer, Workflow manager, Workflow monitor, Developer client and IICS.
• Expert Migrations, FTP requests, Installation of patches, hotfixes and upgrading the tool.
• Experience in integration of various data sources like Oracle, SQL Server, Flat files, Sales force and other API’s
• Expert in developing Logical Data Objects, Profiling them and building a scorecard for Analysis and cleaning the data.
• Extensive experience in implementing SCD types using Informatica Power Center 10.x/9.x/8.x.
• Expert in the analysis, design, coding and testing of the data analysis and warehouse build phase with Xenomorphic TimeScape Workbench 4.0.
• Experience in using SQL Server Integration Services (SSIS) and SQL Server Reporting Services (SSRS).
• Strong in Windows server and Linux Platforms.
• Used Schedulers like Tidal, Ctrl M, AppWorx and ESP Scheduler.

TECHNICAL SKILLS

Operating Systems: Window Server 2008/2003, IBM AIX 6.1, Red Hat Enterprise

ETL Tools: Informatica 10.x/9.x/8.x (Data Quality/Power Center), Informatica Power Exchange 9.x/8.x, Informatica Intelligent Cloud Services.

Programming Languages: SQL, PL/SQL

Relational Databases: Oracle 12c/11g/10g/9i MS SQL Server 2014/2012/2008/2005

Applications: Salesforce, ncino.

Cloud: Microsoft Azure, ICS, IICS

Reporting Tools: SAP BO, SSRS (SQL Reporting Services).

PROFESSIONAL EXPERIENCE

Confidential

Informatica Developer/Administrator

Responsibilities:

• Design new ETL Processes using Informatica Data quality.
• Designed Profiles and scorecards using Informatica IDQ.
• Worked on Informatica cloud for processing the data on API platforms like sales force, ncino.
• Upgraded Informatica (Power Center and Data Quality Services) from 8.6.1HF3 to 9.0.1/9.6.1 HF3 and later from 9.6.1 HF3 to 10.1.1 HF1
• Used Informatica client tools - Source Analyzer, Warehouse designer, Mapping Designer, Mapplet Designer, and Transformation Developer for defining Source & Target definitions and coded the process of data flow from source system to data warehouse.
• Used Tidal to schedule and monitor the Informatica jobs and their dependencies status as an On-Call Support.
• Created complex Informatica mappings and reusable objects based on the client requirements.
• Performed migrations using Import/Export, Folder to Folder copy and Deployment groups.
• As an Administrator, Performed routine maintenances like cleanups, purging objects, Domain and Repository backups.
• Maintained user roles and privileges using LDAP configuration and Active Directory.
• Used Informatica Data Quality Developer Client tool to perform Logical Data Object’s, Data Conversions and Data Cleansing operations.
• Used Informatica Analyst tool to create profiles and scorecards to analyze the data.
• Used techniques like source query tuning, single pass reading and caching lookups to achieve optimized performance in the existing sessions.
• Primary contact for all Informatica operations and questions.
• Exclusively Worked with SAP BO Reporting team.
• Worked on distribution, maintenance, and optimization of universes for Business Objects.

Environment: Informatica Power Center 10.1.1/9.6.1/8.6.1 , Developer Client, Analyst tool, IICS, Oracle 11g/10g, Windows 2008 R2, SQL Server 2008/2012/2014.

Confidential

Informatica Consultant

Responsibilities:

• AbbVie and Abbott Laboratories are sister companies. Since they got separated, our project is to migrate the AbbVie data from Abbott data warehouse.
• Upgraded Informatica (Power Center and Data Quality Services) from 9.0.1 to 9.1.0 in various environments.
• All the environments are built in UNIX platforms and used HA concept for server failovers.
• Worked on Domain and Repository Maintenance, Backups and Recovery Plans.
• Administer Informatica by creating user Logins with appropriate roles, granting and denying login privileges, monitor the user accounts, creation of groups, granting database and application roles to users and groups.
• Perform Tuning long running queries and slow running servers through SQL Profiler and Execution plans.
• Implemented performance tuning logic on Targets, Sources, mappings, sessions to provide maximum efficiency and performance.
• Schedule and maintain routine Jobs, Tasks, and Alerts using AppWorx.
• Assisted with scripting and monitoring interfaces between SQL and Oracle.
• Monitor SQL Error Logs/ Schedule tasks/data activity/ eliminate blocking and deadlocks/ user counts and connections/ locks.
• Used Informatica Data Validation and Data Virtualization to integrate data safely with the internal systems.
• Performing data analysis and gathered columns metadata of source systems for understanding requirement feasibility analysis and Data Quality solutions.
• Used Informatica Analyst tool to track and tune data flow performance, enrich and speed integration.
• Used Developer Client to minimize the risk of data quality problems proliferating throughout the organization.

Environment: Informatica 9.0, 9.1 HF1, Informatica data validation, Informatica data virtualization, Informatica Data Quality, UNIX, Oracle 10g/9i, SQL server 2012/2008/2005.

Confidential

Responsibilities:

• Administrating Informatica, by creating user logins with appropriate roles, granting and denying login privileges, monitor the user accounts, creation of groups, granting database and application roles to users and groups.
• Daily migrations through various environments (EDW, Transformation, Legacy & OBIEE) with export/import Technique using Deployment Group, based on requests raised by users.
• File transfers through FTP using various tools.
• Install of patches, hotfixes and upgrading the tool up to date in regular basis.
• Performing regular Administration activities from Managing system resources, users and database to the fine-tuning level and implemented successfully.
• Worked on Database Maintenance, Backups and Recovery Plans.
• Expertise in installation, configuration, performance tuning, and integration of various data sources like Oracle, MS SQL Server, Flat files into the staging area and Design ETL processes that span multiple projects.
• Implemented performance tuning logic on Targets, Sources, mappings, sessions to provide maximum efficiency and performance.
• Schedule and maintain routine Jobs, Tasks, and Alerts using Ctrl M.
• Assisted with scripting and monitoring interfaces between UNIX scripts and Oracle.
• Monitor Informatica session Logs/ Schedule tasks/data activity/ eliminate blocking and deadlocks/ user counts and connections/Intent locks.

Environment: Informatica PowerCenter 8.6.1/9.0.1/9.1.0 with hot fix3, Oracle 10g, ODBC 5.2., AIX 6.1., Ws-FTP 12.3., Putty 0.58., WinSCP 4.3.7., Password Safe Application 3.14.0.2123. , SQL server 2005/2008.

Confidential

Informatica Developer

Responsibilities:

• Imported all source and target definitions for particular Oracle Golden Gate environment.
• Took the parameters for Dataversion to filter the Admin Audit fact table.
• Compared the Admin Audit in two environments and took the difference using Changing data capture.
• Processed the Not Exists Flat File data for verification with Admin Audit.
• Processed the Flat File data for verification with Admin Audit (INPUT TABLE).
• Loaded from Source to Interim stage table (GOLD -> Staging Table).
• Loaded from Interim Table to Flat File.
• Took the parameters for delete and create a .csv file for Webservices.
• Webservices will update the destination environment with the changes captured in Gold.
• Extensively worked on Connected & Unconnected Lookups, Router, Expressions, Source Qualifier, Web Service, Update Strategy, Filter and Sequence Generator Transformations.
• Developed reusable transformations to load data from flat files and other data sources to the Data warehouse.
• Parameterized the connections in the session & workflows and used Scripts for pre & post sessions.
• Sent data from flat file's to Import tool and Webservices. Take the response and Update the Staging Table whether it’s Processed, Pending or Failed.
• Worked in Agile Methodology Environment with Daily Standup meetings for status Report.
• Administrated by creating user Logins with appropriate roles, granting and denying login privileges, monitor the user accounts, creation of groups.

Environment: Oracle 11g, Oracle Sql Developer, SQL Server 2008/2010, Informatica Power Center 8.6.1/9.1, Microsoft Visio, Putty, WinSCP.

Confidential

ETL Developer

Responsibilities:

• Responsible for the design of mapping and delivering the Business data (Bloomberg) for the data warehouse from existing data sources (Request Builder FTP Site).
• Created Database Architecture using the TimeScape WorkBench 4.0 and Microsoft Excel 2007.
• Separated the data flow into various categories according to the type of data.
• Connected TimeScape to SQL Server 2008 Database for Administration and Data View.
• Created Complex mappings with Task Definition File (TDF) using XTFileImporter (GUI) to import the Bloomberg files.
• ETL Informatica was used to minimize the size of the Bloomberg Files using SEI Holding’s (Geneva and InvestOne) for filtration.
• Scheduled using Batch files for the import process of daily .Dif’s in Development.
• Imported .OUT files once in a month to make sure Database is in Sync.
• Worked in Agile Methodology Environment with Daily Standup meetings for status Report.
• Assisted operation support team (CTS) for Bloomberg data loads in developing AppWorx Job schedules and Job failures.

Environment: Xenomorph TimeScape WorkBench 4.0, Informatica Power Center (8.6.1, 9.1), Microsoft Excel 2007/2010, Bloomberg Data License Request Builder 5.0.19, XTFileImporter (GUI), SQL Server 2008/2010, MetaFrame Presentation Server Client (Citrix), Windows Server 2003.