SUMMARY:

• 6+ years of experience in Informatica Power Center in all phases of analysis, design, development, implementation and support of Data warehousing applications using Informatica Power Center 9.x/8.x/7.x
• Extensive professional experience in Information Technology with strong background in the areas of ETL Design and ETL development in Data Warehousing using Informatica Power Center.
• Excellent understanding of ETL design process, development and maintenance using Mapping Designer, Workflow Manager, Monitor and Repository Manager.
• Experience on Informatica designer tools like reusable transformations, mappings, mapplets, and workflows. Extensively worked with Slowly Changing Dimensions, CDC
• Experience in Data warehouse development, working with Data migration, Data conversion and Extraction/Transformation/Loading using Informatica Power Center and Informatica cloud platform.
• Expert in using design and management tools like Erwin and Toad, SQL Developer
• Highly proficient in integrating data with SFDC using Informatica 8.6 and 9.x versions.
• Excellent Work Experience in Informatica Power center for Data integration between Oracle and SFDC which includes development of Joiner, Aggregator, Lookup, Salesforce Lookup, Router and Sorter transformations.
• Experience in integration of various Operational Data Source (ODS) with Multiple Relational Databases like Oracle, SQL server and DB2 and Worked on integrating data from flat files like fixed width and delimited.
• Strong experience in SQL, PL/SQL, Tables, Database Links, Materialized Views, Synonyms, Sequences, Stored Procedures, Functions, Packages, Triggers, Joins, Unions, Cursors, Collections, and Indexes in Oracle.
• Strong experience in Understanding Logical and Physical Data Modeling, Dimensional Data Modeling - Star Schema/Snow Flake modeling, Fact and Dimension Tables.
• Extensive involvement in composing UNIX shell scripts and computerization of the ETL forms utilizing UNIX shell scripting.
• Solid and extensive knowledge in understanding Software Development Life Cycle (SDLC), requirement, analysis, design and implementation, review specification, testing and maintenance of applications in Agile Methodology and Agile Scrum meeting for creative work.
• Experienced to work with Development team, Production support team and Business Analysts in handling critical situations to meet the deadlines for successful completion of the tasks/projects.
• Experienced in writing and debugging to find out the problems in mappings, troubleshooting and rectifying ETL bugs.
• Proficient in Data Governance, Data Lifecycle, Data Quality Improvement, Master Data Management, and Metadata Management
• Worked with Data governance team to evaluate test results for fulfillment of all data requirements
• Experienced in working for the post development cycle and applications in Production Support
• Excellent interpersonal and communication skills, and is experienced in working with senior level managers, business people and developers across multiple disciplines.
• Authorized to work in United States for any employer.

TECHNICAL SKILLS:

ETL Packages: Informatica Power Center 10.0/9.1.1

Databases: Oracle 10g/11g, MS SQL Server 2005/2008, SQL, PL-SQL, DB2 UDB 8.1/7.2

Database Tools: SQL* Plus, SQL Loader, Toad, Zena, Serena

Operating Systems: Windows NT / 2000 / XP Pro / Vista, 7, Windows Server 2000 / 2003 / 2008, UNIX - Solaris/HP/AIX/UX, Red Hat Linux.

Languages: SQL, PL/SQL, UNIX Shell scripting, C.

Reporting Tools: OBIEE, Micro strategy, Business Objects, IBM Cognos, Framework Manager

PROFESSIONAL EXPERIENCE:

Confidential, Hartford, CT

ETL Developer

Responsibilities:

• Perform requirement analysis through coordination with business analysts and define business and functional specifications.
• As a team conducted gap analysis and Discussions with subject matter experts to gather requirements, emphasize on problem areas and define deliverables.
• Logical and Physical data modeling was done using Erwin for data warehouse database in STAR SCHEMA.
• Using Informatica Power Center Designer analyzed the source data to Extract & Transform from various source systems (oracle 11g, DB2, SQL server and flat files) by incorporating business rules using different objects and functions that the tool supports.
• Using Informatica Power Center created mappings and mapplets to transform the data according to the business rules.
• Designed the ETL mappings between sources to operational staging targets, then to the data warehouse using Power center Designer.
• Involved in Design, analysis, Implementation, Testing and support of ETL processes for Stage, ODS and Mart.
• Documented Informatica mappings in Excel spread sheet.
• Developed mappings/Reusable Objects/Transformation/mapplets by using mapping designer, transformation developer and mapplet designer in Informatica Power Center.
• Worked with Informatica power center Designer, Workflow Manager, Workflow Monitor and Repository Manager.
• Used Informatica Power Center to migrate the data from different source systems.
• Extensively used Autosys for Scheduling and monitoring.
• Responsible for developing, support and maintenance for the ETL (Extract, Transform and Load) processes using Informatica Power Center 9.5 by using various transformations like Expression, Source Qualifier, Filter, Router, Sorter, Aggregator, Update Strategy, Connected and unconnected look up etc.
• Extensively used various Performance tuning Techniques to improve the session performance.
• Developed and maintained ETL (Extract, Transformation and Loading) mappings to extract the data from multiple source systems like Oracle, SQL server and Flat files and loaded into Oracle.
• Created business rules in Informatica Developer and imported them to Informatica Power center to load the standardized and good format of data to staging tables.
• Involved in creating new table structures and modifying existing tables and fit into the existing Data Model.
• Designed and Created data cleansing, validation and loading scripts for warehouse using Informatica Power Center 9.1.1/8.6.
• Worked with offshore team to Develop and deliver the ETL tasks.
• Monitored workflows and session using Power Center workflows monitor
• Used Informatica Scheduler for scheduling the workflows
• Developed the ETL jobs to automate the Data validation process across the systems (Web trends and In house) using Informatica and notifying the variances to stakeholders.
• Extensively used Informatica client tools - Source Analyzer, Mapping designer, Mapplet Designer, Transformation Developer, Informatica Repository Manager and Informatica Server Manager.
• Created workflows and worklets for designed mappings.
• Provide documentation of ETL design and technical specifications, high level and low-level design specifications.
• Design and build reconciliation process.

Environment: Informatica Power Center 10.0/9.1.1, Teradata 14/12, Oracle 11g, My SQL, XML, Flat Files, SQL Assistant, Autosys, Toad, PL/SQL, Erwin, Unix shell scripting, Cognos, Unix, Windows.

Confidential, MO

ETL Developer

Responsibilities:

• Involved in building the ETL architecture and Source to Target mapping to load into Data warehouse.
• Created mapping documents to outline data flow from sources to targets.
• Used various transformations like Filter, Expression, Sequence Generator, Update Strategy, Joiner, Stored Procedure, and Union to develop robust mappings in the Informatica Designer.
• SQL performance tuning by modifying SQL or adding/changing indexes.
• Scheduling the sessions to extract, transform and load data into warehouse database depending on the business requirements.
• Responsible for Unit testing of mappings and workflows.
• Extensively used ETL to load data from Oracle database, Flat files to Data Warehouse.
• Wrote SQL Queries, Triggers and Shell Scripts to apply and maintain the Business Rules.
• Translated business requirements into Informatica mappings/workflows.
• Extracted data from different data sources - Oracle, Access databases and Excel spreadsheets, transformed and mapped non-standard data to standard codes for data integrity and loaded the target Oracle warehouse database
• Developed mapping parameters and variables to support SQL override.
• Created mapplets to use them in different mappings.
• Developed mappings to load into staging tables and then to Dimensions and Facts.
• Created sessions, configured workflows to extract data from various sources, transformed data, and loading into data warehouse.
• Prepared migration document to move the mappings from development to testing and then to production repositories.
• Involved in meetings with Business System Analysts to understand the functionality and prepared ETL Technical Specifications.
• Designing mappings according to the mapping standards, naming standards for future application development.
• Created Summary and Drill down reports for various attributes based on their hierarchies.
• Worked on Documents in Grid and Graph mode by using Micro Strategy Report services.
• Extensively used Informatica 9.5.1 to load data from flat files to Oracle tables.
• Most of transformations were used like the Source Qualifier, Aggregator, Expression, Lookup, Router, Normalizer, Filter, Update Strategy, SQL, UNION, and Joiner transformations etc.
• Used Workflow manager for Creating, Validating, Testing and running the sequential and concurrent Batches and Sessions.
• Interacted with users with SQL Queries and troubleshooting for their reports.
• Involved in data loads and fixing the Issues in all the environments.

Environment: Informatica 9x, Oracle 11g, SQL Server, PL/SQL, SQL*Plus, XML, Putty, SVN, Windows XP Professional, FTP, MS-Excel, MS-Access, Informatica Data Quality (IDQ) 9.0.1.

Confidential

ETL Developer

Responsibilities:

• Involved in requirements gathering from the business users by working closely with architects and business analysts to understand system and business requirements.
• Primary ETL developer responsible for designing and developing various Systems adhering to the relational and dimensional data modeling standards.
• Worked on Source - target mapping and technical design documents
• Extracted data stored in Oracle 11g/10g and Flat files and loaded data into Teradata Data warehouse
• Worked with Source Analyzer, Data Warehouse Designer, Workflow monitor, Mapping Designer, Mapplets,and Transformation Developer in Informatica designer.
• Developed several complex Mappings, Mapplets and Reusable Transformations to facilitate daily weekly andmonthly loading of Data.
• Developed entity diagrams and data dictionaries to accomplish tasks. Develop logical and physical datamodels that capture current state/future state data elements and data flows using ERWIN.
• Involved in data Transformations between different Informatica folders and also Repositories along with DBATeam
• Used Informatica PowerCenter 9.5 for extraction, loading and transformation (ETL) of data in the data mart.
• Designed and developed ETL Mappings to extract data from flat files, MS Excel and Oracle to load the data into the target database.
• Developing several complex mappings in Informatica a variety of PowerCenter transformations, Mapping Parameters, Mapping Variables, Mapplets & Parameter files in Mapping Designer using Informatica PowerCenter.
• Experience in migration Informatica objects from 9.1 to 9.5.
• Experience in Informatica upgrade testing, troubleshoot and resolve issues.
• Created complex mappings in the designer and monitored them. The mappings involved extensive use of Aggregator, Filter, Router, Expression, Joiner, Union, Normalizer and Sequence generator transformations.
• Worked on different data sources such as Oracle, SQL Server, Flat files etc.
• Involved in the Migration of Databases from SQL Server 2005 to SQL Server 2008.
• Developed PL/SQL and UNIX Shell Scripts for scheduling the sessions in Informatica.
• Created E-mail notifications tasks using post-session scripts.
• Wrote SQL, PL/SQL stored procedures, triggers, cursors for implementing business rules and transformations.
• Tuned performance of Informatica sessions for large data files by increasing block size, data cache size and sequence buffer length.
• Worked with DBA on SQL scripts to automate the process of populating the various columns in the tables with surrogate keys
• Involved in preparing detailed ETL design documents.
• Examined the workflow log files and assigning the ticket to the Informatica support based on the error.
• Experience in developing Unix Shell Scripts for automation of ETL process.
• Performed operational support and maintenance of ETL bug fixes and defects.

Environment: Informatica PowerCenter 9.5, ETL, Informatica MDM 9.1, Oracle, SQL Server, UNIX Shell script, Putty, SQL-Developer, Auto-sys.

Confidential

ETL Developer

Responsibilities:

• Responsible for Installation, configuration, Troubleshooting, maintenance and monitoring of different environments of SQL Server.
• Designed and Developed packages for system integration, product development and ongoing maintenance of the tables using SSIS.
• Created SQL server objects like Indexes, Indexed Views, Stored Procedures (dynamic and static), effective Functions, and appropriate Triggers to facilitate efficient data manipulation and data consistency.
• Created Joins, Sub-Queries, Views and User Defined Functions for complex queries involving multiple tables and developed User Defined Functions.
• Collaborated with team members in writing test SQL scripts, performing tests and providing appropriate follow-up actions and documentation.
• Developed PL/SQL triggers, procedures, functions and packages for the various interfaces.
• Used SSIS to create Dynamic ETL Packages to validate, extract, transform and load data to data warehouse databases and involved in Data cleansing in the data transfer.
• Implemented Data Cleaning, Incremental Data Loading, Event Handling and Error Handling.
• Developed Query for generating Drill Down and Drill Through reports in SSRS.
• Designed Cubes with Star Schema using SQL Server Analysis Services (SSAS). Created several Dashboards and Scorecards with Key Performance Indicators (KPI) in SQL Server Analysis Services (SSAS).
• Generated Tabular, Sub reports and Parameterized reports for the Business users.
• Designed report models based on user requirements, explain and train users to use report builder to generate their own personalized reports.
• Involved in Performance Tuning to improve response time of Stored Procedures.
• Created Time Dimensions on OLAP Cubes using SSAS.
• Maintained Database Backups and Scheduled Jobs and Alerts involving with Administrator.

Environment: MS SQL Server, T-SQL, PL/SQL, SSIS, SSRS, SSAS, SQL Server BIDS, MS- Visual Studio, ASP.Net, C#.Net, ADO.Net, XML, MsVisio2003/2007, MS Project.