PROFESSIONAL SUMMARY:

• 9+ years of IT experience with expertise in complete Software Development Life Cycle (SDLC) which includes business requirements gathering, system analysis, design, development and implementation of data warehouse.
• Expertise in building Enterprise Data Warehouses (EDW), Operational Data Stores (ODS), Data Marts and Decision Support Systems (DSS).
• Extensively used Informatica Client tools - Repository Manager, Designer, Workflow Manager and Workflow Monitor.
• Sound knowledge in using Informatica PowerCenter 10.1/9.6/9x/8x (Source Analyzer, Mapplet Designer, Transformation Designer, Star & Snowflake Schemas using Informatica tool on Oracle, Netezza and Teradata databases).
• Strong experience in RDBMS concepts, PL/SQL programming units like Procedures, Functions and Packages in UNIX and Windows environments.
• Good proficiency in using databases like Oracle 11g/10g/9i/8i, Netezza, Teradata and Microsoft SQL Server 2012/2008.
• Worked on Dimensional Data modelling in Star and Snowflake schemas and Slowly Changing Dimensions.
• Worked extensively on Erwin in both OLAP and OLTP applications.
• Proficient in extracting and transforming data from various sources (Oracle tables, Flat files, XML) into the Datawarehouse using ETL tools.
• Extensively worked on transformations such as Source Qualifier, Expression, Aggregator, Filter, Router, Joiner, Lookup, Sorter, Normalizer, Sequence Generator, Stored Procedure, XML Generator, XML Parser and Update Strategy transformations.
• Wide knowledge in Extraction, Transformation and Loading of data from multiple sources to the data warehouse.
• Worked on multiple projects using Informatica Data Quality client tool (IDQ) latest versions 10.1 and 9.6.
• Proficient using query tools like TOAD, SQL Developer, PL/SQL developer and Teradata SQL Assistant.
• Proficient in performance analysis, monitoring and SQL query tuning using EXPLAIN PLAN, Hints and SQL Trace both in Teradata as well as Oracle.
• Extensively involved in Performance issues of both Informatica and Databases.
• Experience in design of logical and physical data modelling and also have expertise in using SQL Loader to load data from external files to Oracle database.
• 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 understanding of using Healthcare applications, Diagnose codes and EDI Transaction codes 837,835,270,271, etc.
• Execute and monitor batch operations, monitor enterprise-level operations using job scheduler tools like BMC Control-M 8.0.0.
• Excellent in verbal and communication skills, good in understanding business procedures and have ability to work as an individual or in a team.

TECHNICAL SKILLS:

ETL tools: Informatica Powercenter 10.1/9.6/9x/8x (Mapping designer, Workflow manager, Workflow monitor, Repository manager), SQL Server Integration Services (SSIS) 2014, DataStage 11.5

Data Modelling: CA Erwin Data Modeler 9.0, Logical data modelling, Physical data modelling, Dimensional modelling (Star and Snowflake schemas, Facts and Dimensions), Entities, Attributes

Databases: Oracle 11g/10g/9i, Netezza, Teradata 13.10, SQL Server 2008/R2/2012, MS Access, DB2

Database tools: TOAD for Oracle 12.8, PL/SQL developer 4.1.3, SQL Plus

Programming: SQL,PL/SQL, UNIX, XML, Hadoop MapReduce, Hive

Scheduling tools: BMC Control: M 8.0.0, IBM Tivoli Workload Scheduler 8.6

Reporting tools: Cognos 8.2/8.4, TIBCO Spotfire Platform 4.5

Defect tracking tools: HP Quality Center 10.0/9.0, JIRA 7.0.0, Microsoft TFS

Operating Systems: MS Windows NT/2000/2003/XP/Vista/7, UNIX, MS-DOS and Linux

Other tools: Microsoft Office Suite, Microsoft Visio

PROFESSIONAL EXPERIENCE:

Confidential, Birmingham

ETL/Informatica developer

Responsibilities:

• Developed Conceptual, Logical and Physical data models to design OTLP and Data warehouse environments.
• Designed project related documents like high-level design (HLD), low-level design (LLD) based on BRD (Business requirement document) received from functional users.
• Worked with the business users to drive the source and target mapping information and created mapping specification documents indicating the source tables, transformations required, business rules, target tables, columns and data types.
• Implemented Message Digest Function (MD5) in Informatica to evaluate data integrity and perform Change Data Capture (CDC) operations to the changes made to enterprise data sources.
• Developed the mappings, applied rules and transformation logics as per the source and target system requirements using IDQ.
• Worked on creation of Folders, Users, Repositories and Deployment Groups using Repository Manager.
• Implemented Slowly Changing Dimensions (SCD Type II) to keep full history to the target database and also used Effective Dates and Flag logics for easy identification of Active and Inactive records in SCD.
• Used ETL to load data from multiple sources to staging area (Oracle) using Informatica PowerCenter 10.1.
• Involved in the development of Informatica mappings, mapplets and sessions and also tuned them for optimum performance, dependencies and batch design.
• Developed mappings/Reusable Objects/mapplets by using mapping designer, transformation developer and Mapplet designer in Informatica PowerCenter 10.1/9.6.
• Responsible to move ETL objects to the UAT, QA & PROD environments by import/export and Deployment Groups of the XML files and subsequently create the migration documents for UAT, QA & PROD.
• Handled Slowly Changing Dimensions (Type I, Type II and Type III) based on the business requirements.
• Used Informatica Power Center Workflow manager to create sessions, batches to run with the logic embedded in the mappings.
• Responsible for tracking the status of all the code changes raised during testing phase, assigning the defects within the team and resolving the defects based on priority using JIRA tool.
• Used Informatica PowerCenter 10.1/9.6 for extraction, loading and transformation (ETL) of data in the data warehouse.
• Used Parameter (.prm) files in Informatica server to manage the relational connection across different environments.
• Experience in upgrading from Informatica version 9.6 to 10.1.
• Applied the business rules and profiled the source and target table data using Informatica Data Quality (IDQ) tool.
• Coordinated with my team members to identify and resolve problems based on Informatica and other database related issues.

Environment: Informatica Powercenter 10.1, Informatica Data Quality 10.1.1, Oracle 11g, TOAD for Oracle 12.8, JIRA v7.0.0, Microsoft Azure, BMC Control-M 8.0.0, UNIX.

Confidential, Chicago

Sr. Informatica developer

Responsibilities:

• Worked closely with client in understanding the Business requirements, analysing the data and delivering it to the client’s expectation.
• Study functional requirements document and understand the client requirements.
• Involved in the development of Informatica mappings and preparation of design documents, technical specification documents and unit testing documents.
• Reviewed data present in the source systems and proposed data acquisition strategy.
• Performed in-depth analysis of the business requirements, prepared logical and physical design specifications and developed the software application for various business rules using Control-M.
• Developed mappings that perform Extraction, Transformation and Load (ETL) of source data using various Powercenter transformations like Source Qualifier, Aggregator, Filter, Router, Sequence Generator, look up, Rank, Joiner, Expression, Stored Procedure, SQL, Normalizer and update strategy to meet business logic in the mappings.
• Designed and developed Informatica Mappings to load data from Source systems to Intermediate layer and then to Data mart.
• Designed and customized data models for Data mart supporting data from multiple sources on real time.
• Reusable transformations and Mapplets are built wherever redundancy was needed.
• Performance tuning is performed at the mapping level as well as the database level to increase the data throughput.
• Designed and developed various PL/SQL stored procedures and T-SQL queries to perform various calculations related to fact measures.
• Used Informatica PowerCenter 9.6 and all its features extensively in migrating data from OLTP to Enterprise Data warehouse.
• Involved in creation of Folders, Users, Repositories and Deployment Groups using Repository Manager.
• Extracted data from different sources like Oracle, flat files, XML, DB2 and SQL Server and loaded into DWH.
• Developed numerous IDQ mappings using transformations like Address Doctor, Parser, Labeler, Match, Exception, Association, Standardizer and other significant transformations.
• Involved in Performance tuning for sources, targets, mappings and sessions.
• Performed Unit testing and maintained test logs and test cases for all the mappings to test the data populated by the Informatica workflows.
• Demonstrated the logical usability of the Control-M application and also promote the tested code across environments to facilitate testing and deployment procedures.

Environment: Informatica Powercenter 9.6, Informatica Data Quality 9.6, IBM Datastage 8.5, Netezza, UNIX scripting, BMC Control-M 8.0.0, Microsoft Visio.

Confidential, Kansas City

Sr. ETL /Informatica developer

Responsibilities:

• Used ETL to load data from multiple sources to staging area (Microsoft SQL Server 2012) using Informatica PowerCenter 9.6.1.
• Coordinated with my team members to identify and resolve problems based on Informatica and other database related issues.
• Worked with data compliance and data governance teams to maintain the data models, metadata, data dictionaries, define source fields and its definitions.
• Worked with pre and post sessions, and extracted data from transaction system into staging area along with knowledge of identifying fact and dimension tables.
• Designed and developed Informatica mappings and workflows, identified and removed bottlenecks in order to improve the performance of mappings and workflows.
• Worked on requirements to implement the Change Data Capture (CDC) to record the latest changes in data from the source system.
• Worked extensively with different caches such as Index cache, Data cache and Lookup cache (Static, Dynamic, Persistent and Shared).
• Created complex mappings in PowerCenter Designer using Aggregate, Expression, Filter, Sequence Generator, Update Strategy, Union, Lookup, Joiner, XML Source Qualifier and Stored procedure transformations.
• Created deployment groups, migrated the code into different environments. Worked closely with the reporting team to generate reports.
• Involved in the development of Informatica mappings and mapplets and also tuned them for Optimum performance, dependencies and batch design.
• Performed Unit testing on the Informatica code by running it in the Debugger and writing simple test scripts in the database thereby tuning it by identifying and eliminating the bottlenecks for optimum performance.
• Worked with UNIX shell scripts for automatically running sessions, aborting sessions, creating parameter files and also to run various batch jobs.
• Used Informatica Power Exchange for loading/retrieving data from IBM Mainframe systems.
• Used Parameter files to manage the relational connection in different environments.
• Worked cooperatively with the team members to identify and resolve various issues relating to Informatica and other database related issues.

Environment: Informatica PowerCenter 9.6.1, Microsoft SQL Server 2012, Microsoft TFS, PL/SQL, Windows, UNIX.

Confidential

ETL Developer

Responsibilities:

• Worked closely with the client in understanding the business requirements, prepared data analysis and provided the code deliverable to the client.
• Prototyped Dimension model and ETL process by matching the business requirements and core technical requirements from the Cognos Reporting team.
• Implemented ETL and Dimension prototype with complex mappings and mapplets for faster and effective means of reporting.
• Worked on dimensional models like Star schema and Snowflake schema.
• Handled Slowly Changing Dimensions - Type 1, Type 2 and Type 3 based on the business requirements.
• Extracted data from different sources like Teradata, flat files and SQL server.
• Worked extensively on Source Analyzer, Transformation Developer, Mapplet Designer and Mapping Designer.
• Worked with the FACETS Team for HIPAA Claims Validation and Verification Process.
• Designed mapping templates to specify high level approach and mapping spreadsheets for the (ETL) team with metadata definitions for source-to-target data mappings with physical naming standards, data types and domain definitions.
• Implemented performance tuning logic on sources, targets, mappings and sessions to provide maximum efficiency and performance.
• Worked extensively with different cache memory in Informatica such as Index cache, Data cache and Lookup cache (Static, Dynamic, Persistence and Shared).
• Involved in migration projects to migrate data from data warehouses on Oracle/DB2 and migrated those to Teradata.
• Worked on the loading and association of EDI transactions like 270,271,837(P/D/I), 835, 834, 820, etc.
• Successfully implemented changes in making all the ETL jobs to harmonize within the allotted DWH time frame.
• Handled entire responsibility of deploying code to Test and Production environments without any issues.
• Tested performance for ETL mappings with various possible scenarios.
• Wrote, tested and implemented Teradata - Fastload, Multiload and BTEQ scripts, DML and DDL statements.
• Supervised sanity test in multiple environments for various stages of the system and streamlined defect management process using HP quality center.
• Demonstrated witness testing to the Client team after iteration of the testing phase.
• Suggested changes in the ETL development process which improved overall productivity and ability to hit the target plans with less overhead.

Environment: Informatica Powercenter 9.1, Teradata 13.10, PL/SQL, FACETS 4.51, UNIX scripting, Informatica Metadata manager, Cognos 8.4, HP Quality Center 10.0.

Confidential

Informatica Developer

Responsibilities:

• Gathered business requirements and performed analysis, design, development and deployment of various ETL components.
• Prepared High level and Low level design specifications of business requirements.
• Formulated Source to Target mapping documents for better ease of ETL implementations.
• Resolved various technical issues in production databases and implemented code fixes in quick pace.
• Appreciated by the client for efficiently rectifying critical real-time customer issues.
• Extensively used Informatica PowerCenter for extraction, transformation and loading of data from relational and non-relational sources.
• Sound knowledge in using various transformations such as Source Qualifier, Expression, Lookup, Aggregator, Joiner, Sequence Generator, Update Strategy while migrating data from various heterogeneous sources like Oracle, DB2 and Flat files.
• Developed Informatica mappings, re-usable transformations, re-usable mappings and mapplets for loading the data into the data warehouse.
• Handled Slowly Changing Dimensions of Type 2 to populate current and historical data into the Dimension and Fact tables in the data warehouse.
• Designed UNIX scripts and automated it to run the workflows at different intervals - daily, weekly and monthly.
• Developed mapping parameters, mapping variable and session parameters using Informatica PowerCenter.
• Composed complex SQL scripts to avoid Joiner, Union and Lookup transformations to enhance the performance of loading huge volumes of data.
• Performed purging of old data using Post-SQL in Informatica mappings.
• Used Informatica Power Exchange for loading/extracting data from mainframe systems.
• Created deployment groups, migrated the code into different environments - Development, Testing or Production.
• Developed mappings for Fact and Dimension tables using the various transformations to extract data from different sources like Oracle, SQL server and XML files.
• Tuned sources, targets, mappings and sessions to improve the performance of data load.
• Extensively tuned Informatica mappings, sessions by following best practices to avoid unnecessary caching of data by the lookups.
• Managed the entire batch workload by understanding the job dependencies, modified the schedule of jobs as per the changes in requirement using job scheduler tool - Tivoli Workload Scheduler (TWS).
• Contributed in designing the logical, physical data models and Star schema for designing the Data Marts.
• Experienced in data migration of Informatica mappings, sessions and workflows to Data Integrator.
• Developed the repository manager, users, user groups and their access profiles.
• Provided requirements to the TIBCO reporting development team to create reports.

Environment: Informatica PowerCenter 9.1/8.6.1, Netezza, UNIX, Oracle BI Data Warehouse Administration Console 11g (DAC), TIBCO Spotfire platform 4.5, Tivoli Workload Scheduler 8.6.

Confidential

Informatica Developer/ Data Analyst

Responsibilities:

• Tuned queries, stored procedures to enhance the performance of applications.
• Created load scripts using Teradata Fast Load and MLoad utilities and procedures in SQL Assistant.
• Implemented Aggregate, Filter, Join, Expression, Lookup and Update Strategy transformations. Used debugger to test the mapping and fixed the bugs.
• Developed mappings using Mapping Designer to standardize data as per business requirements.
• Worked extensively on fine tuning SQL overrides for enhancing performance.
• Involve in performance tuning to optimize existing SQL Scripts.
• Developed PL/SQL scripts and stored procedures for database updates and to create the necessary indexes in the target tables.
• Wrote BTEQ scripts to transform data and FastExport scripts to export data.
• Used Teradata utilities like FLoad, MLoad, TPump to load data.
• Involved in developing stored procedures, triggers for the application.
• Worked extensively with Mapping Designer to join Oracle and Teradata tables using Joiner transformation.
• Worked on developing workflows and sessions and monitoring them to ensure data (target file) is properly loaded into the warehouse.
• Used debugger extensively to identify the bottlenecks in the mappings.
• Responsible for scheduling reports, error checking, production support, maintenance and testing of ETL procedures using Informatica session logs.
• Created Informatica mappings to populate the data into dimensions and fact tables.
• Developed Connected and Unconnected Lookup transformations to lookup the data from source and target tables.
• Provided reliable, timely support of integration, performance and user acceptance testing (UAT) processes.
• Worked along with the DBA to resolve performance and tuning issues.
• Involved in creation of Folders, Users, Repositories and Deployment Groups using Repository manager.
• Utilized the Explain Plan, Hints, Analyze commands, Statistics and Indexes for better performance of SQL queries.
• Documented the best practices to be followed in resolving data load and memory related issues in Informatica.
• Monitored ETL jobs running in Production environment and fixed bugs and documented the same to avoid similar future occurrences.
• Developed and documented mappings/transformations, audit procedures and Informatica sessions and workflows developed.
• Created test scripts, performed System Integration testing, Regression testing and reviewed test results.
• Used SQL Loader to load huge flat files into Oracle database.
• Ad-hoc reports were used for Business Objects User modules for various Portfolios using the Universes as the main Data Providers.
• Extensively involved in making data flowing through mappings consistent and organized.
• Prepared the ETL documentation for data conversions.

Environment: Informatica PowerCenter 8.1.1, Oracle 9i, SQL Server, PL/SQL, UNIX, Windows NT, Autosys.