PROFESSIONAL SUMMARY:

• 8years of IT experience in Data Warehousing technology and all phases of Software Development Life Cycle (SDLC) including Business Requirement Analysis, Application designing, Development, Implementations and Testing of Data warehousing and Database business systems for financial, Insurance and HealthCare domains.
• Exposure in writing SQL using analytical functions like Ranking, case statement etc., also in writing optimize SQL query using ORACLE 12c/11g/10g, SQL Server 2014/2017 and Teradata 14.
• Excellent experience in designing and development of ETL Methodology using Informatica PowerCenter 10.2, 9.6,8.6
• Interacted with end - users to identify and develop Business Requirement Document (BRD) and transform it into technical requirements.
• Experience in Debugging and Performance tuning of targets, sources, mappings and sessions in Informatica.
• Worked in Change Data Capture (CDC) Methodology using Informatica PowerCenter 10.x/9. x
• Interacted with end-users and functional analysts to identify and develop Business Requirement Document (BRD) and transform it into technical requirements.
• Worked extensively in design and analysis of Requirements, Development, Testing and Production deployment.
• Prepared various types of documents like requirements gathering, ETL specification, Data Mapping, Test cases, Data dictionary etc.
• Expert in writing SQL query using multiple databases like ORACLE, SQL Server, Teradata etc.
• Extensive knowledge of Informatica tuning and SQL tuning.
• Experience in integration of various data sources into staging area.
• Performed Unit testing, System testing, Integration testing and users for UAT and prepared test report in different phases of project.
• Extensive experience with Data Extraction, Transformation, and Loading (ETL) from Multiple Sources.
• Designed and developed complex mappings, Mapplets, tasks and workflows and tuned it.
• Experience in Debugging and Performance tuning of targets, sources, mappings and sessions in Informatica.
• Good understanding of the Data modeling concepts like Star-Schema Modeling, Snowflake Schema Modeling.
• Experience in optimizing the Mappings and implementing the complex business rules by creating re-usable transformations like Mapplets.
• Extensively used Slowly Changing Dimension (SCD) technique in business application.
• Experience in Performance tuning of ETL process using pushdown optimization and other techniques. Reduced the execution time for huge volumes of data for a company merger projects. Heavily created mapplets, user defined functions, reusable transformations, look-ups.
• Conducted Unit tests, Integration tests and Customer Acceptance tests.
• Working experience in Agile and Waterfall methodologies.
• Excellent communication skills, ability to communicate effectively with executive and management team, having strong analytical, problem solving skills.
• Experience in design and build of Data Visualization, Analytics and Reporting in Tableau.
• Strong technical experience in Tableau Desktop and Tableau Server.
• Experience with conditional Formatting with shapes, colors, size, text, etc.
• Experience working with a variety of data sources (Excel, SQL, Oracle, Amazon RedShift etc.)
• Experience with actions, parameters, filters, sets, grouping, hierarchies.
• Experience with different kinds of charts like Bubble chart, Pie Chart, Line chart, Heat maps, Bar charts, Funnel charts, Box Plots, Waterfall Charts, Geographic Visualization.
• Experience with LOD Calculations and when to use them.
• Experience in creating Tableau workbooks from multiple data sources using Data Blending.
• Experience with calculations, geo-mapping, date/time field manipulation and dual-axis bar chart with multiple measures
• Experience in developing Performance Dashboards, scorecards, What if analysis and variable objects with formulas.
• Tableau Server-side experience in publishing reports in server and managing user entitlements.
• Tableau Server-side experience in creating new users, user groups, folders and sites.
• Tableau Server-side experience in creating subscriptions and alerts.
• Ability to translate business data into executive-level reports and presentations
• Experience in data modeling using Normalization and de-normalization techniques and Star/Snowflake schemas.
• Experience in writing complex SQL queries, stored procedures, query optimization and resolving key performance issues.
• Strong working experience with Oracle Database and Enterprise Data Management tools
• Experience in delivering quality solutions.
• Involved in data extraction, transformation and loading of data and updates to multi-dimensionalcube data
• Worked in Waterfall and Agile methodologies
• Strong analytical and problem-solving skills and ready to adapt to new BI tools.

TECHNICAL SKILLS:

ETLTools: IICS, Informatica Power Center 10.5

Dashboard Tools: Tableau

Data Warehousing Tool: Oracle, Snowflake, Postgres

Programming Languages: SQL, PL/SQL, UNIX

Operating Systems: Win XP SP2/SP3, win 2000, Win NT 4.0 and UNIX

PROFESSIONAL EXPERIENCE:

Confidential, Woodlands,TX

IICS/Informatica Developer

Responsibilities:

• Involved in data analysis and handling the ad-hoc requests by interacting with business analysts, clients and customers and resolve the issues as part of production support
• Design, Development, Testing and Implementation of ETL processes using IICS
• Developed Cloud mappings to extract the data for different regions.
• Convert specifications to programs and data mapping in an ETL IICS environment.
• Automated/Scheduled the cloud jobs to run daily with email notifications for any failures.
• Developed the audit activity for all the cloud mappings
• Developing UNIX shell scripts for automating and enhancing/streamlining existing manual procedures used at client location
• Extraction of the raw data from CRM to staging tables using Informatica Intelligent Cloud Services (IICS).
• Successfully built Restful API Integration using IICS
• Extensively used Pre-SQL and Post-SQL scripts for loading the data into the targets according to the requirement.
• Created Batch scripts to call Informatica workflow's for number of times. Created different jobs using batch scripting to call the workflow by using Command tasks.
• Executed Sessions, Sequential and concurrent batches for proper execution of mappings.
• Attended status meetings with project managers, escalated issues when necessary, attended meetings for issues resolution.
• Used parameters/variables for Powercenter mappings, sessions and workflows.
• Worked extensively with sources and target like Flat files, SQL Server tables
• To build efficient ETL components to meet the technical requirements
• Debug the sessions by utilizing the logs of the sessions
• Fixed the invalid mapping's and troubleshoot the technical problems of the database.
• Participated in Deployment by adding objects into deployment group and moving the code from test to production.
• Used Mapplets, Parameters and Variables to implement Object Orientation techniques and facilitate the reusability of code.
• Monitor Workflows in Production Environment and debug/resolve issues
• Written complex SQLs using joins, sub queries and correlated sub queries. Expertise in SQL Queries for cross verification of data
• Tuned the performance of mappings by following Informatica best practices and also applied several methods to get best performance by decreasing the run time of workflows.
• Responsible for Unit Testing, Integration Testing and helped with User Acceptance Testing.

Confidential

IICS/Informatica Developer

Responsibilities:

• Coordinating with product owners and scrum masters for performing data analysis and gathering business requirements.
• Developed technical specifications of the IICS and ETL process flow.
• Developed IICS CAI processes, app connections, service connectors and file connections to load data to Cloud integrator databases like Oracle cloud and Azure cloud though cloud connectors.
• Developed IICS data integration tasks, mappings, mapplets, taskflows and components and monitored them.
• Designed the Source - Target mappings and involved in designing the Selection Criteria document.
• Worked on design and development of Informatica mappings, workflows to load data into staging area called file system and from there loading data into applications through REST API calls.
• Used Informatica Power Center to create mappings, sessions and workflows for populating the data into dimension, fact, and lookup tables simultaneously from different source systems (Microsoft DB2, SQL server, Oracle, and Flat files).
• Created mappings using various Transformations like Source Qualifier, Aggregator, Expression, Filter,
• Router, HTTP, Java, Joiner, Stored Procedure, Lookup, Update Strategy, Sorter and Sequence Generator.
• Deployed reusable transformation objects such as mapplets to avoid duplication of metadata, reducing the development time.
• Developed data transformations to parse Json data and load JSON data to application database using REST API calls.
• Worked extensively with variables and parameter files in the mapping and in the session to pass the value and to control the environment and source, target information.
• Developed UNIX shell scripts to create dynamic mapping parameters, variables, parameter files and execute Informatica workflows.
• Developed Informatica scripts to load historical data (Onetime) and delta loads on daily basis.
• Implemented sending of Post-Session Email once data is loaded.
• Implemented Data warehouse framework to back track the data load details.
• Created and Monitored Workflows using Workflow Manager and Workflow Monitor.
• Involved with QA team to test the functionality of the system and test scripts from end to end.
• Used Debugger to test the mappings and fixed the bugs.
• Tuned performance of mapping and sessions by optimizing source, target bottlenecks and implemented pipeline partitioning.
• Involved in Performance/Query tuning. Generation/interpretation of explain plans and tuning SQL to improve performance.
• Performed End to End Informatica objects migration from Development environment to TEST and Production using UNIX shell scripts.
• Developed Tivoli Workflow Scheduler scripts to execute various daily and monthly ETL loads.
• Developed UNIX wrapper shell scripts to run and schedule batch jobs on daily and weekly basis.
• Developed end to end documentation for all the components to provide production support.
• Involved in unit testing and documentation of the ETL process.
• Involved in Production Support in resolving issues and bugs.

Environment: Informatica Power Center 10.2, Informatica Developer, SQL, Microsoft SQLServer, UNIX, REST API, Tivoli Workflow Scheduler and WINSCP.

Confidential

IICS/Informatica Developer

Responsibilities:

• Involved in all phases of SDLC from requirement gathering, design, development, testing, Production, user training and support for production environment.
• Actively involved in interacting with business users to record user requirements and Business Analysis.
• Outlined the complete process flow and documented the data conversion, integration and load mechanisms to verify specifications for this project.
• Parsing high-level design spec to simple ETL coding and mapping standards.
• Worked with PowerCenter Designer tools in developing mappings and Mapplets to extract and load the data from flat files and SQL server database.
• Maintained warehouse metadata, naming standards and warehouse standards for future application development.
• Created the design and technical specifications for the ETL process of the project.
• Used Informatica as an ETL tool to create source/target definitions, mappings and sessions to extract, transform and load data into staging tables from various sources.
• Responsible for mapping and transforming existing feeds into the new data structures and standards utilizing Router, Lookups Using Connected, Unconnected, Expression, Aggregator, Update strategy & stored procedure transformation.
• Worked with various complex mapping, designed slowly changing dimension Type1 and Type2.
• Performance tuning of the process at the mapping level, session level, source level, and the target level.
• Created Workflows containing command, email, session, decision and a wide variety of tasks.
• Tuning the mappings based on criteria, creating partitions in case of performance issues.
• Performed data validation after the successful End to End tests and appropriate error handling in ETL processes.
• Resolving the tickets based on the priority levels raised by QA team.
• Developed Parameter files for passing values to the mappings as per requirement.
• Scheduled batch and sessions within Informatica using Informatica scheduler and also customized pre written shell scripts for job scheduling.

Environment: Informatica PowerCenter 10.2, Oracle 12c, PostgreSQL, Unix, Erwin 9.3, Control M

Confidential

Informatica Developer

Responsibilities:

• Involved in all phases of SDLC from requirement gathering, design, development, testing, UAT, deployment to production environment.
• Actively involved in interacting with business users to record user requirements.
• Involved in Analysis, profiling and cleansing of source data and understanding the business process.
• Translated requirements into business rules & made recommendations for innovative IT solutions.
• Outlined the complete process flow and documented the data conversion, integration, and load mechanisms to verify specifications for this data migration project.
• Involved in documentation of Data Mapping & ETL specifications for development from source to target.
• Also implemented the change Data Capture (CDC) while integrating the enterprise data sources.
• Parsing high-level design spec to simple ETL coding and mapping standards.
• Worked with PowerCenter Designer tools in developing mappings and Mapplets to extract and load the data from flat files and Oracle database.
• Maintained naming standards and warehouse standards for future application development.
• Created the design and technical specifications for the ETL process of the project.
• Used Informatica as an ETL tool to create source/target definitions, mappings, and sessions to extract, transform and load data into staging tables from various sources.
• Responsible for mapping and transforming existing feeds into the new data structures and standards utilizing Router, Lookups Using Connected, Unconnected, Expression, Aggregator, Update strategy & stored procedure transformation.
• Performance tuning of the process at the mapping level, session level, source level, and the target level.
• Strong on Exception Handling Mappings for Data Quality, Data Cleansing and Data Validation.
• Created Workflows containing command, email, session, decision, and a wide variety of tasks.
• Tuning the mappings based on criteria, creating partitions in case of performance issues.
• Tested End to End to verify the failures in the mappings using scripts.
• Performed data validation after the successful End to End tests and appropriate error handling in ETL processes.
• Resolving the tickets based on the priority levels raised by QA team.
• Facilitated in developing testing procedures, test cases and User Acceptance Testing (UAT)
• Developed Parameter files for passing values to the mappings for each type of client
• Scheduled batch and sessions within Informatica using Informatica scheduler and also wrote shell scripts for job scheduling.

Environment: Informatica Power Center 9.6.1., Oracle 11g, MySQL, UNIX, Control M, JIRA.

Confidential

ETL Informatica Developer

Responsibilities:

• Experienced in using Informatica for data profiling and data cleansing, applying rules and develop mappings to move data from source to target systems
• Designed and implemented ETL mappings and processes as per the company standards, using Informatica PowerCenter.
• Extensively worked on complex mappings which involved slowly changing dimensions.
• Developed several complex mappings in Informatica a variety of transformations, Mapping
• Worked extensively on Informatica transformations like Source Qualifier, Expression, Filter, Router, Aggregator, Lookup, Update strategy, Sequence generator and Joiners.
• Deployed reusable transformation objects such as Mapplets to avoid duplication of metadata, reducing the development time.
• Worked on developing Change Data Capture (CDC) mechanism using Informatica
• Power Exchange for some of the interfaces based on the requirements and limitations of the Project.
• Implemented performance and query tuning on all the objects of Informatica using SQL Developer.
• Worked in the ETL Code Migration Process from DEV to QA and to PRODUCTION.
• Created the design and technical specifications for the ETL process of the project.
• Responsible for mapping and transforming existing feeds into the new data structures and standards utilizing
• Created different parameter files and started sessions using these parameter files using pmcmd command to change session parameters, mapping parameters, and variables at runtime.

Environment: Informatica PowerCenter 9.1.1, SQL Server 2008, Oracle 10g, Unix, Teradata 14, Cognos 9