We provide IT Staff Augmentation Services!

Technical Lead - Data Integration Resume

3.00/5 (Submit Your Rating)

Houston, TX

SUMMARY

  • Extensively involved in different phases of Software Development Life Cycle (SDLC) such as business requirement gathering, analysis, developing applications, debugging, testing and support.
  • Defining and configuring Base Objects, Staging Tables, Landing Tables, and Look ups, Foreign Key Relationship, Hierarchies, Queries, Query Groups and Update/Display Packages.
  • Expertise in mapping data from Loading Tables to Staging Tables.
  • Expertise in Informatica MDM Hub Match and Merge Rules, Batch Jobs and Batch Groups.
  • Designed & developed multiple cleansing and standardization scenarios using Cleanse Functions
  • Expert in importing ORS data source in the application server environment for Informatica MDM Hub.
  • Well versed with importing and exporting the ORS repositories from different environments.
  • Expert in configuring Entity Base Objects, Entity Types, Relationship Base Objects, Relationship Types, Profiles using Hierarchy tool.
  • Hands on Experience in Extracting, Transforming, and Loading (ETL) data for data warehouse, data migration and other data conversion.
  • Strong experience in designing and developing complex mappings to extract data from different sources including flat files and RDBMS tables.
  • Designed Mappings and Workflows in Informatica PowerCenter 9.5
  • Experienced with utilizing ETL transformations like Source and Target Definition, Source Qualifier, Lookup Procedures, Expression, SQL Transform, Transaction Control and Router in PowerCenter mappings
  • Experience in writing complex SQL queries and PL/SQL, including the use of stored procedures, functions, Joins, Sub - Queries and Packages to implement business rules and validations.
  • Extensive experience in design of Multi-Dimensional modeling concepts like Star and Snowflakes schema.
  • Exposure in preparation of Technical Design document, Test cases and Unit test documents.
  • Strong experience in resolving SIT, UAT and Post Production issues within the SLA
  • Strong analytical, logical and problem solving skills and ability to quickly adapt to new technologies by self-learning.

TECHNICAL SKILLS

Master Data Management: Informatica MDM 9.x Multi Domain Edition, Siperian MRM

ETL: Informatica PowerCenter 9.5

ERP: Oracle E-Business Suite 11i and R12

Database Management: Oracle 10g/9i/8i, SQL Developer, TOAD

Languages: PL/SQL, SQL, XML/BI Publisher, VB.net, HTML

Operating Systems: Windows XP / 9X, Windows Server 2008, VMWare, Linux Redhat Enterprise and Linux CentOS 5

PROFESSIONAL EXPERIENCE

Technical lead - Data Integration

Confidential, Houston, TX

Responsibilities:

  • Coordinating with business users, enterprise data architects and data modelers in finalizing Downstream Clients requirements.
  • Creating Technical Specs to be used by Development and SIT teams.
  • Defining User Stories in HP Application Lifecycle Management (ALM) and MS Visual Studio.
  • Defining Acceptance Criteria of User Stories, Tasks and Story Points
  • Scrum Master for multiple projects
  • Defining Mappings and Workflow for Informatica PowerCenter 9.5/9.6 to access MDM’s Landing, BOs and Dimension tables.
  • Defining PowerCenter Mapplets for Downstream systems.
  • Utilizing ETL transformations like Source and Target Definition, Source Qualifier, Lookup Procedures, Expression, SQL Transform, Transaction Control and Router in PowerCenter mappings.
  • Defining job schedules in Integration and production environments using Tidal Job Scheduler.
  • Monitoring daily loads from Reltio and load to Dimension tables on SQL Server.
  • Supporting UAT and SIT data requirements for Downstream Systems.
  • Resolving the Defects and Change Request via HP Service Manager, GitHub and Jira.
  • Coordinating with offshore and onshore team for Planned and Emergency Releases.
  • Providing Production Support for exiting Downstream Systems.

Environment: Reltio Master Data Management, Informatica Multi Domain MDM 9.5, Informatica ETL PowerCenter 9.5, Tidal Enterprise Scheduler, WinSCP, Oracle 11g, MS SQL Server

MDM Specialist

Confidential, Houston, TX

Responsibilities:

  • Coordinated with project leads, business users, enterprise data architects and data modelers in finalizing the master data-model.
  • Utilized ERWIN data modeler to define entities, attributes and relationships.
  • Configured Base Objects, Staging Tables, Landing Tables and columns in the tables.
  • Involved in setting up Foundation Objects for Datamodels like Organizations, Business Relationships, Person and Person Privacy data models in MDM Hub.
  • Defined the Foreign Key Relationship between Base Objects.
  • Defined Mapping data from Loading Tables to Staging Tables.
  • Standardized the data using cleanse functions.
  • Created Queries and Query Groups to be used in Packages for IDD and Data Manager Tools.
  • Inserted and Updated records using Data Manager tools under Data Steward
  • Configured Entity Base Objects, Entity Types, Relationship Base Objects, Relationship Types, and Profiles using Hierarchies tool.
  • Defined Put / Update and Display Packages to be used in Hierarchy Manager.
  • Experienced in code deployment using Metadata Manager for Import and Export of Metadata and Promotion between environments from development to production.
  • Defined job schedules in Integration and production environments using Tidal Job Scheduler.
  • Troubleshooting the rejected records during the Landing, Staging and Loading process.
  • Resolving SIT and production support tickets using ALM.
  • Created Outbound Workflows to extract records from MDM tables to be used by Marketing and Privacy teams.
  • Coordinated with Informatica Support team for any Vendor issues.

Environment: Informatica Multi Domain MDM 9.5, Informatica ETL PowerCenter 9.5, Erwin Data-modeler Tidal Enterprise Scheduler, WinSCP, Oracle 11g, TOAD, SQL

Informatica MDM Consultant

Confidential, Chicago, IL

Responsibilities:

  • Defined the source systems in Systems and Trust model workbench.
  • Configured Base Objects, Staging Tables, Landing Tables and columns in the tables.
  • Defined the Foreign Key Relationship between Base Objects.
  • Defined Mapping data from Loading Tables to Staging Tables.
  • Designed and developed validation rules and match/merge rules and data cleansing using Informatica MDM Hub.
  • Standardized the data using cleanse functions.
  • Created Queries and Query Groups to be used by Packages, Data Manager and Merge Manager Tools.
  • Configured Entity Base Objects, Entity Types, Relationship Base Objects, Relationship Types, and Profiles using Hierarchies tool.
  • Defined Put / Update and Display Packages to be used in Hierarchy Manager.
  • Improved the data quality by Match analysis, analysis of the MDM system performance and tuning the performance by changing the existing cleanse function and match rules.
  • Experienced in Metadata manager to Import and Export of Metadata and Promote Incremental changes between environments from development to testing phase.
  • Created user groups, privileges and roles to the users using Security Access Manager (SAM).

Environment: Informatica Multi Domain MDM 9.5, Oracle 11g, TOAD, SQL Developer, WinSCP

Informatica MDM Consultant

Confidential, Minneapolis, MN

Responsibilities:

  • Performed Business Analysis and Requirement gathering
  • Configured Informatica Data Director (IDD) in reference to the Data Governance of users, IT Managers & Data Stewards.
  • Defined Base objects, staging tables loading tables and foreign key relationships.
  • Defined Trust Columns and Trust Scores for source system columns.
  • Standardized the data by validating, correcting, completing, or enriching it.
  • Created packages in MDM Hub for displaying/updating the data.
  • Created subject area groups, subject areas, subject area child, IDD display packages and search queries.
  • Migrated the code between different environments using Metadata Manager.
  • Created Match Paths, Match Columns for Match and Merge Process.
  • Performed Data Steward activities like manual updating and inserting data.
  • Used Metadata manager for validation, promotion, importing and exporting the ORS repositories to different environments.
  • Involved in performance tuning of the existing SQL queries.
  • Provided status reporting to the Higher Management and partnered withTesting, Business Information and Configuration Management/Support teams to ensure quality implementations and the rollout of standardized and supportable code.

Environment: Informatica Multi Domain MDM 9.1 (Formerly Siperian), Informatica Data Director (IDD) Oracle 11g, TOAD

Demographic Data Analyst

Confidential, Springfield, IL

Responsibilities:

  • Organized, analyzed and created reports for 2010 census data based on various attributes and factors to facilitate government policy decisions.
  • Supported Lead Poisoning Program with data reports using Teradata SQL in making policy decisions.
  • Compared the number of Lead Poisoning cases registered for the children under 36 months and 84 months in the year 2009 and 2010 by using Teradata SQL.
  • Utilized SPSS to process and generate reports from National Center for Health Statistics 2008 and 2009 raw data for enabling Community Transformation grant policy.
  • Retrieved and analyzed 97 participating Illinois Counties demographic census data based on race and ethnicity to facilitate information necessary for grant decision making.
  • Standardized and documented the process to use American FactFinder2, SPSS.
  • Supported development of IQUERY a public data access web portal though GUI design evaluations.

Environment: Census 2010, ACS 5-year estimate, Teradata SQL, MS Excel

Summer Intern

Confidential, Houston, TX

Responsibilities:

  • Strategized and implemented security measures on IT platforms to enhance information assurance across company systems.
  • Assessed Network security concerns and implemented programs like password vault to protect confidential information.
  • Rolled out the security measures in different departments of Linux, Windows and PeopleSoft.
  • Monitored for unsecure access, database entries in communication and infrastructure systems using Solarwinds.
  • Enhancing and ensuring security by monitoring systems for improper changes and addressing them manually or cross checking statistics between databases.

We'd love your feedback!