SUMMARY

• 7 plus years of work experience with diverse range of technical skills which includes development, testing, production deployment and production support.
• Expertise in ETL Concepts and development using Informatica Power Center (Rep Manager, Power Center Designer, Workflow Manager and Workflow Monitor).
• Expertise in using multiple Informatica transformations like Source Qualifier, Expression, Filter, Router, Rank, Sorter, Aggregator, Joiner, Look up, Update strategy and Sequence Generator etc.
• Experience in data extraction from heterogeneous sources like Flat Files, Oracle, SQL Server, DB2 using Informatica power center.
• Experience in development of CDC (Change Data Capture) Mappings based on Hash Code using Informatica MD5 function.
• Experience in documentation of project works like ST Mappings, Design Documents, Unit Test Documents, Data Profiling, Data Validations, Post Production, Root cause analysis for job failures.
• Good exposure on Informatica Data Quality (IDQ) for data profiling and data analysis.
• Specialized in identifying long running sessions and apply Performance Optimization by tweaking buffer blocks at Informatica Session Properties level.
• Experience in Sql/PLSql, TSql, tuning Sql that is used in Sql Override of Source Qualifier transformation and apply Indexes where ever required.
• Ability to work with other teams like Database Admins for data repair, System admins for network issues.
• Ability to create complex mappings like SCD’s (SCD1, SCD2, SCD4/SCD7) and complex workflows depending on business requirements.
• Proficient with Data warehousing concepts like Dimensional Data Modeling, Star Schema, SnowFlake schema, OLTP and OLAP, dimensions and facts.
• Familiar in using database application tools like Toad, Sql Developer, WinSCP, Sql Plus and proficient with Unix/Linux scripts with respect to Informatica.
• Experience in Deployment Groups to migrate objects from one environment to another environment using Repository Manager.
• Superior communications skills in dealing with clients and employees - both verbal and written.
• Ability to grasp technical and business concepts as per the requirements, and quickly deliver a credible solution.
• Proficient in using SAS Enterprise Guide and Enterprise Miner.

TECHNICAL SKILLS

Data Warehousing Tools: Informatica Power Centre 8.x,910, 950, 951& SSIS, Dimensional Data Modelling (Star/SnowFlake Schemas)

Databases: Oracle 11g/10g/9i, MS SQL Server 2005/2008/2008 R2/2012, DB2

Business Intelligence Tools: Business Objects, MSBI (SSIS), Cognos

Other Tools & Languages: SQLPLUS, TOAD, SQL Developer, SQL & PL/SQL, C, C++, HTML, PL/ SQLUNIX Shell Scripting

Scheduling Tools: Informatica Schedular, Autosys

Environment: Windows Server 2003, Server 2008, 2008 R2, Windows 7/Vista/XP/Millenium/98Unix, Linux

PROFESSIONAL EXPERIENCE

Confidential

Senior ETL Engineer

Responsibilities:

• Analyzed existing code by deep diving Informatica mappings/workflows and Sql Overrides.
• Documented the analyzed code and reviewed with existing development team, Subject Matter Experts, Data Architects and uploaded on internal sharepoint location for quick reference to project team.
• Interacted with cross functional team for Sql Conversion between existing database and re-architecture database (Column level discussion).
• Developed informatica mappings/sessions and workflows to extract the data from from DB2, Flat Files to Oracle target.
• Involved in creating new table structures and modifying existing tables to fit into the existing Data Model.
• Performed data manipulations as per the business requirements using various Transformations like Source Qualifier, Expression, Lookup, Aggregator, Update Strategy, Joiner, Connected and Unconnected Lookup.
• Written SQL overrides in Source Qualifier to push load onto the database for which the source database is same.
• Created mappings to load multiple Flat files using Indirect loading.
• Created session link constraints in the workflow based on the business requirements - job dependency.
• Redesigned some of the existing mappings in the system to meet new functionality.
• Used Workflow Manager for Creating, Validating, Testing and running the sequential and concurrent Sessions and scheduling them to run at specified time with required frequency.
• Extensively worked in the performance tuning of the mappings/sessions and applied PDO (Push Down Optimization where ever necessary).
• Created unit test documents to validate the data while development in progress and also to ensure the business requirements are met.
• Used Informatica Scheduler to schedule jobs.

Environment: Environment: Informatica 9.5/9.1 Power Centre, Oracle 11g, MS SQL Server, MSBI (SSIS), Cognos, SQLPLUS, TOAD, SQL Developer, SQL, Informatica Schedular, Autosys, Windows

Confidential, Windsor, CT

Senior Informatica Developer

Responsibilities:

• Correlate the business to technical aspect and involved in the development of high level design document to create the Informatica mappings.
• Creation of Informatica Workflows, sessions and tasks (Email, Command tasks).
• Integrating the Work Flows to the Autosys jobs to schedule the run of the mappings.
• Used Informatica Designer to create mappings using different transformations to move data from source systems to OLAP Data Warehouse.
• Developed complex mappings in Informatica to load the data from various sources into the Data Warehouse, using different transformations like Source Qualifier, Expression, Lookup, Aggregator, Update Strategy, Joiner, Sorter, Sequence Generator etc.
• Involved in creating new table structures and modifying existing tables to fit into the existing Data Model.
• Involved in debugging Informatica mappings, Performance and Unit testing of Informatica Sessions, and Target Data.
• Prepared SQL Queries to validate the data in both source and target databases.
• Maintained metadata, naming standards and warehouse standards for future application development
• Worked on preparing documents for migration of developed objects to from Dev to QA. Environment.
• Involved in writing test plan, Unit, System integration, user testing and Implementation of the System.
• Generated various List Reports, Grouped Reports, Cross tab Reports, Chart Reports, Drill-Down and Drill-Through Reports.
• Developed Prompt Pages, Cascaded input Prompts to display only the selected entries in the report and also worked on the customization of prompt parameters.
• Developed reports using Customized prompts, advance filters and conditional formatting.
• Assisted in knowledge transfer regarding the developed components in Informatica to the QA team and worked with them to resolve any issues.

Environment: Informatica Power Centre 9.1, Oracle 11g, Cognos, SQLPLUS, TOAD, SQL Developer, SQL, Informatica Schedular, Windows, Teradata SQL Assistant

Confidential, Grand Rapids, MI

Informatica Developer

Responsibilities:

• Extensively used Source Analyzer/Target Designer/Mapplet Designer/Transformation Developer/Mapping designer
• Designed and developed various mappings using Source Qualifier, Expression, Joiner, Aggregator, Filter, Router, Look up, update Strategy, Sorter, Sequence Generator transformations
• Created various sessions and workflows using workflow manager
• Scheduled Workflows using Informatica Workflow Monitor tool as per business needs (Daily/Weekly/Monthly and Quarterly)
• Monitored workflows as per their scheduled timings and take immediate action in case of failure, fetching the Session logs
• Interacted with Engagement Managers and Support team for Critical issues to resolve their queries
• Ensured SLA is met on production failures by proactively working on them suggesting the best possible solution
• Worked on building the Actuarial Datamart for the warehouse residing on Mainframes. The data mart is loaded on quarterly basis and was built to maintain 7yrs of historical data

Environment: Informatica Power Centre 8.6/9.0, Oracle 11g, SQLPLUS, TOAD, SQL Developer, SQL, Informatica Schedular

Confidential, NY

ETL/Informatica Engineer

Responsibilities:

• Gathered requirements, analyzed and created mappings for ETL design
• Delivered supporting end-to-end source to target mapping and transformation logic for ETL processing
• Designed and developed mappings using Source Qualifier, Expression, Lookup, Router, Filter, Sequence Generator, Sorter, Stored Procedure, Update Strategy, Joiner and Rank transformations
• Used extensively Informatica variables and parameters for incremental loading and connections
• Created sessions, configured workflows to extract data from various sources to loading into data mart
• Developed mappings, workflows to extract data from various sources like oracle, flat files and load them into oracle database
• Developed complex mappings and SCD type-I and Type-II mappings in Informatica to load the data from various sources using different transformations like Source Qualifier, Lookup (connected and unconnected), Expression, Aggregate, Update Strategy, Sequence Generator, Joiner, Filter, Rank and Router

Environment: Informatica Power Centre 8.6/9.0, Oracle 11g, SQLPLUS, TOAD, SQL Developer, SQL, Informatica Schedular, DB2

Confidential

Software Developer

Responsibilities:

• Managed and updated the Metadata associated with the ETL processes used to populate the data warehouse
• Worked under direct supervision to identify the source tables that contain the necessary data
• Worked with the Lead developer on optimizing mappings for better performance and efficiency
• Involved in understanding business requirements for development of data marts in SQL Server
• Prepared SQL Queries to validate the data in both source and target databases
• Documented required technical metadata such as source and target definitions
• Create unit test cases to ensure the data integrity, data correctness and the record count of the data migrated
• Involved in checking the target tables for data type mismatches and correcting them where necessary
• Assist the QA team to perform the testing of the migrated data