Sr. Informatica Developer Resume
Columbus, OH
SUMMARY:
- 8 years of IT experience in Data warehousing with emphasis on Business Requirements Analysis, Application Design, Development, testing, implementation and maintenance of Data Warehouse and Data Mart systems.
- Strong Experience of development and design of ETL (Extract, Transform and Loading data) methodology for supporting data transformations and processing, in a corporate wide ETL Solution using Informatica Power Center (9.x/8.x/7.x), Informatica Power Exchange (9.x/8.x/7.x).
- Worked extensively with Dimensional modeling, StarSchema, and Snowflake modeling, Physical and Logical data modeling using Erwin, Data migration, Data cleansing, Data profiling, Data masking, ETL Processes features for data warehouses.
- Extensive experience in ETL processes in extracting data from operational and legacy systems to data warehouse using Informatica understands complex mappings transformation rules, data formats and efficient in performance tuning of sources, mappings, targets and sessions.
- Designed and developed mappings, from varied transformation logic like Unconnected and Connected lookups, Router, Filter, Expression, Aggregator, Joiner, Stored Procedure, Update Strategy, SCD's Type1, Type2 and Type3 .
- Knowledge of Informatica administration in windows and Linux environment
- Proven experience at building, motivating and leading professional teams, managing projects and supporting client relationships .
- Knowledge of tools such as Erwin and MS Visio Professional .
- Experienced with Multiple Databases including Oracle 11g/10g/9i, Teradata13/12, MS SQL Server 2008/2000 and DB2.
- Experience in Informatica DAC Tool for Customizing Data warehouses and Creating Task and Task Groups in it.
- Worked on Oracle Procedure, Function, Package and Trigger.
- Worked on Teradata utilities BTEQ, FLOAD, FEXPORT, MLOAD and TPUMP.
- Developed test case’s for business and user requirements to perform System/ Integration / Performance testing .
- Experience on Debugger to validate the mappings and gain troubleshooting information about data and error conditions.
- Expertise in Performance Tuning of overall data warehouse, database, ETL and OLAP tuning coordinating with DBAs and UNIX Administrator for better performance.
TECHNICAL SKILLS:
ETLTechnologies: Informatica Power Center 9.1/8.6/8.1/7.1, 6.1, Informatica Power Exchange 9.1/8.6
Tools: Oracle Report Writer, MLOAD, TPUMP, BTEQ, FLOAD, SAS, SQR 3.0, Erwin 4.x/3.5/3.x, SQL, XML, XSL, PL/SQL, SQL*Plus, SQL*Loader and Developer
Databases and related Technologies: Oracle 11g/10g/9i, DB 2 8.0/7.0/6.0, Teradata 13/12, MS SQL Server 2000/7.0/6.5, MS Access 7.0/97/2000
OperatingSystem: Windows Server 2008/2003, UNIX, Sun Solaris 2.x.
PROFESSIONAL EXPERIENCE:
Confidential, Columbus, OH
Sr. Informatica Developer
Roles & Responsibilities:
- Participated in Business Requirement meetings and then involved in writing Functional Specification document.
- Worked on Informatica Power Center tools, which include Designer, Repository Manager, Workflow Manager and Workflow Monitor.
- Calibrated high - level design specification to simple ETL coding and mapping standards.
- Designed and customized Data Models from multiple sources for DWH support
- Laid out the ETL architecture and Source to Target mapping to load data into DWH.
- Created mapping documents to outline data flow from sources to targets.
- Involved in Dimensionalmodeling (Star Schema) of the Data warehouse and used Erwin to design the business process, dimensions and measuredfacts.
- Extracted the data from the flatfiles and other RDBMS databases into staging area and populated onto Datawarehouse.
- Maintained sourcedefinitions, transformationrules and targetsdefinitions using Informatica repositoryManager.
- Used various transformations like Filter, Expression, Sequence Generator, Update Strategy, Joiner, StoredProcedure, and Union to develop robust mappings.
- Developed mapping parameters and variables to support SQLoverride.
- Created mapplets to use them in different mappings.
- Developed mappings to load into stagingtables and then to Dimensions and Facts.
- Used existing ETL standards to develop these mappings.
- Worked on different tasks like sessions, events raise, event wait, decision, e-mail, command, worklets, Assignment, Timer and scheduling of the workflow.
- Created sessions, configured workflows to extractdata from various sources, transformed data, and loading into data warehouse.
- Used SCDType 1 and Type 2 mappings to update slowly Changing DimensionTables.
- Extensively used SQL* loader to load data from flat files to the database tables in Oracle and created Stored Procedures, functions, views, packages and triggers.
- Modified existing mappings for enhancements of new business requirements.
- Used Debugger to test the mappings and fixed the bugs.
- Wrote UNIXshellScripts&PMCMD commands for FTP of files from remote server and backup of repository and folder.
- Involved in Performance tuning at source, target, mappings, sessions, and system levels.
- Prepared migration document to move the mappings from development to testing and then to production repositories.
Environment: Informatica PowerCenter Designer 9.1, Informatica PowerExchange 9.1, Oracle11g, DB2 6.1, MS Visio, TOAD,, Unix- SunOS, PL/SQL,SQL Developer,DB2
Confidential, Baltimore, MDSr. ETL/ Informatica Developer
Roles &Responsibilities:
- Used SQL developer to run the queries to verify the data with the existing GUI functionality.
- Involved in creation of test plan and test cases for testing the enhanced functionality of MBOX.
- Involved in documentation to describe program development, logic, coding, testing, and any changes and corrections.
- Developed ETL code by the business logic defined in the Functional Design Document.
- Analyzed the systems, met with end users and business units in order to define the requirements.
- Conducted business requirements and source system analysis to arrive at optimal ETL designs.
- Develops new ETL applications from simple to moderately complex scope, works with basic applications systems design specifications; and utilizes Company standards, procedures, and techniques.
- Partnering with project managers and development resources to assist with design changes and design decisions.
- Worked with creation of reports for decision support.
- Involved in analysis of the data in the development and test environment.
- Work with analog team to test the existing application.
- Involved in logging defects in JIRA and monitor the progress until it goes to UAT environment.
Environment: Informatica PowerCenter 8.1/8.6, Informatica Power Exchange 8.1/8.6, UNIX, Teradata 12, Oracle 11g, Oracle Data Integrator, SQL, PL/SQL,SQL Server 2008, Erwin 4.5, Oracle Designer, MS VISIO, Autosys, MBOX.
Confidential, Norcross, GAETL/Informatica Developer
Roles &Responsibilities:
- Extensively used ETL to transfer data from different source system and load the data into the target database.
- Extracted the data from the flat files and other RDBMS databases into staging area and populated onto Data Warehouse.
- Developed number of complex Informatica mappings, mapplets, reusable transformations to implement the business logic and load the data incrementally.
- Extracted data from Oracle and SQL Server and load the data into target database.
- Handled slowly changing dimensions of Type1/ Type 2 to populate current and historical data to dimensions and fact tables in the Data Warehouse.
- Developed Informatica mappings by usage of aggregator, SQL overrides in lookups, source filter in source qualifier and data flow management into multiple targets using router transformations.
- Extensively involved in performance tuning of the ETL process by determining the bottlenecks at various points like targets, sources, mappings, sessions or systems. This led to a better session performance.
- Involved in creating the runbook and migration document (from Development to Production).
- Document the process for further maintenance and support.
- Worked on test cases and use cases.
Environment:: Informatica 8.5, Oracle 10g/9i, Flat files, Excel, SQL Server, PL/SQL, Toad, UNIX Shell Scripting, Windows XP, Bussiness Object XI R2.
Confidential, Fort Wayne, INETL Developer
Roles &Responsibilities:
- Designed ETL processes using Informatica to load data from Flat Files, and Excel files to target Oracle Data Warehouse database
- Performed data manipulations using various Transformations like Joiner, Expression, Lookup, Aggregate, Filter, Update Strategy, and Sequence Generator, Stored Procedure etc.,
- Used tuned SQL overrides in source Qualifier to meet business requirements
- Written pre session and post session scripts in mappings.
- Created sessions and workflows for designed mappings. Redesigned some of the existing mappings in the system to meet new functionality
- Created and used different reusable tasks like command and email tasks for session status
- Used Workflow Manager to create Sessions and scheduled them to run at specified time with required frequency
- Monitored and configured the sessions that are running, scheduled, completed and failed.
- Created test case, participate in System integration test, UAT and migrated code from Dev to Test to QA to Prod.
- Compiled report presentations using tools like Bussiness Object reports.
- Involved in writing UNIX shell scripts for Informatica ETL tool to fire off services and sessions
Environment: Informatica Power Center 8.1.1, Oracle 10g, Teradata V2R6, Micro Strategy, MS SQL server 2000, Unix, Shell scripting and Windows XP, Erwin 4.2, SQL/PL SQL.
Confidential, Newark, CAETL Developer
Roles &Responsibilities:
- Developed Procedures, functions, packages and Triggers for enforcing the business rules using PL/SQL.
- Involved in creation of Schema Objects like indexes views, and stored procedures.
- Involved in a team in designing the Database Schema, for the metadata for storing the informative queries that are generated dynamically.
- Identifying integrity constraints for tables.
- Involved in writing the Triggers which internally calls procedures and functions.
- Tested the application to ensure proper functionality, data accuracy, and that modifications have no adverse Impact on integrated system environment
- Involved in documenting the entire process.
- Involved in Implementation and Testing phases of the system
Environment: Informatica Power Center 7.1.1, Oracle 10g, Teradata V2R6, Micro Strategy, MS SQL server 2000, Unix, Shell scripting and Windows XP, Erwin 4.2, SQL/PL SQL.
Confidential, New York, NYETL Developer
Roles &Responsibilities:
- Involved with the business analyst and the ETL team to gather Business requirements.
- Identified the workflows, worklets and Mappings to be enhanced and the new mappings to be created.
- Created and modified the mappings, worklets and workflows which are affected by the new source modifications.
- Support the offshore people.
- Generated the XML files and Performed Power Center Administration and migrated ETL code from Development to Test, and to Production using both Import/Export XML and Repository Manager's copy/paste utility.
- Created Mappings for Full load and also for the incremental load of the data.
- Developed new forms, XML Publisher Reports and discoverer reports.
- Handling VLDF files (Variable Length Delimited Flat Files) by taking a business case.
- Extensively used Expression, Joiner, Lookup, Aggregator, and Update strategy, filter Transformations etc. in various mappings.
- Mostly utilized the SQL override and Lookup SQL override for filtering the data according to the requirement.
- Used IDE for data analysis, Data Migration and understanding the different patterns of the data.
- Enhanced the production environment by modifying the existing mappings by check in and check out, and then moved to the production.
- Incorporated SQL tuning recommendations for data retrieval by using indexing strategy and using hints.
- Unit testing was done on each mapping separately for validating the performance and verifying the data.
- Informatica dataflow partition was used for loading large files of data.
- Improved the performance of the mappings, which were having data loadingissues.
- Worked on development and testing environment and then migrated my workflows to the production environment.
- Created labels, wrote queries in the repository manager for the deployment folder.
- Provided test queries for the QA team for the validation of the data.
- Designed restart recovery logic and also defined point of commit activities for highly volume loads.
- Involved in writing UNIX shell scripts, PL/SQL procedures, Pre-session and Post- Session Scripts.
Environment: Informatica Power Center 6.1.1, Oracle 9i, SQL *Loader and TOAD, PL/SQL, SQL Developer, UNIX(server).