We provide IT Staff Augmentation Services!

Etl Informatica Developer Resume

PROFESSIONAL SUMMARY:

  • Over 9 years of IT experience, ETL Designer and Developer, using Informatica Power Center 9.5, 9.1, 9.0.1/ 8.6.1 and Informatica Data Quality, Oracle 11i/10g/9i.
  • Expertise in using Informatica (Repository Manager, Server Manager, Mapping Designer, Workflow Manager, Workflow Monitor, Transformation Developer, Source Analyzer) and DAC (Data ware house Application Console).
  • Excellent testing experience in all phases and stages of Software Testing Life Cycle and Software Development Life Cycle (SDLC) with good working knowledge of testing methodologies, disciplines, tasks, resources and scheduling.
  • Worked on various domains including Health, Insurance, Finance, Retail and Energy.
  • Strong knowledge of Data warehouse concepts - Star Schema, Snowflake and Slowly Changing Dimensions.
  • Involved in Full Life Cycle Development of building a Data Warehouse including agile and waterfall methodologies.
  • Experience working with Informatica Data Quality tool Developer and Analyst tool. Carried out data analysis, data matching, and data conversion and reporting.
  • Developed several complex mappings in Informatica a variety of PowerCenter transformations, Mapping Parameters, Mapping Variables, Mapplets & Parameter files in Mapping Designer using both the Informatica PowerCenter and IDQ.
  • Experience on creating profile, rules and mappings with IDQ.
  • Experience working with IDQ transformations like Labeller, Parser, Standardizer etc.
  • Knowledge in software development, maintenance, testing and troubleshooting on Master Data Management (MDM), data integration and Oracle database environment.
  • Strong knowledge of Data warehouse concepts - Star Schema, Snowflake and Slowly Changing Dimensions (SCD) Type I and II.
  • Closely worked on developing the business rules for cleansing and performed data profiling & various data quality rules development using Informatica Data Quality.
  • Interacted with end users to resolve Informatica Power Center issues and coordinated with Informatica support for patches and bug fixes.
  • Developed complex mappings using various transformation logic like Source Qualifier, Router, Filter,Expression, Sorter, Aggregator, Joiner, Union, Connected/Unconnected lookups, Update Strategy and Normalizer and loaded data into different target types from different sources like Flat files (Delimited files and Fixed width files) like text files or CSV files, XML, Oracle, IBM Mainframe, Cobol files, SQL server, DB2, Teradata.
  • Good exposure in writing BTEQ scripts and loading data into Teradata using FASTLOAD, MLOAD and TPUMP utilities.
  • Experienced in writing Unix Shell Scripts for the automation of ETL processes and using schedulers like Autosys, Ctrl-M.
  • Good communication and interpersonal skills, ability to learn quickly, with good analytical reasoning and adaptive to new and challenging technological environment
  • Ability to quickly adapt to different project environments, work in teams and accomplish difficult tasks independently within timeframe.

TECHNICAL SKILLS:

ETL Tools: Informatica Power Center 9.x/8.x, IDQ

Database Tools: Oracle 11g/10g/9i/8i, T-SQL, MS SQL Server 2012/2008/2005, Sybase SQLServer 12.0/11.x, Teradata V2R12/V2R6, MS Access 7.0/2000, SQL, PL/SQL,DB2 UDB 8.0/7.0/6.0

Development Languages: SQL, PL/SQL, UNIX, Shell Scripting

Data Bases: Oracle 11g/10g, My SQL

Operating Systems: Windows XP/7, UNIX, Sun OS

BI Tools: Crystal Reports

Scheduling: Informatica Scheduler, Control M, Autosys, Tidal

Web Technologies: Java, HTML, XML, Eclipse.

Others: Toad, PL/SQL Developer, WinSCP, Putty, MS Office, Remedy

PROFESSIONAL EXPERIENCE:

Confidential

ETL Informatica Developer

Responsibilities:

  • Worked on Informatica - Source Analyzer, Data warehousing designer, Mapping Designer &Mapplet and Transformations.
  • Developed ETL procedures to ensure conformity, compliance with standards and lack of redundancy, translates business rules and functionality requirements into ETL procedures using Informatica Power Center.
  • Implemented logical and physical data modeling with STAR schema techniques in Data Mart.
  • Performance tuning of Informatica sessions for large data files has been done by increasing block size, data cache size and, sequence buffer length.
  • Extensively used various transformations Lookup, Update Strategy, Expression, Aggregator, Filter, Procedures and Joiner etc.
  • Extensive experience in extraction of data from various sources like relational databases Oracle, SQL Server, Flat Files, MS Access & XML Files and DB2.
  • Used Informatica Power Center Workflow manager for session management, database connection management and scheduling of jobs to be run in the batch process.
  • Worked on creating profiles, profile models, rules and mappings with IDQ.
  • Created Profiles using IDQ rules and filters.
  • Developed several complex mappings in Informatica a variety of PowerCenter transformations, Mapping Parameters, Mapping Variables, Mapplets & Parameter files in Mapping Designer using both the Informatica PowerCenter and IDQ.
  • Implementation of SCD type1/type2/type3 in existing ETL interfaces for capturing slowly changingdimensions.
  • Performed planning and execution of large data conversion.
  • Extensively used Toad utility for executing SQL scripts and worked on SQL for enhancing the performance of the conversion mapping.
  • Developed UNIX Shell scripts to automate repetitive database processes and maintained shell scripts for data conversion.
  • Source data was extracted from Oracle, SQL Server, flat files, COBOL sources
  • Implemented Change data capture and incremental logics in inventory ETL Interfaces by identifying the audit columns for the data.
  • ETL mapping Documents for every mapping and Data Migration document have been developed for smooth transfer of project from development to testing environment and then to production environment.
  • Worked in debugging using Session Log messages, Server Messages.
  • Performed extraction, transformation and loading of data from RDBMS tables and Flat File sources into Oracle 9i in accordance with requirements and specifications.
  • Used TOAD to run SQL queries.
  • Extensively used SQL*Loader to load data from flat files to database tables in Oracle.
  • Responsible for the analyzing and comparing complex data from multiple sources (Oracle, flat files).
  • Responsible for writing Unix Shell Scripts to schedule the jobs.
  • Actively interacted with business analysts.
  • Worked with Business analysts and the DBA for gathering requirements and for project coordination.

Environment: Informatica PowerCenter v9.1, IDQ,Oracle 11g, IMS Database (DB1), DB2, Teradata, SQL, Flat Files, Putty, Windows-XP (Client), Mainframe, Unix, AS/400, TOAD 9.0, MS Visio, ILM, Informatica servers on Unix and PowerExchange.

Confidential, Washington, D.C

Informatica/IDQ Developer

Responsibilities:

  • Interacted with business community and gathered requirements based on changing needs. Incorporated
  • Developed Informatica Mappings/Workflows to load domain data from Sybase Database, Flat Files into Db2.
  • Used IDQ to profile the project source data, define or confirm the definition of the metadata, cleanse and accuracy check the project data, check for duplicate or redundant records, and provide information on how to proceed with ETL processes.
  • Worked with InformaticaData Quality(IDQ) toolkit, Analysis, data cleansing, data matching, data conversion, exception handling, and reporting and monitoring capabilities of IDQ 9.1.0
  • Profiled customer data and identified various patterns of the phone numbers to be included in IDQ plan.
  • Data extraction and data Transfer Sybase Database using utilities / tools like BCP, and BULK INSERT.
  • Designed Informatica complex Mappings and Workflows to be re-startable after a failure.
  • Used Informatica Designer to create complex mappings using different transformations like Filter, Router, Connected & Unconnected lookups, Stored Procedure, SQL Transformation, Joiner, Update Strategy, Expressions and Aggregator transformations to pipeline data to Data Mart.
  • Designed tables required for the execution of the ETL processes using Erwin.
  • Developed DB2 SQLs for the ETL and for populating run statistics.
  • Used scripts to import and export data to from the database.
  • Developed Slowly Changing Dimensions for Type 1 SCD and Type 2 SCD.
  • Developed UNIX Shell scriptsfor File Manipulation, FTP, Executing DB2 SQLs and archiving log files.
  • Implemented various Performance Tuning techniques on Sources, Targets, Mappings, Sessions, Workflows and database.
  • Involved in designing Logical/Physical Data Models (Star Schema), forward/reverse engineering using Erwin.
  • Prepared Technical Documents related to design, development and testing as per CMM.
  • Implemented reusable mappings & sessions for Operational Audit Process.
  • Created mappings to keep historical data (SCD type 2) and load control for ETL extract.
  • Prepared the technical specifications using use cases and maintained versioning & deployment groups’ functionality.
  • Involved in monitoring of production ETL applications, Production Support through tickets. Executing
  • Scripts / Managing scheduled activities based on business requirements.

Environment: Informatica Power Center 8.6.1, IDQ 8.6.1, CDC, IBM DB2 UDB 8, Facets 4.51, Sybase, Erwin 4.2, SQL Server 2005, Oracle11g, Excel, Flat files, SQL, PL/SQL, Win SQL, Windows XP, UNIX Shell Scripts, IBM AIX 5.3.4

Confidential, Charlotte, NC

Informatica Developer

Responsibilities:

  • Involved in requirements gathering and analysis to define functional specifications.
  • Extensively worked on Process Design, Development, Testing and Implementation of the Project.
  • Analyzing existing database schemas and designing star schema models to support the users reporting needs and requirements.
  • Developed ETL processes to load data from different source systems such as Oracle and Flat Files into target systems i.e. Oracle and Flat files.
  • Extracted the data from Oracle10g, Netezza, XML, Flat files, DB2 load the data in to Oracle warehouse.
  • Extensively worked on Informatica Power Center - Source Analyzer, Data warehousing designer, Mapping Designer, Mapplet & Transformations to import source and target definitions into the repository and to build mappings.
  • Developed mappings in Informatica to load the data from various sources into the Data Warehouse, using different transformations like Joiner, Aggregator, Update Strategy, Rank, Router, Lookup, Sequence Generator, Filter, Sorter, Source Qualifier.
  • Defined Target Load Order Plan for loading data into Target Tables
  • Used Informatics features to implement Type II changes in slowly changing dimension tables.
  • Created tables, views, primary keys, indexes, constraints and sequences.
  • Involved in developing optimized code using PL/SQL for Server related Packages to centralize the application through procedures, functions and packages.
  • Different database triggers containing PL/SQL were created and stored in the database and fired off when contents of database were changed.
  • Used debugger to test the mapping and fixed the bugs.
  • Created and configured workflows, Worklets & Sessions to transport the data to target systems using Informatica Workflow Manager.
  • Provided Knowledge Transfer to the end users and created extensive documentation on the design, development, implementation, daily loads and process flow of the mappings.
  • Implemented performance tuning logic on Targets, Sources, mappings, sessions to provide maximum efficiency and performance.
  • Involved in the architecture and management of data governance with Business Intelligence team.
  • Used Control-M Tool to schedule shell scripts and Informatica jobs.
  • Performed Unit, Grid Integration, testing and validate results with end users.

Environment: Informatica Power Center 9.1, Informatica Data Quality, Oracle 10g, SQL Server, SSIS 2013, SSRS 2012, PL/SQL, MS Visio, UNIX Solaris/AIX, WINSCP.

Confidential, Atlanta GA

Informatica Developer

Responsibilities:

  • Developed Informatica mappings, reusable transformations. Developed and wrote procedures for getting the data from the Source systems to the Staging and to Data Warehouse system.
  • Extensively used transformations to implement the business logic such as Sequence Generator, Normalizer, Expression, Filter, Router, Rank, Aggregator, Look Up (Target as well as Source), Update Strategy, Source Qualifier and Joiner, Designed complex mappings involving target load order and constraint based loading
  • Create/build and run/schedule workflows and worklets using the Workflow Manager.
  • Extensively worked in the performance tuning of the programs, ETL Procedures and processes. Coded database triggers, functions and stored procedures and written many SQL Queries.
  • Helped coding shell scripts for various administration activities for daily backup. Involved in Physical schema implementation, objects like table-space, table rollback segments, Created database structures, objects and their modification as and when needed.
  • Performance Tuning of the Informatica Mappings by adopting Explain plans, cutting down query costs using Oracle hints, changing the mapping designs.
  • Responsible to tune ETL procedures and STAR schemas to optimize load and query Performance.
  • Optimizing/Tuning mappings for better performance and efficiency, Creating and Running Batches and Sessions using the Workflow Manager, Extensively used UNIX Shell scripts for conditional execution of the workflows.
  • Optimized the performance of Mappings, Workflows and Sessions by identifying and eliminating bottlenecks Performed Unit Testing at development level, Source code migration and documentation
  • Managed users & roles for database security, Maintained system security, control and monitor user access to database.
  • Involved in full life cycle development including Design, ETL strategy, troubleshooting Reporting, and Identifying facts and dimensions.
  • Managed the Metadata associated with the ETL processes used to populate the data warehouse.
  • Assigned predefined profiles and roles to the users to maintain database security, CPU activity, idle time and quota management on table-spaces

Environment: Informatica Power Center 8.6, SQL, MS SQL, Windows NT, SQL Server, SQL * Loader, UNIX shell scripting, Toad

Hire Now