We provide IT Staff Augmentation Services!

Informatica Architect Resume

2.00/5 (Submit Your Rating)

Jersey City, NJ

SUMMARY

  • 15 Years of IT experience and technical proficiency in the field of Data Warehousing teamed with Data Architecture, Data Modeling, Data Analysis, Business Requirements Analysis, Application Design, Development & testing, Data profiling, data standardization & Quality Control and full life cycle Implementation of Data Warehouse.
  • Project Management Methodologies - Waterfall, Agile (Scrum)
  • Project Management Skills - Managing Resources, Tracking Project Timelines, Creation of Statement of Work, Maintain Project Financials, Risk and Issue Management, Stakeholder Communication, Status Reporting, Relationship Building, Work Breakdown Structure (WBS).
  • AGILE/SCRUM - Managing Product Backlogs, Sprint Planning, Burndown Charts, KANBAN Boards
  • Extensive experience on AWS GLUE to load the data in to S3 bucket and also to Redshift DB.
  • Setting up Glue Crawlers to read the data from S3 bucket
  • Setting up Glue Crawlers to define metadata structure for Atana and spectrum.
  • Defining roles, access, permissions with IAM.
  • Loaded data to Redshift and queried using SQL workbench.
  • Created cloud formation templates for infrastructure setup along with EC2 server configuration.
  • Performed DR drill using cloud formation templates.
  • Used cloud watch for monitoring infrastructure and setting up alerts and mechanisms.
  • Strong experience in ETL Administration. Upgraded the ETL platform from 7.1.3 to 8.1 and Powercenter 8.6.1 Hotfix14 to Powercenter 9.1.3 Hotfix 2. Also upgraded the Informatica 9.1 HF6 to 9.5.1 HF2.
  • Installation of hotfixes provided by vendor Informatica on Linux 4.0/5.0 and sun Solaris 10 environments.
  • Installation of Informatica on AWS EC2 Instance.
  • Have noledge on HDFS, Hive, Python.
  • Extensive experience on Informatica HA/GRID setup.
  • Informatica Data Quality (IDQ) setup for connecting to HIVE and HDFS.
  • End to end setup of Informatica 9.6.1 HF3 BDE with Cloudera Cluster CDH 5.4.7.
  • End to end setup of Informatica 10.1 BDE with Cloudera cluster CDH 5.5.4.
  • Code deployments to the QA and production environment using deployment groups and labels.
  • Enabled versioning on Development, QA and Production environments.
  • Strong Data Warehousing experience in Application development & Quality Assurance testing using Informatica Power Center 10.1/9.6.1/9.5/9.1/8.6/8.1/7.1 (Designer, Workflow Manager, Workflow Monitor).
  • Versed using command line utilities like pmrep, pmcmd, infacmd and infasetup
  • Configured Model repository, data integration and content management services for IDQ
  • Root cause analysis for ETL job failures/data issues raised by business
  • Supporting password Change policy, bouncing Activities or restarting the services
  • Coordinating with DBA, Network and UNIX/Linux team for any kind of outages
  • Experienced in checking file transfer activities via SFTP
  • Installed and Supported BDM 10.2.1 and applied couple of EBF’S as required.
  • Closely worked with Infromatica Global support for resolving tool issues and applied custom EBF’s as required.
  • Experience in creating complex Informatica Mappings using Source Qualifier, Expression, Router, Aggregator, Lookup, and other transformations in Informatica and well versed in debugging an Informatica mapping using Debugger
  • Extensive experience in Business Intelligence arena with BI Suite and Business Objects XI/6.5/3.1
  • Experience in Designing and Developing Business Objects Universes BO Designer and Reports using BO Desktop Intelligence / Business Objects 6.5.
  • Strong SQL experience in Coding and Query tuning. Well versed with Oracle SQL tools like TOAD and SQL Plus.
  • Experience in creating efficient and TEMPeffective BRD (Business requirement document), TAD (Technical Architecture document), TDD (Technical design document) involving data mappings
  • Extensive experience in writing Use Cases, Functional specifications, Scenarios, Business processes, Workflows, Process flows, Test cases and Test Plans.
  • Experience in designing error and exception handling procedures to identify, record and report errors
  • Experience in coordinating with the configuration and change management groups for Clear Case Version Control and Build Making Process
  • Through experience in scripting using Unix Shell .
  • Ability to work well both individually and in teams.
  • Excellent communication skills, strong decision making skills, organizational skills, and customer service oriented. Excellent analytical and problem solving skills.
  • Strong experience in Installing and Configuring of various Informatica MDM components
  • Data modelling, data mappings, data validations, data standardization, defining business rules for cleansing, matching, merging and maintaining data.
  • Created and Configured Landing tables, Staging Tables, Base Objects, Hierarchies, Foreign Key Relationships, Lookups in the Hub, Queries, Query Groups and Packages in MDM.
  • Experienced with hierarchy manager to develop hierarchies as per the business needs.
  • Created IDD application as per the business needs by creating the subject area and subject area groups.
  • Extensively used Merge Manager and Data Manager for Managing Data.
  • Worked on Repository manager for validation, promotion, importing and exporting the ORS repositories to development, QA, pre-production and production environments.
  • Hands on experience in Informatica MDM Hub Match and Merge Rules, Batch Jobs and Batch Groups.
  • Data Validation and Data cleaning using User Exits in MDM Hub and in IDD.
  • Developed database objects like Stored Procedures, Functions, Packages and Triggers, Ref Cursor, External TablesandCollections
  • Installed and configured MDM Hub Console, Hub Store, Hub server, Cleanse and Match Server, Resource Kit, Address Doctor applications by following Informatica Product Availability Matrix( PAM) document
  • Created and Configured Landing tables, Staging Tables, Base Objects, Hierarchies, Foreign Key Relationships, Lookups in the Hub, Queries, Query Groups and Packages in MDM.
  • Determined relative trust and validation values of source data and decay in reliability.
  • Identified Gloden Record(BVT) by analyzing the data, cleansing the data and merging duplicate records coming from different source systems.
  • Defined the Match and Merge Rules in the MDM Hub by creating match path components, match strategy, match columns and rules.
  • Analyzed the source system for integrity issues to the data resided in various source systems and defined the same in Systems and Trust.
  • Involved in implementing the Landing Process of loading the customer/product Data Set into Informatica MDM Hub using ETL tool that was coming from various source systems.
  • Worked on data cleansing and standardization using the cleanse functions in Informatica MDM.
  • Defined the Trust and Validation rules and setting up the match/merge rule sets to get the right master records.
  • Configuring Delta detection and raw retention period for the Base Object.
  • Execute Stage Jobs, Load Jobs, Match and Merge Jobs using the Batch Viewer and Batch groups
  • Using SoapUI user interface to communicate with MDM HUB.
  • Used Informatica’ s features to implement Type I, II changes in slowly changing dimension tables and also developed complex mappings to facilitate daily, weekly and monthly loading of data.
  • Created and Configured Landing tables, Staging Tables, Base Objects, Hierarchies, Foreign Key Relationships, Lookups in the Hub, Queries, Query Groups and Packages in MDM.

TECHNICAL SKILLS

Database: Teradata,Oracle,DB2,HIVE,Netezza,Redshift

Methodology: Agile, Waterfall,Scrum,Kanban

Tools: and Utilities Informatica 10.1 BDE,Informatica 9.6.1 HF3 BDE, Informatica Power Center 7.1.1, Informatica Power Center 8.1.1, Informatica Power Center 8.6, Informatica 9.1, Informatica 9.5.0, Informatica 9.6.1 HF3,Metadata manager, Data Analyzer, Power exchange, IDQ.

ETL Tools: Informatica Power Center (Admin & Development), Big Data Management (ADMIN & Development), Informatica, Data-Quality (ADMIN), IICS (ADMIN) AXON (ADMIN), MDM (ADMIN), PETL and SSIS. Informatica EDC

PROFESSIONAL EXPERIENCE:

Confidential, Jersey City, NJ

Informatica Architect

Environment: Informatica Powercenter/IDQ 9.6.1 BDE/10.1/10.4, Linux 6.5 64 bit

Responsibilities:

  • Informatica development activities on CDR platform.
  • Informatica development activities on DRS platform involving Mantas data and loading in to Risk Canvas application.
  • Informatica Administration activities involving repository automation, hotfix installations, code reviews and migrations.
  • Informatica server support and maintenance.
  • Informatica upgrade activities from 9.6.1 to10.1.
  • Informatica Data Quality (IDQ) setup for connecting to HIVE and HDFS.
  • Informatica installation and upgrade on Physical Servers.
  • Experienced in providing system administration, operational support in windows/Unix environment.
  • Install/Upgrade Informatica 9.6 to 10.2.0.
  • Later upgraded 10.2.0 to 10.2.0 HF2.
  • Experienced in migrating Informatica form old host to new host and restoring domain.
  • Setting up with LDAP configuration to use AD accounts instead of Native account.
  • Python scripting for file validations.
  • Migrating code to different environments using XML methods.
  • Review of ETL design docs and working closely with development team to ensure standards are followed.
  • Running both technical conference bridges and business update calls.
  • Taking lead of CAB Meeting and approving the changes for production fixes.
  • Coordination with the development team to resolve the infrastructure issues.
  • Autosys is used as a scheduling tool to schedule Informatica workflows.
  • Good working experience in Partitioning and PDO in Informatica.
  • Have very good noledge on Informatica. Have worked on transformations like Sorter, Aggregator, Router, Filter, Union, Joiner, Normalizer, Lookups, Update Strategy and Expression.
  • Worked with various sources like XML, Flat files,Teradata,Netezza,Oracle, DB2 etc.
  • Informatica upgrade from 9.1 HF5 to 9.6.1 HF3.
  • Strong experience in Installing and Configuring of various Informatica MDM components
  • Data modelling, data mappings, data validations, data standardization, defining business rules for cleansing, matching, merging and maintaining data.
  • Created and Configured Landing tables, Staging Tables, Base Objects, Hierarchies, Foreign Key Relationships, Lookups in the Hub, Queries, Query Groups and Packages in MDM.
  • Experienced with hierarchy manager to develop hierarchies as per the business needs.
  • Created IDD application as per the business needs by creating the subject area and subject area groups.
  • Extensively used Merge Manager and Data Manager for Managing Data.
  • Worked on Repository manager for validation, promotion, importing and exporting the ORS repositories to development, QA, pre-production and production environments.
  • Hands on experience in Informatica MDM Hub Match and Merge Rules, Batch Jobs and Batch Groups.
  • Data Validation and Data cleaning using User Exits in MDM Hub and in IDD.
  • Developed database objects like Stored Procedures, Functions, Packages and Triggers, Ref Cursor, External TablesandCollections
  • Installed and configured MDM Hub Console, Hub Store, Hub server, Cleanse and Match Server, Resource Kit, Address Doctor applications by following Informatica Product Availability Matrix( PAM) document
  • Created and Configured Landing tables, Staging Tables, Base Objects, Hierarchies, Foreign Key Relationships, Lookups in the Hub, Queries, Query Groups and Packages in MDM.
  • Determined relative trust and validation values of source data and decay in reliability.
  • Identified Gloden Record(BVT) by analyzing the data, cleansing the data and merging duplicate records coming from different source systems.
  • Defined the Match and Merge Rules in the MDM Hub by creating match path components, match strategy, match columns and rules.
  • Analyzed the source system for integrity issues to the data resided in various source systems and defined the same in Systems and Trust.
  • Involved in implementing the Landing Process of loading the customer/product Data Set into Informatica MDM Hub using ETL tool that was coming from various source systems.
  • Worked on data cleansing and standardization using the cleanse functions in Informatica MDM.
  • Defined the Trust and Validation rules and setting up the match/merge rule sets to get the right master records.
  • Configuring Delta detection and raw retention period for the Base Object.
  • Execute Stage Jobs, Load Jobs, Match and Merge Jobs using the Batch Viewer and Batch groups
  • Using SoapUI user interface to communicate with MDM HUB.

Confidential

Informatica BigData Management(BDM) Architect

Environment: Informatica Powercenter/BDM/10.2, Linux 6.5 64 bit/AWS/EC2

Responsibilities:

  • Informatica Big Data Management activities involving development activities to load data to Postgresql DB.
  • Informatica mappings, workflows and applications creation on developer client tool.
  • Data loading to many facts and dimensions tables using star schema design.
  • Data loading to different databases like SQL server and Postgresql DB using powercenter and informatica developer client tool.
  • Informatica is installed on AWS platform .
  • Loading the data to S3 Environment.
  • Informatica development activities on CDR platform.
  • Informatica development activities on DRS platform involving Mantas data and loading in to Risk Canvas application.
  • Informatica Administration activities involving repository automation, hotfix installations, code reviews and migrations.
  • Informatica server support and maintenance.
  • Informatica upgrade activities from 9.6.1 to10.1.
  • Informatica Data Quality (IDQ) setup for connecting to HIVE and HDFS.
  • Informatica installation and upgrade on Physical Servers.
  • Experienced in providing system administration, operational support in windows/Unix environment.
  • Install/Upgrade Informatica 9.6 to 10.2.0.
  • Later upgraded 10.2.0 to 10.2.0 HF2.
  • Experienced in migrating Informatica form old host to new host and restoring domain.
  • Setting up with LDAP configuration to use AD accounts instead of Native account.
  • Have noledge on HDFS, Hive, Python.
  • Migrating code to different environments using XML methods.
  • Review of ETL design docs and working closely with development team to ensure standards are followed.
  • Running both technical conference bridges and business update calls.
  • Taking lead of CAB Meeting and approving the changes for production fixes.
  • Coordination with the development team to resolve the infrastructure issues.
  • Autosys is used as a scheduling tool to schedule Informatica workflows.
  • Good working experience in Partitioning and PDO in Informatica.
  • Have very good noledge on Informatica. Have worked on transformations like Sorter, Aggregator, Router, Filter, Union, Joiner, Normalizer, Lookups, Update Strategy and Expression.
  • Worked with various sources like XML, Flat files,Teradata,Netezza,Oracle, DB2 etc.
  • Informatica upgrade from 9.1 HF5 to 9.6.1 HF3.
  • Strong experience in Installing and Configuring of various Informatica MDM components
  • Data modelling, data mappings, data validations, data standardization, defining business rules for cleansing, matching, merging and maintaining data.
  • Created and Configured Landing tables, Staging Tables, Base Objects, Hierarchies, Foreign Key Relationships, Lookups in the Hub, Queries, Query Groups and Packages in MDM.
  • Experienced with hierarchy manager to develop hierarchies as per the business needs.
  • Created IDD application as per the business needs by creating the subject area and subject area groups.
  • Extensively used Merge Manager and Data Manager for Managing Data.
  • Worked on Repository manager for validation, promotion, importing and exporting the ORS repositories to development, QA, pre-production and production environments.
  • Hands on experience in Informatica MDM Hub Match and Merge Rules, Batch Jobs and Batch Groups.
  • Data Validation and Data cleaning using User Exits in MDM Hub and in IDD.
  • Developed database objects like Stored Procedures, Functions, Packages and Triggers, Ref Cursor, External TablesandCollections
  • Installed and configured MDM Hub Console, Hub Store, Hub server, Cleanse and Match Server, Resource Kit, Address Doctor applications by following Informatica Product Availability Matrix( PAM) document
  • Created and Configured Landing tables, Staging Tables, Base Objects, Hierarchies, Foreign Key Relationships, Lookups in the Hub, Queries, Query Groups and Packages in MDM.
  • Determined relative trust and validation values of source data and decay in reliability.
  • Identified Gloden Record(BVT) by analyzing the data, cleansing the data and merging duplicate records coming from different source systems.
  • Defined the Match and Merge Rules in the MDM Hub by creating match path components, match strategy, match columns and rules.
  • Analyzed the source system for integrity issues to the data resided in various source systems and defined the same in Systems and Trust.
  • Involved in implementing the Landing Process of loading the customer/product Data Set into Informatica MDM Hub using ETL tool that was coming from various source systems.
  • Worked on data cleansing and standardization using the cleanse functions in Informatica MDM.
  • Defined the Trust and Validation rules and setting up the match/merge rule sets to get the right master records.
  • Configuring Delta detection and raw retention period for the Base Object.
  • Execute Stage Jobs, Load Jobs, Match and Merge Jobs using the Batch Viewer and Batch groups
  • Using SoapUI user interface to communicate with MDM HUB.

Confidential, Bridgewater, NJ

Informatica Architect/Administrator

Environment: Informatica Powercenter/IDQ 9.6.1/9.5/9.1/8.6.1 , Oracle 11.2.0.3, Linux 6.5 64 bit

Responsibilities:

  • Informatica Administration activities involving repository automation, hotfix installations, code reviews and migrations.
  • Informatica server support and maintenance.
  • Informatica upgrade activities from 8.6.1 to 9.1/9.1 to 9.6.1.
  • Informatica Data Quality (IDQ) setup for connecting to HIVE and HDFS.
  • End to end setup of Informatica 9.6.1 HF3 BDE with Cloudera Cluster CDH 5.4.7.
  • Informatica installation and upgrade on VM.
  • Coordination with the development team to resolve the infrastructure issues.
  • Creating connections for Teradata,Netezza,oracle, SQL Server and Powerexchange .
  • Control-M is used as a scheduling tool to schedule Informatica workflows.
  • Worked with various sources like XML, Flat files,Teradata, Oracle, DB2 etc.
  • Informatica upgrade from 9.1 HF5 to 9.6.1 HF3.

Confidential: Charlotte, NC

Informatica Architect

Environment: Informatica Powercenter 9.1/9.5/8.6.1 , Oracle 10G,LINUX, UNIX,AIX

Responsibilities:

  • Informatica Administration activities involving repository automation, hotfix installations, code reviews and migrations.
  • Informatica server support and maintenance.
  • Coordination with the development team to resolve the infrastructure issues.
  • Creating connections for Teradata,Netezza,oracle, SQL Server and Powerexchange .
  • Extensively worked on HA and Grid setup.
  • Autosys is used as a scheduling tool to schedule Informatica workflows.
  • Troubleshooting data interrogation issues in development, test, and production environments.
  • Involved in extensive Performance Tuning by determining bottlenecks in sources, targets, mappings and sessions.
  • Created various active and passive transformations like Source Qualifier, Lookup, Router, Aggregator, Filter, Joiner, Expression and standard/reusable mappings using Informatica
  • Schedule and Run Extraction and Load process and monitor sessions using Informatica Workflow Manager.
  • Performed requirement gathering and business analysis for business rules and their documentations by having close interaction with Business Analysts and business users.
  • Strong experience in Installing and Configuring of various Informatica MDM components
  • Data modelling, data mappings, data validations, data standardization, defining business rules for cleansing, matching, merging and maintaining data.
  • Created and Configured Landing tables, Staging Tables, Base Objects, Hierarchies, Foreign Key Relationships, Lookups in the Hub, Queries, Query Groups and Packages in MDM.
  • Experienced with hierarchy manager to develop hierarchies as per the business needs.
  • Created IDD application as per the business needs by creating the subject area and subject area groups.
  • Extensively used Merge Manager and Data Manager for Managing Data.
  • Worked on Repository manager for validation, promotion, importing and exporting the ORS repositories to development, QA, pre-production and production environments.
  • Hands on experience in Informatica MDM Hub Match and Merge Rules, Batch Jobs and Batch Groups.
  • Data Validation and Data cleaning using User Exits in MDM Hub and in IDD.
  • Developed database objects like Stored Procedures, Functions, Packages and Triggers, Ref Cursor, External TablesandCollections
  • Installed and configured MDM Hub Console, Hub Store, Hub server, Cleanse and Match Server, Resource Kit, Address Doctor applications by following Informatica Product Availability Matrix( PAM) document
  • Created and Configured Landing tables, Staging Tables, Base Objects, Hierarchies, Foreign Key Relationships, Lookups in the Hub, Queries, Query Groups and Packages in MDM.
  • Determined relative trust and validation values of source data and decay in reliability.
  • Identified Gloden Record(BVT) by analyzing the data, cleansing the data and merging duplicate records coming from different source systems.
  • Defined the Match and Merge Rules in the MDM Hub by creating match path components, match strategy, match columns and rules.
  • Analyzed the source system for integrity issues to the data resided in various source systems and defined the same in Systems and Trust.
  • Involved in implementing the Landing Process of loading the customer/product Data Set into Informatica MDM Hub using ETL tool that was coming from various source systems.
  • Worked on data cleansing and standardization using the cleanse functions in Informatica MDM.
  • Defined the Trust and Validation rules and setting up the match/merge rule sets to get the right master records.
  • Configuring Delta detection and raw retention period for the Base Object.
  • Execute Stage Jobs, Load Jobs, Match and Merge Jobs using the Batch Viewer and Batch groups
  • Using SoapUI user interface to communicate with MDM HUB.

Confidential

Informatica Administrator

Environment: Informatica Powercenter 9.1/8.6.1, Oracle 10G, Teradata12, UNIX (Sun OS-Solaris 10)

Responsibilities:

  • Created new Informatica mappings.
  • Documentation of Informatica mappings
  • Maintaining the Informatica 8.6 Server built on Unix(Sun Solaris)
  • Worked on Informatica Power Center 8.6 tool - Source Analyzer, warehouse designer, Mapping Designer, Workflow Manager, Mapplets, and Reusable Transformations.
  • Troubleshooting data interrogation issues in development, test, and production environments.
  • Involved in extensive Performance Tuning by determining bottlenecks in sources, targets, mappings and sessions.
  • Created various active and passive transformations like Source Qualifier, Lookup, Router, Aggregator, Filter, Joiner, Expression and standard/reusable mappings using Informatica
  • Schedule and Run Extraction and Load process and monitor sessions using Informatica Workflow Manager.
  • Performed requirement gathering and business analysis for business rules and their documentations by having close interaction with Business Analysts and business users.
  • Optimized the mappings using various optimization techniques and also debugged some existing mappings using the Debugger to test and fix the mappings.
  • Monitored workflows and collected performance data to maximize the session performance.
  • Created the repositories and user groups using Informatica Admin console.
  • Analyzed the specifications and identifying the source data that needs to be moved to the data warehouse.
  • Developed mappings/sessions using Informatica Powercenter for data loading.
  • Used aggregate, expression, lookup, update strategy, router, and rank transformation.
  • Developed joiner transformation for extracting data from multiple sources.
  • Documentation of Technical specification, business requirements, functional specifications for the development of Informatica Extraction, Transformation and Loading (ETL) mappings to load data into various tables and defining ETL standards.
  • Autosys is used as a scheduling tool to schedule Informatica workflows.
  • Successfully upgraded To Informatica Powercenter 9.1 from version Powercenter 8.6.1.

Confidential

Team Lead

Environment: Oracle 10G

Responsibilities:

  • To gather all the functional and technical requirements from the client.
  • Analyzing the existing ETL process (SQL, PL/SQL).
  • Created new PL/SQL procedures, Functions, Triggers etc.
  • Provide the requirements to the offshore resource and validate the work completed by offshore resource.
  • Extract the data from the ADP database and load the data in to e-Personality oracle database by doing required transformations.
  • Creating and maintaining Triggers, Packages, Functions and Procedures.
  • Design and Development of data validation, load processes, test cases using PL/SQL, SQL.

Confidential

Informatica Administrator/ Production Support

Environment: Informatica 8.1.1, BOXI, Oracle 9i, UNIX (Sun OS-Solaris 10)

Responsibilities:

  • Analyzing the existing ETL process (SQL, PL/SQL).
  • Created new Informatica mappings.
  • Documentation of Informatica mappings
  • Maintaining the Informatica 8.1 Server built on Unix(Sun Solaris)
  • Creating Business Objects Universe.
  • Creating Business Objects Reports.
  • Providing access to all Business Objects users through CMC.
  • Maintaining the Business Objects Server built on UNIX (Sun Solaris).
  • Up gradation of Informatica 7.1 to Informatica 8.1
  • Worked on Informatica Power Center 8.1.1 tool - Source Analyzer, warehouse designer, Mapping Designer, Workflow Manager, Mapplets, and Reusable Transformations.
  • Developed source to target business specification documents based on stored procedures in Oracle.
  • Troubleshooting data interrogation issues in development, test, and production environments.
  • Involved in extensive Performance Tuning by determining bottlenecks in sources, targets, mappings and sessions.
  • Created various active and passive transformations like Source Qualifier, Lookup, Router, Aggregator, Filter, Joiner, Expression and standard/reusable mappings using Informatica
  • Schedule and Run Extraction and Load process and monitor sessions using Informatica Workflow Manager.
  • Performed requirement gathering and business analysis for business rules and their documentations by having close interaction with Business Analysts and business users.
  • Optimized the mappings using various optimization techniques and also debugged some existing mappings using the Debugger to test and fix the mappings.
  • Monitored workflows and collected performance data to maximize the session performance.
  • Created the repositories and user groups using Informatica Repository Manager.
  • Analyzed the specifications and identifying the source data that needs to be moved to the data warehouse.
  • Developed mappings/sessions using Informatica Power Center for data loading.
  • Used aggregate, expression, lookup, update strategy, router, and rank transformation.
  • Developed joiner transformation for extracting data from multiple sources.
  • Documentation of Technical specification, business requirements, functional specifications for the development of Informatica Extraction, Transformation and Loading (ETL) mappings to load data into various tables and defining ETL standards.
  • Autosys is used as a scheduling tool to schedule Informatica workflows.

Confidential

Informatica Developer/Administrator

Environment: Informatica 7.1, Oracle 9i, Erwin

Responsibilities:

  • Analyzing the existing ETL process (SQL, PL/SQL).
  • Created new Informatica mappings for Sales data Mart.
  • Documentation of Informatica mappings.
  • Worked on Informatica Power Center 7.1. tool - Source Analyzer, warehouse designer, Mapping Designer, Workflow Manager, Mapplets, and Reusable Transformations.
  • Troubleshooting data interrogation issues in development, test, and production environments.
  • Involved in extensive Performance Tuning by determining bottlenecks in sources, targets, mappings and sessions.
  • Created various active and passive transformations like Source Qualifier, Lookup, Router, Aggregator, Filter, Joiner, Expression and standard/reusable mappings using Informatica.
  • Schedule and Run Extraction and Load process and monitor sessions using Informatica Workflow Manager.
  • Discussed the Data warehouse requirements and measured its need with the Technical Lead
  • Optimized the mappings using various optimization techniques and also debugged some existing mappings using the Debugger to test and fix the mappings.

We'd love your feedback!