SUMMARY

• 8 years of experience in Information Technology with a strong background in Database development, Management and Data warehousing.
• Good experience in designing, Implementation of Data warehousing and Business Intelligence using ETL tools like Informatica Power Center (designer, workflow manager, workflow monitor and repository manager).
• Designed & Created mappings in mapping Designer to load data from various sources using transformations like Transaction Control, Lookup (Connected and Un - connected), Router, Filter, Expression, Aggregator, Joiner and Update Strategy, SQL, Stored Procedure and more.
• Excellent Knowledge on Slowly Changing Dimensions (SCD Type1, SCD Type 2, SCD Type 3), Change Data Capture, Data archiving, Dimensional Data Modeling, Ralph Kimball Approach, Star/Snowflake Modeling, Data Marts, OLAP and FACT and Dimensions tables, Physical and Logical data modeling.
• Experience in developing Transformations, Mapplets and Mappings in Informatica Designer and creating tasks using Workflow Manager to move data from multiple sources to target.
• Worked in different phases of the projects involving Requirements Gathering, Design, Development, Deployment, Testing and Maintaining.
• Good Knowledge on Database architecture of OLTP and OLAP applications, Data Analysis.
• Worked with wide variety of sources like Relational Databases, Flat Files, Mainframes, XML files and Scheduling tools like Control-M, Auto sys and Informatica Scheduler.
• Experience with healthcare data in HIPAA formats including HL7, NCPDP,837, 834, 835.
• Very strong experience working in agile environment with fast sprints. Effective use of Agile tools like one note, Jira.
• Experience on Quality Assurance testing, Logging defects, providing verifications on fixes in multiple environments and communicating fix success, failures and status updates as appropriate using bug tracking tools like Test Director and Quality center.
• Very Strong skills and clear understanding of requisites and solutions to various issues in implementation throughout the Software Development life cycle (SDLC).
• Experience working with ETL performance tuning techniques, identifying bottlenecks, improving performance using Partitioning at session level and more.
• Hands on experience in PL/SQL (Stored Procedures, Functions, Packages, Triggers, Cursors, Indexes) and UNIX Shell scripting.
• Expertise in doing Unit Testing, Integration Testing, System Testing and Data Validation for Developed Informatica Mappings.
• Hands on experience working in LINUX, UNIX and Windows environments.
• Experience in working Production Support and migrated the code from DEV to QA to Production.
• Very good exposure to Oracle 11g/10g/9i, MS SQL Server 2008/2005, IBM DB2, Teradata databases.
• Excellent Verbal and Written Communication Skills. Have proven to be highly effective in interfacing across business and technical groups.

TECHNICAL SKILLS

Environment: Windows, Linux, UNIX, Mainframes.

ETL tools: Informatica, Sql Server SSIS, Pentaho, Informatica TDM.

Data Modeling: Star Schema, Snowflake Schema, Erwin 4.0, Dimension Data Modeling.

Databases: Oracle11g/10g/9i/8.x, SQL Server 2012/2008/2005/2000 , IBM DB2, Teradata 13.1, Sybase, MS Access

Scheduling Tools: Control-M, CA7 Scheduler, Autosys, Informatica Scheduler, Tidal Scheduler

Reporting Tools: Crystal Reports, Business Objects XI R2/XI 3.3, OBIEE 11g R1 (11.1.5).

Programming: SQL, PL/SQL, Transact SQL, HTML, XML,Unix Shell, Batch.

Operating Systems: Windows 7/XP/NT/95/98/2000, DOS, UNIX and LINUX

Other Tools: SQL*Plus, Toad, SQL Navigator, Putty, WINSCP, MS-Office, SQL Developer.

PROFESSIONAL EXPERIENCE

Confidential, Westfield, OH

Sr Informatica Developer

Responsibilities:

• Analyze the business requirements and framing the Business Logic for the ETL Process and maintained the ETL process using Informatica Power Center.
• Work extensively on various transformations like Normalizer, Expression, Union, Joiner, Filter, Aggregator, Router, Update Strategy, Lookup, Stored Procedure and Sequence Generator.
• Develop an ETL Informatica mapping in order to load data into staging area. Extracted from Mainframe files and databases and loaded into Oracle 11g target database.
• Create workflows and work lets for Informatica Mappings.
• Write Stored Procedures and Functions to do Data Transformations and integrate them with Informatica programs and the existing applications.
• Work on SQL coding for overriding for generated SQL query in Informatica.
• Involve in Unit testing for the validity of the data from different data sources.
• Design and develop PL/SQL packages, stored procedure, tables, views, indexes and functions. Experience dealing with partitioned tables and automating the process of partition drop and create in oracle database.
• Involve in migrating the ETL application from development environment to testing environment.
• Perform data validation in the target tables using complex SQLs to make sure all the modules are integrated correctly.
• Perform Data Conversion/Data migration using Informatica PowerCenter.
• Involve in performance tuning for better data migration process.
• Analyze Session log files to resolve error in mapping and identified bottlenecks and tuned them for optimal performance.
• Create UNIX shell scripts for Informatica pre/post session operations.
• Automated the jobs using Cisco Tidal Scheduler.
• Worked on Direct Connect process to transfer the files between servers.
• Document and present the production/support documents for the components developed, when handing-over the application to the production support team.

Confidential, Sacramento, CA

Sr Informatica Developer

Responsibilities:

• Imported DT service in Informatica Powercenter which parsed incoming XML files.
• Worked in Agile environment to convey the assignment in view of scrum cycle.
• Utilized Jira to assign and manage task under the supervision of scrum master.
• Implemented Technical and logical specifications for ETL solution.
• Contributed in the design phase of logical and physical data model using Erwin 4.0.
• Designed, developed and documented the ETL (Extract, Transformation and Load) strategy to populate the Data Mart from the various source systems.
• Implemented partitioning and bulk loads for loading large volume of data.
• Identified bugs in existing mappings/workflows by analyzing the data flow and evaluating transformations.
• Based on the requirements, used various transformations like Source Qualifier, Normalize, Expression, Filter, Router, Update strategy, Sorter, Lookup, Aggregator, Joiner, unstructured data transformation and Sequence Generator in the mappings.
• Developed Mapplets, Worklets, Sessions and Transformations for reusability.
• Identified performance bottlenecks and Involved in performance tuning of sources, targets, Mappings, transformations and sessions to optimize session performance.
• Played a key role in all the testing phases and responsible for the Unit testing from the development perspective as well.
• Optimized mappings, sessions/tasks, source and target databases as part of the performance tuning.
• Deployed the code to the higher environments using dynamic deployment groups.
• Scheduled jobs for both inbound and outbound using tidal control resources.

Confidential, Irving, TX

Sr Informatica Developer

Responsibilities:

• Informatica Data Quality was used to profile/cleanse the data as per the business rules..
• Created mapping for Address Validator transformation in IDQ for validating the address.
• Imported the Address validation transformation mapping as a mapplet in Informatica Powercenter to cleanse/validate the address from different source system.
• Worked in Agile environment to deliver the task based on scrum cycle.
• Used Jira application to create task/stories to report scrum cycle activities to the scrum master.
• Created detailed Technical specifications for Data Warehouse and ETL processes.
• Involved in design phase of logical and physical data model using Erwin 4.0.
• Worked on Informatica - Source Analyzer, Warehouse Designer, Mapping Designer, Mapplet Designer and Transformation Developer.
• Extracted/loaded data from/into diverse source/target systems like Oracle, Sql Server, XML, HL7 and Flat Files.
• Used most of the transformations such as the Source Qualifier, Expression, Aggregator, Filter, Connected and Unconnected Lookups, Joiner, update strategy, stored procedure and unstructured data transformation.
• Converted Unstructured HL7 file into readable format in Informatica Powercenter with the help of B2B Unstructured data transformation.
• Developed mappings to load Fact and Dimension tables, SCD Type I and SCD Type II dimensions and Incremental loading and unit tested the mappings.
• Developed code to generate extracts for downstream applications on day to day basis and archiving the extracts using scripting techniques.
• Experience in automating archiving flat files at both source and target level by using scripting/ ETL Informatica task.
• Developed History/Archive tables for the data which gets landed on monthly basis. Effectively created mapping by using parameter files and sql overrides to make use of the archive data.
• Addressed many performance issues on ETL jobs, semantic views, stored procedures, Reporting and Ad-hoc SQL.
• Involved in creating different types of reports including OLAP, Drill Down and Summary in BO.
• Worked in the Performance Tuning of SQL, ETL and other processes to optimize session performance.
• Experience dealing with Oracle partitioned tables to improve the performance of loads.
• Improving performance of huge loads using ETL Informatica partitioning concept at session level.
• Created Reusable transformations, Mapplets, Worklets using transformation Developer, Mapplet Designer and Worklet Designer.
• Calling Workflows with the use of pmcmd command.
• Tuned Informatica mappings to improve the execution time by applying suitable Partitioning mechanisms and tuning individual transformations inside the mapping.
• Worked with database partitioned tables in landing area for better performance.

Confidential, Cleveland

Sr Informatica Developer

Responsibilities:

• Analyze the business requirements and framing the Business Logic for the ETL Process and maintained the ETL process using Informatica Power Center.
• Work extensively on various transformations like Normalizer, Expression, Union, Joiner, Filter, Aggregator, Router, Update Strategy, Lookup, Stored Procedure and Sequence Generator.
• Develop an ETL Informatica mapping in order to load data into staging area. Extracted from Mainframe files and databases and loaded into Oracle 11g target database.
• Create workflows and work lets for Informatica Mappings.
• Write Stored Procedures and Functions to do Data Transformations and integrate them with Informatica programs and the existing applications.
• Work on SQL coding for overriding for generated SQL query in Informatica.
• Involve in Unit testing for the validity of the data from different data sources.
• Design and develop PL/SQL packages, stored procedure, tables, views, indexes and functions. Experience dealing with partitioned tables and automating the process of partition drop and create in oracle database.
• Involve in migrating the ETL application from development environment to testing environment.
• Perform data validation in the target tables using complex SQLs to make sure all the modules are integrated correctly.
• Perform Data Conversion/Data migration using Informatica PowerCenter.
• Involve in performance tuning for better data migration process.
• Analyze Session log files to resolve error in mapping and identified bottlenecks and tuned them for optimal performance.
• Create UNIX shell scripts for Informatica pre/post session operations.
• Automated the jobs using Cisco Tidal Scheduler.
• Worked on Direct Connect process to transfer the files between servers.
• Document and present the production/support documents for the components developed, when handing-over the application to the production support team.

Confidential, Detroit, MI

Informatica ETL Prod Support

Responsibilities:

• Interacted with business analysts, data architects, application developers to develop a data model.
• Designed and developed complex aggregate, join, look up transformation rules (business rules) to generate consolidated (fact/summary) data identified by dimensions using Informatica Power Center 8.5.x tool.
• Created sessions, database connections and batches using Informatica Server Manager/Work flow Manager.
• Optimized mappings, sessions/tasks, source and target databases as part of the performance tuning.
• Designed ETL Mappings and Workflows using power center designer and workflow manager.
• Involved in the extraction, transformation and loading of data from source flat files and RDBMS tables to target tables.
• Developed various Mappings, Mapplets and Transformations for data marts and Data warehouse.
• Used Shell Scripting to automate the loading process.
• Used VBA Macro excels to compare data to show proof of concept for Unit testing.
• Used Pipeline Partitioning feature in the sessions to reduce the load time.
• Analyzed and Created Facts and Dimension Tables.
• Used Informatica features to implement Type I and II changes in slowly changing dimension tables.
• Used command line program pm cmd to communicate with the server to start and stop sessions and batches, to stop the Informatica server and recover the sessions.
• Designed processes to extract, transform and load data to the Data Mart.
• Performed impact analysis, remedial actions and documented on process, application failures related with Informatica ETL and Power Analyzer.
• Performed regular backup of data warehouse, backup of various production, development repositories including automating and scheduling processes. As part of optimization process, performed design changes in Informatica mappings, transformations, sessions.