SUMMARY

• Over 6+ years of experience in IT industries and 3+ years of Data Warehouse experience with domain knowledge of Finance/Banking, Insurance and Title Insurance / Real Estate Services domain.
• Extensive experience in ETL and Data Integration for developing ETL mappings and scripts using Informatica Power Center 9.5,8.6.1/8.6, using Designer, Repository Manager, Workflow Manager & Workflow Monitor. Exposure on Power Exchange functionality, Informatica Data Quality (IDQ).
• Experience working with SDLC and implementing, Waterfall and Agile methodologies.
• Hands on experience on all phases of software development life cycle (SDLC) of Data warehousing, including requirement gathering from business users, analysis, design, creation of mapping documents, specification writing, development, testing, and implementation.
• Experience working with Informatica in Unix and Linux environments.
• Expertise using Oracle 11g/10g, Teradata 12, MS SQL Server 2008/2005/2000 , Erwin 7.0/4.0/3.5, Toad, SQL Developer.
• Extensively used Teradata SQL Assistant and BTEQ to write SQL’s for ETL.
• Extensive experience in creating Transformations and Mappings using Informatica Designer to implement business rules and processing tasks using Workflow Manager to move data from Multiple Sources into Targets.
• Expertise in working with various transformations using Aggregator, Look Up, Update Strategy, Joiner, Filter, Sequence Generator, Normalizer, Sorter, Router, Java transformations in Informatica PowerCenter Designer.
• Experienced in creating documentation like Source - Target Mapping (STM) documents, function and technical design documents.
• Experience in implementation of Data Cleanup procedures, transformations, Scripts, Stored Procedures and execution of test plans for loading the data successfully into the targets.
• Extensive expertise in Debugging, Performance Tuning and Optimization of the Sessions and Mappings.
• Proficiency in data warehousing techniques for Data Cleansing, Slowly Changing Dimension Phenomenon, Surrogate Key assignment.
• Extensive Experience in integration of various RDBMS like Oracle, DB2, SQL server into staging area.
• Expertise in Data Analysis, Data Design, Developing and Deployment for Data Integration for BI requirements.
• Profound knowledge of the principle of Data Warehouse using Fact tables, Dimensional Table, Star Schema Modeling and Snowflake Schema Modeling.
• Designed, developed and implemented Master Data Management solutions using MDM 9.6.1.
• Extensive Knowledge of Installation, Configuration and Maintenance of Informatica Power Center on various OS platforms, Windows2000, Windows2003, Windows XP.
• Experience in Administrative activities such as creating folders, assigning security permissions to users and creating repositories, setting up groups/users permissions in Informatica Repository Manager and admin console.
• Ability to analyze source data for potential data quality issues and addressing these issues in ETL procedures.
• Coordinate ETL and database development work with developers and conduct Code Reviews.
• Excellent Oral/Written/Interpersonal communication skills, quick learner, willing to adapt to the team and organizational environment.

TECHNICAL SKILLS

ETL Tools: Informatica 9.5.1/9.1/9. x/8.x/7.x/6.x (Power Centre, Power Mart, PowerExchange), Informatica Data Quality (IDQ), Talend ETL.

Databases/Datawarehouse: Oracle 11g/10g, SQL Server 2012/2008, MySQl, TeraData 12

Data Modeling Tools: Erwin 4.5/4.0/3.x, MS Visio

Query Tools: SQL Developer, Toad, SQL*Plus, SQL*Loader.

OLAP/Reporting Tools: OBIEE 10.1.3, Tableau Software.

Languages: Unix Shell Scripting, XML, JSON, WSDL, Java 1.6

Operating systems: Linux, Unix, Widows 10,7, Windows 2003/2007, Windows XP

IDE/Development tools: Eclipse, Toad

Development Methodologies: Agile, Waterfall, Test Driven Development

PROFESSIONAL EXPERIENCE

Confidential, Columbus OH

Informatica ETL Developer

Responsibilities:

• Experience in developing and deploying full lifecycle ETL project using Agile Development Methodology.
• Active part in Scrum meeting on day to day activities and Task
• Worked closely with Business Analysis team and Reverse Engineering Team to gather the Analytics requirements and created the Business Model using Star schemas.
• Worked on designing and coding the complete ETL process using Informatica for various transactions and loading data from different sources like Flat Files, Web Services and Relational Database.
• Created numerous Mappings and Mapplets using Transformations like Filters, Aggregator, Lookups, Expression, Sequence generator, Sorter, Joiner and Update Strategy.
• Implemented slowly changing dimensions Type1 and Type2 using date dimension.
• Created Mapplets and reusable transformations to be re-used during the development life cycle.
• Created Indexes on the Target database tables using pre-sql and post-sql techniques while loading huge tables.
• Created session and Worklets in Workflow manager to trigger e-mail events
• Handled UNIX operating system tasks by generating Pre and Post-Session UNIX Shell Scripts.
• Developed shell scripts for running batch jobs and scheduling them.
• Worked closely in resolving Issues using Session Logs and Workflow Logs.
• Responsible for determining Incremental Loading mappings using Mapping Variables and Parameter Files.
• Performed Unit Testing and played an active role in moving the code to Staging, Testing, UAT and Production environments
• Collaborate with team members to resolve issues to assure the successful delivery of high quality ETL and BI Code. Involved in Unit and Integration Testing of the Data Warehouse.
• Performed the data validations and control checks to ensure the data integrity and consistency.
• Involved in resolving Performance Tuning bugs reported by business users by following Query Optimization techniques. Involved in troubleshooting data quality and integrity issues.
• Developed PL/SQL Procedures, Functions, Packages, SQL scripts in Oracle 11g.
• Wrote UNIX shell scripts to prepress data using PMCMD command.
• Writing documentation to describe program development, logic, coding, testing, changes and corrections.

Environment: Informatica Power Center 9.x/8.6.1, ETL, Oracle 11g, Teradata, Flat Files, XML, CSV Files, Unix Shell Scripts, SQL Developer, Linux.

Confidential, Columbus OH

Informatica ETL Developer

Responsibilities:

• Interacted with End-users for gathering Business Requirements and Strategizing the Data Warehouse processes
• Worked closely with the Data Architect and actively assisted in the creation of Logical and Physical data models
• Coordinated with Business Analysts in the creation of the Technical Specification documents, Source/Target Matrices based on the Business Requirements
• Reviewed source systems and proposed data acquisition strategies and staging where necessary
• Reversed engineered the business logic from PL/SQL packages, Shell scripts, Java Programs and converted them to Informatica Mappings
• Followed the Informatica Best Practices and Standards while creating Informatica Mappings, Sessions and Workflows
• Designed and developed Mappings using Informatica Power Center 8.6 to load data from a variety of Source Systems to the Data Warehouse
• Designed and developed ETL and Data Quality mappings to load and transform data from source to target using Powercenter and IDQ
• Cleansed and Scrubbed the data in uniform datatype and format applying MDM Informatica.
• Developed MDM Hub and match and merge rules, batch jobs and batch rules.
• Assisted Informatica Lead in enhancing the Naming Conventions, ETL strategies and Best Practices for DW environment
• Extensively worked with Source Qualifier, Expression, Aggregator, Joiner, Lookups(Connected/Unconnected), Update Strategy, Union, Normalizer, SQL, Router and Filter Transformations
• Created Mapplets, Reusable Transformations, Reusable Session/Email/Command Tasks to increase the code reusability and maintenance
• Configured sessions to use Pre-Post SQL/Session Commands/Emails
• Worked with XML Files and Flat File Sources to load data to staging and the reporting layers
• Analyzed the performance issues and actively participated in tuning both the Informatica and Oracle environments
• Used Indexing strategies, Hints, Partitioning, Load Strategies, Cache Optimization procedures to remove the bottlenecks for Informatica processes
• Migrated the Mappings, Sessions, Other Tasks, Workflows from Dev to QA/UAT and Production Environments
• Aggressively worked on high priority tasks and production redesigns; Owned the responsibility for the Migration, Implementation, Fallback strategy and documentation of the same
• Implemented Slowly Changing Dimensions Type I and Type II while populating the dimension tables. Designed and Developed the Change Data Capture processes.
• Developed the ETL processes for loading the Customer Dim, Time Dim, Sales Fact, Orders Fact and Transaction Summaries
• Developed Shell Scripts for File Handling, FTP and Scheduling the jobs in ControlM
• Used MKS for versioning Informatica Objects. Worked in Release Management to co-ordinate ETL activities
• Provided 24/7 Post-Implementation and Production Support/Maintenance
• Documented the Informatica processes and conducted KT sessions.
• Involved in Scrum meeting on day to day activities and Task

Environment: Informatica Power Center 8.6, IDQ, MDM, Oracle 11g, Red Hat Enterprise Linux V5, XML, Java, Flat Files, CSV Files, Unix Shell Scripts, Toad 9.0, Win SCP.

Confidential

Software Engineer / ETL Developer

Responsibilities:

• Interacted with business analysts and undertook responsibility for requirement gathering analysis and end user meetings based on changing needs.
• Parsed high-level design spec to simple ETL coding and mapping standards, tested the data by running queries on the database for validation and accuracy.
• System Documentation of Dataflow and methodology.
• Assisted in designing Logical/Physical Data Models, forward/reverse engineering using Erwin 4.0.
• Developed mappings to extract data from Oracle, Flat files and load using the Power Center.
• Made use of mapping variable & mapping parameters and developed common routine mappings.
• Developed Slowly Changing Dimension for type 1and type II (flag, date).
• Made use of mapplets in order to save valuable design time and effort.
• Used Informatica Workflow Manager to create, schedule, execute and monitor sessions, worklets and workflows.
• Data extraction and data Transfer from/ to SQL Server Database using utilities / tools like BCP, and BULK INSERT.
• Conducted Database testing to check Constrains, field size, Indexes, Stored Procedures, etc.
• Created testing metrics using MS-Excel.
• Implemented various Performance Tuning techniques on Sources, Targets, Mappings, Workflows and database tuning. Involved during User Testing and performed Unit testing.
• Involved in generating reports from using Tableau. Defects were tracked, reviewed and analyzed.
• Built Reports and Dashboard for Business Users, and Set up Usage Tracking database.
• Using the Oracle BI Administration tool developed and enhanced meta-data.
• Extensively used Oracle BI Administration Tool for customizing and modifying the physical, business and presentation layers of the metadata repository.
• Performed Configuration Management to Migrate Informatica mappings/sessions /workflows from Development to Test and to production environment.

Environment: Informatica Power Center 8.6, Sql Server 2005/2008, Linux, Informatica Scheduler, OBIEE 11g, Oracle SQL developer, Oracle 10g, PL/SQL, UNIX, Tableau, HP Quality Center, Remedy

Confidential

Software Engineer / ETL Developer

Responsibilities:

• Used Informatica PowerCenter 8.6.1 and its all features extensively to transform and load to Sql Server 2005/2008.
• Gathered requirements for the scope of loading data from various sources to database.
• Built Integration between various Sources.
• Extract Data from various sources, flat files to Transform and load into Staging
• Designed and developed ETL Mappings using Informatica to extract data from flat files and XML, and to load the data into the target database.
• Worked withVariables and Parametersin the mappings.
• Used various Transformations like Router, Filter, Joiner, Update Strategy and connected and unconnected lookups for better data messaging and to migrate clean and consistent data using the Informatica PowerCenter Designer.
• Involved in the Development of Informatica mappings and Mapplets and also tuned them for Optimum performance, Dependencies and Batch Design.
• Worked on troubleshooting the Mappings to improving Performance by identifying bottlenecks.
• Performance tuning of the process at the mapping level, session level, source level, and the target level.
• Week on Week Status report to manager on the process and Timelines
• Used Informatica Scheduler and Crontabs to schedule Informatica mappings

Environment: Informatica Power Center 8.6.1(Repository Manager, Designer, Source Analyzer, Workflow Manager, Workflow Monitor, Transformation Developer, Mapplet Designer, Mapping Designer and Task Developer), Sql Server 2005/2008, XML Files, Unix.

Confidential

Oracle SQL Developer

Responsibilities:

• Initial analysis of Raw Data received from business Users, Data differs from County to county and State to state
• Worked on SQL * Loader to load the data from flat files obtained from various vendors.
• Wrote SQL and PL/SQL programs to retrieve required information from the database.
• Created Indexes on the table for faster retrieval of the data to improve database performance.
• Created database objects like tables, views, materialized views, procedures and packages using oracle tools like TOAD, SQL Developer and SQL*Plus.
• Handled errors using exception handing extensively for the ease of debugging and displaying the error message in the application.
• Involved in ETL in order to meet the requirements for extraction, transformation, cleansing, and loading from source to target.
• Involved in ETL process from development to testing and production environments.
• Extracted data from various sources and loaded it into target database using Informatica Power Center 8.6.
• Tuned mapping and SQL queries for better performance and efficiency.
• Performed unit testing and validated the Data.
• Provided Weekly status report to manager on the process and timeliness.

Environment: Oracle 10g, ETL, SQL, PLSQL, Unix, SQL Developer, SQL*Loader.