We provide IT Staff Augmentation Services!

Informatica Architect/sr.developer Resume

Philadelphia, PA

SUMMARY:

  • Over 11 years of experience in the Information Technology and wide range of experience in Software development, Project management, Data Integration, Master Data Management, Metadata Management, Data governance and Data Quality assurance.
  • Proficient in Analysis, Development and support of ETL processes for Data Marts using Informatica Power Center.
  • Expertise in Master Data Management concepts, Methodologies and ability to apply this knowledge in building MDM solutions.
  • Having exposure on Informatica Cloud Services.
  • Knowledge of complete Software Development Life cycle(SDLC) in datawarehousing project.
  • Extensive knowledge on Analysis, Designing of Documents like Technical Requirement Documents (TRD), Specification Design Documents (HLD and LLD) and Unit Test Plan.
  • Extensive experience in Data Extraction, Transformation and Loading Data using Informatica Power Center 9.x/8.x (Admin Console, Informatica Service, Repository Manager, Designer,
  • Workflow Manager, and Workflow Monitor), Informatica Power Exchange 9.X
  • Experienced in integration of various data sources like Oracle 11g/10g, MS SQL Server 2012/2008 and Flat Files into staging area.
  • Slowly Changing Dimensions Management including Type 1, 2, 3, Hybrid Type 3, De - normalization, Cleansing, Conversion, Aggregation, Performance Optimization.
  • Worked on non-relational sources like Flat Files and used secure FTP.
  • Worked on Exception Handling Mappings for Data Quality, Data Profiling, Data cleansing and data validation by using IDQ
  • Worked on Oracle PL/SQL programming, Stored Procedures, Creating Triggers and Sequence Generator on the Target Table.
  • Extensively used SQL statements to query the Oracle Database for Data Validation and Data Integrity
  • Created the SQL Views, Table pairs and created the DVO jobs for validating the Source and Target Tables data as part of Automation Testing.
  • Developed Several Testing Strategies-Integration, System, and High-availability and Disaster recovery - which constituted to overall project effort
  • Restoring the Database to Disaster Recovery Server.
  • Worked on Performance Tuning Informatica Targets, Sources, Mappings and Sessions.
  • Experience in developing Informatica Reusable components for using them across the projects.
  • Extensively worked with Informatica Mapping Variables, Mapping Parameters and Parameter Files.
  • Experienced in UNIX work environment, File Transfers, Job Scheduling and Error Handling.
  • Experience on ER Data modeling tools like Erwin, ER-Studio and Visio in developing Fact & Dimensional tables, Logical and Physical models.
  • Worked on OLTP and OLAP Systems.
  • Good understanding of Kimball and Inmon methodologies.
  • Excellent knowledge of both Batch and Online Systems.
  • Excellent experience in project management, handling offshore and onsite teams (12 resources).
  • Extensive knowledge in maintaining monthly metrics, weekly status reports and daily execution reports.
  • Working experience on Agile and waterfall methodology implementation projects.
  • Self-motivated and ability to meet operational deadlines in a demanding fast-paced environment and Capable of working independently as well as in a team.
  • Diverse background with fast learning skills and creative analytical skills.
  • Excellent communication skills, interpersonal skills, team coordination and versed with Software Development processes.

TECHNICAL SKILLS:

Informatica Tools: Informatica Power Center 10.1/9.6/8.6/7.1, Informatica Power Exchange 9.5, Informatica Data Quality (10.1/9.6/9.1/8.6 ), Informatica MDM Multi-Domain 10.1/9.5, Informatica Data Director (IDD/BDD), SIF, Informatica Metadata Manager 9.6.1, Business Glossary, Informatica B2B(DX/DT), Informatica Cloud 10.1, Informatica Big Data Management(BDM) 10.1

Reporting Tool: Cognos 8.4, Qlikview, Tableau, SSRS

Databases: SQL Server 2012 / 2008, Teradata 14, Oracle 11g / 10g, DB2.

Other Tools: SAP BW, SAP ECC, Hadoop, HDFS, Hive, Salesforce

Scheduling Tools: Autosys, Skybot, Robot, Crontob, UC4

Programming Languages: C, PL/SQL,Shell Scripting

Operating System: Windows 8/7/98/2003 Server/XP, Linux

PROFESSIONAL EXPERIENCE:

Confidential, Philadelphia, PA

Informatica Architect/Sr.Developer

Responsibilities:

  • Extensively involved in almost all the phases of Project Life Cycle (SDLC) right from Requirements Gathering to Development, Testing and Implementation etc.
  • Learned the company’s EDW architecture which consists of sources, middleware, staging area, data warehouse, and reporting tools.
  • Responsible for design and development of multiple projects leveraging Informatica Power Center ETL tool, Data Quality, Informatica Cloud, DVO and Metadata Manager.
  • Implement Informatica MDM workflow including data profiling configuration specification and coding match rules tuning migration
  • Build out best practices regarding data staging data cleansing and data transformation routines within the Informatica MDM solution
  • Define and build best practices regarding creating business rules within the Informatica MDM solution
  • Created Base Tables, Stages tables based on the data model and number of source systems
  • Developed the mappings using various cleanse functions in the Hub and the address doctor to standardize the data.
  • Worked with Business users in understanding Match Merge setup and incorporated their requirements and ideas.
  • Collaborated with users in defining Match Rules and conducted workshops to discuss over and under matching
  • High level review of SAM discussed use of Roles creation of users and assignment of user to Role.
  • Defined Roles and privileges for each environments according to the platform requirements
  • Develop and maintain the master and translation entities in the MDM Hub and published the data into SFDC s and ERP s for supporting the ongoing business support
  • Created Customer onboarding process to load data into landing tables of MDM Hub using external batch processing for initial data load in hub store and define automation process for staging loading match and merge
  • Configured, designed and delivered MDM hubs across multiple data domains Party, Service/Product Prospect
  • Used hierarchies tool for configuring entity base objects, entity types, base objects relationship types, profiles put and display packages and used the entity types as subject areas in IDD.
  • Created and Developed IDD application by creating Subject Area Groups Subjects Areas and Entity Relation ships.
  • Integrated Informatica Data Quality IDQ with MDM and Created various data quality mapplets in Informatica Data Quality tool and imported them as IDQ cleanse functions.
  • Used Informatica data quality tool to cleanse and standardize the data while loading to staging tables.
  • Worked on data profiling & various data quality rules development using Informatica Data Quality.
  • Implemented Exception Handling Mappings by using Data Quality, Metadata, Data validation by using Informatica Analyst.
  • Extracted Profile results from Informatica repository source tables using mappings and loaded them into fact tables to build reports for Scorecard purposes.
  • Used Informatica Metadata Manager xConnectors and built in connectors to bring in metadata from various source systems Oracle, SAP PowerDesigner, Teradata, Tableau, PowerCenter, BTEQ’s, SSRS etc.
  • Creation of Lineages starting from Source all the way to Target depicting the flow of Data from Source to Target.
  • Worked on Informatica- Source Analyzer, Warehouse Designer, Mapping Designer &Mapplet, and Transformation Developer.
  • Used most of the transformations such as the Source Qualifier, Expression, Aggregator, Filter, Connected and Unconnected Lookups, Joiner, update strategy and stored procedure.
  • Queried the Target database using Teradata SQL and BTEQ for validation.
  • Worked extensively with different Caches such as Index cache, Data cache, Lookup cache (Static, Dynamic and Persistence) and Join cache while developing the Mappings.
  • Created Reusable transformations, Mapplets, Worklets using Transformation Developer, Mapplet Designer and Work let Designer.
  • Responsible for Unit Testing, Integration Testing and helped with User Acceptance Testing.
  • Implemented pipeline partitioning concepts like Database, Round-Robin, Key-Range, Pass Through techniques in mapping transformations.
  • Expertise in Debugging and Performance tuning of targets, sources, mappings and sessions. Experience in optimizing the Mappings and implementing the complex business rules by creating re-usable transformations and mapplets.
  • Scheduling Informatica jobs and implementing dependencies if necessary using UC4.
  • Responsible for performing SQL query optimization using Hints, Indexes and Explain plan.
  • Managed post production issues and delivered all assignments/projects within specified time lines.
  • Assisted in UAT Planning and Issues Resolution.

Technical Environment: Informatica Power Center 9.6.1/10.1, Informatica Cloud 10.1, Informatica MDM 10.1, Informatica SIF, User Exits, Informatica IDD 10.1, Informatica Data Quality (IDQ) 9.6.1/10.1, Informatica Analyst 9.6.1/10.1, Informatica Business Glossary 9.6.1/10.1, Informatica Metadata Manager 9.6.1/10.1, Teradata 14, BTEQ’s, Manta, SAP Power Designer 16.1, Tableau, Oracle 11g/12c, PL/SQL, SQL, Flat Files, TOAD, Unix, Shell Scripting, SQL Server 2012, UC4, Github.

Confidential, Indianapolis, IN

Sr. Informatica D eveloper

Responsibilities:

  • Worked with Business Analyst and application users to finalize Data Model, functional and detailed technical requirements.
  • Extensively worked on Data Integration using Informatica for the Extraction transformation and loading of data from various database source systems
  • Defined Business rules in Informatica Data Quality (IDQ) to evaluate quality of data by creating cleanse processes to monitor compliance with standards and also identified areas for data quality gaps and assist in resolving data quality issues.
  • Design and developed Exception Handling, data standardization procedures and quality assurance controls
  • Exported Mappings from IDQ to Informatica Power Center
  • Responsible for Data Warehouse Architecture, ETL and coding standards.
  • Developed Capacity Planning/Architecture/ Strategic Roadmaps/Implementing standards.
  • Used Informatica as ETL tool, and stored procedures to pull data from source systems/ files, cleanse, transform and load data into databases.
  • Created detailed Technical specifications for Data Warehouse and ETL processes.
  • Conducted a series of discussions with team members to convert Business rules into Informatica mappings.
  • Used Transformations like Look up, Router, Filter, Joiner, Stored Procedure, Source Qualifier, Aggregator and Update Strategy extensively.
  • Tuned performance of Informatica session for large data files by increasing block size, data cache size, sequence buffer length and target based commit interval.
  • Created Mapplets and used them in different Mappings.
  • Developed stored procedure to check source data with warehouse data and if not present, write the records to spool table and used spool table as lookup in transformation.
  • Done extensive bulk loading into the target using Oracle SQL Loader.
  • Involved in doing error handling, debugging and troubleshooting Sessions using the Session logs, Debugger and Workflow Monitor.
  • Managed Scheduling of Tasks to run any time without nay operator intervention.
  • Leveraged workflow manager for session management, database connection management and scheduling of jobs.
  • Created Unix Shell Scripts for Informatica ETL tool to automate sessions and cleansing the source data.
  • Experienced in Debugging and Performance tuning of targets, sources, mappings and sessions. Experience in optimizing the Mappings and implementing the complex business rules by creating re-usable transformations and mapplets.
  • Delivered all the projects/assignments within specified timelines.

Technical Environment: Informatica Powercenter 9.6.1, Informatica IDQ 9.6.1, Informatica Analyst 9.6.1, Informatica MDM 10.0.1, IDD/BDD, Service Now, Oracle 12.1, Flat Files.

Confidential, Phoenix, AZ

Informatica Technical Lead.

Responsibilities:

  • Involved in the complete Software Development Life cycle(SDLC).
  • Worked with business analysts for requirement gathering, business analysis and project- coordination.
  • Creating the project activities and Assigning the work to the Offshore team and other team members.
  • Creating the Technical specifications and Knowledge transfer documents required.
  • Worked on the mappings which extracts the data from SAP BW, SAP ECC, SQL Server and Flat files.
  • Helping the Offshore team with the development and support issues.
  • Providing the status updated on On-going developments and production support issues to the Data Integration, SAP, Web methods and Business Intelligence managers and the team mates.
  • Worked on the Informatica Powerexchange CDC Process.
  • Upgrading the Address Doctor files required for IDQ in Production.
  • Involved in the Integration test cycles(ITC) done as part of final testing before Go-Live.
  • Creating the Change request for the new development activities required to deploy in production and getting the approval from Change control board.
  • Providing and driving the system improvements required.
  • Worked on the SLA’s in nightly process and achieved the targets.
  • Creating the Incidents/Problems and resolving for production support issues.

Technical Environment: Informatica 9.5, SQL server, Informatica Power exchange, HP ALM, HP Agile manager, Service Now, Informatica IDQ 9.5, Informatica Analyst, Data Profiling, Score cards, Address Doctor, Informatica Web services Hub

Confidential, Irvine, CA

P Data Architect/ Informatica ETL Lead

Responsibilities:

  • Involved in the complete Software Development Life cycle(SDLC).
  • Interacting with the end clients to provide the status updates on the project.
  • Worked with business analysts for requirement gathering, business analysis and project- coordination.
  • Worked to identify different source systems and performed data analysis to determine the best approach of procuring source data using Informatica Power Center.
  • Created the DDL’s required for the datawarehouse tables.
  • Created the Source to target Mapping specification document.
  • Assigned the work to the developers based on the work estimates.
  • Done the peer reviews.
  • Used slowly changing dimensions and developed the Summary Fact tables.
  • Designed and developed UNIX scripts to load tables and also for scheduling the jobs.
  • Used Assembla to track the bugs and issues raised.

Technical Environment: Informatica 9.5, Oracle 11g, WINSCP, TOAD 10.6, Assembla, UNIX and Shell Scripting, PL/SQL

Confidential, Washington DC

Technical Specification writer/ Senior Developer.

Responsibilities:

  • Interacting with the clients and understanding the requirements.
  • Creating the Technical Source to Target Field mappings.
  • Involved in designing of Informatica mappings by translating the business requirements.
  • Used Informatica power center for ETL extraction, transformation and loading data into target warehouse.
  • Performed detail data analysis of both data elements requested by the business and transactional source systems.
  • Imported Source/Target Tables from the respective databases and created reusable transformations like Joiner, Routers, Lookups, Filter, Expression and Aggregator and created new mappings using Designer module of Informatica.
  • Developed Slowly Changing Dimension Mappings of type I, and II.
  • Prepared the unit test cases document to perform the Unit Testing.
  • Involved in the Unit Testing and Integration testing of the workflows developed.
  • Developed UNIX shell scripts to automate applications, Schedule jobs and for audit purposes.

Technical Environment: Informatica 9.5, Oracle 11g, WINSCP, TOAD, UNIX and Shell Scripting

Confidential

Informatica Lead/Senior Developer.

Responsibilities:

  • Interacting with the clients through TRIAGE meetings and Understanding the requirements.
  • Involved in designing of Informatica mappings by translating the business requirements.
  • Used Informatica power center for ETL extraction, transformation and loading data into target warehouse.
  • Used Siperian/Informatica MDM(Master Data Management) tool to develop the MDM mappings and used the Trust/Validation rules.
  • Performed detail data analysis of both data elements requested by the business and transactional source systems.
  • Imported Source/Target Tables from the respective databases and created reusable transformations like Joiner, Routers, Lookups, Filter, Expression and Aggregator and created new mappings using Designer module of Informatica.
  • Developed complex Informatica Mappings, Mapplets and the corresponding workflows to facilitate daily, monthly and yearly loading of data.
  • Implemented the Change Data Capture(CDC) logic.
  • Developed Slowly Changing Dimension Mappings of type I, and II.
  • Developed Balance and Control mappings for Auditing Purpose.(Source and target data records loaded check)
  • Prepared the unit test cases document to perform the Unit Testing.
  • Involved in the Unit Testing and Integration testing of the workflows developed.
  • Improved the performance of the mappings using various optimization techniques in order to reach the 30 Minute NRT(Near Real Time) loading process.

Technical Environment: Informatica 9.0, Siperian/Informatica MDM, Oracle 11g,HP Quality Control.

Confidential

Informatica Lead/Senior Developer

Responsibilities:

  • Interacting with the clients through TRIAGE meetings and Understanding the requirements.
  • Preparing the Low Level Mapping Specification Documents from the High Level Business Documents.
  • Assigning the work to the team and assisting them.
  • Involved in designing of Informatica mappings by translating the business requirements.
  • Used Informatica power center for ETL extraction, transformation and loading data into target warehouse.
  • Used IDQ(Informatica Data Quality) as data Cleansing tool to create the IDQ Mappllets and to correct the data before loading into the Target tables.
  • Used Siperian/Informatica MDM(Master Data Management) tool to develop the MDM mappings and created the jobs(STAGE and LOAD jobs) to load the Golden records into Base Objects.
  • Worked on Informatica to extract data from flat files and Oracle and to load the data into the target tables.
  • Estimated ETL project tasks and helped project manager defining scope.
  • Imported Source/Target Tables from the respective databases and created reusable transformations like Joiner, Routers, Lookups, Filter, Expression and Aggregator and created new mappings using Designer module of Informatica.
  • Developed complex Informatica Mappings, Mapplets and the corresponding workflows to facilitate daily, monthly and yearly loading of data.
  • Developed Slowly Changing Dimension Mappings of type I, and II.
  • Prepared the unit test cases document to perform the Unit Testing.
  • Involved in the Unit Testing and Integration testing of the workflows developed.
  • Optimizing Informatica Mappings and Sessions to improve the performance.
  • Creating the Package and delivered the final code to the QA and On-sight team.

Technical Environment: Informatica 9.0, Informatica IDQ 9.0, Siperian/Informatica MDM, Oracle 11g, JIRA tool.

Confidential

Sr. ETL Developer

Responsibilities:

  • Primarily responsible for Analysis and developing Extraction, Transformation and loading process using ETL tool Informatica.
  • Worked on Informatica power center tool- Source Analyzer, Warehouse designer, Mapping and Mapplet designer, Transformations, Workflow Manager and Workflow Monitor.
  • Designed and developed Informatica Mappings and Sessions based on user requirements and ETL rules to load data from source Flat files and RDBMS tables to target flat files and tables.
  • Created Mappings using the transformations like Source Qualifier, Aggregator, Expression, Lookup, Filter, Router, Joiner, Update Strategy, Union, and Stored Procedure.
  • Developed workflows and worklets using sessions, command, decision, control and email tasks.
  • Scheduling the workflows using the Crontab.
  • Involving performance tuning of ETL flow.

Technical Environment: Informatica 8.6, Oracle 10g,Sub Version Tool(SVN)

Confidential

ETL Developer

Responsibilities:

  • Mainly involved in ETL developing.
  • Analyzed the Sources, targets, transformed the data, and mapped the data and loading the data into Targets using Informatica.
  • Transformations like Expression, Router, Joiner, Lookup, Update Strategy, and Sequence Generator are mainly used.
  • Creating the reusable mapping using Mapplet designer and that Mapplet are used in mapping
  • Using ETL process to Extract, Transform and Load the data into stage area and data warehouse.
  • Prepared the Documentation for the mappings according to the Business Requirements.

Technical Environment: Informatica 8.1, Oracle 9i.

Confidential

Informatica Developer.

Responsibilities:

  • Extensively worked in the performance tuning of programs, ETL procedures and processes. Error checking and testing of the ETL procedures and programs using Informatica session log.
  • Data migration from one environment to another environment using ETL Informatica tool.
  • Worked extensively with central data repository and pharmaceutical R&D domain.
  • Worked extensively on Oracle database 9i and flat files as data sources.
  • Developed and fine-tuned PL/SQL stored procedures to increase the performance.
  • Huge volumes of Data extraction from legacy systems and uploaded into Oracle using SQL*Loader and PL/SQL.
  • Developed UNIX shell scripts to automate applications, Schedule jobs, develop interfaces.
  • Performed integrated testing for various mappings. Tested the data and data integrity among various sources and targets.

Technical Environment: Informatica power center 7.1.2, Oracle 9i, Flat Files and UNIX.

Hire Now