PROFESSIONAL SUMMARY:

• Over 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.
• Extensive experience with Data Extraction, Transformation, and Loading (ETL) from disparate data sources like Multiple Relational Databases (Oracle, SQL SERVER), and Flat Files
• Strong experience with Informatica tools using real - time Change Data Capture and MD5.
• Performed the data profiling and analysis making use of Informatica Data Quality (IDQ).
• Worked with various transformations like Normalizer, expression, rank, filter, group, aggregator, lookups, joiner, sequence generator, sorter, SQLT, Update strategy, Source Qualifier, Transaction Control, JAVA, Union, CDC etc.,
• Experience with Teradata 14/13/12 utilities like Fast Load and Multi Load and Tpump and highly experienced in Teradata SQL Programming.
• Designing and developing Informatica mappings including Type-I, Type-II, Type-III 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.
• Experience in Performance Tuning and Debugging of existing ETL processes.
• Good hands on experience in writing UNIX shell scripts to process Data Warehouse jobs.
• Coordinating with Business Users, functional Design team and testing team during the different phases of project development and resolving the issues.
• Working Knowledge of Hadoop Ecosystem (HDFS, HBase, Spark, Scala, Hive, Pig, Flume, NoSQL, MapReduce etc.)
• Good skills in defining standards, methodologies and performing technical design reviews.
• Good communication skills, interpersonal skills, self-motivated, quick learner, team player.

TECHNICAL SKILL S:

ETL Tools: Informatica PowerCenter 9.6/8.x, Informatica Cloud

Languages: C, C++, Java basic, SQL, UNIX Shell Scripting

Methodology: Agile, Waterfall

Databases: Oracle 11g/10g, SQL Server 2012, DB2, Teradata 12

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

IDEs: TOAD, Teradata SQL Assistant

Modelling Tool: Erwin 9.1/7.2

Scheduling Tools: Control-m, Autosys

Hadoop / Big Data: Cloudera, HDFS, HBaase, Spark, Scala, Hive, Pig, Flume, NoSQL, MapReduce

Reporting: Tableau 9.2, Cognos 9/8

Others Tool: MS office -SQL, Control - M, Autosys, ORACLE ERP, PUTTY

PROFESSIONAL EXPERIENCE:

Confidential, Tampa, FL

Sr. Informatica Developer

Responsibilities:

• Extracted the data from the flat files and other RDBMS databases into staging area and populated onto Data Warehouse.
• Developed number of mappings, Mapplets, reusable transformations to implement the business logic and to load the data incrementally.
• Tuning Informatica Mappings and Sessions for optimum performance.
• Developed various mapping by using reusable transformations.
• Developed mappings by usage of Aggregator, SQL Overrides in Lookups, Source filter in Source Qualifier and data flow management into multiple targets using Router transformations.
• Used various transformations like Filter, Expression, Sequence Generator, Update strategy.
• Used Power Center server manager/Workflow manager for session management, database connection management and scheduling.
• Worked on loading of data from several flat files to Staging using Teradata MLOAD, FLOAD and BTEQ.
• Created multiple Type 2 mappings in the Customer mart for both Dimension as well as Fact tables, implementing both date based and flag-based versioning logic.
• Monitor troubleshoots batches and sessions for weekly and Monthly extracts from various data sources across all platforms to the target database.
• Involved in Performance tuning at source, target, mappings, sessions, and system levels.
• Tested the data and data integrity among various sources and targets. Associated with Production support team in various performances related issues.
• Developed UNIX shell scripts to move source files to archive directory.

Environment: Informatica PowerCenter 9.6.1, Oracle 11g, SQL Server, Teradata 14, Microsoft SQL Server Management Studio, UNIX shell scripting, Agile.

Confidential, Miami, FL

Sr. Informatica Developer

Responsibilities:

• Analyze business requirements, technical specification, source repositories and physical data models for ETL mapping and process flow.
• Worked extensively with mappings using expressions, aggregators, filters, lookup, joiners, update strategy and stored procedure transformations.
• Extensively used Pre-SQL and Post-SQL scripts for loading the data into the targets as per requirement.
• Designed the ETL processes using Informatica to load data from Oracle, Flat Files (Fixed Width and Delimited) to staging database and from staging to the target Warehouse database.
• Developed mapping to load Fact and Dimension tables, for type 1 and type 2 dimensions and incremental loading and unit tested the mappings.
• Coordinate and develop all documents related to ETL design and development.
• Responsible for debugging and performance tuning of targets, sources, mappings and sessions.
• Optimized the mappings and implementing the complex business rules by creating re-usable transformations and Mapplets.
• Development of scripts for loading the data into the base tables in EDW and to load the data from source to staging and staging area to target tables using Fast Load, Multiload and BTEQ in utilities of Teradata.
• Worked extensively on Informatica Partitioning when dealing with huge volumes of data and also partitioned the tables in Teradata for optimal performance.
• Worked with large amounts of data analysis, utilizing appropriate tools and techniques and presenting them to both internal and external business need.
• Used Informatica workflow manager for creating, running the Batches and Sessions and scheduling them to run at specified time.
• Created Workflows, tasks, database connections, FTP connections using workflow manager.
• Scheduled jobs for running daily, weekly and monthly loads through control-M for each workflow in a sequence with command and event tasks.
• Code walks through with team members.
• Used created stored procedures using and driving scripts using Unix Shell Scripts.
• Created UNIX shell scripting for automation of ETL processes.
• Used UNIX for check in’s and check outs of workflows and config files in to the Clear case.
• Automated ETL workflows using Control-M Scheduler.
• Involved in production deployment and later moved into warranty support until transition to production support team.
• Experience in monitoring and Cognos reporting issues for the Daily, weekly and Monthly processes. Also, work on resolving issues on priority basis and report it to management.

Environment: Informatica PowerCenter 9.6.1, IDQ 9.6.1, Oracle 11g, Teradata 13, Teradata SQL Assistant, MSSQL Server, Shell Scripting.

Confidential, Winston-Salem, NC

Sr. Informatica Developer

Responsibilities:

• Co-ordination from various business users’ stakeholders and SME to get Functional expertise, design scenarios review, UAT participation and validation of data from multiple Hospital applications - like EPIC, PATCOM etc.
• Designing custom reports via SQL Reporting Services to align with requests from internal account teams and external Clients.
• Created Mappings using Mapping Designer to load the data from various sources, using different transformations like Source Qualifier, Expression, Lookup (Connected and Unconnected), Aggregator, Update Strategy, Joiner, Filter, and Sorter transformations.
• Assigned requirements and implement them into source to target mappings.
• Extensively worked on Mapping Variables, Mapping Parameters, Workflow Variables and Session Parameters.
• Worked on PowerCenter Designer tools like Source Analyzer, Warehouse Designer, Mapping Designer, Mapplet Designer and Transformation Developer.
• Designing and executing test scripts and test scenarios, reconciling data between multiple data sources and systems.
• Used Debugger within the Mapping Designer to test the data flow between source and target and to troubleshoot the invalid mappings.
• Designed the ETL processes and load data from Oracle, Flat Files to staging database and from staging to the target Warehouse database.
• Designed various Mappings for extracting data from various sources involving Flat files, Oracle and SQL Server using Teradata utilities BTEQ, MLOAD, FLOAD and PUMP.
• Used DDL Commands and DML Commands (SQL) in Teradata utilities like Fast Load and Multi Load.
• Strong hands on experience in SQL and Teradata utilities (Fast Export, Multiload, Fast Load, TPT and BTEQ).
• Sessions, configured workflows to extract data from various sources, transformed data, and loading into data warehouse.
• Working with large amounts of data independently executing data analysis, utilizing appropriate tools and techniques Interpreting results and presenting them to both internal and external client.
• Worked on SQL tools like TOAD and SQL Developer to run SQL Queries and validate the data.
• Worked on Dimensional Data Modeling using Data modeling tool Erwin.
• Scheduled Informatica Jobs through Autosys scheduling tool.
• Created quick Filters Customized Calculations, Conditional formatting for various analytical reports and dashboards.
• Involved in creating Informatica mappings, mapplets, worklets and workflows to populate the data from different sources to warehouse.
• Used MS Excel, Word, Access, and Power Point to process data, create reports, analyze metrics, implement verification procedures, and fulfill client requests for information.
• Involved in testing the database using complex SQL scripts and handled the performance issues effectively.
• Cognos reporting for the Daily, weekly and Monthly processes. work on resolving issues on priority basis and Cognos report it to management.

Environment: Informatica PowerCenter 8.6.1, Oracle 11g, TOAD, Putty, Autosys Scheduler, UNIX, Teradata 13, Erwin 7.5, Cognos 9.

Confidential, Peoria, IL

Informatica Developer

Responsibilities:

• Experience in integration of data sources like SQL server and MS access and non-relational sources like flat files into staging area.
• Designed and developed Technical and Business Data Quality rules in IDQ (Informatica Developer) and created the Score Card to present it to the Business users for a trending analysis (Informatica Analyst)
• Effectively worked on Mapping Designer, Workflow Manager, and Workflow Monitor.
• Extensively used Sequence Generator in all mappings and fixed bugs / tickets raised in production for existing mappings in common folder for new files through versioning (Check in and Check out) on an urgency through support for QA in component unit testing and validation.
• Used shortcuts for sources, targets, transformations, mapplets, and sessions to reuse objects without creating multiple objects in the repository and inherit changes made to the source automatically.
• Applied slowly changing Dimensions Type I and Type II on business requirements.
• Extensively worked on performance tuning and in isolating header and footer in single file.
• Writing SQL queries to create end-user reports /Developing SQL Queries and stored procedures in support of ongoing work and application support.
• Executing test scripts and test scenarios and data between multiple data sources and systems.
• Involved in requirement gathering, Design, testing, project coordination and migration.
• Worked on Multidimensional Models and created Reports in Report Studio using Cubes as a data source.
• Running daily, weekly and monthly loads through control-M Scheduled jobs for each workflow in a sequence with command and event tasks.
• Used most of the transformations such as the Aggregators, Filters, Routers, Sequence Generator, Update Strategy, Rank, Expression, lookups (connected and unconnected), Mapping Parameters, Session parameters, Mapping Variables and Session Variables.
• Fine-tuned ETL processes by considering mapping and session performance issues.
• Responsible for Creating workflows and Worklets. Created Session, Event, Command, Control, Decision and Email tasks in Workflow Manager.
• Maintained the proper communication between other teams and client.

Environment: Informatica PowerCenter 8.6, SQL, UNIX Shell Scripting, SQL Server 2008, Oracle 11g, Control-M.

Confidential, Chicago, IL

Informatica Developer

Responsibilities:

• Involved in full life cycle development including Design, ETL strategy, troubleshooting Reporting, and Identifying facts and dimensions.
• Reviewing the requirements with business, doing regular follow ups and obtaining sign offs.
• Worked on different tasks in Workflows like sessions, events raise, event wait, decision, e-mail, command, worklets, Assignment, Timer and scheduling of the workflow.
• Created sessions, configured workflows to extract data from various sources, transformed data, and loading into data warehouse.
• Moving the data from source systems to different schemas based on the dimensions and fact tables by using the slowly changing dimensions (SCD) type 2 and type 1.
• Used Debugger to test the mappings and fixed the bugs.
• Used various transformations like Filter, Expression, Sequence Generator, Source Qualifier, Lookup, Router, Rank, Update Strategy, Joiner, Stored Procedure and Union to develop robust mappings in the Informatica Designer.
• Prepared the required application design documents based on functionality required.
• Designed the ETL processes using Informatica to load data from Oracle, Flat Files (Fixed Width and Delimited) to staging database and from staging to the target Warehouse database.
• Worked on database connections, SQL joins, aggregate conditions, parsing of objects and hierarchies.
• Responsible for monitoring all the sessions that are running, scheduled, completed and failed. If the session fails debug the Mapping.
• Involved in testing Unit and integration Testing of Informatica Sessions, Batches, fixing invalid Mappings.
• Defined the program specifications for the data migration programs, as well as the necessary test plans used to ensure the successful execution of the data loading processes.
• Developed and executed scripts to schedule loads, for calling Informatica workflows using PMCMD command.
• Built the Informatica workflows to load table as part of data load.
• Wrote Queries, Procedures and functions that are used as part of different application modules.
• Implemented the best practices for the creation of mappings, sessions and workflows and performance optimization.
• Created Informatica Technical and mapping specification documents as company standards.

Environment: Informatica PowerCenter 8.1, IDQ 8.1, Oracle 10g, Toad, SQL Developer, UNIX.