SUMMARY

• Extensive Experience in End to end Software Development Life Cycle (SDLC) including Requirement gathering analysis, Design, Development, Data Analysis and Production Support, testing of Data warehouse, Operational Data Store(ODS) and BusinessData marts
• Experience in Data Modeling (Star & Snowflake Schema and Logical data model & Physical data model) for large and complex data warehousing projects and also experience in leading development teams.
• Strong experience in the Administration, Implementation of Extraction, Transformation & Loading (ETL) Life Cycle using Informatica Power Center 9.x/8.x/7.x/10x
• Experience in Installation, Configuration, Upgrade Informatica Powercenter, Informatica Data Quality(IDQ) 8.x/9.x/10.1, Test Data Management TDM, Metadata Manager, DataArchival, Datavault FAS, Powercenter Power monitoring PMPC, Cloud REALTIME services
• Experience in installation and configuration of Powerexchange PWX services for mainframes, CDC, Salesforce, Webservices, facebook, twitter,linkedin
• Experience in installation and configuration of secure agent services for CLOUD integration
• Informatica MDM Installation, DataHub store Configuration, implementation
• Created and Maintained the Repositories using Power Center Web Based Administration Console. Used the Web Based Administration Console to manage of Data Sources distributed across the Network.
• Experience with Informatica Admin activities—Installation, Upgrade, Migration, Users accounts creation,security setup, folder creation, created source - target DB connections, repository, domain configuration, restarting of repository, integration services, Analyst, MRS,DIS,Search
• Experience in Oracle 12C/11g/10g/9i, DB2, SQL Server, Teradata, Teradata Utilities(FLOAD,MLOAD,TPUMP), NETEZZA
• Experience in working with SQL, PL/SQL programming, writing Stored Procedures, Functions, Triggers and Views onOracle, DB2, SQL Server, DB2,materializedviews
• Experience inPerformance TuningofInformatica code includesTargets, Sources, SQL overrides, Sessions, Mappings and Transformations
• Experience in UNIX commands and Shell scripting
• Worked on integrating data fromFlat fileslike fixedwidth /delimited, XML filesand COBOL files.
• Experience in data modeling tool such as Erwin 3.5,ER Studio 7.1, MS Visio
• Strong understanding of BI Software development life cycle (SDLC) methodologies including Waterfall and Agile scrum
• Expertise in job scheduling tools including Maestro, Control-M, Autosys GECS
• Strong experience in ETL and SQL performance tuning
• Involved in Data analysis and data profiling handled huge volume of source data
• Created and configured Migrated executed TDM jobs Project, Plan, profiles policies rules for DATAMASKING
• Created and configured executed Dataarchival FAS Jobs, retirement jobs, connections,entities
• Created loaded Resources Business glossaries and published Business glossary using Metadata Manager
• Expert proficiency in Microsoft Office Excel includes creation of Spreadsheets, workbooks, Macros, Pivots, Charts
• Exposure to ERP system as a source legacy systems including SAP, Oracle financials, JD Edwards, DB2 Mainframes, AS400
• Having knowledge of BigData Maps/Reduces, HIVE,scripting
• Knowledge of Informatica MDM Installation, Configuration, implementation
• Experience in Monitor, schedule jobs troubleshoot and resolve errors in Production
• Experience in conducting mock Disaster Recovery drills, Design and Build enterprise level High Availability, DR and Grid PowerCenter environments
• Self-motivated, quick learner, adaptive to new technologies, team player with good verbal and written communication skills and possess strong leadership qualities.

TECHNICAL SKILLS

ETL Tool: Informatica Power Center 6.2/7.1/8.6/9.5/9.6/10.1

Informatica: TDM 9.7.1, Informatica DVOMetadata Manager 10, PMPC

Informatica Power: Exchange PWX 9.6.1Informatica Dataquality IDQ 8.6/9.6

Informatica CLOUD: Realtime

Informatica: MDM

Informatica: Dataarchival, Datavault FAS

OLAP Tools: SAP BO XI R3

Data Modeling Tools: Erwin 3X/4X, ER Studio 7.1, MS-Visio 2007,Trillium DataDiscovery, Dataquality

Databases: Oracle 8i/9i/10g,Sybase ASE 12.0,Teradata 13/14Load Utilities(FastLoad,MultiLoad,BTEQ), Netezza

DB Interface Tool: Toad,Winsql,SQL plus, SQL/PLSQL Developer

Scheduling Tools: Maestro, Autosys, Control M,ESP, GECS

Programming Languages: SQL, PL/SQL, Knowledge of Java, Python, C#

Version Control Tools: Microsoft VSS, Sharepoint,Clearcase

Other Tools: Winscp, Putty

PROFESSIONAL EXPERIENCE

Confidential, NY

Informatica Admin

Responsibilities:

• Installed and configured Informatica test data management TDM for Datamasking, PMPC Rule RTM
• Upgraded Informatica 9.5.1 to 9.6.1 with HotFix2.
• Recently Upgraded Informatica 961 Hf2 to version 10 in Non prod, planning to rollout in production next month
• Installed and configured the CLOUD secure agents and registered on cloud
• Installed and configured MDM services data Hub store in sandbox environments, created configured base objects, queries, packages, hierarchies, configured the data flow
• Configured the ODBC, Oracle, MS SQL, Netezza, Rest API, PowerExchange for salesforce, TDM connections using ODBC and Native driver support in Non and production environments provided RX access permission to users and groups
• Create support cases with informatica technical support and Helped Development Support team resolved issues
• Involved in migrating deployment groups from Development to Testing to Production systems
• Involved in providing access to security groups in Native and LDAP domains
• Involved in Administration - creation of Folders, Users, User Groups, and giving privileges.
• Worked with DBA in order to do some performance tuning for ETL jobs/mappings.
• Performed Installations/Upgradation, Setup, Maintenance & Troubleshooting of Informatica Software on Linux and Oracle platform.
• Upgraded the Metadata manager MM services to version 10
• Upgraded ILM DataArchival, Datavault FAS to 6.4 HF2
• Created the Archival jobs and queries the DB schema offline using AQuadata
• Upgraded Powercenter, applied hotfixes/EBF, upgraded Metadata manager, loaded resources, upgrade ILM dataarchive and Datavault FAS
• Installed and configured Dataquality and dataquality services on premises and cloud
• Created TDM Projects, Plans,Rules, Policies. Generated workflows migrated the code from lower to higher environments in TDM
• Created Project filer shares, mounts, NFS, DFS
• Created resources in MM and loaded the metadata for Oracle,Erwin,BO,business glossary
• Involved in configuration of Informatica Powerexchange connections to source systems
• Installed the Powerexchange PWX plugin and configured connection for Salesforce
• Installed and configured secure agents servers for Informatica CLOUD in prod and non prod
• Created and configured useraccounts and groups connections in Cloud
• Configured OKTA sign sign on SSO to enable users to access cloud
• Created Groups, roles, privileges OS Profiles and assigned them to each user group both for Native and LDAP account.
• Setup and configured power center domain, grid, repository services and Integration service in oracle and Linux platform.
• Involved in creating different type of scripts (Back up, Clean up, Project set up, Monitoring) which decreases the manual effort and save the time of our resources.
• Migrated the code part of Deployment groups from DEV to stage and stage to prod
• Identifies performance bottlenecks and availability risks, manage action items to address and prevent issues, and influence peer organizations to implement improvements.
• Worked with Informatica vendor support raised tickets and resolved production issues
• Proactively monitor and apply required bug fixes, Hot Fix releases etc. on the existing Informatica environments
• Monitored and resolved Informatica repository domain backup jobs issues
• Created and configured file archival unix script job
• Installed and configured Informatica Metaquery support console SQL worksheet tool in Non and prod environments
• Created the ILM retirement jobs, archival jobs, defined entities in ILM IDV
• Created PMPC alerts rules to system resource utilization and jobs failures
• Created NTZ, Erwin, BO, Oracle, SQL, BG, XML resources in Metadata Manager
• Created Business glossaries Cataloges, Custom model, linked the resources ran the lineages liked the resouces in METADATA MANAGER
• Configure Netezza,oracle, RestAPI,web service, SALESFORCE, SERVICENOW, JDBC connections in CLOUD and realtime ICRT
• Configured runtimeenvironments, Discovery ID, DIS and Process engine, Bundles, Hierarchies, Schedules in Cloud
• Created configure user and usergroups, OKTA SAML in CLOUD
• Created PC, DSS, Data replication, Mapping configuration tasks, Migrated the tasks in CLOUD
• Created configured Rules, Alerts in PMPC rulespoint
• Created and configured testcases in DVO
• Created configured schema, Basedobjects,queries packages, Hierarchies,MDM Hubstore processes, application accesses, users groups, roles, Batch jobs in MDM
• Installed and configured IDQ services and Accelerator package
• Created DSS and mapping tasks in cloud to convert Json files to CSV file format
• Installed and configure powerexchnage listerner services to convert ASCII to ESCIDIC files format
• Accepted and resolved, within defined SLA metrics, operations application and data related help desk requests to meet or exceed IT support expectations.
• Monitored the scheduled jobs or run the workflows and scripts which need to run as per schedule.
• Prepared the month load closing status and Send the daily load status as per the client requirement.
• Gathering the month load preparation and Maintain a log files, screenshot, run statistics.
• Communicated with the clients and customers and attend the calls and provide the solution on time.
• Created and scheduled UNIX script for daily backups of the Informatica repository for production environment.
• Worked on Production Support and Root Cause Analysis documentation

Confidential

Informatica Admin

Responsibilities:

• Primarily responsible for Informatica Administration including managing domain, grids, nodes, services, folders, installing and applying patches/HotFixes, starting and stopping of Informatica server and services.
• Upgraded powercenter, applied hotfixes/EBF, upgraded Metadata manager, loaded resources, upgraded ILM dataarchive and DATAVAULT
• Installed and configured DATAQUALITY IDQ services applied incremental licenses
• Created configured DIS, MRS, CMS, Search, Human task, Profiles warehouse, ANALYST services in IDQ
• Installed and Configured POWEREXCHANGE(PWX )for webservices, Salesforce,DB2
• Tuned ETL processes inside and outside of the Informatica.
• Involved in migrating the repository objects from Development to Testing to Production systems
• Involved in Administration - creation of Folders, Users, User Groups, and giving privileges.
• Worked with DBA in order to do some performance tuning for ETL jobs/mappings.
• Performed Installations/Upgradation, Setup, Maintenance & Troubleshooting of Informatica Software on Linux and Oracle platform.
• Migrated the servers from physical machines data center to virtual data centers
• Migrated the application database connection to virtual data center
• Created the deployment groups and migrated the code from lower to higher environments
• Involved in configuration of Informatica Powerexchange PWX connections to source systems
• Created Groups, roles, privileges and assigned them to each user group both for Native and LDAP account.
• Setup and configured power center domain, grid, repository services and Integration service in oracle and Linux platform.
• Involved in creating different type of scripts (Back up, Clean up, Project set up, Monitoring) which decreases the manual effort and save the time of our resources.
• Identifies performance bottlenecks and availability risks, manage action items to address and prevent issues, and influence peer organizations to implement improvements.
• Worked with Informatica vendor support raised tickets and resolved production issues
• Proactively monitor and apply required bug fixes, Hot Fix releases etc. on the existing Informatica environments
• Installed configure IDQ content installer Accelerator packages
• Created IDQ mappings to standardardized phone numbers and addreses as per the client standards
• Monitored and resolved Informatica repository domain backup jobs issues
• Created and configured jobs scripts schedules in Control-M
• Migrated the CODE as part of release change management request from Non prod to prod
• Accepted and resolved, within defined SLA metrics, operations application and data related help desk requests to meet or exceed IT support expectations.
• Monitored the scheduled jobs or run the workflows and scripts which need to run as per schedule.
• Prepared the month load closing status and Send the daily load status as per the client requirement.
• Gathering the month load preparation and Maintain a log files, screenshot, run statistics.
• Communicated with the clients and customers and attend the calls and provide the solution on time.
• Created and scheduled UNIX script for daily backups of the Informatica repository for production environment.
• Worked on Production Support and Root Cause Analysis documentation

Confidential

Informatica Triilium Admin

Responsibilities:

• Primarily responsible for Informatica Administration including managing domain, grids, nodes, services, folders, installing and applying patches/HotFixes, starting and stopping of Informatica server and services.
• Installed and configured Trillium Datadiscovery and Dataquality on Windows servers
• Migrated the trillium datadiscovery and dataquality to Linux servers
• Created user and groups assigned permission to users in Informatica, trillium and Sharepoints servers
• Involved in migrating the repository objects from Development to Testing to Production systems
• Involved in Administration - creation of Folders, Users, User Groups, and giving privileges.
• Worked with DBA in order to do some performance tuning for ETL jobs/mappings.
• Involved in creating different type of scripts (Back up, Clean up, Project set up, Monitoring) which decreases the manual effort and save the time of our resources.
• Identifies performance bottlenecks and availability risks, manage action items to address and prevent issues, and influence peer organizations to implement improvements.
• Performed Installations/Upgradation, Setup, Maintenance & Troubleshooting of Informatica Software on Linux and Oracle platform.
• Involved in configuration of Informatica powerexchange connections to source systems
• Created Groups, roles, privileges OS profiles and assigned them to each user group both for Native and LDAP account synchronized the LDAP domain changes
• Setup and configured power center domain, grid, repository services and Integration service in oracle and Linux platform.
• Worked with Informatica vendor support raised tickets and resolved production issues
• Proactively monitor and apply required bug fixes, Hot Fix releases etc. on the existing Informatica environments
• Monitored and resolved Informatica repository domain backup jobs issues
• Participated in CR calls weekly and Created the change requests got approvals migrated the Deployment groups code from Non prod to prod environments
• Created symbolic links NFS share mount point in linux
• Accepted and resolved, within defined SLA metrics, operations application and data related help desk requests to meet or exceed IT support expectations.
• Created and scheduled UNIX script for daily backups of the Informatica repository for production environment.
• Worked on Production Support and Root Cause Analysis documentation
• Monitored the scheduled jobs or run the workflows and scripts which need to run as per schedule.
• Prepared the month load closing status and Send the daily load status as per the client requirement.
• Gathering the month load preparation and Maintain a log files, screenshot, run statistics.
• Communicated with the clients and customers and attend the calls and provide the solution on time.

Confidential, Dallas, Texas

ETL Admin

Responsibilities:

• Involved in installation & configuration ofInformaticaPowerCenter (Client, Server & Repository Server), PowereExchange connectors, Administration ofInformaticaPowerCenter servers in DEV, Stage and production environments
• Applied Hotfixes, EBF patches
• Involved in the release migrations code deployments.
• Provided oncall support during maintenance outages and server downtimes
• Coordinated with DBA teams and other vendor team to resolve the issues in production
• Created project folders configured,subfolders, users, groups assigned privileges to users and groups
• Configured users groups OS profiles assigned roles and priveleges over LDAP Native domains.
• Created configured relation DB connections resolved access issues in all environments
• Installed and configured Trillium Dataquality on Linux servers provided support for data profiling
• Configured jobs schedules, Involved in Production support activities include monitoring of ETL jobs scheduled on daily,weekly,quarterly,yearly basis
• Installed and configuredInformaticaSupport Console and Metaquery to proactively monitor the environment.
• Created configured powerexchange CDC mappings copybooks
• Extensively worked towards Analysis and Resolution of production job failures
• Migrated the code as part of release management CR request from lower to higher environments
• Loaded the data on monthly basis as part of Pipeline Client setup process to include newly enrolled customers
• Involved in Secondary oncall activities carry forward report updates, Aged reports resolutions, EDW cycle status updates
• Assisted in configuration, development and testing of AutoSys JIL and other scripts.
• Coordinated with the client management on a daily basis for issues and status update.
• Created and configured copybook within informatica powerexchange
• Extracted the data from DB2 legacy sytems in the form of flat files
• Coverted the flat file data from EBSIDIC to ASCII format
• Implemented the Informatica CDC logic to Process the delta data using Informatica PWX
• Extensively worked on flat files and involved in creation of UNIX shell scripts for FTP and in archiving the files after the completion of loads.
• Fine-tuned mappings with bottlenecks to improve the performance Maintained Document standards, processes and procedures relating to best practices, issues and resolutions
• Created Release notes, tickets and co-coordinated with Production teams admins, DBA’s to migrate the code.
• Ensure that all support requests are properly approved, documented, and communicated using the Remedy tool. Documenting common issues and resolution procedures.
• Held daily meetings with team members to resolve open issues to meet project plan deadlines.
• Redesigned existing mappings in the system to meet new functionality.

Confidential, Phoenix, AZ

Developer Analyst

Responsibilities:

• Worked with Informatica Data Quality 8.6.1 (IDQ) toolkit, Analysis, data cleansing, data matching, data conversion, exception handling, and reporting and monitoring capabilities of IDQ 8.6.1.
• Designed IDQ mappings which is used as Mapplets in Power center.
• Developed numerous mappings using the various transformations including Address Validator, Association, standardizer,labeler, Comparison, Consolidation, Match, Merge, Parser etc.
• Identified and eliminated duplicates in datasets through IDQ 8.6.1 and Mixed Field matcher
• Involved in Secondary oncall activities carry forward report updates, Aged reports resolutions, EDW cycle status updates
• Assisted in configuration, development and testing of AutoSys JIL and other scripts.
• Coordinated with the client management on a daily basis for issues and status update.
• Implemented the Informatica CDC logic to Process the delta data.
• Developed pre-session, post-session routines and batch execution routines using Informatica Server to run Informatica sessions
• Identifiedslowly changing dimensiontables and its impact to the overall Data Warehouse including changes to Source-Target mapping, transformation process, database, etc.
• Evaluated thelevel of granularity, Defined hierarchies
• Interpreted logical and physical data models for business users to determine common data definitions and establish referential integrity of the system using ER-Studio
• Extensively worked on flat files and involved in creation of UNIX shell scripts for FTP and in archiving the files after the completion of loads.
• Fine-tuned mappings with bottlenecks to improve the performance Maintained Document standards, processes and procedures relating to best practices, issues and resolutions
• Created Release notes, tickets and co-coordinated with Production teams admins, DBA’s to migrate the code.
• Held daily meetings with team members to resolve open issues to meet project plan deadlines.
• Redesigned existing mappings in the system to meet new functionality.

Confidential

Developer

Responsibilities:

• Involved in requirement analysis understanding
• Involved in Requirements gathering and Design documentation
• Actively involved in the meetings for data mapping and transformations with Business Analysts, data modelers, to come up with source to target mappings rules.
• Involved in Review of design and development of PAS Driver interfaces
• Involved in Design and Development of IBS and longview Drivers
• Involved in performance optimizations of long running PAD driver jobs
• Created, optimized, reviewed, and executedTeradata SQL test queriesto validate transformation rules used in source to target mappings/source views, and to verify data in target tables
• Modified underlying BTEQ queries jobs to in corporate new changes as part of change request and maintenance
• Developed pre-session, post-session routines and batch execution routines using Informatica Server to run Informatica sessions
• Designed and developed Informatica mappings and workflows, Identified and Removed Bottlenecks in order to improve the performance of mappings and workflows and usedDebuggerto test the mappings and fix the bugs
• Provided support for User acceptance testing phase to fix the defects
• Prepared Documentation including unit test case documents, Migration checklist, Release checklist as part of deployment process

Confidential

ETL Developer

Responsibilities:

• Prepared business flow diagrams and defind the workflows.
• Co-ordinated with Offshore teams and Involved in different Team review meetings
• Handled production support issues which involve ticket resolution, root cause analysis and fixes
• Created and executed SQL queries and scripts to validate data movement and generate expected results for UAT.
• Participated in daily standup meeting to discuss on project updates and deliverables.
• Conducted code walkthroughs and review peer code and documentation.
• Participated in Production support, scheduling and monitoring of reports.
• Helped business users for generating adhoc reports.
• Involved in troubleshooting of BO users requests to resolve the data discrepancy issues
• Administration of BO XI cluster servers,User account management.
• Involved in Performance optimization of BO servers
• Troubleshooting of data discrepancy issues for OLAP reports.
• Provided the permanent fix whenever the jobs get failed due to recurring issues.
• Analysis of Data related issues using Informatica, Monitoring of ETL jobs,Scheduling,ETL design changes.
• Resolved data discrepancy issues as reported by the business users

Confidential

Data Analyst

Responsibilities:

• Analysis of Functional Specifications,preparation of technical specifications documents.
• Performed Gap Analysis to check the compatibility of the existing system infrastructure with the new business requirements
• Defined the scope of the project based on the gathered business requirements including documentation of constraints, assumptions, business impacts, project risks and scope.
• Involved in ETL Development estimations for every task and sub task.
• Developed Mappings as per the design document with proper naming conventions for transformations and Mapping variables.
• Worked on Informatica Designer Components - Source Analyzer, Warehouse Designer, Transformation Developer, Mapplet and Mapping Designers
• Developing Tasks/Sessions and workflows as required with session variables.
• Performance optimization of Informatica workflows.
• Involved in Sql query tuning and ETL optimization process.
• Modified Oracle PL/SQL procedures for performance tuning addition of table structure and data elements
• Created and modified Informatica workflows and sessions
• Compared the data output of mapping results post migration with source data from source systems
• Involved in peer code review and preparation of code review checklist.
• Prepared migration checklist release documents as part of code release management