We provide IT Staff Augmentation Services!

Sr. Etl/mdm Consultant/team Lead Resume

CA

SUMMARY:

  • Around 12 years of professional IT experience in System analysis, design, development, Data Warehouse/Data Mart design, development and implementation of client server applications with strong business understanding knowledge of Pharmaceutical, Healthcare, payment processing and Inventory management projects.
  • About 4 years of experience in Master Data Management (MDM) and Very good knowledge with MDM Hub & IDQ, IDD and Informatica Could for SFDC.
  • Around 5 years Informatica Administration experience.
  • About 8 years of strong Data warehousing ETL experience using Informatica Power Center 10.1.1/9.6.1/9.1.0/8.6 , Power Mart 5.1.2 (Repository Manager, Server Manager, Mapping Designer, Mapplet Designer, Transformation Developer, Warehouse Designer, Workflow Manager and Workflow Monitor).
  • Good experience working with SFDC (Salesforce) data loader.
  • Very good experience working with Power Exchange for SAP, SFDC and Oracle CDC (PowerExchange Navigator).
  • Good experience with AutoSys 3.4, the scheduling and operations automation software for distributed computing environments.
  • Strong experience using Oracle 11g/9i/8i/8.0, MS SQL Server 2000, MS Access 97/2000 in Software Analysis, Testing, Design, Development and Production Support in Data Warehousing under Windows NT/2000/XP environment.
  • Worked with Oracle, MS SQL Server 2000, and Sybase and MS Access databases.
  • Expertise in Database Design and Database Programming (Stored procedures, Triggers, Packages, PL/SQL) using SQL Server 2000, Oracle 8.0
  • Experience in Manual Testing and Debugging.
  • Domain knowledge on Health care, Manufacturing and Sales Management.
  • On site experience in Hospital Care Management (Domain Knowledge).
  • Experience in Agile methodology as a lead and worked with offshore team
  • Developing system documents like Functional Specifications, Technical Specifications etc. Excellent Analytical, Communication skills.

TECHNICAL SKILLS:

ETL: Informatica Power Center 10.1.1/9.6.1/9.1/8.6.1/7.1.3/6.2.1, Informatica Data Quality (IDQ), DVO, Informatica Cloud (IOD), PowerExchange 9.1

MDM Tool: Informatica MDM Hub 10.2/9.7/9.0.1

Languages: C, C++, Java, VBScript, PERL Script, XML

Database: Oracle 11g, SQL Server 7.0 / 2000, MS access 2000 and Teradata.

Source Code Control System: Visual SourceSafe 6.0

Reporting Tools: Business Objects, Cognos Report Studio

EDI Tools: Mercator 5.0/ 6.0/6.5/6.7 (Mercator Design Studio, Mercator Enterprise Manager, Database Interface Designer, Integration Flow Designer)

Tools: ERWIN, Autosys 3.4, Appworx, Redwood

Operating System: Windows XP / 2000 / NT, UNIX.

PROFESSIONAL EXPERIENCE:

Confidential, CA

Sr. ETL/MDM Consultant/Team lead

Responsibilities:

  • Managing Team, Timelines and Coordinating with the Business Partners.
  • Allocated work to team members and mentored them by aiding them in completion of tasks to ensure smooth delivery.
  • Mentored and trained new associates and team members
  • Worked with Informatica Data Quality (IDQ) 10.1 for data cleansing, data matching and data conversion.
  • Hands on experience on developing IDQ Profiles
  • Built several reusable components on IDQ using Parsers Standardizers and Reference tables
  • Installed and configured Address Doctor (In house version Global addresses).
  • Good understanding of activeVos flows for real time data integration
  • Involved in implementing the Land Process of loading the customer Data Set into Informatica MDM from various source systems (Data integration).
  • Worked with different sources like SURF, flat files, SAP HANA, MS SQL Server.
  • Managing the DEV/QA/UAT/PROD environments with High Availability and GRID setup
  • Configured and installed Informatica MDM Hub server, cleanse server, and Address Doctor5.10 in Development, QA, Pre - prod and Prod Environments.
  • Performed Daily Deployments (DEV-TEST, TEST-UAT, UAT-PROD)
  • Power Center & Data Quality Systems Administration.
  • Lead a team of 5 ETL developers to maintain the day to day operations.
  • Configured Landing Tables, Base Objects, Relationships, Staging Tables, Mappings, custom cleanse functions, Match and Merge settings, Trust and Validation Rule
  • Worked on ETL jobs to schedule Batch Groups for all the domains and called via ETL workflows which call corresponding MDM SIF API's.
  • Data Quality and Data integration in real-time using SIF API's
  • Involved in SIF integration to develop xml code for external applications to perform search match API calls against MDM Hub Data.
  • Configured Queries and Packages for all the domains for use in IDD
  • Created Task Assignment in IDD for Account creation.
  • Applied HF and EBF's in Informatica Versions

Environment: Informatica 10.1, IDQ 10.1, Address Doctor 5.10, DVO, Informatica MDM HUB 10.1, Linux (Red Hat), SQL Server 2012, SAP HANA

Confidential, Walnut Creek, CA

Sr ETL/ Informatica Administrator

Responsibilities:

  • Mentored and trained new associates and team members
  • Provide Administration support, security setup and maintenance, deployment automation, enforce the standards
  • Configure Informatica Integration Service to run on Grid, Configure the Repository Service and Integration Service for High Availability
  • Configure OS Profiles to maintain security multiple project teams.
  • Upgraded INFORMATICA environment from version 9.1.0 to 9.6.1( Hotfix 2)
  • Install of patches, hotfixes up to date in regular basis.
  • Performing regular Administration activities from Managing system resources, users and database to the fine-tuning level and implemented the project successfully.
  • Collaborated with Project Manager, Business analysts for requirements gathering for business analysis and design.
  • Interacted with data analysts and business users to develop data profiles and analyzed source data using IDQ.
  • Analyzed the data based on requirements, wrote down the techno-functional documentations and developed complex mappings using Informatica Data Quality (IDQ) Developer to remove the noises of data using Parser, Labeler, Standardization, Merge, Match, Case Conversion, Consolidation, Address Validation, Key Generator, Lookup, Decision etc
  • Prepared Technical design documents and source to target mapping specifications according to Business Requirements.
  • Documented ETL Design Document for test plans, test cases, test scripts, test procedures,
  • Working with PowerExchange SAP plug-in to read data from SAP system.
  • Created "Informatica PowerExchange Datamaps" to pull data from Oracle Source Systems and imported the Datamaps into Source Analyzer by using Informatica PowerCenter Designer.
  • Used SQL tools like Query Analyzer and TOAD to run SQL queries and validate the data. Tuning the Mappings for Optimum Performance.
  • Deploying the Informatica objects to Production Server using Change request in VMware service Management.
  • Involved in the maintenance and production support operations on weekly basis
  • Create a solution document for ETL team using Informatica
  • Worked with UNIX shell scripts for job execution and automation.
  • Installed & Configured MDM Hub(10.1) on Dev, Test (part of MDM POC project)

Environment: Informatica PC 9.6.1,IDQ 9.6.1,Informatica DVO, PowerExchange 9.1, Oracle 11g, Toad 9, SAP, Flat Files, IDQ, UNIX Shell Scripting.

Confidential, South San Francisco, CA

Senior ETL/ MDM Consultant

Responsibilities:

  • Defining and documenting business functionality form various inbound source systems and creating technical design documents in-line with the business requirement.
  • Interacted with data architects and business users to develop data profiles and analyzed source data.
  • Implementing the standards of creating Informatica Workflows.
  • Extensively used Informatica Power Center 9.1/8.6 to develop ETL code to pull data from various sources like SFDC, Oracle, XML and Flat files to the target Locations.
  • Played an important Key role to create data model according to the requirements.
  • Defined the Base objects, Staging tables, foreign key relationships, static lookups, dynamic lookups, queries, packages and query groups.
  • Created Mappings to get the data loaded into the Staging tables during the Stage Process.
  • Analyzed the data based on requirements, wrote down the techno-functional documentations and developed complex mappings using Informatica Data Quality (IDQ) Developer to remove the noises of data using Parser, Labeler, Standardization, Merge, Match, Case Conversion, Consolidation, Address Validation, Key Generator, Lookup, Decision etc
  • Used the Address Doctor to validate the address and performed exception handling. Created different rules as mapplets, Logical Data Objects (LDO), workflows.
  • Created IDD application and Subject Areas, Subject Area Groups, Deploy and test IDD application, cleanse functions, utilizing timeline, export and import master data from flat file.
  • ETL mappings were developed to perform tasks like validating file formats, business rules, database rules and statistical operations.
  • Created and scheduled Sessions, Jobs based on demand, run on time and run only once using Workflow Manager and UNIX scripts.
  • Validated the mapping and integrity of data populated in the database using SQL queries.
  • Created Data marts for audit reporting from MDM CDC (history tables)

Environment: Informatica 9.1/8.6, PowerExchange 9.1, Oracle 11g, Toad 9.0.1, SFDC, SAP, Flat Files, Redwood(Scheduling tool), MDM Hub 9.7, IOD (Informatica Cloud), IDQ,IDD, UNIX Shell Scripting.

Confidential, Mountain View, CA

Sr. ETL Developer/ Analyst

Responsibilities:

  • Prepared Technical design documents and source to target mapping specifications according to Business Requirements.
  • Handled onsite-offshore communication.
  • Designed and implemented the data models for data warehouse (Physical as well as logical).
  • Developed Build, Transaction and Error Reporting Mapping for ePayment Reporting project.
  • Coordinated with QA team during QA cycles and UAT (User Acceptance Test).
  • Developed UNIX shell scripts to post the datasets in secured shared server.
  • Performance tuning of ETL processes.
  • Used XML Generator Transformation to read data from multiple sources and generate the XML messages.
  • Provided the End user with XML messages.

Environment: Informatica 8.1.5, Oracle 9i, Oracle 11i ERP, PL/SQL, Toad 9.0.1, Appworx 6, UNIX Shell Scripting.

Confidential, SFO, CA

Informatica Developer

Responsibilities:

  • Prepared Technical mapping specifications referring Business Requirements for SLDM project.
  • Developed Build, Transaction and Error Reporting Mapping for SLDM project.
  • Worked with Business Analyst and development teams and gathered future requirements for SLDM project.
  • Worked Closely with Advent group to gather requirements for Advent Transaction Mapping.
  • Created Job docs and Jil’s for scheduling nightly jobs in Autosys.
  • Prepared QA and Preproduction Release notes.
  • Involved in Pre-prod testing.
  • Coordinated with QA team during QA and Preproduction testing process for SLDM project.
  • Involved in trouble shooting the existing mappings and optimized existing mappings.
  • Developed UNIX shell scripts.
  • Created Mapplets which were used in all mappings to test data truncation and populate truncation table.

Environment: Informatica 8.1.1, Oracle 9i, PL/SQL, Toad 8.6, Autosys, UNIX Shell Scripting

Confidential, Sunnyvale, CA

ETL Developer/ Analyst

Responsibilities:

  • Involved in analyzing the scope and re-designing the architecture
  • Prepared design documents
  • Developed Informatica mappings, sessions & workflows for data load
  • Developed unit test cases
  • Performance tuning of ETL processes
  • Developed UNIX scripts
  • Handled onsite-offshore communication

Environment: Informatica 7.1.1, Oracle 9i, PL/SQL, Toad 8.6, Appworx, UNIX Shell Scripting

Confidential, Irvine, CA

ETL Developer

Responsibilities:

  • Involved in the upgrade process from PowerMart 5.1.2 to PowerCenter 7.12 and also in fixing the bugs during the upgrade process.
  • Extensively used Informatica PowerCenter version control for Team based development and provided the team members with the version control best practices document.
  • Created Labels, Queries and Performed the Repository Deployment from a Versioned Repository to a Non-versioned Repository.
  • Developed several mappings, tasks and workflows.
  • Involved in identifying bugs in existing mappings by analyzing the data flow, evaluating transformations and fixing bugs so that they conform to the business needs.
  • Written JIL scripts for Autosys scheduler and integrate with autosys.
  • Created Folder Deploy scripts to migrate folders between the repositories.
  • Used SQL tools like Rapid SQL for Sybase to run SQL queries and validate the data loaded in to the target tables.
  • Used UNIX scripting and Scheduled PMCMD to interact with Informatica Server from command mode.

Environment: Informatica PowerMart 5.1.2/PowerCenter 7.1.2, Windows 2000/XP Pro, Rapid SQL 7.3.1 for Sybase, Autosys 3.4.2, UNIX Shell Scripting and Sybase ASE 12.5

Confidential, CA

ETL Developer

Responsibilities:

  • Interacted with the Business Personnel to analyze the business requirements and transformed the business requirements into the technical requirements.
  • Worked with various Informatica client tools like Source Analyzer, Warehouse designer, Mapping designer, Mapplet Designer, Transformation Developer, Informatica Repository Manager and Workflow Manager.
  • Developed complex mappings using various transformations like Source Qualifier, Expression, Filter, Aggregator, Lookup, Update Strategy, Stored Procedure, Sequence generator, Joiner Transformations and Router Transformation.
  • Used Informatica Workflow Manager for Creating, running the Sessions, Worklets and Workflows and scheduling them to run at specified time.
  • Wrote pre-session and post-session stored procedures to drop the indexes, to re-create the indexes, and to make joins in the database.
  • Used Shortcuts in different folders to avoid re-importing or copying in all the folders for sources and targets and used Synonyms in the database.
  • Used SQL tools like TOAD to run SQL queries and validate the data loaded in to the target tables.
  • Fine-tuned existing Informatica mappings for Performance Optimization.
  • Worked with Debugging, Troubleshooting, Testing, and Documentation of the current application.
  • Worked in up gradation of version from Informatica 6.2 to Informatica 7.1.3.

Environment: Oracle 9i/10g, Informatica Power Center 7.1.3, Windows XP Pro, TOAD for Oracle, Power Connect for Mainframes.

Hire Now