Sr. Informatica Developer Resume
Greensboro, NC
SUMMARY:
- 8 years of experience in Design, Development and Business intelligence and Maintain ETL process using Informatica 9/8.x and lower versions across Healthcare, Automotive, Financial and Insurance sectors.
- Expert knowledge in working with ETL tool Informatica Power Center 9.x/8.x
- Extensively used Informatica Repository manager, Power center Designer, Workflow manager, and Workflow Monitor.
- Proficient in Extraction, Transformation and Loading (ETL) of data from multiple sources into Data Warehouse.
- Experience in integration of various data sources like Oracle, Flat files, DB2 Mainframes.
- Experience in designing and developing complex mappings applying various transformations such as Expression, Aggregator, Lookup, Source qualifier, Update strategy, Filter, Router, Sequence generator, Rank, Normalizer, Sql, Union, Java, Salesforce lookup, Stored procedure, Joiner and Sorter.
- Extensive experience in performance tuning and resolving performance bottlenecks of sources, transformation, targets, mappings and sessions.
- Experienced in handling SCDs (Slowly Changing Dimensions) using Informatica PowerCenter.
- Expertise in Data warehousing concepts like OLTP/OLAP System, Star schema and Snowflake schema used in relational, dimensional modelling.
- Performance tuning of the Informatica mappings using various components like Parameter files, Variables and Dynamic Cache
- Used various database client tools like TOAD, SQL developer, SQL server, Teradata SQL Assistantto access/create/change database objects and create scripts.
- Monitored and scheduling in - house financial applications and ensure daily, weekly, and monthly processes successfully complete
- Working Experience in UNIX commands, DOS Scripts
- Extensively Worked in Performance of SQL Queries
- Extensively worked with Teradata, Oracle and SQL Server.
- Experience in using Oracle11g/10g/9i, SQL(DCL, DML, DDL, TCL), PL/SQL, and SQL Editor(SQL*Plus, TOAD).
- Automation and scheduling of Informatica jobs using AutoSys.
- Monitor functional and integration test execution on sales Force CRM, Veeva CRM. Experience working with force.com IDE, Data Loader, Apex Explorer and Salesforce.com Sandbox environments.
- Created page layouts, search layouts to organize fields, custom links, related lists, and other components on record pages.
- Excellent written and verbal communication skills, good analytical reasoning and ability to learn quick and high adaptability to new tools and technologies.
TECHNICAL SKILLS:
Data Warehousing ETL: InformaticaPowerCenter 9x/8x, Informatica Power Exchange9x,8x,IDQ
Data Modeling: Physical Modeling, Logical Modeling, Relational Modeling, Dimensional Modeling, Entities, Attributes, ER Diagrams.
Databases: Oracle 12g, 11g/10g/9i, MS SQL Server 2005/2000, Teradata, MS Access, DB2
Programming: SQL, PL/SQL,HTML,JAVA, Unix Shell Scripting
Other Tools: SQL Plus, TOAD, SQL developer, SQL server 8,12, AutoSys
Environment: UNIX, Windows (XP, / 2003/2005/2008 ).
Other: MS Office 2003/2007/2010/2013- Word, Excel, Outlook, PowerPoint, Notepad ++, Notepad, MS Visio, OneNote, Adobe Acrobat
PROFESSIONAL EXPERIENCE:
Confidential, Greensboro, NC
Sr. Informatica Developer
Responsibilities:
- Analyzed business requirements, performed source system analysis, prepared technical design document and source to target data mapping document
- Worked with Informatica power center 9x to extract the data from Oracle into Data warehouse
- Implemented Slowly Changing Dimensions - Type I & II in different mappings as per the requirements
- Created complex Informatica mappings to load the data mart and monitored them. The mappings involved extensive use of transformations like Aggregator, Filter, Router, Expression, Joiner, Sequence generator.
- Performed incremental aggregation, built slowly changing dimensions using lookup and update strategy transformations, used re-usable transformations
- Performance tuning of the Informatica mappings using various components like Parameter files, Variables and Dynamic Cache
- Developed various Transformations, validated and fine-tuned the ETL logic coded into mappings.
- Made substantial contributions in simplifying the development and maintenance of ETL by creating re-usable Mapplets and Transformation objects.
- Used Stored Procedure Transformation for truncating the target tables before loading the data to SQL Server staging.
- Experience in using Informatica Power Center (9.x/8.x/7.x), Data stage 8.7 and Informatica Bid Data Edition.
- Created equal partitions to ensure the smooth flow of data concurrently for better performance.
- Experience working with Informatica Big Data Edition. Experience pulling data from HDFS/Hive Sources using Informatica Developer 9.6.1 and Writing to Hive Targets.
- Used Mapplets, Parameters and Variables to implement Object Orientation techniques and facilitate the reusability of code.
- Monitored and scheduling in-house financial applications and ensure daily, weekly, and monthly processes successfully complete.
- Provided support to Informatica developers including creating users, granting user/group permissions, creating folders, data sources, connections, Exchange distribution lists and monitoring workflows.
- Extensive experience in implementation of Data Cleanup procedures, transformations, Scripts, Stored Procedures and execution of test plans for loading the data successfully into the targets
- Used dynamic group deployments for Repository level migrations
- Created error log tables and Data recoverable option in session level.
- Worked on Work flow Manager Tools - Task Developer, Work flow Designer & Work let Designer.
- Developed ETL processes to populate the Enterprise Product Orders data mart Dimensions and Fact using Informatica, Oracle SQL, UNIX shell scripts
Environment: Informatica Power Center 9x,Informtica PowerExchange 9x, Big Data, Oracle 12/11g, SQL Developer, Teradata, IDQ, TOAD, Putty, AutoSys¸ PL/SQL, Business Objects, Crystal Reports, Unix, Windows XP/7, SQL Server2012,Windows XP/7
Confidential, Palm Harbor, FL
Sr. Informatica developer
Responsibilities:
- Worked with business analysts, data modelers and database to help identify data sources.
- Responsible for definition, development and testing of processes/programs necessary to extract data from operational databases, Transform and cleanse data, and Load it into data warehouse using Informatica Power center.
- Worked with Informatica power center 9x to extract the data from Oracle into Data warehouse.
- Developed complex mappings in Power Center Designer using Expression, Filter, Sequence Generator, Update Strategy, Joiner and Stored procedure transformations.
- Developed connected and unconnected Lookup transformations to lookup the data from the source and target tables.
- Responsible for making suitable changes in the development environment as per the business requirement and also tuned for better performance
- Created Mapplets and used in different Mappings.
- Used designer debugger to test the data flow and fix the mappings. Involved in Unit testing of mappings, workflows and debugging mappings for failed sessions.
- Worked with mapping parameters and variables to load data from different sources to corresponding partition of the database table.
- Experience pulling data from HDFS/Hive Sources using Informatica Developer 9.6.1 and Writing to Hive Targets.
- Created Schema objects like Indexes, Views, and Sequences.
- Created several complex PL/SQL Packages, Procedures, Triggers and Functions to implement business logic at front end and also perform validations on the imported data from legacy system.
- Designed and developed table structures, stored procedures and functions to implement business rules and used application development tools like TOAD (Oracle) to develop SQL queries and stored procedures. Teradata as backend database.
- Designing and creation of complex mappings using SCD Types involving transformations.
- Developed UNIX shell scripts,commands to implement ETL process
- Involved in creating best practice documents for ETL Process.
- Collaborated with development and testing team to support end to end testing.
Environment: Informatica Power Center 9x, Informtica PowerExchange 9x, Oracle 11/10g, SQL Developer, TOAD, Big Data, Putty, PL/SQL, Unix, Windows XP/7, SQL Server.
Confidential, Chicago, IL
Informatica Developer
Responsibilities:
- Worked closely with client in understanding the Business requirements, data analysis anddeliver the client expectation.
- Used Informatica PowerCenter 9xand its all features extensively in migrating data from OLTP to Enterprise Data warehouse.
- Participated in Logical and Physical data modeling and designed Star Schemas.
- Extracted data from different sources like Oracle, flat files, XML, DB2 and SQL Server loadedinto DWH.
- Created complex mappings in Power Center Designer using Aggregate, Expression, Filter and Sequence Generator, Update Strategy, Union, Lookup, Joiner, XML Source Qualifier and Stored procedure transformations.
- Developed mappings/Reusable Objects/mapplets by using mapping designer, and mappletdesigner, transformation developer in Informatica Power Center 9.6.1/9.5.
- Handled slowly changing dimensions (Type I, Type II and Type III) based on the businessrequirements.
- Used Informatica Power Center Workflow manager to create sessions, batches to run withthe logic embedded in the mappings.
- Involved in creation of Folders, Users, Repositories and Deployment Groups usingRepository Manager.
- Developed PL/SQL and UNIX Shell Scripts for scheduling the sessions in Informatica.
- Worked along with the DBA to resolve performance and tuning issues.
- Provided reliable, timely support of integration, performance and user acceptance testingprocesses.
Environment: Informatica Power Center 9x, Informtica PowerExchange 9x, Oracle 11g,Teradata, DB2, XML, Flat files, CDC, SQL, PL/SQL, TOAD,SQL Server, Putty,Windows, UNIX.
Confidential, Tempa, Florida
Informatica Developer
Responsibilities:
- Involved in the requirement definition and analysis in support of Data Warehousing efforts.
- Created ETL design and mapping documents for the change requests and developed several Informatica mappings (Aggregator’s, lookup, sorter, filter, joiner etc.).
- Responsible for making suitable changes in the development environment as per the business requirement and also tuned for better performance.
- Created Mapplets and used in different Mappings.
- Used designer debugger to test the data flow and fix the mappings. Involved in Unit testing of mappings, workflows and debugging mappings for failed sessions.
- Tuned Informatica mappings and sessions for maximum efficiency and performance.
- Worked with mapping parameters and variables to load data from different sources to corresponding partition of the database table.
- Created Schema objects like Indexes, Views and Sequences.
- Created partitions, SQL over ride in source qualifier, session partitions for improving performance.
- Performed unit testing and system testing of the mappings developed and documented with various scenarios.
- Created several complex PL/SQL Packages, Procedures, Triggers and Functions to implement business logic at front end and also perform validations on the imported data from legacy system.
- Responsible for Backup recovery to all the mappings, sessions and workflows at the repository server
- Provided detailed technical, process and support documentation like daily process rollback and detailed specifications and very detailed document of all the projects with the workflows and their dependencies
Environment: Informatica Power Center 9x/8x, Informatica Power Exchange 8.0.1, TOAD, SQL, PL/SQL, Teradata, Putty, Java, Windows, UNIX Shell Script.
Confidential
Informatica Developer
Responsibilities:
- Involved in the requirement definition and analysis in support of data warehousing efforts.
- Involved in Designing the Data warehouse using Informatica ETL tool by using Source Analyzer, Warehouse Designer, Mapping Designer & Mapplet and Transformations.
- Developed ETL procedures to ensure conformity, compliance with standards and lack of redundancy, translating business rules and functionality requirements into ETL procedures.
- Developed almost all Transformations such as Filter, Aggregator, Expression, Router, Lookup, Joiner, Update Strategy and Rank.
- Extensively involved in Performance Tuning issues.
- Involved in Creating tasks, Worklets, workflows and Schedule, Run, Monitor sessions by using workflow manager and workflow monitor.
- Migrated Mappings, Sessions and Workflows from Development to Test and then to Production environment.
- Tuned performance of Informatica session for large data files by increasing block size, data cache size, sequence buffer length and target based commit interval.
- Tested the data and data integrity among various sources and targets. Associated with Production support team in various performances related issues.
- Involved in developing ad-hoc and business reports according to the requirement.
Environment: Informatica Power Center 8.x, Oracle, SQL loader, LINUX, UNIX, Windows 2000.