We provide IT Staff Augmentation Services!

Etl/mdm Developer Resume

2.00/5 (Submit Your Rating)

SUMMARY:

  • Around 10 years of extensive experience in data modeling, data architecture, data management, data visualization,, data security, data virtualization, Data Integration, elastic computes like AWS / Azure / Google Cloud / Oracle Cloud / Confidential, various RDMS databases like Oracle, SQL Server, DB2, Sybase and extensively in Oracle, UNIX / Linux and Window platforms / environments.
  • Having architecting and development experience using Multidomain MDM tool Informatica 9.x and 10.x.
  • Sound knowledge on Informatica MDM architecture and configuring its components Hub Server(MRM, HM and AM), Hub Store (Master and ORS databases), Cleanse and Match servers, Hub Console and Informatica Data Director(IDD)
  • Experience in designing and configuring landing tables, staging tables, base objects, lookups, query groups, custom queries, packages, and hierarchies.
  • Expertise in Informatica MDM Hub Trust and Validation rules, Match column, Match path, Match and Merge Rules, Batch Jobs and Batch Groups.
  • Designed & developed multiple cleanse functions, Graph function and standardization scenarios using Address Doctor.
  • Configured to connect to third party data providers Dun & Bradstreet, Acxiom and IMS for data enrichment.
  • Configured Soap based SIF API calls by using Soap UI for performing multiple tasks in Informatica MDM Hub.
  • Experience in configuring Entity Base Objects, Entity Types, Relationship Base Objects, Relationship Types, Profiles using Hierarchy tool.
  • Successfully, setup the data and configured the components needed by Hierarchy Manager for MDM HUB implementation which included implementing hierarchies, relationships types, packages and profiles by using hierarchies’ tool in model workbench.
  • Experience in several facets of MDM implementations including Data Profiling, data migration, validation, reject processing and pre - landing processing.
  • Configured Informatica Data Director (IDD) for data governance to be used by the business users, IT Managers and Data Stewards and also implemented IDD using hierarchy configuration and created subject area groups, subject areas, subject area child, IDD display packages in hub and search queries for searching the data.
  • Configured Soap based SIF API calls by using Soap UI for performing multiple tasks in Informatica MDM Hub.
  • Sound knowledge on Informatica architecture - Client tools (Repository Manager, Designer, Workflow Manager, Workflow Monitor) and Server Manager components (Repository Service, Integration Service, Reporting Service, SAP BW Service and Web Services Hub).
  • Proficient in Data Warehouse Concepts like Star, Snowflake, Hybrid Schema design, ETL and ELT.
  • Experience in creating Transformations and Mappings using Informatica Designer and processing tasks using Workflow Manager to move data from multiple sources into targets and creating target flat files dynamically along with filenames.
  • Developed various mappings using Mapping Designer and worked with Aggregator, Filter, Router, Joiner, Source Qualifier, Lookup, Expression, Stored Procedure, Sorter and Sequence Generator,Transaction Control,Update Strategy transformations.
  • Performance tuning at transformation using Push-Down optimization and session partitioning techiques.
  • Very strong in implementation of data profiling, creating score cards, Creating reference tables and documenting Data Quality metrics/dimensions like Accuracy, completeness, duplication, validity, consistency.
  • Experience in analyzing trend charts from score cards to analyze the threshold which is to be considered in further development
  • Have good understanding and development of business rules for its Standardization, Cleanse and Validation of data in various formats.
  • Identifying performance bottlenecks at Target, Source, and transformation using the thread statistics.
  • Using Bulk loading techniques to improve session performance while loading data to databases Oracle, SQL Server, DB2 and Sybase.
  • Good operational knowledge in the development of Oracle SQL and PLSQL Objects.
  • Proficient in writing various kind of SQL like DML, DDL, DCL and DRL Query Language
  • Experience in writing Stored procedures, Triggers, Functions, Packages, DB Links, Sequences, Materialized Views(Snapshot), Materialized View Logs(Snapshot Logs) and other database objects.
  • Uunderstanding of Cloud Data Integration Services(IICS) and created POC.
  • Conceptual understanding and knowledge in Object-Oriented Programming.
  • Development experience using Agile/Scrum methodology and XP(Extreme Programming).
  • Knowledge in providing data through a Service Oriented Architecture (SOA).
  • Proficient in creating and maintenance of large Data Warehouses, Data Marts and OLAP Cubes.
  • Knowledge of performance boost in analytical queries using columnar (column major) format both in-memory and storage.
  • Build dimensional data models using tools like Erwin data modeling tool.
  • Proficient in data modelling techniques and notations (IE and UML).
  • Knowledge of Cloud Environments - AWS RDS, Aurora, Redshift, Azure SQL, Azure SQL Datawarehouse, Azure Cosmos DB.
  • Part of DevOps practice created automated test scripts for unit testing.
  • Proficient in Unix and Linux based environments.

PROFICIENCY:

Informatica Multidomain MDM (9.x, 10.x), Informatica Power Centre (8.x, 9.x, 10.x), and Informatica Data Quality (9.x, 10.x), Oracle SQL, PL/SQL, Dimensional Data Modelling, Data Warehousing Concepts, Core Java, Azure Data Lake, MicroStrategy, Shell Scripting, AutoSys

TECHNICAL SKILLS:

Primary Skills: Informatica MDM(9.6,9.7,10.0,10.1), Informatica Data Quality(9.6,10.1), Informatica Power Center(8.6,9.5,9.6,10.1), Oracle SQL, PL/SQL, Core JAVA, Linux

Secondary Skills: Shell Scripting, Windows Scripting, XML, XSD

RDBMS: Oracle 9i / 10g / 11g, SQL Server 2005

Tools: Used: Toad, SQL Developer, PLSQL Developer,Erwin 8.x/9.x, SSH Client, PuTTY, AutoSys, Tortoise SVN(Client), Altova XMLSpy, Textpad,ServiceNow,Jira

Platforms: HP-UX, Solaris, Linux, Unix, MS-Windows 2000 / XP / 2003 /2008 / 7 / 8

Others: HTML, TCP/IP, OSI Layers, GIT hub,Network Topologies.

PROFESSIONAL EXPERIENCE:

Confidential

ETL/MDM Developer

Responsibilities:

  • All facets of MDM implementations including Data Profiling, metadata acquisition, data migration, validation, reject processing and pre landing processing.
  • Performing requirement gathering analysis design development testing implementation support and maintenance phases of both MDM and Data Integration Projects.
  • MDM development includes creating Base object tables, staging tables and landing tables as per requirement in LLD.
  • Developing mappings using various cleanse functions and Address doctor to standardize and move data into Stage tables
  • Configured to connect to third party data providers Dun & Bradstreet.
  • Closely worked with other IT team members business partners data stewards stakeholders steering committee members and executive sponsors for all MDM and data governance related activities.
  • Defining and configuring Trust Score Validation rules, Match rules, and Merge settings, and created Queries & package to integrate the trust score.
  • Configuring the trust and validation in base object columns as per business requirement. Also configured many merge rules for Auto merge and Manual merge.
  • Involved in creating various Match rules,(Fuzzy match will be set based on token known as tokenization and Exact match will give exact record information)
  • Configured IDD for client usage on web application to access the master record and update the information in base object.
  • Developing the IDD application building Hierarchies as per the business needs.
  • Worked on Real Time Integration between MDM Hub and External Applications using SIF API for JMS.
  • Ran the load jobs for moving data from Staging tables to base object tables.
  • Setup SIF for java application communication and interfacing the IDD as required.
  • Created User exit features extending the functionality and features of MDM HUB.
  • Created and deployed applications in Informatica Data Director and binding application to a specific ORS
  • Used Metadata manager for validation, promotion, importing and exporting the ORS repositories to different environments.
  • Created ETL mappings to integrate data form disperate systems to ladning tables for MDM bacth process.
  • Used IDQ to create mappings to cleanse and standardize data using address doctor before loading to landing tables.
  • Performed testing on data validation, Batch Jobs and Batch groups
  • MDM outbound queue integration to Azure Data Lake, and AWS data stores.
  • Designed and implemented the Java cleanse functions and uploaded the JAR/WAR files to MDM.

Confidential

ETL/MDM Developer

Responsibilities:

  • Head complex ETL requirements; Design, Develop & Implement an Informatica based ETL solutions fulfilling stringent performance requirements.
  • Identify the existing ETL process and recommend ETL architecture improvements for better performance.
  • Perform Data Analysis & Data Profiling of various source systems and develop Data Integration strategies; Design Source-Target mappings conforming to Enterprise Data Warehousing standards.
  • Provide Requirements & Technical Specification Documents to the Business Stakeholders & Application Development Teams.
  • Extensively used Informatica Data Explorer (IDE) & Informatica Data Quality (IDQ) profiling capabilities to profile various sources, generate score cards, create and validate rules and provided data for business analysts for creating the rules.
  • Master Data Management MDM Data Integration concepts in large scale implementation environments.
  • All facets of MDM implementations including Data Profiling metadata acquisition data migration validation reject processing and pre landing processing.
  • Performing requirement gathering analysis design development testing implementation support and maintenance phases of both MDM and Data Integration Projects.
  • Creating landing tables Staging tables Base Tables as per the data model and data sources.
  • Developing mappings using various cleanse functions and Address doctor functions to move data into Stage tables
  • Defining Trust Score Validation rules Match rules and Merge settings.
  • Configured to connect to third party data providers Dun & Bradstreet, Acxiom and IMS for data enrichment.
  • Closely worked with other IT team members business partners data stewards stakeholders steering committee members and executive sponsors for all MDM and data governance related activities.
  • Developing the IDD application building Hierarchies as per the business needs.
  • Development includes two crucial jobs - Pre-landing job and Landing job in ETL.
  • MDM development includes creating Base object tables, staging tables and landing tables as per requirement in LLD.
  • Created mappings for moving data from landing table to staging tables.
  • Configuring the trust and validation in base object columns as per business requirement.
  • Ran the load jobs for moving data from Staging tables to base object tables. Base object tables more like Bo tables, Xref tables history tables etc.
  • Configured Trust and created Queries & package to integrate the Trust score.
  • Involved in creating various Match rules,(Fuzzy match will be set based on token known as tokenization and Exact match will give exact record information)
  • Also configured many merge rules for Auto merge and Manual merge.
  • Configured IDD for client usage on web application. Clients can access the master record and update the information directly in base object.
  • Setup SIF for java application communication and interfacing the IDD as required.
  • Created User exit features extending the functionality and features of MDM HUB.
  • Created and deployed applications in Informatica Data Director and binding application to a specific ORS
  • Used Metadata manager for validation, promotion, importing and exporting the ORS repositories to different environments.
  • Performed testing on data validation, Batch Jobs and Batch groups

Confidential

ETL/MDM Developer

Responsibilities:

  • Worked with Data Steward Team for designing, documenting and configuring Informatica Data Director for supporting management of MDM data.
  • Create Conceptual, Logical and Physical Data Models using Data Modeling Tools viz. ERWin in accordance with best architectural standards and best practices to ensure high data quality and reduced redundancy.
  • Publish relevant Data Modeling Artifacts at different stages of the project; Provide Walkthrough of the Data Models with the business and procure sign-off.
  • Optimize existing Data Models to support business enhancements.
  • Head complex ETL requirements; Design, Develop & Implement an Informatica based ETL solutions fulfilling stringent performance requirements.
  • Identify the existing ETL process and recommend ETL architecture improvements for better performance.
  • Perform Data Analysis & Data Profiling of various source systems and develop Data Integration strategies; Design Source-Target mappings conforming to Enterprise Data Warehousing standards.
  • Provide Requirements & Technical Specification Documents to the Business Stakeholders & Application Development Teams.
  • Extensively used Informatica Data Explorer (IDE) & Informatica Data Quality (IDQ) profiling capabilities to profile various sources, generate score cards, create and validate rules and provided data for business analysts for creating the rules.
  • Design & Develop Autosys Job Scheduler Scripts (JIL Scripts); Design & Develop UNIX Scripts to automate the scheduling jobs.
  • Identify ETL performance bottlenecks; Optimize Informatica mappings / sessions for better performance of extraction, transformation & load process of ETL architecture.
  • Execute projects using AGILE-SCRUM methodology, Track using JIRA; Be a Scrum Master to lead the team members use the Scrum Process to perform at the highest level.
  • Involved in implementing the Land Process of loading the customer Data Set into Informatica MDM from various source systems.
  • Worked on data cleansing using the cleanse functions in Informatica MDM.
  • Data Quality and Data integration in real-time using SIF API's.
  • Defined Trust and validation rules before loading the data into the base tables
  • Involved in SIF integration to develop xml code for external applications to perform search match API calls against MDM Hub Data.
  • Running the Stage Jobs, Load Jobs, Match and Merge Jobs using the Batch Viewer and Automation Processes.
  • Performed in creating tasks in the workflow manager and exported IDQ mappings and executed them using the scheduling tools.
  • Configured to connect and get customer data from Acxiom.
  • Publishing Data using Message Queues to notify external applications on data change in MDM Hub Base Objects.

Confidential

ETL Developer

Tools: & Technologies: Informatica power center 9.5, PosgreSQL,LINUX,pgAdmin,SQL Server 2012,ERWIN.

Responsibilities:

  • Work with Business Users & Application Development Teams to understand the existing systems “as is”, identify the business requirements, to implement data strategies, build data flows and develop Enterprise wide Data Models that supports long-term solutions.
  • Create Conceptual, Logical and Physical Data Models using Data Modeling Tools viz. ERWin in accordance with best architectural standards and best practices to ensure high data quality and reduced redundancy.
  • Publish relevant Data Modeling Artifacts at different stages of the project; Provide Walkthrough of the Data Models with the business and procure sign-off.
  • Optimize existing Data Models to support business enhancements.
  • Head complex ETL requirements; Design, Develop & Implement an Informatica based ETL solutions fulfilling stringent performance requirements.
  • Identify the existing ETL process and recommend ETL architecture improvements for better performance.
  • Perform Data Analysis & Data Profiling of various source systems and develop Data Integration strategies; Design Source-Target mappings conforming to Enterprise Data Warehousing standards.
  • Provide Requirements & Technical Specification Documents to the Business Stakeholders & Application Development Teams.
  • Devise a Data Warehouse Bus Matrix that identifies the business process based on requirements; Design Facts & Dimensions for an Enterprise Data Warehouse.
  • Develop Oracle, IBM DB2 & Informix Database Objects i.e., Stored Procedures, Functions, Triggers, Materialized Views, etc.
  • Extensively used Informatica PowerCenter 9.6/9.1/8, Informatica Data Quality (IDQ) 9.6/9.1 as ETL tool for extracting, transforming, loading and cleansing data from various source data inputs to various targets, in batch and real time.
  • Perform Tune DB - SQL & PL/SQL Scripts; Identify & Implement various DB objects viz. Indexes, Partitions, Materialized Views, Collections, Index Organized Tables, Clustering Objects, etc., to boost utmost performance of Enterprise Data Warehouse.

Confidential

Data Anyalyst

Responsibilities:

  • Developed ETL programs using Informatica to implement the business requirements.
  • Developed various mappings using Mapping Designer and worked with Aggregator, Lookup, Filter, Router, Joiner, Source Qualifier, Expression, Stored Procedure, Sorter and Sequence Generator transformations.
  • Automation of day to day batch support activities using ASP and Shell scripts.
  • Involved in knowledge transfer and documentation.
  • Optimized big mappings by reducing transformations used.
  • Optimizing performance tuning at Source, Target, Mapping and Session level.
  • Developed ETL programs using Informatica to implement the business requirements.
  • Effectively used Informatica parameter files for defining mapping variables, workflow variables, FTP connections and relational connections.
  • Created complex mappings which involved Slowly Changing Dimensions, implementation of Business Logic and capturing the changed data in the source systems.
  • Involved in enhancements and maintenance activities of the data warehouse including tuning, modifying of stored procedures for code enhancements.
  • Used debugger in identifying bugs in existing mappings by Analysing data flow, evaluating transformations.
  • Reviewed and analyzed functional requirements, mapping documents, problem solving and trouble shooting.
  • Performance tuning was done at the functional level and mapping level. Used relational SQL wherever possible to minimize the data transfer over the network.
  • Performed unit testing at various levels of the ETL and actively involved in team code reviews and creating mapping documents.

Confidential

Database Developer

Responsibilities:

  • Involved in Business Users Meetings to understand their requirements.
  • Designed, Developed and Supported Extraction, Transformation and Load Process (ETL) for data different business logic with Informatica 8.6
  • Developed various mappings using Mapping Designer and worked with Aggregator, Lookup, Filter, Router, Joiner, Source Qualifier, Expression, Stored Procedure, Sorter and Sequence Generator transformations.
  • Worked extensively with the connected lookup Transformations using dynamic cache.
  • Coded PL/SQL scripts.
  • Wrote UNIX scripts for the business needs and to capture data from different relational systems to flat files to use them as source file for ETL process.

We'd love your feedback!