We provide IT Staff Augmentation Services!

Sr. Etl Idq /mdm Developer Resume

5.00/5 (Submit Your Rating)

Southbury, CT


  • About 6+ years of experience in Information Technology with a strong background in Database development and Data warehousing and ETL process using Informatica Power Center and IDQ (Informatica Data Quality).
  • Strong experience in creating ETL processes using Informatica Power center, Informatica Designer (joiner,expressions, lookups, filters, stored procedures etc.,), Informatica Workflow Manager (Sessions, Sources, targets, transformations etc., & direct, indirect sources), Informatica Workflow Monitor, Informatica Administration Console and Repository Manager.
  • Expertise in Master Data Management concepts, Methodologies and ability to apply this knowledge in building MDM solutions.
  • Worked on Data Profiling using IDE - Informatica Data Explorer and IDQ-Informatica Data Quality to examine different patterns of source data. Proficient in developing Informatica IDQ transformations like Parser, Classifier, Standardizer and Decision.
  • Experience in several facts of MDM implementations including Data Profiling, Data extraction, Data validation, Data Cleansing, Data Match, Data Load, Data Migration, Trust Score validation.
  • Experience in integration of various data sources with Multiple Relational Databases like DB2, Oracle, SQL Server and worked on integrating data from flat files like fixed width and delimited.
  • Worked on MDM Hub configurations - Data modeling & Mappings, Data validation, Match and Merge rules, Hierarchy Manager, customizing/configuring Informatica Data Director (IDD).
  • Have extensively worked in developing ETL for supporting Data Extraction, transformations and loading using Informatica Power Center.
  • Expertise in full life cycle of ETL (Extraction, Transformation and Loading) using Informatica Power Center (Repository Manager, Server Manager, Mapping Designer, Workflow Manager, Workflow monitor).
  • Analyzed COBOL code for field level analysis.
  • Implemented performance tuning techniques at application, database and system levels.Experience in UNIX shell programming.
  • Solid understanding of Relational (ROLAP) and Multidimensional (MOLAP) modeling, broad understanding of data warehousing concepts, star and snowflake schema database design methodologies and Meta data management.
  • Expertise in working with Oracle Stored Programs, Packages, Cursors, Triggers, Database Link, Snapshot, Roles, Privileges, Tables, Constraints, Views, Indexes, Sequence, and Synonyms Dynamic SQL and SQL*Loader in distributed environment.
  • Expertise in working with different data sources like flat files, XML, Teradata, DB2, and Oracle.
  • Experience in SQL-tuning using Hints, and Materialized Views. Expertise in understanding Fact Tables, Dimension Tables, and Summary Tables.
  • Good exposure to development, testing, debugging, implementation, documentation, user & production support.
  • Have a clear understanding of Business Intelligence and Data Warehousing Concepts.
  • Excellent analytical and logical programming skills with a good understanding at the conceptual level and possess excellent presentation, interpersonal skills with a strong desire to achieve specified goals.


ETL Tools: Informatica Data Quality (IDQ), Informatica Power Center 9.6, Informatica PowerExchange, Informatica Data Quality (IDQ)

Reporting Tools: SSRS, Oracle BI Business Intelligence (OBIEE 10.1.3.x, Siebel Analytics 7.x.), Business Objects, Cognos 8.4 (Awareness).

Scheduling Tool: OBIEE DAC, Autosys, Tidal, Control M, Puppet, Chef

Operating System: UNIX, WINDOWS & LINUX

Database: Oracle 11g/10g/9i, Netezza,MS SQL Server 2012/2008/2005 , DB2, Teradata

Database tools: SQL PLUS, Toad, SQL Developer, SQL Assistant

Languages: Basic, PL/SQL, SQL,SQL* Loader, UNIX shell programming, C, C++,, COBOL


Confidential, Southbury CT

Sr. ETL IDQ /MDM Developer


  • Created ETL Design documents and technical specifications for ETL team to understand the Star & Snowflake Schema designs related to Fact & Dimension Tables in MDM.
  • Worked with Informatica Data Quality 9.6 (IDQ) toolkit, Analysis, data cleansing, data matching, data conversion, exception handling.
  • Identified and eliminated duplicates in datasets thorough IDQ 9.6 Algorithms of Edit Distance, Jaro Distance, Hammer Distance and Mixed Field matcher, It enables the creation of a single view of customers data.
  • Worked onInformaticaPower Center tools- Designer, Repository Manager, Workflow Manager, and Workflow Monitor.
  • Developed IDQ mappings using various transformation like Labler, Standarization,Case Converter, Match and Address validation Transformation
  • Extracted the provider records based on given requirement and sending the error messages for the records excluded from state file.
  • Used various transformations like Filter, Expression, Sequence Generator, Update Strategy, Joiner, Stored Procedure, and Union to develop robust mappings in the Informatica Designer.
  • Wrote SQL overrides and used filter conditions in source qualifier thereby improving the performance of the mapping.
  • Designing, document and configure the Informatica MDM Hub to support loading, cleansing, matching, merging, and publication of MDM data.
  • Developed IDQ mappings using various transformation like Labler, Standarization, Case Converter, Match and Address validation Transformation.
  • Worked on Informatica MDM tool for the data processing of the master data as required by the Business users.
  • Developed data conversion, quality, cleansing rules and executed data cleansing activities such as data Consolidation, and standardization for the unstructured flat file data.
  • Created various transformations such as Expression, Lookup, Joiner, Router, Filter, Aggregator and Sequence Generators.
  • Worked closely with MDM team and testing team to resolve any data issues.
  • Extensively used SQL Scripts and worked in UNIX Environment.
  • Extensively worked in the performance tuning of the ETL process at mapping and transformation level.
  • Monitored sessions using the workflow monitor, which were scheduled, running, completed or failed debugged mappings for failed sessions.
  • Worked on data cleansing and standardization using the cleanse functions in Informatica MDM.
  • Developed UNIX Shell Scripts to start the Informatica jobs using command line.
  • Worked withre-usablesessions,decisiontask,controltask andEmailtasks foron success, on failuremails.
  • Deploying and scheduling Reports using Business Objects to generate all daily, weekly, monthly and quarterly Reports including current status.

Environment: Informatica Power Center 9.6, Informatica Data Quality IDQ 9.6, Informatica MDM, Teradata 12, SSRS, Oracle 11/10g, PL/SQL, Perl Scripting, SSRS, Autosys, TOAD 9.x,Oracle Financials, Shell Scripting, python, Dynamic SQL, Oracle SQL *Loaderand UNIX.

Confidential, Billerica MA

ETL InformaticaDeveloper


  • Design and develop data migration mappings and workflows to load data from SQL Server to Oracle using Informatica.
  • Performed performance tuning of the Informatica jobs to load large volume of the data. Extensively used reusable objects like mapplets, sessions and transformations in the Mappings.
  • Developed sequential, concurrent sessions and validated them. Scheduled these sessions using workflowmanager.
  • Creating Informatica MDM Base objects, staging tables, mappings, setting up strong match rules and creating IDD applications.
  • Developed complex Informatica mappings using various transformations- Source Qualifier, Normalizer, Filter, Connected Lookup, Unconnected Lookup, Update strategy, Router, Aggregator, Sequence Generator, Reusable sequence generator transformation.
  • Designing, document and configure the Informatica MDM Hub to support loading, cleansing, matching, merging, and publication of MDM data.
  • Tuned target, source, transformation, mapping, and session to improve session performance Expertise in understanding the reporting requirements.
  • Developed stored procedures and tested the application with Toad. Developed PL/SQL procedures andfunctions to build business rules which are helpful to extract data from source and load data to target.
  • Created and maintained the Shell Scripts and Parameter files in UNIX for the proper execution of Informatica workflows in different environments.
  • Extensively used debugger to find out errors in mappings and later fixed themExpertise in running and controlling workflows using the pmcmd.

Environment: Informatica MDM, InformaticaPower Center 9.1, Power Designer,Power Exchange, Work Flows, ETL, Oracle 11g, Teradata, XML, SSRS, Web-Services, MS SQL Server, TOAD 9.6.1, Unix Shell Scripts, Autosys.

Confidential, Houston, TX

ETL Informatica Developer


  • Responsible for requirement gathering from various groups. Followed Iterative Waterfall model for Software Development Life Cycle Process (SDLC).
  • Designed and developed Informatica mapping codes to build business rules to load data.
  • Extensively worked on Informatica Lookup, stored procedure and update transformations to implement complex rules and business logic.
  • Analyzed and created facts and dimension tables.
  • Analyzed business requirements and worked closely with the various application teams and business teams to develop ETL procedures that are consistent across all applications and systems.
  • Developed the functionality at the database level PL/SQL using Toad tool as well at the Unix OS level using shell scripting.
  • Experienced in identifying and documenting data integration issues, challenges such as duplicate data, nonconfirmed data, and unclean data
  • Imported Source/Target Tables from the respective databases and created Reusable Transformations (Joiner, Routers, Lookups, Rank, Filter, Expression and Aggregator), Mapplets and Mappings using Designer module of Informatica.
  • Used Informatica power center for (ETL) extraction, transformation and loading data from heterogeneous source systems.
  • Participated in PL/SQL and Shell scripts for scheduling periodic load processes.
  • Worked extensively on SQL coding to check the data quality coming from the respective parties.
  • Worked cooperatively with the team members to identify and resolve various issues relating to Informatica and databases.
  • Applied performance tuning techniques for cubes to reduce calculate time and partitioned cubes.

Environment: InformaticaPower Center 8.1, Oracle 9i, SQL, PL/SQL, SQL*Plus,Unix Shell Scripting.


ETL Developer


  • Developed ETL mappings, Transformations and Loading using Informatica Power Center.
  • Extensively used ETL to load data from Flat file, MS Excel, which involved both fixed width as well as Delimited files and also from the relational database, which was Oracle.
  • Developed and tested all the Informatica mappings, sessions and workflows - involving several Tasks.
  • Worked on Dimension as well as Fact tables, developed mappings and loaded data on to the relational tabase.
  • Worked extensively on different types of transformations like source qualifier, expression, filter, aggregator, update strategy, Lookup, sequence generator, joiner, Stored Procedure.
  • Analyzed the session, event and error logs for troubleshooting mappings and sessions.
  • Provided support for the applications after production deployment to take care of any post-deployment issues.

Environment: SQL Server 2000/ 2005,PL/SQL,SSIS,T-SQL,SQL*LOADER, Microsoft Office, Windows 2003/XP.

We'd love your feedback!