We provide IT Staff Augmentation Services!

Sr. Informatica Developer Resume

PROFESSIONAL SUMMARY:

  • Around 8 Years of professional experience in designing and implementing Data Warehouse applications using Informatica PowerCenter 9.x/8.x/7.x in different business domains like finance, banking, Insurance and health care industries.
  • Involved in different phases of Data Warehouse Life Cycle including business requirements gathering, source system analysis, ETL design/development, project deployment, production support, maintenance of client/server Data warehouse and Data mart systems.
  • Extensively worked with various components of the Informatica PowerCenter tools - PowerCenter Designer, Repository Manager, Workflow Manager, and Workflow Monitor to create mappings for the extraction of data from various source systems.
  • Worked on various types of transformations like Lookup, Update Strategy, Stored Procedure, Joiner, Filter, Aggregator, Rank, Router, Normalizer, Sorter, External Procedure, Sequence Generator, and Source qualifier.
  • Experience in upgrading from Informatica PowerCenter 9.1 to Informatica PowerCenter 9.5.
  • Experience in monitoring the environments and suggesting improvements for stability and performance tuning using Database Tuning, Partitioning, Index Usage, and Aggregate Tables, Session partitioning, Load strategies, commit intervals and transformation tuning.
  • Worked on integration of multiple data sources and targets like Oracle, SQL Server, flat files, COBOL files and XML.
  • Good understanding in database, data warehousing concepts (OLTP & OLAP) and code management tools.
  • Implemented the concept of slowly changing dimensions (SCD) Type I and Type II to maintain current, historical data in the dimension.
  • Implemented Data Cleansing,Data Analysis, Data Profiling,Transformation Scripts, Stored Procedures/Triggers and necessary Test plans to ensure the successful execution of the data loading processes.
  • Extensively used SQL and PL/SQL to write Stored Procedures, Functions, Packages and Triggers.
  • Extensive experience in using Informatica tool, SSIS package for implementation of ETL methodology in Data Extraction, Transformation and Loading.
  • Extensively worked with Teradata utilities like BTEQ, Fast Export, Fast Load, Multi Load to export and load data to/from different source systems including flat files.
  • Good knowledge in Normalizing and De-normalizing the tables and maintaining Referential Integrity by using Triggers, Primary and Foreign Keys.
  • Experience in Dimension Data modeling concepts like Star Schema Modeling, Snow-Flake Modeling, FACT and Dimensions Tables, Physical and Logical Data Modeling.
  • Good knowledge of Master Data Management (MDM) concepts.
  • Developed UNIX Shell scripts to archive files after extracting and loading data to Warehouse and also wrote UNIX shell scripts to automate manual tasks.
  • Experience in Scrum, Agile and Waterfall models.
  • Full Software Development Life Cycle ( SDLC ) experience including Analysis, Design and Review of Business and Software Requirement Specifications.

TECHNICAL SKILLS:

ETL Tools: Informatica PowerCenter 9.x/8.x, Power Exchange 9.1/8.1, Informatica Developer 9.5

Languags: SQL, PL/SQL, C, C++, XML, HTML, Visual Basic 6.0

Operating Systems: UNIX, Windows XP/2007, Sun Solaris

Tools: PL/SQL, SQL, Developer 2000, Oracle Developer Suite, SQL Plus, Toad 8.x/9.x/10.x, SQL *Loader, Multi-Load, Teradata 12/13, SQL Assistant

Databases: Oracle 11g/10g, SQL Server 2000, Teradata 14/12, DB2

Job Scheduling: Autosys, TWS(Tivoli Workload Scheduler)

BI Tools: Cognos 9, QlickView 8.5, Business Objects XI R3

PROFESSIONAL EXPERIENCE:

Confidential

Sr. Informatica Developer

Responsibilities:

  • Logical and Physical data modeling was done using Erwin for data warehouse database in STAR SCHEMA
  • Extracted data from various centers with the data in different systems like Oracle Database and SQL Server and loaded the data into Teradata staging using Informatica Power Center 9.5.
  • Designed and developed various Informatica mappings using transformations like Expression, Aggregator, External Procedure, SQL transformation, Stored Procedure, Normalizer, Lookup, Filter, Joiner, Rank, Router and Update Strategy.
  • Worked on different tasks in Workflows like sessions, events raise, event wait, decision, e-mail, command, worklets, Assignment, Timer and scheduling of the workflow. Working on the User migration from one database (Bydesign) to other database (EBS).
  • Migrating code from Dev to QA, QA to UAT and UAT to PROD. Maintaining the version control and release notes in GIT.
  • Creating the tickets for bugs and issues in JIRA and assign it to related teams.
  • Extracting the user data from EBS and loading into Data Ware house.
  • Implemented the concept of slowly changing dimensions (SCD) Type I and Type II to maintain current and historical data in the dimension.
  • Developed complex Informatica mappings to implement Change Data Capture (SCD) mechanism by using Type-2 effective date and time logic.
  • Wrote complex SQL Queries involving multiple tables with joins and also generated queries to check for consistency of the data in the tables and to update the tables as per the Business requirements.
  • Used Debugger to test the mappings and fixed the bugs .
  • Implemented restart strategy and error handling techniques to recover failed sessions.
  • Used Unix Shell Scripts to automate pre-session and post-session processes.
  • Used ERStudio to analyze and optimize database and data warehouse structure.
  • Supported the BI team by extracting operational data from multiple sources, merging and transforming the data to facilitate enterprise-wide reporting and analysis and delivering the transformed data to coordinated data marts.
  • Reviewed the defects raised by the UAT team and following up on the critical defects with the team to ensure to fix the defects.

Environment: Informatica PowerCenter 9.6, Informatica PowerExchange 9.5, Oracle EBS, Oracle 11g, UNIX, PL/SQL, SQL, Unix Shell Scripts, TOAD 10.1.1, Putty, Erwin 8.0, SQL *Loader, GIT, JIRA.

Confidential, Atlanta

Sr. InformaticaDeveloper

Responsibilities:

  • Coordinated with Business Users to understand business needs and implement the same into a functional Data warehouse design.
  • Translate requirements and high-level design into detailed functional design specifications.
  • Extracted data from various centers with the data in different systems like Oracle Database andSQL Server and loaded the data into Teradata staging using Informatica PowerCenter 9.5.
  • Involved in Migration from Informatica PowerCenter 9.1 to Informatica PowerCenter 9.5
  • Designed and developed various Informatica mappings using transformations like Expression, Aggregator, External Procedure, Stored Procedure, Normalizer, Lookup, Filter, Joiner, Rank, Router and Update Strategy.
  • Implemented the concept of slowly changing dimensions (SCD) Type I and Type II to maintain current and historical data in the dimension.
  • Developed complex Informatica mappings to implement Change Data Capture (SCD) mechanism by using Type-2 effective date and time logic.
  • Created critical re-usable transformations , mapplets and work lets wherever it is necessary
  • Integrated IDQ mappings, rules as mapplets within PowerCenter Mappings.
  • Created Stored Procedures, Functions, Packages and Triggers using PL/SQL.
  • Wrote complex SQL Queries involving multiple tables with joins and also generated queries to check for consistency of the data in the tables and to update the tables as per the Business requirements.
  • Extensively used SQL tools like TOAD, Rapid SQL and Query Analyzer, to run SQL queries to validate the data.
  • Involved in debugging Informatica mappings, testing of Stored Procedures and Functions, Performance and Unit testing of Informatica Sessions, Batches and Target Data.
  • Implemented restart strategy and error handling techniques to recover failed sessions.
  • Used Unix Shell Scripts to automate pre-session and post-session processes.
  • Used ERStudio to analyze and optimize database and data warehouse structure.
  • Used Autosys scheduler to schedule and run the Informatica workflows on a daily/weekly/monthly basis.
  • Developed Oracle PL/SQL Package, procedure, function and trigger.
  • Supported the BI team by extracting operational data from multiple sources, merging and transforming the data to facilitate enterprise-wide reporting and analysis and delivering the transformed data to coordinated data marts.
  • Assisted BI Developers to fetch Reports using QlickView 8.x .
  • Reviewed the defects raised by the UAT team and following up on the critical defects with the team to ensure to fix the defects.

Environment: Informatica PowerCenter 9.5/9.1, Informatica PowerExchange 9.5, Oracle 11g, UNIX,PL/SQL, SQL, Oracle 11g, Unix Shell Scripts, Embarcadero ERStudio Data Architect, TOAD 10.1.1, Autosys, Putty, Erwin 8.0, QlickView 8.5, SQL *Loader, SQL, PL/SQL.

Confidential, Arizona

Informatica Developer

Responsibilities:

  • Interacted with Business Analysts for Requirement gathering, understanding the Requirements, Explanation of technical probabilities and Application flow.
  • Developed ETL mappings, transformations using Informatica PowerCenter 9.1
  • Extracted data from flat files, DB2 and loaded the data into Oracle staging using Informatica PowerCenter .
  • Designed and created complex source to target mapping using various transformations inclusive of but not limited to Sorter, Aggregator, Joiner, Filter, Source Qualifier, Expression and Router Transformations.
  • Extensively used Lookup Transformation and Update Strategy Transformation while working with Slowly Changing Dimensions (SCD) and also performed reading and loading high-volume Type 2 dimensions.
  • Extensively used Informatica debugger to figure out the problems in mappings. Also involved in troubleshooting existing ETL bugs.
  • Implemented Incremental loading of mappings using Mapping Variables and Parameter Files.
  • Experienced in designing and developing Informatica IDQ environment.
  • Used Mapping Parameters and Mapping Variables based on business rules provided.
  • Wrote PL/SQL Procedures for data extractions, transformation and loading.
  • Assisted in Data Modeling and Dimensional Data Modeling.
  • Involved in Performance Tuning by determining bottlenecks at various points like targets, sources, mappings, sessions or system. This led to better session performance.
  • Scheduled workflow daily basis for incremental data loading.
  • Designed and developed UNIX shell scripts as part of the ETL process to automate the data load processes to target.
  • Developed BTEQ, MLOAD scripts to load data to Teradata Data mart.
  • Accomplished data movement process that load data from databases, files into Teradata by the development of Korn Shell scripts, using Teradata SQL and utilities such as BTEQ,FASTLOAD, FASTEXPORT, MULTILOAD.
  • Involved in Unit Testing, User Acceptance Testing (UAT) to check whether the data loads into target are accurate, which was extracted from different source systems according to the user requirements.
  • Maintained Version Control using Clear Case.
  • Scheduling jobs using Autosys to automate the Informatica Sessions.
  • Provided Production Support at the end of every release.

Environment: Informatica PowerCenter 9.1, Oracle 10g, Sql Server2000/2008, UNIX, COBOL, ERWIN 3.5, Shell script, Rapid-SQL, Toad, Teradata 12, Visio, Autosys, Clear Case.

Confidential, Hartford, CT

Informatica Developer

Responsibilities:

  • Used Informatica PowerCenter 8.6 for migrating data from various OLTP databases andother applications to the Radar Store Data Mart.
  • Worked with different sources like Relational , Mainframe (COBOL), XML, flat files (CSV) loaded the data into Oracle staging.
  • Created complex Informatica mappings with extensive use of Aggregator, Union, Filter, Router, Normalizer, Java, Joiner and Sequence generator transformations.
  • Created and used parameter files to perform different load processes using the same logic .
  • Extensively used PL/SQL for creation of stored procedures and worked with XML Targets, XSD’s and DTD’s.
  • Filtered Changed data using Power exchange CDC and loaded to the target.
  • Defined Target Load Order Plan and Constraint based loading for loading data appropriately into multiple Target Tables.
  • Used different Tasks ( Session, Assignment, Command, Decision, Email, Event-Raise, Event-Wait and Control ) in the creation of workflows.
  • Utilized the new utility Informatica Data Quality (IDQ) and Informatica Data Explorer (IDE) that came up with Informatica Version 8.
  • Performed performance tuning of source level, target level, mappings and session.
  • Involved in modifying already existing UNIX scripts and used them to automate the scheduling process.
  • Coordinated with testing team to make testing team understand business and transformation rules being used throughout ETL process.

Environment: Informatica PowerCenter 8.6, Informatica Exchange, Oracle 10g, XML, UNIX, PL/SQL, Windows 2000/XP, Autosys.

Confidential, Birmingham, AL

ETL/Informatica Developer

Responsibilities:

  • Interacting with the end users to get all the incomplete requirements and developed client satisfied code.
  • Performed Source System Data analysis as per the Business Requirement. Distributed data residing in heterogeneous data sources is consolidated onto Teradata staging using Informatica PowerCenter 8.3.
  • Used heterogeneous data sources Oracle, DB2, and XML Files, Flat Files as source also imported stored procedures from Oracle for transformations.
  • Developed Mappings, Sessions, Workflows and Shell Scripts to extract, validate, and transform data according to the business rules.
  • Identify the Fact tables and slowly changing dimensional (SCD) tables.
  • Extensively used SQL tools like TOAD, Rapid SQL and Query Analyzer, to run SQL queries to validate the data.
  • Developed BTEQ, MLOAD scripts to load data to Teradata Data mart.
  • Sourced the data from XML files, flat files, SQL server tables and Oracle tables.
  • Made substantial contributions in simplifying the development and maintenance of ETL by creating re-usable Mapplets and Transformation objects. Partitioned the sessions to reduce the load time.
  • Performed data cleansing and cache optimization.
  • Change Data Capture for Incremental Aggregation.
  • Involved in review of the mappings and enhancements for better optimization of the Informatica mappings, sessions and workflows.
  • Extensively worked in performance tuning of programs, ETL procedures and processes.
  • Performed Unit, Systems and Regression Testing of the mappings. Involved in writing the Test Cases and also assisted the users in performing UAT.
  • Extensively used UNIX shell scripts to create the parameter files dynamically and scheduling jobs using Autosys.
  • Created integration services, repository services and migrated the repository objects.
  • Written PL/SQL procedures for processing business logic in the database.
  • Provided production support and maintenance for all the applications with the ETL process.

Environment: Informatica PowerCenter 8.3, Oracle 10g, Teradata12, SQL, PL/SQL, TOAD, Shell Scripts, UNIX (AIX), Tidal, SQL Assistance.

Confidential, Bellevue, Washington

SQL/ETL Developer

Responsibilities:

  • Used Informatica as an ETL tool to extract data from multiple source systems by creating mappings using various transformations.
  • Developed and tested mappings, sessions, work lets and workflows.
  • Developing and modifying changes in mappings according to business logic and also tuned them for better performance.
  • Worked on complex data loading (implemented the batch data cleansing and data loading).
  • Used BCP utility to publish table output to text files.
  • Worked on DTS Package, DTS Import/Export for transferring data from Heterogeneous Database to SQL Server.
  • Used Modification Language (DML) to insert and update data, satisfying the referential integrity constraints.
  • Performance tuning of SQL queries and stored procedures using SQL Profiler and Index Tuning Wizard.
  • Developed SQL scripts to Insert/Update and Delete data in MS SQL database tables.
  • Created Business-Crucial stored procedures and functions to support efficient data storage and manipulation.
  • Maintained a good client relationship by communicating daily status and weekly status of the project.

Environment: Informatica PowerCenter 8.1, UNIX, Shell Scripting, SQL Server 7.0/2000, Oracle 8 Enterprise Manager, SQL Profiler, DTS, PL/SQL, Replication, Linux

Hire Now