We provide IT Staff Augmentation Services!

Lead Architect Resume

SUMMARY:

  • Around 12+ years of experience in Informatica Power Design, Development, Testing, Informatica Data quality implementation. Oracle, Sql server, DB2, Netzza, Informatica Power center Administration, Informatica data quality Administration and Unix shell scripting.
  • Around 5 years experience Master data management.
  • Excellent knowledge in Insurance (property and casualty), Investment Banking, Informatica Big data management.
  • Excellent hands experience in Unix shell script.
  • Excellent experience in Data modeling and dimensional modeling.
  • Developed Confidential architecture, solution architecture, Data flow, Process flow, E2E exceptional handling flow for all the Confidential projects.
  • Demonstrated expertise in utilizing Informatica Transformations and Performance Optimization techniques to provide robust solution.
  • Installation & configuration of Confidential hub & Cleanse in JBoss on both Windows and Linux environments.
  • Highly experienced in Data modeling to support business requirement and Informatica Confidential velocity recommendations and best practices.
  • Solution architect / designer for interfacing applications to support real time & batch updates.
  • With business acumen and advance technical concepts, implemented highly integrated, scalable, real - time solutions in Master Data Management and Data Governance areas.
  • Extensive experience in Program/Project management helped clients achieve their enterprise goals within timeline and budget.
  • Identified issues with the Informatica Confidential application and interfaced with Informatica Support & Engineering team for resolution. This helped the product to enhance more and benefited other customers.
  • Expertise in Confidential Project Implementation & support for multiple industries.
  • A highly motivated, energetic individual and a team player with excellent communication and interpersonal skills.

TECHNICAL SKILLS:

Data warehouse / Data Modeling: Informatica Power Center 10.1/9.5.1, ER Data modeling and Statistical, Informatica data quality (IDQ) 10.2, Informatica Master Management ( Confidential ) 10.2, Informatica Power Center 10.2, Informatica Meta Data Manager 10.2, Informatica Big data Management (BDM ) 10.2

OLAP Tools: WebFocus 7.1,Hyperion 8.1

Database: Oracle 11g, Teradata, DB2, TOAD, Teradata, SQL Server 2016,Netezza

Languages: C, SQL, PL/SQL, Perl scripting

Tools: MSOffice, Rational clear case, Remedy7/6

Operating System: Windows98/NT/2000/XP /UNIX.

Scheduler Tools: Maestro, ESP, Autosys

Data Warehouse/ETL Architect: Requirement assessment/analysis by meeting with SMEs, creating process flow and context diagrams, Developing full SDLC plans to implement ETL solutions, Defining and implementing ETL development standards and procedures, Identifying, recommending and implementing ETL process and architecture improvement

Data Modeling: Expertise in Dimensional Data modeling, Relational Data modeling, Star Join Schema modeling, Snow-Flake modeling, FACT and Dimensions tables, XML Schema, Physical and logical data modeling, Erwin Data Modeler

Data Governance: Defining Data Governance framework, analyzing data quality, defining and implementing data quality procedures and reporting policies, issues and corrective council to the Data Governance executive council for their approval

Confidential Architect: Accountable for identifying and verifying appropriate application solution alternatives and driving the entire technical design for the project including functional, integration, data and infrastructur design, and working closely with dedicated resources for each area, Collaborated with enterprise architecture organization to provide Confidential Stratergy for MasterData Management and related Integrated layers like Data lakes, Middleware,Collaborate with the Confidential Service team, SOA Team, Data Governance, and Business Partners to define functional and technical requirements for Confidential technology, Define/Design Confidential solution/architecture, Create the Confidential implementation roadmap, Lead the Confidential application and technical architecture analysis, design, and implementation, and ensure that the product fulfills the requirements.

PROFESSIONAL EXPERIENCE:

Confidential

Lead Architect

Responsibilities:

  • Accountable for identifying and verifying appropriate application solution alternatives and driving the entire technical design for the project including functional, integration, data and infrastructur design, and working closely with dedicated resources for each area.
  • Collaborated with enterprise architecture organization to provide Confidential Stratergy for MasterData Management and related Integrated layers like Data lakes, Middleware.
  • Collaborate with the Confidential Service team, SOA Team, Data Governance, and Business Partners to define functional and technical requirements for Confidential technology.
  • Define/Design Confidential solution/architecture.
  • Create the Confidential implementation roadmap.
  • Lead the Confidential application and technical architecture analysis, design, and implementation, and ensure that the product fulfills the requirements.
  • Define and review to-be Processes and Governance model.
  • Define/Design Data quality framework in IDQ
  • Collaborate with Data Architect team.
  • Define the Match Rules and Trust settings based on discussions with Business discussion
  • Define/design Address doctor and Web service API for real time.

Confidential

Senior Informatica Confidential Developer

Responsibilities:

  • Gathering requirements based on discussion with stake holders.
  • Create profile and analyze profile in IDQ for Data anomalies
  • Designing Cleans/Validation rules in IDQ.
  • Manage and Architect the development Confidential Solution Integrations of the mastering customer and provider information or data.
  • Design the data quality framework to enrich the customer data
  • Worked with Data Architect to created Data Model.
  • Create data quality Rules, Mappletes and mappings in IDQ for standardization.
  • Provide Promote IDQ rules, Mappletes and mappings from IDQ to Power Centre.
  • Create address doctor Mapping for address validation.
  • Create schema for Base objects
  • Configure hierarchies and relational type
  • Create and Configure Landing, Base objects, Staging tables,
  • Created ETL mappings to load Landing tables
  • Created mappings for Staging tables and Batch Groups for job and configured Delta detection in stage process.
  • Finalizing the Match Rules and Trust settings based on discussions with data stewards and data analysis.
  • Configured Fuzzy, Exact match types and configured Match and Merge settings.
  • Designed and implemented data governance hierarchies (region based hierarchy; based hierarchy, go to market view hierarchy).
  • Worked on POC and provide end to end solution for IDQ and Confidential .
  • Arranging Meetings with business stake holders to understand source systems.
  • Creating Functional, HLD and LLD documents.
  • Written Queries and packages for displaying and updating data by Data Manager and Merge Manager.
  • Configure Address doctor and support in Web service API for real time.
  • Used User Exit interface, SIF API and IDD.
  • Understand source Hierarchy model and designing same in Confidential .
  • Designing Matching and Trust rules in Confidential based on discussions with stake holders.
  • Presenting matched/unmatched customers information to stakeholders during the review
  • Involved the Confidential Target data model creation (i.e. creating the base objects).
  • Create mappings for loading landing tables.

Environment: Informatica PC 10.2 IDQ 10.2, Sql Server 2012, ORACLE12c, Confidential 10.2

Confidential, New Jersey

Informatica Developer

Responsibilities:

  • Work on POC and provide end to end solution for Confidential
  • Arranging Meetings with business stake holders to understand source systems.
  • Gathering requirements based on discussion with stake holders.
  • Creating HLD documents, LLD document, mapping sheets and also explaining to team.
  • Hands on experience on Informatica Confidential - Creating Landing, Base objects, Staging tables, mappings by using cleanse functions and configured Delta detection in stage process
  • Configured Fuzzy, Exact match types and configured Match and Merge settings.
  • Written Queries and packages for displaying and updating data by Data Manager and Merge Manager also created the Batch Group.
  • Used User Exit interface, SIF API and IDD
  • Understand source Hierarchy model and designing same in Confidential .
  • Designing Cleans/Validation rules in IDQ
  • Create Rules, Mappletes and mappings in IDQ
  • Promote IDQ rules, mappletes and mappings from IDQ to power center.
  • Designing Matching and Trust rules in Confidential based on discussions with stake holders.
  • Presenting matched/unmatched customers information to stakeholders during the review
  • Involved the Confidential Target data model creation (i.e. creating the base objects).
  • Create mappings for loading landing tables
  • Create profiles in IDQ to check anomalies in the data
  • Create standardization rules in IDQ
  • Assign tasks to Team members

Environment: Informatica 10.1/9.5, IDQ 9.6, Confidential 9.7.1, Sql Server2012, DVO, Netezza

Confidential, New Jersey

ETL/IDQ Architect

Responsibilities:

  • Analyze the business requirement and check the feasible in Informatica and pl/sql
  • Involved Data modeling
  • Design mapping technical and functional document and develop the mappings
  • Prepare Approach document and design document.
  • Migrate the informatica mappings and workflows from Dev to UAT and from UAT to Production Repositories
  • Involved informatica Administration
  • Optimizing the bad Performing mappings
  • Optimizing bad performing queries sql queries (Recommend index, partition or materialized view based queries bad status).
  • Doing POC to check feasible solutions in informatica
  • Assigning and tracking individual task with Team members
  • Review the code developed by Peers
  • Involved in recruitment process
  • Review the code developed by Peers
  • Involved in Informatica and Data modeling Practice in the company
  • Create profile in IDQ analyze data

Environment: Informatica 9.5, IDQ 9.5.1 Sql Server, Oracle 10g,DVO,Netezza

Confidential, New York

ETL Architect

Responsibilities:

  • Analyze the business requirement and check the feasible in Informatica, Unix and Pl/Sql
  • Involved Data modeling
  • Design mapping technical and functional document and develop the mappings
  • Create stored procedures and Unix shell scripts
  • Prepare Approach document and design document.
  • Migrate the Informatica mappings and workflows from Dev to UAT and from UAT to Production Repositories
  • Involved Informatica Administration
  • Optimizing the bad Performing mappings
  • Creating test cases and testing the Informatica sessions
  • Optimizing bad performing queries Sql queries (Recommend index, partition or materialized view based queries bad status).
  • Write complex queries and shell script to execute workflow, to create parameter files which can used in Informatica
  • Doing POC to check feasible solutions Informatica
  • Assigning and tracking individual task with Team members
  • Review the code developed by Peers
  • Involved in recruitment process
  • Review the code developed by Peers
  • Involved in Informatica and Data modeling Practice in the company

Environment: Informatica 9.1,8.6, 8.1, DB2,Oracle 10g, BO, Unix, Autosys

Confidential, Los Angeles

ETL Developer/Architect

Responsibilities:

  • Get the requirement and do the impact analysis
  • Assigned the task to Team members
  • Analyze Db2 system and Mappings
  • Prepare Approach document and design document.
  • Prepared up gradation approach document and coordinating with various team
  • Upgraded Informatica 8.6 .1 to Informatica 9.0.1
  • Optimizing the mappings
  • Coordinating the production move
  • Involved Informatica Administration act ivies
  • Developed the Mapping Design Document.
  • Creating test cases and testing the Informatica sessions
  • Used most of the transformations such as the Source qualifier, Router, Aggregator, Joiner, Lookups, Expression, and Filters & Sequence to integrate data to the target.
  • Worked with Different sources such as Relational Databases, Flat Files.
  • Optimizing Sql queries.
  • Review the Informatica code

Environment: Informatica 8.6, 8.1, 9.0.1 Sql server 2008, DB2 MicroStrategy

Hire Now