We provide IT Staff Augmentation Services!

Senior Informatica Power Center Lead Resume

Oak Brook Terrace, IL

SUMMARY:

  • About 10+ years of Information Technology Experience in Data Warehouse using Informatica PowerCenter 9.x, 10.x .
  • 4+ years of experience on Informatica PowerExchange 10.x
  • 4+ years of experience as Informatica Admin experience on 9.6.1 and 10.2.
  • 1+ year of experience on IICS ( Informatica intelligent cloud services ) data integration with sales force.
  • Good experience in Full Life Cycle Implementation of applications on multi - platforms.
  • Data Processing experience in designing and implementing Data Mart applications using ETL tool, developed ETL mapping/mapplet, transformation & workflows.
  • Strong Knowledge on E-R modeling and Dimensional Data Modeling Methodologies like Star Schema and Snowflake Schema used in relational, dimensional.
  • Experience in using heterogeneous sources like flat files, XML, Oracle, SQL Server, and Teradata.
  • Developed Complex mappings from various transformation logic like Unconnected /Connected lookups, Router, Filter, Expression, Aggregator, Normalizer, Joiner, Union, and Update Strategy.
  • Experienced in configuring Nodes and Repositories in Informatica Power Center Designer, Workflow Manager, Workflow Monitor and Repository Manager.
  • Experience in implementing SCD (Slowly Changing Dimension) Type 1, Type 2, and Type 3.
  • Conducted System, UAT and Functionality testing and investigated software bugs.
  • Extensive experience in conducting Requirement-gathering sessions, writing Business Requirement Document, Functional Requirement Document.
  • Working experience using SQL, PL/SQL, Import/Export utilities.
  • Worked with Oracle Stored Procedures, Triggers, Indexes, DML, DDL, Database Links, Sequences and UNIX shell scripts used in scheduling Informatica pre/post session operations.
  • Scheduled the batch jobs; deployment of objects between environments.
  • Created and maintained Informatica users (including LDAP configuration) and privileges.
  • Manage code synchronization across all development, QA and production environments
  • Managing the DEV/QA/UAT/PROD environments with High Availability
  • Deploying the code between environments.
  • Advanced analytical and problem-solving ability, Good organizational skills, Hardworking, Team player and self-starter, capable of working independently and motivating a team of professionals.

TECHNICAL SKILLS:

ETL TOOLS: Informatica PowerCenter 9.x and 10.2

Informatica PowerCenter Administration Console: Informatica PowerExchange 9.x and 10.2, Informatica Intelligent Cloud Services (DI)

LANGUAGES: SQL, C, C++, JAVA, Python

OS: UNIX, WINDOWS.

DATABASE: ORACLE, SQL SERVER, TERADATA, MS-ACCESS, DB2

REPORTING TOOLS: Trained in COGNOS, AND BUSINESS OBJECTS.

MDM: Trained in Informatica MDM

SCRIPTS: UNIX shell, Python (Pandas)

DEVELOPMENT TOOLS: SQL * PLUS, SQL DEVELOPER, HP ALM, Rapid SQL, Version-one

SCHEDULING TOOLS: CAWA, DAC, ZENA & AUTOSYS

PROFESSIONAL EXPERIENCE:

Confidential, Oak brook Terrace, IL

Senior Informatica Power Center Lead

Responsibilities:

  • Worked with business analysts to clarify requirements and translate the requirement into technical specifications. Involved in business analysis and technical design sessions with business and technical staff to develop requirements documents, and ETL specifications.
  • Good experience in communicating with offshore teams and helped the team in analyzing the data to identify the data quality issues.
  • Created Dimensions and Fact tables for the data mart and implemented SCD (Slowly Changing Dimensions) Type I and II for data load.
  • Extraction, Transformation and Load was performed using Informatica Power Center to build Data warehouse. Worked on Informatica PowerCenter tools like Source Analyzer, Warehouse Designer, Mapping Designer, Mapplets and Transformation Developer.
  • Developed standard and re-usable mappings, mapplets using various transformations like expression, aggregator, joiner, source qualifier, lookup, and Router. Also, developed mappings using parameters and variables.
  • Developed complex mappings in Informatica Power Center to load the data from various sources using different transformations like Source Qualifier, Look up (connected and unconnected), Expression, Aggregate, Update Strategy, Joiner, Filter and Router.
  • Designed and documented design document, LLD, UTC, UTR, validation rules, error handling and test strategy of ETL process.
  • Created mappings, complex workflows with multiple sessions, worklets with consecutive/concurrent sessions for loading fact and dimension tables into data mart presentation layer.
  • Used Workflow Manager for creating, validating, testing and running sequential and concurrent batches. Migration of the object between environments.
  • Implemented source and target-based partitioning for existing workflows in production to improve performance to cut back the running time.
  • Analyzed workflow, session, event and error logs for troubleshooting Informatica ETL process.
  • Worked with Informatica Debugger to debug the mappings in Informatica Designer.
  • Involved in creating test plans, test cases to unit test Informatica mappings, sessions and workflows.
  • Used Informatica power exchange CDC for oracle real time and batch modes.
  • Configured PowerExchange in conjunction with PC to capture CDC for oracle using logger (log miner).
  • IICS Data integration experience on Sales force integration (extracting and loading to SF).
  • Experience on IICS tasks like Synchronization, Replication, Data masking tasks, PC task, and mapping tasks.
  • Experience on IICS assets like File listener, Saved Query, Intelligent structure model for JSON.
  • Experience on IICS transformations like Lookup, joiner, source, target, aggregator, expression (macros), transaction control and filter..etc.

Environment: Informatica Power center and PowerExchange 10.2, IICS DI, MS SQL SERVER, ORACLE, UNIX scripting, Sales Force

Confidential, McLean, VA

Senior Informatica Power Center Developer/Lead

Responsibilities:

  • Designed and created source to target mappings for ETL processes using various transformations
  • Used Informatica Power Center for migrating data from various OLTP databases to the DataMart.
  • Extracted data from various source systems like Oracle, SQL Server, XML and flat files and loaded into relational data warehouse and flat files.
  • Done the analysis from PL/SQL code like procedures, packages and records.
  • Involved in creating data mapping specifications.
  • Translated Business Requirements into Informatica mappings to build Data Warehouse by using Informatica Designer, which populated the data into the target Star Schema
  • Created various Informatica mappings and mapplets to load the data mart. The mappings involved extensive use of transformations like Aggregator, Filter, Router, Expression, Joiner, Sequence generator.
  • Implemented restart ability, precheck, duplicate file check, post balancing check, empty file check to improve data quality and Integrity between the systems.

Environment: Informatica Power center 9.x, DB2, AUTOSYS, UNIX scripting, Version one & HP ALM, doors.

Confidential, McLean, VA

Senior Informatica Power Center Developer/Lead, Informatica Administrator

Responsibilities:

  • Source File validations had been handled in multiple shell scripts.
  • Developed complex mappings in Informatica Power Center to load the data from various sources using different transformations like Source Qualifier, Look up (connected and unconnected), Expression, Aggregate, Update Strategy, Joiner, Filter and Router.
  • Designed and documented design document, LLD, UTC, UTR, validation rules, error handling and test strategy of ETL process.
  • Created mappings, complex workflows with multiple sessions, worklets with consecutive/concurrent sessions for loading fact and dimension tables into data mart presentation layer.
  • Conducted performance tuning of Informatica components for daily and monthly incremental loading tables. Used Timer, Event Raise, Event Wait, Decisions, and Email tasks in Informatica Workflow Manager.
  • Used Workflow Manager for creating, validating, testing and running sequential and concurrent batches. Migration of the object between environments.
  • Implemented source and target-based partitioning for existing workflows in production to improve performance to cut back the running time.
  • Analyzed workflow, session, event and error logs for troubleshooting Informatica ETL process.
  • Senior level Informatica Admin with extensive experience in Informatica PowerCenter, Installation and configuration of Informatica Power Center
  • Manage new installations, hot fixes, configuration, and troubleshooting of Informatica platform including hardware, and software
  • Plan, test, and execute upgrades involving Informatica components; Assure Informatica platform stability and security
  • Design, document, and implement administration producers, security model, backup, and fail over / recovery operations for Informatica platform
  • OS Level statistical monitoring and performance tuning
  • Managing the DEV/QA/UAT/PROD environments with High Availability
  • Provide troubleshooting and diagnostic support. Incident, problem and service outage management
  • Purging the old versions of the Informatica objects.

Environment: Informatica Power center 9.x, DB2, AUTOSYS, UNIX scripting, Version one & HP ALM

Confidential, Fremont, CA

Senior Informatica Developer, Informatica Administrator

Responsibilities:

  • Worked on performance tuning of Informatica components for daily and monthly incremental loading tables. Used Timer, Event Raise, Event Wait, Decisions, and Email tasks in Informatica Workflow Manager.
  • Used Workflow Manager for creating, validating, testing and running sequential and concurrent batches. Migration of the object between environments.
  • Analyzed workflow, session, event and error logs for troubleshooting Informatica ETL process.
  • Worked with Informatica Debugger to debug the mappings in Informatica Designer.
  • Involved in creating test plans, test cases to unit test Informatica mappings, sessions and workflows.
  • Extensively worked with Informatica Power Center to load data from flat files, oracle and other source systems into target databases.
  • Created checklists for coding, reviewing, bug logging, troubleshooting, testing and release for smooth functioning of the entire project.
  • Scheduling the sessions to extract, transform and load data into a warehouse database on Business requirements.
  • Implemented Error handling logic to capture Invalid/Null records coming from staging tables.
  • Created test plans for unit testing, integration testing and UAT.
  • Developed SQL Scripts and ad-hoc queries for data verification and validation processes.
  • Managed QA and PROD deployments and automation of ETL Jobs.
  • Aided in diagnosing production problems related to the project.

Environment: Informatica Power center 9.6, oracle, AUTOSYS Scheduling Tool, UNIX, JIRA

Confidential, Branchville, NJ

Informatica Dev Lead, Informatica Administrator

Responsibilities:

  • Analyzed and Resolved issues in Extraction, Transformation and Loading (ETL) Processes, especially in transformation and mapping development.
  • Responsible for the life-cycle development, implementation, deployment, quality assurance & operational integrity of multiple production projects and environments that support key business areas.
  • Manage the Informatica and Oracle data transformation environments and processes including development, quality assurance, and production.
  • Identify process/procedure/control improvements and implement when/where appropriate. Ensure project testing and development quality assurance meets approved standards. Maintain and foster effective relationships with staff, clients, developers and others.
  • Responsible for POC and time estimation for other technology projects, and Production support for Informatica tools. Used to take care of performance and connectivity issues.
  • Analyzed source database, designed mapping (using various transformations like Update Strategy, Look Up, Stored Procedure, Router, Filter, Sequence Generator, Joiner, Aggregate and Expression) to transform and load data on target databases (SQL Server) using Informatica PowerCenter (ETL Tool).
  • Development of UNIX shell scripts for job scheduling and Informatica pre and post mapping session processes.
  • Development of Informatica mappings to load data to various Dimensions, FACTS, Aggregate FACT and other tables.
  • Worked with create PowerExchange CDC for MS SQL SERVER in conjunction with PC.
  • Remote logging of data for powerexchange oracle CDC.
  • Informatica High-Availability/redundant configurations
  • Strong experience in administration and support of Informatica PowerCenter, Web services, Data Quality and PowerExchange-CDC in a Unix or Linux environment
  • Experience in Architecture Assessment, Capacity Planning, System Architecture Design for High Availability and Load Balancing/Grid Configuration of Informatica
  • Experience in administration of Informatica Developer, Informatica Data Analyzer and Web services
  • Understanding of change control management and production support processes
  • Able to prepare implementation and contingency plan for supported applications

Environment: Informatica Power center 9.x, MS SQL SERVER 14, ZENA scheduling Tool, Windows, COGNOS

Confidential, Chicago, IL

Sr. Informatica Developer/Prod Support Lead , Admin

Responsibilities:

  • Production support - Daily monitoring the jobs
  • Supporting the daily, weekly and monthly loads and addressing any failures or manual loads of files.
  • Created run documents, standard operating procedures for genuine errors/failures or steps to be taken care.
  • Analyzed the bugs or new requirements or enhancements with the business and functional requirements and provided high level technical design specifications to drive ETL Development efforts.
  • Involved in finding the impact analysis of the enhancements and documented all the impacts and creating efforts.
  • Designed ETL specification documents to load the data in target using various transformations according to the business requirements.
  • Extensively worked with Informatica Power Center to load data from flat files, oracle and other source systems into target databases.
  • Designed and developed Complex Informatica mappings using various transformations like Source Qualifier, Expression, Lookup, Aggregator, Update Strategy, Joiner, and Rank for populating target tables/Files in an efficient manner.
  • Designed and developed ETL workflows with job dependencies and scheduling, participated in code reviews of ETL processes.
  • Created checklists for coding, reviewing, bug logging, troubleshooting, testing and release for smooth functioning of the entire project.
  • Created and Configured Workflows, Worklets, and Sessions to load the data to target warehouse Oracle tables using Informatica Workflow Manager.
  • Supported the Unix scripting and log analysis.
  • Scheduling the sessions to extract, transform and load data into a warehouse database on Business requirements.
  • Implemented Error handling logic to capture Invalid/Null records coming from staging tables.
  • Created test plans for unit testing, integration testing and UAT.
  • Developed SQL Scripts and ad-hoc queries for data verification and validation processes.
  • Managed QA and PROD deployments and automation of ETL Jobs.
  • Aided in diagnosing production problems related to the project.
  • Enabling powerexchange listener service from Informatica admin console.
  • Senior level Informatica Admin with extensive experience in Informatica PowerCenter, Installation and configuration of Informatica Power Center.
  • Manage new installations, hot fixes, configuration, and troubleshooting of Informatica platform including hardware, and software
  • Plan, test, and execute upgrades involving Informatica components; Assure Informatica platform stability and security
  • Design, document, and implement administration producers, security model, backup, and fail over / recovery operations for Informatica platform
  • Managing the DEV/QA/UAT/PROD environments with High Availability
  • Provide troubleshooting and diagnostic support. Incident, problem and service outage management
  • Experience managing offshore resources
  • Managing prod deployments.
  • Experience in coordinating with ETL developers on their issues and support them with performance tuning stuff.
  • Repository and domain backup script and managing back ups.
  • Maintaining folders and its permissions along with the OS profiles.

Environment: Informatica Power Center 8.x, Oracle 11g, UNIX shell scripting, CAWA Scheduling tool.

Confidential

ETL Development Lead

Responsibilities:

  • Responsible for the life-cycle development, implementation, deployment, quality assurance & operational integrity of multiple production projects and environments that support key business areas.
  • Manage the Informatica and Oracle data transformation environments and processes including development, quality assurance, and production.
  • Identify process/procedure/control improvements and implement when/where appropriate. Ensure project testing and development quality assurance meets approved standards. Maintain and foster effective relationships with staff, clients, developers and others.
  • Responsible for POC and time estimation for other technology projects, and Production support for Informatica tool. Used to take care of performance and connectivity issues.
  • Analyzed source database, designed mapping (using various transformations like Update Strategy, Look Up, Stored Procedure, Router, Filter, Sequence Generator, Joiner, Aggregate and Expression) to transform and load data on target databases (SQL Server) using Informatica PowerCenter (ETL Tool).
  • Development of UNIX shell scripts for job scheduling and Informatica pre and post mapping session processes.
  • Created dictionaries using Informatica Data Quality that was used to cleanse and standardize data.
  • Development of Informatica mappings to load data to various Dimensions, FACTS, Aggregate FACT and other tables.
  • Analyzed and Resolved issues in Extraction, Transformation and Loading (ETL) Processes, especially in transformation and mapping development.

Environment: Informatica Power Center 8.x, Oracle 10g, TEST LINK, DAC, Windows 2000/XP.

Confidential, Stamford, CT

ETL senior Dev and Lead

Responsibilities:

  • Extraction, Transformation and Load was performed using Informatica Power Center to build Data warehouse. Worked on Informatica power center tools like Source Analyzer, Warehouse Designer, Mapping Designer, Mapplets and Transformation Developer.
  • Developed standard and re-usable mappings, mapplets using various transformations like expression, aggregator, joiner, source qualifier, lookup, and Router. Also, developed mappings using parameters and variables.
  • Developed complex mappings/workflows in Informatica Power Center to load the data from various sources using different transformations like Source Qualifier, Look up (connected and unconnected), Expression, Aggregate, Update Strategy, Joiner, Filter and Router.
  • Designed and documented design document, LLD, UTC, UTR, validation rules, error handling and test strategy of ETL process.
  • Created mappings, complex workflows with multiple sessions, worklets with consecutive/concurrent sessions for loading fact and dimension tables into data mart presentation layer..
  • Migrated Informatica ETL application and Database objects through various environments such as Development, Testing and Production environments.

Environment: Informatica Power Center 8.x, Oracle 10g, UNIX, Informatica workflow scheduler, Business Objects, Sybase, flat files like csv/fixed width/delimiter, XML, WSS.

Confidential, Stamford, CT

ETL Developer

Responsibilities :

  • Designed and created source to target mappings for ETL processes using various transformations
  • Used Informatica Power Center for migrating data from various OLTP databases to the DataMart.
  • Extracted data from various source systems like Oracle, SQL Server, XML and flat files and loaded into relational data warehouse and flat files.
  • Done the analysis from PL/SQL code like procedures, packages and records.
  • Involved in creating data mapping specifications.
  • Translated Business Requirements into Informatica mappings to build Data Warehouse by using Informatica Designer, which populated the data into the target Star Schema
  • Created various Informatica mappings and mapplets to load the data mart. The mappings involved extensive use of transformations like Aggregator, Filter, Router, Expression, Joiner, Sequence generator.
  • Implemented restart ability, pre-check, duplicate file check, post balancing check, empty file check to improve data quality and Integrity between the systems.

Environment: Informatica PowerCenter 7.1, Oracle 9i, flat files, Teradata, UNIX, PL/SQL, SQL Loader.

Hire Now