SUMMARY:

• 7 years of extensive professional experience in Information Technology with strong background in the areas of ETL Design and ETL development in Data Warehousing using Informatica PowerCenter.
• Extensively expertise in working with all major components of Informatica PowerCenter like Repository Manager, Designer, Workflow Manager, and Workflow Monitor.
• Proficiency in developing SQL and PLSQL scripts for relational databases like Oracle.
• Experience in Full Life Cycle development of Enterprise Data Warehouse.
• Experience in Data Integration, Data Migration and Data Warehouse projects using Informatica PowerCenter (10.1) end to end starting from accepting Business requirements, Data Analysis, preparing Data Model, created Functional and Technical Design documents, estimation, development, review and testing.
• Strong experience in developing ETL program for supporting Data Extraction, transformations and loading using Informatica Power Center
• Experience in Informatica Power Center (10.1) in creating complex mappings, sessions, workflows, reusable components in Designer, Workflow Manager using various transformations like SQL Transform, Source Qualifier, Unconnected and Connected Lookups, Router, Filter, Expression, Aggregator, Joiner, Update Strategy, Stored Procedure etc.,
• Experienced in coding SQL Queries (Analytic Functions, SQL joins, Nested Queries, Unions, Multi - table joins), PL/SQL, Procedures and Functions.
• Strong experience in performing Informatica objects migration from one environment to another environment. Development to TEST, UAT, PVS and Production using DevOps tools Jenkins and uDelopyment.
• Experienced writing UNIX shell scripts/commands and modifying the shell scripts as per the business requirements.
• Extensive experience in creating reports with BI Publisher integrated with OBIEE.
• Worked on Dimensional modeling in creating Star and Snowflake Schemas and created slowly changing (SCD) Type I/II/III dimension mappings.
• Strong knowledge in Extraction, Transformation and Loading of data from heterogeneous source systems like Oracle, Microsoft SQL Server, Teradata, Flat files.
• Understanding & Working knowledge of Informatica CDC (Change Data Capture).
• Extracted Data from multiple operational sources of loading staging area, Data Warehouse and data marts using CDC/ SCD (Type1/Type2/Type3) loads.
• Involved in Prod Support to research and resolve the daily load issues and trouble shoot them.
• Document the Prod job failures and provide the root cause analysis to the management.
• Strong knowledge in Informatica Administration including Installation, up-gradation, Configuration, maintenance and troubleshooting.
• Expensive experience in Production support process in loading data, monitoring the Batch jobs, tracking and resolving the incidents and provided solutions on time to the application users.
• Experienced in finding the root cause for Batch Job failures, reviewing Logs, raising the incidents, resolving the issues by coordinating with the respective teams.
• Experience in scheduling the batch jobs using Workflow Monitor.
• Good experience in performing/supporting Unit testing, System Integration Testing (SIT), UAT testing for all the Power Center and Developer objects.
• Hands on experience in identifying bottlenecks in various levels like Sources, mappings and sessions and tuning them. Hands on experience in optimizing SQL scripts and improving performance of databases.
• Functional knowledge of Oracle EBS 11i- R12 in Supply Chain (INV, PO, OM, WIP).
• Well experienced in coordinating different functional groups (DBAs, System Admins, Business teams, QA and Support teams) in providing the solutions for the issues/tickets raised on time.

TECHNICAL SKILLS:

ETL Tools: Informatica PowerCenter (10.1/9.x/8.x), Informatica Cloud Data Integrations.

Data Quality Tools: Informatica Data Quality 9.x

Databases: ORACLE 12c/11g/10g, MS SQL Server 2008/2012, DB2 9/10.x, Oracle Cloud API

Languages: SQL, PL/SQL, XML, UNIX Shell Scripting

Operating System: Windows, UNIX

BI Tools: Oracle OBIEE 11.1

Data Migration Tools: Tortoise Git Lab, Jenkins, uDelopyment

PROFESSIONAL EXPERIENCE:

Confidential, CT

EDW ETL Developer

Responsibilities:

• Co-ordinated with Business Analysts and source developer for performing data analysis and gathering business requirements.
• Developed technical specifications of the ETL process flow.
• Designed the Source - Target mappings and involved in designing the Selection Criteria document.
• Worked on design and development of Informatica mappings, workflows to load data into staging area, data warehouse and data marts in Oracle.
• Used Informatica Power Center to create mappings, sessions and workflows for populating the data into dimension, fact, and lookup tables simultaneously from different source systems (SQL server, Oracle, Oracle Cloud API, Teradata and Flat files).
• Created mappings using various Transformations like Source Qualifier, Aggregator, Expression, Filter, Router, HTTP, Joiner, Stored Procedure, Lookup, Update Strategy and Sequence Generator.
• Deployed reusable transformation objects such as mapplets to avoid duplication of metadata, reducing the development time.
• Used flag enable mappings to update the slowly changing dimensions to keep full history to the target database.
• Developed Json format data to parse from Oracle Cloud API to Oracle Raw (CLOB) tables.
• Worked extensively with variables and parameter files in the mapping and in the session to pass the value and to control the environment and source, target information.
• Developed recursive workflow execution using UNIX scripts and parameter files.
• Developed Informatica scripts to load historical data (Onetime) and delta loads on daily basis.
• Implemented sending of Post-Session Email once data is loaded.
• Implemented Data warehouse framework to back track the data load details.
• Created and Monitored Workflows using Workflow Manager and Workflow Monitor.
• Used Debugger to test the mappings and fixed the bugs.
• Tuned performance of mapping and sessions by optimizing source, target bottlenecks and implemented pipeline partitioning.
• Worked with DBA for partitioning and creating indexes on tables used in source qualifier queries.
• Involved in Performance/Query tuning. Generation/interpretation of explain plans and tuning SQL to improve performance.
• Performed End to End Informatica objects migration from Development environment to TEST, PVS, UAT and Production using Tortoise Git Lab, Jenkins and UDelopyment tools.
• Involved in exporting database, table spaces, and tables using Toad for Oracle.
• Developed Connect Direct scripts to move files from windows environment to UNIX environment.
• Knowledge of Cold/Hot backups and RMAN backups.
• Developed scripts for various daily and monthly ETL loads using ESP Job schedule tool.
• Developed UNIX wrapper shell scripts to run and schedule batch jobs on daily basis.
• Involved in unit testing and documentation of the ETL process.
• Involved in Production Support in resolving issues and bugs.

Environment: Informatica Power Center 10.1, Informatica Cloud Data Integration, SQL, PL/SQL, Microsoft SQL Server, UNIX, Teradata Studio, Oracle Cloud API, Toad for Oracle, GitLab, Jenkins and uDelopyment.

Confidential, NY

Informatica PowerCenter Developer

Responsibilities:

• Data gathering and analyzed the business requirements and functional specifications from client.
• Extracted data from oracle database, flat files and staged into a single place and applied business logic to load them in the central oracle database.
• Used Informatica Power Center 9.6 for extraction, transformation and load (ETL) of data in the data warehouse.
• Extensively used Transformations like Router, Aggregator, Normalizer, Joiner, Expression and Lookup, Update strategy and Sequence generator.
• Developed mappings in Informatica to load the data from various sources.
• Used Informatica Power Center Workflow manager to create sessions and workflows to run with the logic embedded in the mappings.
• Software installation/ upgrades
• Repository Backups
• Maintaining Nodes, Repository & Integration service.
• Maintenance of Database Connections.
• Single point of control for Migrations to Production Environment.
• Creating Informatica GRID and configure Informatica Integration Service to run on GRID.
• Creating labels and deployment groups.
• Working with Power Exchange Data maps
• Ensuring UNIX File System Directories are maintained
• Daily admin activities like creating and maintaining Informatica users and groups, Code migration at Informatica level, migration of UNIX scripts, handling Execution of Adhoc workflows, executing Adhoc shell scripts from UNIX, etc.
• Creating UNIX shell scripts for Server heath monitoring CPU utilization, Memory utilization and File system utilization on UNIX box.
• Handling Emergency tickets as well as Planned Change Management requests.
• Creating scripts which will do Repository maintenance by purging older versions of Informatica objects, deleting older logs and update stats to improve repository performance.
• Extensively working as On-Call contact for production outages.
• Extensively used Informatica debugger to figure out the problems in mapping.
• Created complex mappings for slowly changing dimensions.
• Experienced in resolving on-going maintenance issues and bug fixes; monitoring Informatica sessions as well as performance tuning of mappings and sessions.
• Created data models and configurations for Oracle BI reporting.
• Monitoring and maintenance of the workflows on daily basis as per the end user data availability.
• Created and modified several UNIX shell Scripts according to the changing needs of the project and client requirements.
• Written documentation to describe program development, logic, coding, testing, changes and corrections.

Environment: Informatica Power Center 9.x/10.x, Power Exchange 9.x/10.x, Informatica Data Quality, Informatica Cloud Data Integration, SQL, PL/SQL, Oracle SQL Developer, UNIX, Scheduling Tool - GE Service Now Ticketing Tool.

Confidential, NY

ETL Informatica Developer and Oracle SQL, PLSQL Developer

Responsibilities:

• Responsible to ensure that the goals of the business with regards to Data Migration and Data Integration are met.
• Software installation/ upgrades.
• Repository Backups, maintaining Nodes, Repository & Integration service.
• Maintenance of Database Connections and migrations to Production Environment.
• Creating Informatica GRID and configure Informatica Integration Service to run on GRID.
• Creating labels and deployment groups.
• Ensuring UNIX File System Directories are maintained
• Daily admin activities like creating and maintaining Informatica users and groups, Code migration at Informatica level, migration of UNIX scripts, handling Execution of Adhoc workflows, executing Adhoc shell scripts from UNIX, etc.
• Handling Emergency tickets as well as Planned Change Management requests.
• Creating scripts which will do Repository maintenance by purging older versions of Informatica objects, deleting older logs and update stats to improve repository performance.
• Creating Informatica Standards and Processes document for our team.
• Extensively working as On-Call contact for production outages.
• Designed and developed the logic to handle business logic and scenarios while moving data form source to target.
• Worked with DBA in making enhancements to physical database schema's, creating and managing tables, indexes, sequences, synonyms, triggers and privileges
• Used Informatica Designer and Workflow Manager to create complex mappings and sessions.
• Created various transformations like filter, router, lookups, stored procedure, joiner, update strategy, expressions and aggregator to pipeline data to Data Warehouse and monitored the Daily and Weekly Loads.
• Created Mappings, Mapplets, Sessions and Workflows with effective caching and logging using Informatica Power Center 8.6/9.1
• Involved in Fine tuning SQL overrides in Source Qualifier and Look-up SQL overrides for performance Enhancements.
• Created reusable Mapplets and transformations in Informatica.
• Developed UNIX shell scripts to pick up flat files from FTP server, covert it into generic names, matching the counts with the control files before loading files and send email on success/failure accordingly.
• Extensively used scheduler to run Informatica jobs.
• Developed/Modified mappings and sessions which meet the business requirements, and carried out Unit and System testing for functionality and effective performance.
• Worked with Memory cache for static and dynamic cache for the better throughput of sessions containing Rank, Lookup, Joiner, Sorter and Aggregator transformations.
• Worked with the DBA to improve Informatica session performance and query performance by collecting statistics and defining relevant indexes on target tables.
• Studied new features released by Informatica, educated the ETL team by sharing the knowledge.
• Performed impact assessments for major releases, Hotfixes and patches (as needed) for all Informatica products from a system perspective, planning and executing installations/upgrades following organizational standards (e.g. SLAs, audit trail, ability to rollback, etc.)
• Established and coordinated system backup/restore of required Informatica components.
• Coordinated prioritized support for all escalated activities.
• Maintained cross-business responsibilities by providing end-user support to multiple organizations within the company when issues arise.
• Understanding of Meta Data, Data Profiling & Data Quality needs on ETL and Data Warehouse processes.
• Assisted developers and aided production jobs.
• Migrated Informatica mappings and workflows to SIT, UAT environment and provided production support.

Environment: Informatica Power Center 9.1.0/9.6.1, Informatica MDM 10.1, Power Exchange 9.1.0/9.6.1, Informatica Data Quality, Informatica Information Lifecycle Management, Informatica Data Quality, Informatica Master Data Management, Oracle EBS Applications R12, Oracle SQL Developer 11i, UNIX, Toad

Confidential

Informatica Developer

Responsibilities:

• Understand the case and gather requirements from clarify requester.
• Created stored procedures and packages to effectively handle complex business logic. Effectively used exception handling to take care of erroneous scenarios.
• Experience in providing 24x7 Support.
• Performed installation/configuration of Informatica Power Center/ Power Exchange 9.1.0 to 9.5.1.
• Performed installation/configuration of Proactive Monitoring
• Performed code/design review for various projects
• Experience in Grids, nodes, Repository services and Integration services.
• Experience in Applying Informatica Latest Hot fixes/Patches.
• Extensive experience in Extraction, Transformation and Loading of data from different heterogeneous source systems like Flat files, Excel, XML, Oracle, SQL Server.
• Extensively worked on Informatica Designer Components - Source Analyzer, Warehouse Designer, Transformation Developer, Mapplet and Mapping Designer.
• Hands on experience with Complex mappings from varied transformation logics like Connected and Unconnected Lookups, Router, Aggregator, Joiner, Update Strategy etc.
• Extensively used Informatica Client Tools Repository Manager, Source Analyzer, Target Designer, Mapping Designer, Mapplet Designer, Workflow Manager and Workflow Monitor.
• Identified performance issues in existing sources, targets and mappings by analyzing the data flow, evaluating transformations and tuned accordingly for better performance.
• Coordinating with Informatica Support Team for resolution of certain critical Issues
• Worked with Nodes and implemented Failover.
• Created UNIX shell scripts for Server heath monitoring CPU utilization, Memory utilization and File system utilization on UNIX box.
• Worked with Versioned repositories.
• Created database Tables, Indexes, Views, Sequences in Development and Production environment using PL/SQL, SQL*Plus and Toad.
• Created PL/SQL stored procedures, function and packages for moving the data from staging area to data mart.
• Created indexes on the tables for faster retrieval of the data to enhance database performance.
• Involved in the Configuration of application setups for oracle purchasing and Inventory Item modules.
• Involved in Unit, Integration and System testing to validate the data.
• Responsible for Designing & creation of the Database object.
• Performed ETL changes to improve maintainability, data quality, best practices and performance.
• Executing the System Test Scripts based on business process of the client for the releases in Validation and System Testing.

Environment: Informatica Power Center 9.1.0/9.5.1, Oracle 11g, PL/SQL, Power Exchange 9.5.1, Proactive Monitoring Management Console, UNIX, Toad, HP Quality center.