We provide IT Staff Augmentation Services!

Sr. Informatica/idq Developer Resume

3.00/5 (Submit Your Rating)

SUMMARY

  • Over 8 plus years of progressive hands - on experience in analysis, ETL processes, design and development of enterprise level data warehouse architectures, designing, coding, testing, integrating ETL.
  • Experience in Dimensional data modelling techniques, Slow Changing Dimensions (SCD), Software Development Life Cycle (SDLC) (Requirement Analysis, Design, Development & Testing), and Data warehouse concepts - Star Schema/Snowflake Modelling, FACT & Dimensions tables, Physical & Logical Data Modelling.
  • Experienced in integration of various data sources like Oracle 11g, 10g/9i/8i, MS SQL Server, XML files, Teradata, Netezza, Sybase, DB2, Flat files, into staging area and different target databases.
  • Expertise in the ETL Tool Informatica and have extensive experience in Power Center Client tools including Designer, Repository Manager, Workflow Manager/ Workflow Monitor.
  • Extensively worked with complex mappings using various transformations like Filter, Joiner, Router, Source Qualifier, Expression, Union, Unconnected / Connected Lookup, Aggregator, Stored Procedure, XML Parser, Normalize, Sequence Generator, Update Strategy, Reusable Transformations, User Defined Functions, etc.
  • Extensively worked on Relational Databases Systems like Oracle11g/10g/9i/8i, MS SQL Server, Teradata and Source files like flat files, XML files.
  • Worked with Informatica Data Quality 9.6.1 (IDQ) toolkit, Analysis, data cleansing, data matching, data conversion, exception handling, and reporting and monitoring capabilities using IDQ 9.6.1.
  • Experienced in mapping techniques for Type 1, Type 2, and Type 3 Slowly Changing Dimensions
  • Strong experience in SQL, PL/SQL, Tables, Database Links, Materialized Views, Synonyms, Sequences, Stored Procedures, Functions, Packages, Triggers, Joins, Unions, Cursors, Collections, and Indexes in Oracle.
  • Sound knowledge of Linux/UNIX, Shell scripting, experience in command line utilities like pmcmd to execute workflows in non-windows environments.
  • Designed complex Mappings and have expertise in performance tuning and slowly-changing Dimension Tables and Fact tables.
  • Expertise in Informatica Data Quality (IDQ) tool installation and Standardization, Address Validation and Deduplication.
  • Have hands on experience in tools like Address Doctor which is used for Address validations
  • Good Experience in working with Teradata utilities like (BTEQ, FASTLOAD, FASTEXPORT, MULTILOAD).
  • Extensive experience using database tool such as SQL *Plus, SQL *Developer, Autosys and TOAD.
  • Proficient in Oracle Tools and Utilities such as TOAD and SQL*Loader.
  • Identified and fixed bottlenecks and tuned the complex Informatica mappings for better Performance.
  • Excellent analytical, problem solving, technical, project management, training, and presentation skills.

TECHNICAL SKILLS

ETL Tools: Informatica PowerCenter 10.1/9.6.1/9.5/9.1/8.6 , Informatica Cloud, Informatica Power Exchange, Informatica Power Connect and Master Data Management (MDM), Data Quality Tool (IDQ), Informatica Data Services(IDS) 9.6.1Databases Oracle12C/11g/10g/9i/8i/8.0 Teradata14.1, DB2 UDB 8.1, MS SQL Server 2008/2005, Netezza and DB Artisan (Sybase) ASEOperating Systems UNIX (Sun - Solaris, HP-UX), Linux, Windows NT/XP/Vista

Programming: SQL, SQL-Plus, PL/SQL, TSQL, Perl Scripting, UNIX Shell Scripting

Data Modelling: Dimensional Data Modelling, Star Schema Modelling, Snow Flake Modelling, FACT, Dimensions, Relational Modelling, Physical, Logical Data Modelling, and ER Diagrams.

Tools: Erwin, Tivoli Job Scheduler.

Other Tools: SQL Navigator, SQL for DB2, Quest Toad for Oracle, Toad for Data Analyst, SQL Developer, Autosys, Control M, MS Excel, MS Access, SSIS

PROFESSIONAL EXPERIENCE

Sr. Informatica/IDQ Developer

Confidential

Responsibilities:

  • Good proficiency in Informatica Data Quality 9.5.1/9.6.1 and Informatica power center 9.x/8.x/7.xs.
  • Extensively used ETL to load data using Power Center from source systems like Flat Files into staging tables and load the data into the target database Oracle. Analyzed the existing systems and made a Feasibility Study.
  • Involved in full software development lifecycle from the throughout the development and support finance industry using Informatica Power Center, Repository Manager, Designer, Workflow Manager, and Workflow Monitor.
  • Experience in ETL processes utilizing Informatica Power center tools to design data conversions from a variety of relational, XML and flat file source systems to data warehouse/data marts.
  • Design reference data and data quality rules using IDQ and involved in cleaning the data using IDQ in Informatica Data Quality 9.1 environment.
  • Created mappings in Informatica Data Quality (IDQ) using Parser, Standardizer and Address Validator Transformations.
  • Developed several IDQ complex mappings in Informatica a variety of Power Center, transformations, Mapping Parameters, Mapping Variables, Mapplets & Parameter files in Mapping Designer using Informatica Power Center.
  • Experienced in creating IDQ mappings using Labeler, Standardizer, Address Validator transformations with Informatica Developer and migrated to Informatica Power Center.
  • Profiled the data using and performed Proof of Concept forInformatica Data Quality(IDQ).
  • Design, document and configure the Informatica MDM Hub to support loading, cleansing of data.
  • Worked on data cleansing and standardization using the cleanse functions in Informatica MDM & Worked on maintaining the master data using Informatica MDM
  • Imported the mappings developed in data quality (IDQ) to Informatica designer.
  • Worked on Informatica Analyst Tool IDQ, to get score cards report for data issues.
  • Wrote UNIX Shell Scripts for Informatica Pre-Session, Post-Session and Autosys scripts for scheduling the jobs (work flows).
  • Used Autosys for Scheduling the Informatica Workflows & have done testing using Autosys scheduling tool.
  • Provided Knowledge Transfer to the end users and created extensive documentation on the design, development, implementation, daily loads, and process flow of the mappings.

Environment: Informatica Power Center 10.1/9.6.1, Data Quality 9.6.1, UNIX, SQL, MDM, Autosys, Oracle 11g/10g.

Sr. Informatica Developer

Confidential

Responsibilities:

  • Developing the ETL components as well as Oracle procedures, functions & triggers.
  • Defined Trust and validation rules for the base tables & created PL/SQL procedures to load data from Source Tables to Staging Tables
  • Created Oracle PL/SQL Cursors, Triggers, Functions and Packages
  • Used IDQ transformation like labels, standardizing, proofing, parser, address doctor, Match, Exception transformations for standardizing, profiling and scoring the data.
  • Worked on data cleansing and standardization using the cleanse functions in Informatica MDM.
  • Performed land process to load data into landing tables of MDM Hub using external batch processing for initial data load in hub store.
  • Data governance application for Informatica MDM Hub that enables business users to effectively create, manage, consume, and monitor master data using IDD (Informatica Data Director).
  • Worked on IDQ parsing, IDQ Standardization, matching, IDQ web services.
  • Scheduled the batch jobs in Autosys to automate the process.
  • Designed and Developed SSIS Packages using various Control Flow and Data Flow items to Transform and load the Data from various Databases using SSIS.
  • Worked on Teradata Utilities like Fast-Load, Multi-Load & Fast-Export.
  • Involved in writing Autosys jobs, JIL file for Box as well as Command jobs.
  • Created run books for job information which is scheduled on Autosys.

Environment: Informatica Power Center 9.6.1, MDM, UNIX, Oracle, Shell, IDQ, PL/SQL, Tidal, Autosys, Oracle 11g/10g, Teradata 14.0.

ETL Developer

Confidential

Responsibilities:

  • Documented high and low-level design document specifications for source-target mapping, based on the transformation rules.
  • Documented technical requirements for ETL process and Design documents for each source. Designed, Developed and Supported Extraction, Transformation and Load Process (ETL) for data migration.
  • Used IDQ's standardized plans for addresses and names clean ups.
  • Worked on IDQ file configuration at user's machines and resolved the issues & used IDQ to complete initial data profiling and removing duplicate data.
  • Design reference data and data quality rules using IDQ and involved in cleaning the data using IDQ in Informatica Data Quality(IDQ) environment.
  • Created and used the Normalizer Transformation to normalize the flat files in the source data.
  • Worked on Maestro job scheduling and Unix Scripting.
  • Involved in finding production status by using Autosys commands.
  • Developed UNIX shell scripts to run the pmcmd functionality to start and stop sessions, batches and scheduling workflows.
  • Experience in working with reporting team in building collection layer for reporting purpose.

Environment: Informatica Power Center 9.6.1/9.5.1 , IDQ, Oracle 11g/10g, Autosys, Flat File, Windows.

ETL / Informatica Developer

Confidential

Responsibilities:

  • Designing the dimensional model and data load process using SCD Type 2 for the quarterly membership reporting purposes.
  • Derived the dimensions and facts for the given data and loaded them on a regular interval as per the business requirement.
  • Extracted data from multiple sources such as Oracle, XML, and Flat Files and loaded the transformed data into targets in Oracle, Flat Files.
  • Designing and coding the automated balancing process for the feeds that goes out from data warehouse.
  • Implement the automated balancing and control process which will enable the control on the audit and balance and control for the ETL code.
  • Improving the database access performance by tuning the DB access methods like creating partitions, using SQL hints, and using proper indexes.
  • All the jobs are integrated using complex Mappings including Mapplets and Workflows using Informatica power center designer and workflow manager.
  • Use debugger in identifying bugs in existing mappings by analyzing data flow, evaluating transformations, and create mapplets that provides reusability in mappings.
  • Analyzing the impact and required changes to in corporate the standards in the existing data warehousing design.
  • Following the PDLC process to move the code across the environments though proper approvals and source control environments & Source control using SCM.

Environment: Informatica Power Center 9.1/8.5, Power Exchange, UNIX, Oracle 10g,SQL Server 2008, SQL Assistant, DB2.

ETL Developer

Confidential

Responsibilities:

  • Involved in analysis, design, development, test data preparation, unit and integration testing, Preparation of Test cases and Test Results
  • Coordinating with client, Business and ETL team on development
  • Developed Batch jobs using extraction programs using COBOL, JCL, VSAM, Datasets, FTP to Load Informatica tables
  • Involved in full project life cycle - from analysis to production implementation and support with emphasis on identifying the source and source data validation, developing logic, and transformation as per the requirement and creating mappings and loading the data into BI database.
  • Based on the business requirements created Functional design documents and Technical design specification documents for ETL Process.
  • Developing code to extract, transform, and load (ETL) data from inbound flat files and various databases into various outbound files using complex business logic.
  • Most of the transformations were used like Source Qualifier, Aggregator, Filter, Expression, and Unconnected and connected Lookups, Update Strategy.
  • Extensively worked with the Debugger for handling the data errors in the mapping designer.
  • Created events and various tasks in the work flows using workflow manager.
  • Responsible for tuning ETL procedures to optimize load and query Performance.
  • Created automated shell scripts to transfer files among servers using FTP, SFTP protocols and download files.
  • Expertise in creating control files to define job dependencies and for scheduling using Informatica.
Environment: Informatica Powercenter 8.5/8.1, ETL, Business Objects, Oracle 9i/8i, PL/SQL.

We'd love your feedback!