Sr. Informatica Developer Resume
NC
SUMMARY
- Over 8 Years of IT Experience in Analysis, Design, development, implementation and troubleshooting of Data warehouse applications.
- Expertise in building Enterprise Data Warehouses (EDW), Operational Data Store (ODS), Data Marts, using Multidimensional and Dimensional modeling (Star and Snowflake schema) Concepts.
- Demonstrated expertise in utilizing ETL tool Informatica power center 9.x/8.x/7.x for developing the Data warehouse loads as per client requirement.
- Good experience on Developing, Managing, Scheduling, and Monitoring of Informatica workflows.
- Created complex mappings using Lookup, Sorter, Aggregator, Union, Rank, Normalizer, Update strategy and Router transformations in an efficient manner.
- Extensively used transformations like Source Qualifier, Expression, Filter, Aggregator, Joiner, Lookup, Sequence Generator, Router, Sorter and Stored Procedures. And used debugger to test the mappings and fixed the bugs.
- Experienced in the data extraction process from various data sources like Oracle, SQL Server, XML files and Flat files etc.
- Involved in Informatica code deployment process using Informatica deployment groups and Import/Export option.
- Extracted Data from multiple operational sources and loaded into staging area, Data Warehouse and Data Marts using SCD (Type1/Type2/Type3) loads.
- Excellent knowledge in identifying performance bottlenecks and tuning the Informatica Load for better performance and efficiency.
- Very strong skills in writing SQL Queries and Procedures for development and testing Business applications.
- Experience in UNIX shell scripting, FTP and file management in various UNIX environments.
- Implemented the PMCMD command to run the workflows through UNIX shell scripts.
- Coded complex scripts and finely tuned the queries to enhance performance and also tested scripts by running workflows and assisted in debugging the failed sessions.
- Very good knowledge in working with Informatica Scheduler to schedule and run the jobs
- Highly motivated & Team oriented analyst with excellent interpersonal, collaborative, diplomatic, and documenting skills.
TECHNICAL SKILLS
ETL Tools: Informatica Power Center 9.x/8.x/7.x
Databases: Oracle 9i/10g/11g/11i, IBM DB2, SQL Server 2008
Data Access Tools: Toad 9.7, PL SQL, SQL
Web Technologies: HTML, JavaScript, Visual Basic
Programming: PL/SQL, Transact - SQL and Java, Shell Scripting
Tools & Technologies: MS Office Suite,, Quality Centre & IBM Rational Clear Quest and Clear Case, MS Visual source safe and Autosys
Operating Systems: Windows XP/98/2000/7, UNIX, LINUX
PROFESSIONAL EXPERIENCE
Confidential, NC
Sr. Informatica Developer
Responsibilities:
- Extensively involved in the requirements gathering process and analyzed the functional specs provided and created technical specs documents for all the ETL related process.
- Created System Design Specifications Document, Technical Design Document, Code Change Document.
- Extracted the data from the flat files and other RDBMS databases into staging area and populated onto Data warehouse
- Modified and developed mapping code according to the requirements and specifications of the client.
- Extensively used Expression, Filter, Joiner, Lookup, Router, Aggregator and Update Strategy transformations.
- Used the Debugger to run Debug sessions setting Breakpoints across instances to verify the accuracy of data.
- Created sessions, configured workflows to extract data from various sources, transformed data, and loading into data warehouse.
- Used PMCMD command to start, stop and ping server from UNIX.
- Created Test cases and detailed documentation for Unit Test, System, and Integration Test to check the data quality.
- Actively associated with Production support team in various performance and production related issues.
Environment: Informatica Power Center 9.5, DB2, Flat files, Oracle, UNIX and Windows 7.
Confidential, Chicago, IL
Software Developer
Responsibilities:
- Designed the logical data model and physical data model for the enhancement purpose as per the client requirements for EDW
- Extensively involved in the requirements gathering process and analyzed the functional specs provided and created technical specs documents for all the ETL related process
- Work closely with BA and Application developers to understand the source data, application structure to develop and create data warehouse process which is consistent with the application screens
- Developed various Sources to Stage and Stage to Target Informatica process using Informatica Power Center tools- Mapping Designer, Workflow Manager, Workflow Monitor and Repository Manager.
- Schedule the session tasks comprising of different mappings for data conversion and extraction in order to load data into target database.
- Migrated mappings, sessions and workflows from Development to testing and tan to Production Environments.
- Performed folder level migration from development to testing environment for ODS.
- Run Monthly EDW workflow in Production, troubleshoot session failures, and validate the data in Production.
- Monitor, schedule, and troubleshoot batches and sessions for weekly and daily extracts from various data sources across all platforms to the Target database.
- Involved in the maintenance process by changing and updating of the existing EDW complex mappings, sessions and workflows.
- Implemented the PMCMD command to run the workflows through UNIX shell scripts.
- Coded complex scripts and finely tuned the queries to enhance performance and also tested scripts by running workflows and assisted in debugging the failed sessions.
- Created Data Dictionary, EDW Stage load to Target Load process documents.
- Created Integration, UAT testing scenarios. Performed regression and unit testing.
Environment: Informatica 9.x and SQL Developer, Flat Files, HTML, XML, UNIX, VB.Net
Confidential, MA
Programmer Analyst
Responsibilities:
- Created design document Informatica mappings based on business requirement.
- Created Informatica Complex mappings using various Transformations like Joiner, Aggregate, Expression, Filter, and Update Strategy.
- Moved the mappings from development environment to test environment and tan to production environments.
- Interacted with the business community and database administrators to data realties.
- Created complex mappings using Unconnected Lookup, Sorter, Aggregator, Union, Rank, Normalizer, Update strategy and Router transformations in an efficient manner.
- Populated error tables as part of the ETL process to capture the records dat failed the migration.
- Tested scripts by running workflows and assisted in debugging the failed sessions.
- Improving workflow performance by shifting filters as close as possible to the source and selecting tables with TEMPfewer rows as the master during joins.
- Involved in the validation of the OLAP Unit testing.
- Involved in the Release Management team and verify the Production checklist documents necessary for the Production Activities.
- Created tasks and workflows in the Workflow Manager and monitored the sessions in the Workflow Monitor and also setup Project Folders in all Environments.
- Implemented the PMCMD command to run the workflows through UNIX shell scripts.
- Migration of developed objects across different environments.
Environment: Informatica Power Center 9.0.1, DB2, SQL Server, IBM Rational Clear Case, IBM Rational Clear Quest, HTML, XML, UNIX, Cognos 8.0.
Confidential, MA
Programmer Analyst
Responsibilities:
- Involved in complete Life Cycle of developing Enterprise Data Warehouse Application and, developing ETL Architecture using Informatica.
- Used legacy systems, Oracle, and Flat files sources to extract the data and to load the data.
- Interacted with Source system SME’s to analyze how various business processes have been tracked across the source tables.
- Designed Data warehouse target tables by using Dimensional Modeling Techniques - Star and Snowflake Schemas. Created Dimensions and Fact tables.
- Extracted data from various data sources such as Oracle and Flat file, and transformed and loaded into targets using Informatica.
- Created various complex mappings using different transformations such as Source Qualifier, Joiner, Aggregator, Expression, Filter, Router, Lookup, Update Strategy, and Sequence Generator etc.
- Designed and developed initial and incremental data loads using Informatica.
- Designed and Developed several mapplets and worklets for reusability.
- Executed sessions, both sequential and concurrent for efficient execution of mappings and used other tasks like event wait, event raise, email, command and pre/post SQL.
- Created tasks and workflows in the Workflow Manager and monitored the sessions in the Workflow Monitor and also setup Project Folders in all Environments.
- Implemented CDC using Informatica Power Exchange.
- Identified performance issues in existing sources, targets and mappings by analyzing the data flow, evaluating transformations and tuned accordingly for better performance.
- Involved in Unit testing, User Acceptance testing to check whether the data loads into target are accurate, which was extracted from different source systems according to the user requirements.
- Prepared the Standard Operating Procedure (Knowledge Transfer) document, which provides necessary information, required for the Maintenance and Operation of the application.
- Documented ETL test plans, test cases, test scripts, test procedures, assumptions, and validations based on design specifications for unit testing, system testing, expected results, preparing test data and loading for testing, error handling and analysis.
- Unix Scripts were written at various situations like event automation and job scheduling.
- Used Informatica debugging techniques to debug the mappings and used session log files and bad files to trace errors occurred while loading.
Environment: Informatica Power Center 8.6, Oracle, SQL, Toad, XML, Flat file, Windows XP, UNIX, Shell Scripting.
Confidential
Programmer
Responsibilities:
- Extraction, Transformation and data loading were performed using stored procedures into the database.
- Based on the requirements created Functional design documents and Technical design specification documents for ETL.
- Extracted data from various sources such as Flat files, XML’s and transformed and loaded into targets using Informatica.
- Created various complex mappings using different transformations such as Source Qualifier, Joiner, Aggregator, Expression, Filter, Router, Lookup, Update Strategy, and Sequence Generator etc.
- Designed and developed initial and incremental data loads using Informatica.
- Designed and Developed several mapplets and worklets for reusability.
- Created tables, views, indexes, sequences and constraints.
- Involved in testing of Stored Procedures and Functions. Designed and developed table structures, stored procedures, and functions to implement business rules.
- Involved in design and development of data validation, load process and error control routines.
Environment: Oracle 8i, Informatica 7.x, XML, Windows, UNIX, Putty