SUMMARY

• Around 7 years of IT experience in all phases of Software Development Life Cycle (SDLC) which includes User Interaction, Business Analysis/Modeling, Design, Development, Integration, Planning and testing and documentation in data warehouse applications, ETL processing and distributed applications.
• Excellent domain knowledge of Banking Financial, Manufacturing and Insurance.
• Strong expertise in using ETL Tool Informatica Power Center 8.x/9.x/10.0,Informatica Intelligent Cloud Services (Designer, Workflow Manager, Repository Manager And ETL Concepts).
• Extensive experience with Data Extraction, Transformation, and Loading (ETL) from disparate data sources like Multiple Relational Databases (Teradata, Oracle, SQL Server, DB2) and Flat Files
• Worked with various transformations like Normalizer, expression, rank, filter, group, aggregator, lookups, joiner, sequence generator, sorter, SQLT, stored procedure, Update strategy, Source Qualifier, Transaction Control, JAVA, Union, CDC etc.,
• Worked with Teradata utilities like Fast Load and Multi Load and Tpump and Teradata Parallel transporter and highly experienced in Teradata SQL Programming.
• Experienced in Teradata Parallel Transporter (TPT). Used full PDO on Teradata and worked with different Teradata load operators.
• Designing and developing Informatica mappings including Type - I, Type-II slowly changing dimensions (SCD).
• Experienced in using advanced concepts of Informatica like Push Down Optimization (PDO).
• Very good in data modeling knowledge in Dimensional Data modeling, Star Schema, Snow-Flake Schema, FACT and Dimensions tables.
• Experienced in writing SQL, PL/SQL programming, Stored Procedures, Package, Functions, Triggers, Views, Materialized Views.
• Experience in debugging mappings, identified bugs in existing mappings by analyzing the data flow and evaluating transformations.
• Very strong knowledge on end to end process of Data Quality requirements and its implementation.
• Good experience in writing UNIX shell scripts, SQL scripts for development, automation of ETL process, error handling and auditing purposes.
• Coordinating with Business Users, functional Design team and testing team during the different phases of project development and resolving the issues.
• Experience in performance tuning of Informatica mappings and sessions to improve performance for the large volume projects.
• Excellent communication and interpersonal skills, self-motivated, quick learner, team player.

TECHNICAL SKILLS

ETL Tools: Informatica PowerCenter 10.0/9.x/8.x, Informatica PowerExchange 9.x/8.x, Informatica Intelligent Cloud Services (IICS)

Languages: SQL, PL/SQL, HTML, XML, Perl, UNIX Shell Scripting

Methodology: Agile, SCRUM, Waterfall.

Databases: Oracle 11g/10g, SQL Server 2012/2008, DB2, Teradata 15/14, UDB DB2

Databases utility: AWS S3 bucket, AWS Redshift, Teradata SQL Assistant, Fastload, Mload, BTEQ, F-Export, TPump, TPT.

Operating Systems: Windows NT, 2003, 2007, UNIX, Linux.

Modelling Tool: Erwin 9.1, MS Visio

Scheduling Tools: Control-M, Autosys

Reporting: Tableau 9.2, Cognos 10

Others Tool: JIRA, Notepad++, MS office, T-SQL, TOAD, SQL Developer, XML Files, Rally, Control - M, Autosys, GitHub, ORACLE ERP, PUTTY, WinSCP, SharePoint, PL/SQL Developer, TOAD, Teradata SQL Assistant

PROFESSIONAL EXPERIENCE

Confidential - Portsmouth, NH

Sr. Informatica Developer

Responsibilities:

• Effectively analyze large amounts of data from data modelling perspective.
• Identify, analyze the source system data for data quality, data profiling and data governance.
• Responsible for BI/Data Warehouse data modeling with involvement in design, dimensional modeling and architecture.
• Responsible for developing ETL data mapping documents for source to target column mapping and business rules.
• Analyze and understand data relationships between entities.
• Building re-engineering models from already existing models of source.
• Optimization of SQL scripts by Indexing, Partitioning and de-normalization.
• Responsible for developing Unit test case documents.
• Responsible for creating connection with AWS S3 and Redshift through Informatica Intelligent Cloud services.
• Worked in agile team, responsible for creating user stories and subtask.

Environment: Informatica Intelligent cloud Services, SAP HANA, AWS S3, AWS Redshift, SQL, PL/SQL, DB Visualizer, JIRA Task board.

Confidential - Detroit, Michigan

Sr. Informatica Developer

Responsibilities:

• Involved in all phases of SDLC from requirement gathering, design, development, testing, Production, user training and support for production environment.
• Proactively 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 data migration 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 Oracle database.
• Maintained warehouse metadata, naming standards and warehouse standards for future application development.
• Created multiple BTEQ scripts and Teradata utilizes like BTEQ, FASTLOAD, MLOAD, and FASTEXPORT.
• Created the design and technical specifications for the ETL process of the project.
• UsedInformaticaas 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.
• Maintained Development, Test and Production Mappings, migration using Repository Manager. Involved in enhancements and Maintenance activities of the data warehouse.
• Performance tuning of the process at the mapping level, session level, source level, and the target level.
• Implemented various new components like increasing the DTM Buffer Size, Database Estimation, Incremental Loading, Incremental aggregation, Validation Techniques, and load efficiency.
• 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 shell scripts.
• Performed data validation after the successful End to End tests and appropriate error handling in ETL processes.
• Developed Parameter files for passing values to the mappings for each type of client
• Scheduled batch and sessions with in Informatica using Informatica scheduler and wrote shell scripts for job scheduling.

Environment: Informatica PowerCenter 10.2, Informatica PowerExchange 10.2, Cognos 10, Linux, SQL, PL/SQL, Oracle 11g, Teradata 15, TOAD, SQL Server 2012, ORACLE 11g, Control M

Confidential - Costa Mesa, CA

Sr. Informatica Developer

Responsibilities:

• Used Informatica Power Center for (ETL) extraction, transformation and loading data from heterogeneous source systems into target database.
• Created mappings using Designer and extracted data from various sources, transformed data according to the requirement.
• Involved in extracting the data from the Flat Files and Relational databases into staging area.
• Mappings, Sessions, Workflows from Development to Test and then to UAT environment.
• Developed Informatica Mappings and Reusable Transformations to facilitate timely Loading of Data of a star schema.
• Developed the Informatica Mappings by usage of Aggregator, SQL overrides usage in Lookups, source filter usage in Source qualifiers, and data flow management into multiple targets using Router.
• Created Sessions and extracted data from various sources, transformed data according to the requirement and loading into data warehouse.
• Developed several reusable transformations and mapplets that were used in other mappings.
• Prepared Technical Design documents and Test cases.
• Implemented various Performance Tuning techniques.
• Used SQL tools like TOAD to run SQL queries to view and validate the data loaded into the warehouse.
• Performed data integration and lead generation from Informatica cloud into Salesforce cloud.
• Created summarized tables, control tables, staging tables to improve the system performance and as a source for immediate recovery of Teradata database
• Created Stored Procedures to transform the Data and worked extensively in PL/SQL for various business needs of the transformations while loading the data into Data warehouse.
• Developed transformation logic as per the requirement, created mappings and loaded data into respective targets.
• Wrote hundreds of SQL query for data quality analysis to validate the input data against business rules.
• Responsible for determining the bottlenecks and fixing the bottlenecks with performance tuning.
• Extensively worked on Unit testing for the Informatica code using SQL Queries and Debugger.
• Used PMCMD command to start, stop and ping server from UNIX and created UNIX Shell scripts to automate the process.
• Improved performance testing in Mapping and the session level.
• Worked with UNIX shell scripts extensively for job execution and automation.
• Coordinated with Autosys team to run Informatica jobs for loading historical data in production.
• Documented Data Mappings/ Transformations as per the business requirement.
• Migration of code from development to Test and upon validation to Pre-Production and Production environments.
• Provided technical assistance to business program users and developed programs for business and technical applications.

Environment: Informatica PowerCenter 9.6, Informatica PowerExchange 9.6, SQL Server 2008, Shell Scripts, ORACLE 11g, SQL, PL/SQL, UNIX, Toad, SQL Developer, HP Quality Center, Cognos 9, T-SQL, Autosys

Confidential, San Francisco, California

Informatica Developer

Responsibilities:

• Created analysis of source systems, business requirements and identification of business rules.
• Responsible for developing, support and maintenance for the ETL (Extract, Transform and Load) processes rising Informatica PowerCenter
• Worked on mappings, Mapplets and workflow to meet the business needs ensured they are reusable transformation to avoid duplications.
• Extensively used ETL to transfer and extract data from source files (Flat files and Netezza) and load the data into the target database.
• Documented Mapping and Transformation details, user requirements, implementation plan and schedule.
• Extensively used Control-M for Scheduling and monitoring.
• Involved in building tables, views and Indexes.
• Involved in ad hoc querying, quick deployment, and rapid customization, making it even easier for users to make business decisions.
• Designed and developed efficient Error Handling methods and implemented throughout the mappings. Responsible for Data quality analysis to determine cleansing requirements.
• Worked with several facets of the Informatica PowerCenter tool - Source Analyzer, Data Warehousing Designer, Mapping & Mapplet Designer and Transformation Designer. Development of Informatica mappings for better performance.
• Responsible for Performance Tuning at the Mapping Level, Session Level, Source Level and the Target Level for Slowly Changing Dimensions Type1, Type2 for data Loads.
• Configured the sessions using workflow manager to have multiple partitions on Source data and to improve performance. Understand the business needs and implement the same into a functional database design.
• Developed many stored procedures using PL/SQL to implement complex business logic.
• Prepared Unit/ Systems Test Plan and the test cases for the developed mappings.
• Written documentation to describe development, logic, testing, changes and corrections.

Environment: Informatica PowerCenter 8.6, Oracle 11g, MySQL, AWS Redshift, HDFS, MSSQL Server 2012, Erwin 9.2, PL/SQL, Control-M, Putty, Shell Scripting, WinSCP, Notepad++, JIRA, Tableau 8.2

Confidential

Informatica Developer

Responsibilities:

• Working with business users and business analyst for requirements gathering and business analysis.
• Converted business requirement into high level and low-level design.
• Designing and customizing data models for Data warehouse supporting data from multiple sources on real time.
• Extracted data from different flat files, MS Excel, MS Access and transformed the data based on user requirement using Informatica Power Center and loaded data into target, by scheduling the sessions.
• Worked on Informatica Power Center 8.6 tool - Source Analyzer, Data Warehousing designer, Mapping & Mapplet Designer and Transformation Designer.
• Developed Informatica mappings and in tuning of mappings for better performance.
• Used Normalizer transformation with COBOL sources stored in DB2.
• Created reusable mapplets and Transformations starting concurrent batch process in server and did backup, recovery and tuning of sessions.
• Worked on various kinds of transformations like Expression, Aggregator, Stored Procedure, Java, Lookup, Filter, Joiner, Rank, Router and Update Strategy.
• Used debugger to debug mappings to gain troubleshooting information about data and error conditions.
• Involved in monitoring the workflows and in optimizing the load times.
• Used Change Data Capture (CDC) to simplify ETL in data warehouse applications.
• Involved in writing procedures, functions in PL/SQL.
• Involved in extensive performance tuning by determining bottlenecks at various points like targets, sources, mappings, sessions or system. This led to better session performance.
• Prepared UNIX Shell Scripts and these shell scripts will be scheduled in AUTOSYS for automatic execution at the specific timings.
• Stored reformatted data from relational, flat file, XML files using Informatica.

Environment: Power Center 8.6.1, Flat files, MS Excel Files, MS Access, Oracle 9i/10g, Erwin 7.3, Power Designer, MS SQL Server 2005/2000, PL/SQL, IBM DB2 8.0, Teradata V2R5, Mainframes, Toad, Perl, Unix scripting, Windows NT, Autosys, Microsoft Project Plan.