SUMMARY

• 8+ years of technical experience on Client - Server architecture, Business applications in various phases of IT projects such analysis, design, development, implementation, and testing of Data warehouse environment using Informatica, SQL, PLSQL, Teradata and Oracle on OLAP and OLTP environment.
• Data integration experience in developing ETL mappings using Informatica power center 8.x/9.x/10.x and Informatica Data Quality (IDQ).
• Good technical/functional knowledge of Business Intelligence and Data warehouse concepts and experience in integration of various data sources with Multiple Relational Databases.
• Expertise in developing Informatica Mappings, Mapplets, Sessions, Workflows and Worklets for data loads.
• Worked with heterogeneous data sources like Oracle, SQL Server, Flat Files, XML files.
• Expertise in developing complex mappings using different transformations like Source Qualifiers, Expressions, Filters, Joiners, Routers, Union, Unconnected / Connected Lookups, Aggregators, Stored procedure transformation and more.
• Expertise on performance tuning techniques to improve the performance at workflow level, mapping level and session level.
• Experience with dimensional modeling using Star Schema and Snowflake Models.
• Knowledge on building IDQ mapplets and workflows.
• Proficient in working with PL/SQL for improving the performance of SQL queries by writing stored procedures, functions, and triggers.
• Knowledge in deploying reports using Reports 12c/11g.
• Experienced in preparing and analyzing Data flow diagrams, Data dictionary, Database Normalization theory techniques, E-R Modeling, and design techniques.
• Proficient in working with different databases - Oracle, Teradata, DB2 and SQL Server.
• Extensively used Slowly Changing Dimension (SCD) Type1 and (SCD) Type2 to maintain history.
• Experience is writing wrapper scripts using Unix Shell Script for the execution of the workflow.
• Experience in Job scheduling tools like Control-M.
• Experience in executing DWH projects both Agile & Waterfall methodologies.
• Exposure to plan and execute all phases of System Development Life Cycle (SDLC) including requirement Analysis, Design, Development, Maintenance, Unit testing, integration testing, Regression Testing, UAT, Implementation, Documentation and Production/Application Support.

TECHNICAL SKILLS

Databases: Oracle 8i/9i/10g/11g,12c, MS SQL SERVER 2012/2014/2016, DB2

ETL Tools: Informatica PowerCenter 9.x,10.x (Designer, Workflow Manager, Workflow Monitor, Repository manager), IDQ 9.x/10.x (Informatica Data Quality)

Methodologies: Star Schema, Snowflake Schema, Dimensions and Facts.

Languages/Utilities: SQL, PL-SQL, UNIX Shell scripts, C, C#, HTML, CSS, XML, ASP.NET

IDE/Tools: Putty, Toad, SQL Developer

Operating Systems: UNIX, LINUX, Windows XP, 7, 8, 10.

Scheduling Tools: Control - M

PROFESSIONAL EXPERIENCE

Confidential - Birmingham, Alabama

ETL Informatica/PL SQL Developer

Responsibilities:

• Responsible for analyzing the business requirements, technical specifications and implementing the data transformations using Extract, Transform and Load (ETL) applications to deliver efficient solutions.
• Understanding the Logical and Physical data models for designing, developing, testing, analyzing and maintaining the application system.
• Responsible for setting up the development standards, best practices and technical feasibility of the business requirements.
• Design the system components to load the data from multiple source systems to the intermediate Staging area and then to the reporting tables in the Data warehouse.
• Developed mappings/sessions using Informatica Power Center 9.6/10.2 for data loading and worked with heterogeneous data sources like Oracle, SQL Server, Flat Files, XML files.
• Performed data manipulations using various Informatica Transformations like Filter, Expression, Lookup (Connected and Unconnected), Aggregate, Update Strategy, Normalizer, Joiner, Router, Sorter, Union and more.
• Implemented Slowly Changing dimensions to update the dimensional schema.
• Implemented procedures, functions in PL/SQL for stored Procedure Transformations.
• Used Informatica debugging techniques to debug the mappings and used session log files and bad files to trace errors occurred while loading.
• Extensively worked with Informatica Repository tables to analyze workflows, tasks, worklets run statistics and developed code to enable reporting of the delay in SLA for the scheduled batch runs daily and weekly.
• Worked on Production Support issues such as validation of SQL query, data-type mismatches, checking for database connectivity, and Stored Procedure connectivity, dropping indexes in independent sessions and re-creating them in different sessions, workflow session architecture setup.
• Applied SCD Type Dimension concept to populate the Data Warehouse Dimension tables.
• Used Parameter files to define the database connections for these DW tables.
• Used Informatica Scheduler in one of the projects I worked on to schedule these mappings as a daily run process.
• Expertise in unit test, integration test of Informatica components and to identify bottlenecks and bugs, and devise solutions to these problems to ensure the best possible performance.
• Configure deployment groups to integrate all the ETL objects like Source definitions, Target definitions, transformations, mappings, sessions, workflows to migrate to Production environment.
• Coordinated with the Admin team for deployment activities, server related issues and install necessary features in Informatica client tool.
• Troubleshoot issues for tracking the status of all defects raised during testing phase, assigning the defects within the team and resolving the defects based on priority to ensure the timelines of the deliverables.
• Developed UNIX Shell scripts to automate repetitive database processes and maintained shell scripts for data conversion.
• Used Control-M tool for Job scheduling.
• Integrated OBIEE with our monitoring system for report generation.

Environment: Informatica power center 9.6,10.2, Oracle 12c, Toad, SQL Server, OBIEE, Unix, Flatfiles, Putty and WinSCP.

Confidential

Database Developer

Responsibilities:

• Developed back end interfaces using PL/SQL stored procedures, packages, functions, Object Types, DB triggers, Indexes and Collections.
• Involved in developing E-R diagrams, logical & physical data modeling, development and implementation of the system.
• Involved in development of User Interface Objects (Forms9i and Reports9i) and Testing of the entire module.
• Analyzed, designed, and developed Oracle forms 10g queries, layout, report triggers, parameter form, data models etc.
• Hands on experience working with error handling and performance tuning in TERA data queries and utilities.
• Developed Database objects like tables, Indexes, triggers for Reporting Database.
• Developed various new reports from scratch utilizing Oracle Reports Builder for day-to-day validations.
• Creation of database objects liketables, views, materialized views, procedures, and packagesusing oracle tools likeToad, PL/SQL DeveloperandSQL* plus
• Hands on experience working with error handling and performance tuning in TERA data queries and utilities.
• Used SQL hints and Indexes as needed to improve performance.

Environment: PL/SQL, TOAD, MS-SQL server, SSIS, SSRS, Teradata, Erwin, MS Excel.