SUMMARY

• 8+ years of experience in software applications analysis, design and development, Testing, Maintenance and Enhancement in data warehousing, Data Integration.
• 8 years of strong Data Warehousing experience in Business Requirement Analysis, Design, Development, Testing, Implementations, Loading, Maintenance and Enhancements of Data warehouse and ODS systems using Informatica Power Center 10.1.1/9.x/8.x/7.x, Oracle 11g/10g/9i, DB2, SQL, PL/SQL and well versed with Data Warehousing Architecture, Technology and Dimensional Data Modeling.
• Heavily interacted with the Source System owners and business users to gather requirements, design tables, standardize interfaces for receiving data from multiple operational sources, coming up with load strategies of loading staging area and data warehouse.
• Experience in designing and implementation of real - time Data warehouse using Informatica Power Exchange 9.1/8.6.
• Implemented slowly changing dimensions (Type1, Type2 and Type3), Merge Queries for Updates, slowly growing targets, and simple pass through mapping’s using Power Center.
• Extensive knowledge with Dimensional Data modeling, Star Schema/Snowflakes Schema, Fact and Dimension tables.
• Experience working on Informatica IDQ to design, develop, test and review, optimize Informatica IDQ.
• Worked with Informatica Data Quality toolkit, Analysis, data cleansing, data matching, data conversion, exception handling, and reporting and monitoring capabilities of IDQ.
• Expertise in Master Data Management concepts, Methodologies and ability to apply this knowledge in building MDM solutions.
• Worked extensively with Flat Files, COBOL Files, DB2 Relational source data, and Workflow and Scheduling Job design, resolving production issues.
• Integrated IDQ Mappings and Mapplets with Power Center and automated the scheduling process.
• Used features like pre-session/post-session commands/SQL, fine-tuned databases, mappings, and sessions to get optimal performance.
• Experience in UNIX shell scripting, Application Monitoring using UNIX Shell Scripting.
• Extensive experience with relational databases (Oracle 10g/11g, DB2, SQL Server, Teradata.
• Worked in Agile methodology, have experience on Rally, Basecamp.
• Extensive experience in UNIX shells scripting and Job scheduling like Autosys, Tidal and Informatica Scheduler.
• Experience in developing Test Strategy, Test plan, Test cases, Use Case, Test scripts.
• Possess excellent interaction, communication and problem solving abilities.
• Strong experience in offshore and onsite coordination.

TECHNICAL SKILLS

ETL TECHNOLOGY: Informatica Power Center 10.1.1/9.x/8.x/7.x, Informatica Power Exchange 9.x/8.6

DATA WAREHOUSE: Multidimensional Model Design, Star Schema Development

DATA MODELLING: Star-Schema Modeling, Snowflake Modeling, MS Visio.

DATABASES: MS SQL Server, Oracle 11g/10g/9i, DB2 mainframe 9, MDM, IDQ, Teradata 12/V2R5/14/15,MySQL, MS Access, Sybase

PROGRAMMING: SQL, PL/SQL, Shell Scripting, PERL

REPORTING TOOLS: Business Objects XI, Cognos.

OPERATING SYSTEMS: Windows 7, IBM AIX 5.1, Red Hat Linux V6

APPLICATIONS: Toad 9.2/8.6, DB Visualizer 9.2, FileZilla, Winscp, JIRA, Service Desk

MANAGEMENT TOOLS: MS-Office

PROFESSIONAL EXPERIENCE

Confidential, Miami, FL

Sr. Informatica Developer

Responsibilities:

• Member of core ETL team involved in gathering requirements, performing source system analysis and development of ETL jobs to migrate data from the source to the target DW.
• Analyzed the business requirement document and created functional requirement document mapping for all the business requirements.
• Extensive use of DataMart and OLAP concepts.
• Designed and Developed ETL mappings using transformation logic for extracting the data from various sources systems.
• Developed complex ETL mappings making use of transformations like Source Qualifier, Joiner, Update Strategy, Connected Lookup and unconnected Lookup, Rank, Expression, Java, Java Expressions, Router, Filter, Aggregator and Sequence Generator transformations.
• Automated the load process using UNIX shell scripts.
• Involved in the data migration from Control-M to TWS scheduler
• Involved in performing data validation for various applications such as Salesforce, Annuities and Investments
• Used the features like Workload designer, Viewpoint manager etc.
• Created, monitored and troubleshooted sessions for daily extracts
• Involved in tuning the SQL statements to optimize the performance
• Disabled the jobs scheduled through Control-M after two weeks of successful runs in TWS.
• Used parallel processing capabilities, Session-Partitioning and Target Table partitioning utilities.
• Performed the data validations and control checks to ensure the data integrity and consistency.
• Extensively used debugger to trace errors in the mapping.
• Extensively involved in coding of the Business Rules through PL/SQL using the Functions, Cursors and Stored Procedures
• Involved in developing test plans and test scripts to test the data based on the business requirements.
• Created source, target, transformations, sessions, batches and defined schedules for the sessions.
• Re-designed ETL mappings to improve data quality.
• Developed standard and re-usable mappings and mapplets using various transformations like expression, aggregator, joiner, source qualifier, router, lookup Connected/Unconnected, and filter.
• Created Workflows and used various tasks like Email, Timer, Scheduler, Control, Decision, and Session in the workflow manager.
• Tuning Informatica Mappings and Sessions for optimum performance
• Implemented performance tuning of Sources, Targets, Mappings and Sessions by identifying bottlenecks and used Debugger to debug the complex mappings and fix them.
• Partitioned sessions for concurrent loading of data into the target tables.
• Prepared ETL mapping Documents for every mapping and Data Migration document for smooth transfer of project from development to testing environment and then to production environment.
• Used Informatica features to implement Type I, II, and III changes in slowly changing dimension tables.
• Used Shell Scripting to automate the loading process.
• Actively involved in production support. Implemented fixes/solutions to issues/tickets raised by user community.
• Co-ordinate between different teams across circle and organization to resolve release related issues.

Environment: Informatica Power Center 10.2/10.1/9.6.1 , MDM, Data Quality, Erwin, Oracle 11g, Sybase, Toad, SQL Developer, SQL Loader, Windows 7/NT, UNIX/Linux, SQL Server 2012/2010, Autosys 11.3.XML, Flat Files, Windows, IBM UNIX (AIX), Tidal.

Confidential, Woodland hills, CA

Sr. ETL/ Informatica Developer

Responsibilities:

• Performed fine tuning of existing mappings in order to increase the performance of the mappings.
• Developed Claims processing data mappings to provide more feasibility to end users from the downstream applications.
• Implemented Type II slowly changing dimension(SCD) to keep full history of dimensional data in the table.
• Extensively worked with SCD Type-I, Type-II and Type-III dimensions and data warehousing Change Data Capture(CDC).
• Managed and compile documentation for all ETL processes.
• Performed maintenance of SQLs, Views, and Informatica objects.
• Worked extensively on Informatica Power Center tool - Source Analyzer, Data Warehousing designer, Mapping & Mapplet Designer and Transformation Designer. Developed Informatica mappings and also in tuning of mappings for better performance.
• Designed, documented and configured the Informatica MDM Hub to support loading, cleansing of data.
• Imported mapplets and mappings from Informatica developer (IDQ) to Power Center.
• Identify solutions to enhance the existing Business Intelligence infrastructure processes and technology.
• Monitored data warehouse month-end loads to ensure successful completion.
• Used tools in the utility workbench in Informatica MDM like Batch group, batch viewer, process server, Audit manager.
• Proactively work with other Data Warehouse team members and with the members of other teams (business customers, analysts, developers, and DBA's and technical support staff) to create innovative analytical solutions.
• Developed Conceptual, normalized Logical and Physical data models to design OTLP and Data warehouse environments.
• Used ETL process to load data from multiple sources to staging area (Oracle) using Informatica Power Center 10.2.
• Worked with pre and post sessions and extracted data from transaction system into staging area along with knowledge of identifying fact and dimension tables.
• Extensively used Informatica Workflow Manager to run the workflows/mappings and monitored the session logs in Informatica Workflow Monitor.
• Extensively used Data Stage for extracting, transforming and loading databases from sources including Oracle, DB2 and Flat files.
• Experience in 24X7 production support, ETL executions and resolving root causes.
• Extensively used ETL Tool Informatica to load data from Flat Files, Oracle and XML sources.
• Involved in the development of Informatica mappings and sessions and also tuned their performance for Optimum performance.
• Validated test data results using complex SQL queries.
• Strong Performance tuning and optimization experience with SQL and stored procedures (PL/SQL)
• Written complex SQL queries for data validation by querying data from different database tables as per the requirement.
• Involved in writing PL/SQL Packages, Functions, Stored Procedures and Triggers.
• Modified the Stored Procedures, Trigger & other backend objects for performance.
• Monitor the usage of database space and performance. Performance optimization of the database and applications. Resolve on-call issues for hundreds of production databases.

Environment: Informatica Power Center 10.2/10.1/9.6.1 , MDM, Data Quality, Erwin, Oracle 11g, Sybase, Toad, SQL Developer, SQL Loader, Windows 7/NT, UNIX/Linux, SQL Server 2012/2010, Autosys 11.3.

Confidential, Grand Rapids, Michigan

Sr. ETL/Informatica Consultant

Responsibilities:

• Involved with business and product development teams to get the functional requirements and specking out the Technical Requirement Documents for the data conversion.
• Performed profiling using Informatica Analyst and Informatica Developer.
• Designed data modeling with team as per the requirement.
• Created scorecards to review data quality.
• Designed and created ORS, User Creation, Informatica MDM Database Configuration
• For Metric Promotion Automation Process, created shell script for avoiding manually editing the shell scripts for each environment specific changes as you migrate code (parameterization)
• Involved with Data Steward Team for designing, documenting and configuring Informatica Data Director for supporting management of MDM data.
• Used Informatica Data Quality tool (Informatica Developer) to scrub, standardize and match customer address against the USPS database.
• Identify solutions to enhance the existing Business Intelligence infrastructure processes and technology.
• Design, Development and implementation of Informatica Developer Mappings for data cleansing using Address validator, Labeler, Association, Parser, Expression, Filter, Router, Lookup transformations etc.
• Design, Development and implementation of Power center mappings for DQ Framework using SQL, Normalizer, Expression, Filter, Router, Lookup transformations etc.
• Imported mapplets and mappings from Informatica developer (IDQ) to Power Center.
• Created complex PL/SQL stored procedures and triggers.
• Worked with version control tool using clearcase .
• Developed mapping spreadsheets for (ETL) team with source to target data mapping with physical naming standards, data types, volumetric, domain definitions, and corporate meta-data definitions.
• Worked extensively on Informatica Power Center tool - Source Analyzer, Data Warehousing designer, Mapping & Mapplet Designer and Transformation Designer. Developed Informatica mappings and also in tuning of mappings for better performance.
• Extensively worked with SCD Type-I, Type-II and Type-III dimensions and data warehousing Change Data Capture(CDC).
• Responsibilities include designing the documents which is based on the requirement specifications.
• Involved with Data Steward Team for designing, documenting and configuring Informatica Data Director for supporting management of MDM data.
• Used tools in the utility workbench in Informatica MDM like Batch group, batch viewer, process server, Audit manager.
• Used GIT HUB as version control tool and Udeploy for UNIX scripts deployments
• Debug the Informatica mappings for DQ Metrics and by utilizing the session logs in Informatica.
• Practical understanding of the Data modeling (Dimensional & Relational) concepts like Star-Schema Modeling, Snowflake Schema Modeling, Fact and Dimension tables.
• Involved in design, development and testing of the Patient Match and Merge Process.
• Done extensive testing and wrote queries in SQL for push down optimization.
• Worked with Memory cache for static and dynamic cache for the better throughput of sessions containing Rank, Lookup, Joiner, Sorter, SQL and Aggregator transformations.
• Fixed the invalid mappings and troubleshoot the technical problems of the database.
• Debug the sessions by utilizing the logs of the sessions.
• Developed and implemented the UNIX shell script for the start and stop the sessions.
• Modified the Stored Procedures, Trigger & other backend objects for performance.

Environment: Informatica Power Center 10.2/10.1/9.6.1 , MDM, Data Quality, Erwin, Oracle 11g, Sybase, Toad, SQL Developer, SQL Loader, Windows 7/NT, UNIX/Linux, SQL Server 2012/2010, Autosys 11.3.

Confidential, Ann Arbor, Michigan

Sr. ETL/Informatica Developer

Responsibilities:

• Source system evaluation, standardizing received data format, understanding business/data transformation rules, business structure and hierarchy, relationships, data transformation through mapping development, validation and testing of mappings.
• Performed requirement analysis and developed designing technical specifications for data migration according to the business requirement.
• Used Information Power Exchange for loading/retrieving data from mainframe systems.
• Developed complex ETL structures to extract, transform and load data from multiple data sources into data warehouse bases on business requirements.
• Extensively worked with SCD Type-I, Type-II and Type-III dimensions and data warehousing Change Data Capture(CDC).
• Created mapplets in place of mappings which were repeatedly used like formatting date or data type conversion.
• Ensured accurate, appropriate and effective use of data; including data definition, structure, documentation, long - range requirements, and operational guidelines.
• Designed, Developed and Build Informatica Power Center Mappings and Workflows using Teradata External Loaders.
• Monitor all the Production, System Test and developments boxes for any errors in the logs and fix them as needed.
• Created complex PL/SQL stored procedures and triggers.
• Monitored ETL process activity and utilization, with particular strengths in performance tuning highly transactional data integration package in both the development and production environments.
• Responsible for troubleshooting and resolving issues related to system performance, Informatica applications, and data integrity
• Involved with Data Steward Team for designing, documenting and configuring Informatica Data Director for supporting management of MDM data
• Extensively worked with SQL queries, created stored procedures, packages, triggers, views using PL/SQL Programming.
• Developed Unix Shell Scripts and PL/SQL Procedures to extract and load data.
• Involved in optimization and performance tuning of Informatica objects and database objects to achieve better performance.
• Sourced data from Teradata to Oracle using Fast Export and Oracle SQL Loader.
• Created load scripts using Teradata Fast Load and Mload utilities and procedures in SQL Assistant.
• Offered production support for daily jobs
• Worked with Unix commands and used Unix shell scripting to automate jobs.
• Performed Unit and Integration testing and wrote test cases
• Worked extensively in defect remediation and supported the QA testing.
• Involved in periodic maintenance of environments by applying patches and content upgrades .
• Involved in code migration for versioned repositories
• Involved in taking repository backup and restoring it, starting and stopping Informatica services and worked with pmcmd commands.
• Created Drill through Reports & Master Detail Reports for Sales Department
• Extensively used prompts, filters, cascading prompts, calculations, conditional variables, multiple queries for data extraction in reports.

Environment: Informatica Power Center 9.6.1, MDM, Informatica Data Quality9.6.1, PL/SQL, DB2, Oracle 11g, Linux RHEL 6.x, Autosys, Windows 7/XP, Flat Files.