SUMMARY

• Over 8+ years of IT experience in design, coding, and testing of Data Warehousing implementations across Financial, Insurance, al, and Retail Industries.
• Extensive experience with different phases of Software Development Life Cycle (Requirements gathering, Analysis, Design, Implementation, Testing, and debugging new and existing client - server-based applications).
• Experience in building Workflow Solutions and Extract, Transform, and Load (ETL) solutions for data warehousing using Informatica.
• Strong working experience in the Data Analysis, Design, Development, Implementation, and Testing of Data Warehousing using ETL.
• Used transformations like Joiner, Expression, Connected and Unconnected Lookups, Filter, Aggregator, Stored Procedure, Rank, Update Strategy, Transaction control, Router, and Sequence generator.
• Captured data changes with the help of SCD Type 1 and Type 2 mappings and also utilized MD5 to accomplish Dimension, Facts, and error record loading.
• Experience in creating Transformations and Mappings using Informatica Designer and processing tasks using Workflow Manager to move data from multiple sources into targets.
• Understand the business rules completely based on High-Level document specifications and implement the data transformation methodologies.
• Extensive experience in developing stored procedures, functions, Views and Triggers, Complex queries using SQL Server and Oracle PL/SQL
• Experience working on Informatica MDM to design, develop, test, review, & optimize Informatica MDM (Siberian).
• Strong experience in Extraction, Transformation and Loading (ETL) data from various sources into Data Warehouses and Data Marts using Informatica Power Center (Repository Manager, Designer, Workflow Manager, Workflow Monitor, Metadata Manager), Power Exchange, Power Connect as ETL tool on Oracle, SQL Server Databases and DB2.
• Skilled in analyzing data for error records using Informatica mapping debugger.
• Involved in Analyzing the System requirements, implementation of star schema & involved in designing and developing the data warehouse environment. Also, gathered requirements with Business Users and converted them into project documentation.
• Created mapplets for reusing transformation logic in multiple mappings.
• Involved in Dimensional modeling (Star Schema/Snow Flake) of the Data Warehouse and designed the business process, dimensions, and measured facts.
• Involved in Unit testing, User Acceptance Testing to check whether the data is loading into the target, which was extracted from different source systems according to the user requirements.
• Responsible for Performance Tuning at the Source level, Target level, Mapping, Session, and database level.
• Designed, Installed, Configured core Informatica/Siberian MDM Hub components such as Informatica MDM Hub Console, Hub Store, Hub Server, Cleanse Match Server, Cleanse Adapter, Data Modeling.
• Experience in scheduling workflows using Informatica scheduler.
• Experience in Database Development using mainly Oracle databases. Experience with Data Cleansing, Data Profiling, and Data analysis. UNIX Shell Scripting, SQL, and PL/SQL coding.
• Thorough Knowledge of different OLAPs, DW/BI concepts, and SOA.
• Experience in integration of various relational databases such as Oracle, SQL Server, DB2, Netezza, MS Access, XML sources, VSAM files, and Flat Files into the staging area and Teradata.
• Strong experience in developing and supporting complex SQL and database views in a large data warehouse environment.

TECHNICAL SKILLS

Operating systems: UNIX, Windows 2008/2007/2005/ NT, MS-DOS.

ETL Tools: Information Informatica Power Center 10.2/9.x(Designer, Workflow Manager, Workflow Monitor, Repository Manager, and Informatica Server), IICS

Dimensional data modeling: Dimensional Data Modeling, Star Schema Modeling, Snowflake Modeling, FACT and Dimensions Tables, ERWIN 4.5/4.0/3.5/3.2

Databases: Oracle 11g/10g/9i, DB2/UDB, SQL Server, Teradata, Netezza, My SQL

Operating Systems: Windows 95/98/NT/2000/XP, UNIX, Linux.

Others: XML, UNIX shell scripting, PL/SQL, SQL, SQL Developer, TOAD and SQL Server Management Studio, HP Quality center, JIRA, GIT HUB, Advanced Query Tool (QAT), Informatica MDM Multi-Domain Edition 10.0, 9.7.1, 9.5, 9.1.

PROFESSIONAL EXPERIENCE

Confidential, Detroit

Informatica MDM Developer

Responsibilities:

• Worked with ETL Developers to create External Batches to execute mappings and Mapplets using Informatica workflow designer to integrate Shire’s data from varied sources like Oracle, DB2, flat files, and SQL databases and loaded into landing tables of Informatica MDM Hub.
• Created mappings using Designer and extracted online user registration data from various sources like Flat files, relational sources, XML, Normalized data, and transformed data according to the requirement.
• Involved in extracting the data from the Flat Files and Relational databases into the staging area.
• Developed Informatica Mappings and Reusable Transformations to facilitate timely Loading of Data of star schema and snowflake schema.
• Used Transaction control transformation to generate Flat files dynamically for downstream users.
• Deployed new MDM Hub for portals in conjunction with the user interface on the IDD application.
• Used various transformations like Filter, Expression, Sequence Generator, Update Strategy, Joiner, Router, and Aggregator to create robust mappings in the Informatica Power Center Designer.
• Created Sessions and extracted data from various sources, transformed data according to the requirement and loading into the data warehouse.
• Used Web Services Transformation for authentication of the end-users.
• Captured data changes with the help of SCD Type 1 and Type 2 mappings and also utilized MD5 to accomplish Dimension, Facts, and error record loading.
• Worked on the Support to solve the existing Informatica mappings issues.
• Involved indata analysis with data analysts to define the structure of dimensions and facts.
• Wrote SQL queries, PL/SQL programming, and Query Level Performance tuning.
• Developed Data Integration Mappings using IICS.
• Moved Mappings, Sessions, Workflows from Development to Test, UAT, and Prod environment.
• Involved in Unit testing, User Acceptance Testing to check whether the data is loading into the target, which was extracted from different source systems according to the user requirements.
• Attended status meetings with project managers, escalated issues when necessary, attended meetings for issues resolution.
• Involved in performance tuning and optimization of Informatica mappings and sessions using features like partitions and data/index cache to manage a very large volume of data.
• Used parameters/variables for Powercenter mappings, sessions, and workflows.
• Created process documents in case of job failures, and also documented failures to fix repeat issues.
• Worked with various teams like BSA, DBA, Business users, and environment technical leads in case of job failures.
• Created Stored Procedures to transform the Data and worked extensively in PL/SQL for various needs of the transformations while loading the data.

Environment: Informatica Power Center 10.2/9.1.6, Oracle 11g, DT Studio, SQL Server 2008/2005, DB2, Flat Files, Tableau, Python, MS Visio, MS Office, PL/SQL (Stored Procedure, Trigger, Packages), UNIX, LINUX, Toad, Teradata 6, Informatica MDM Multi-Domain Edition 10.0, 9.7.1, 9.5, 9.1.

Confidential, MN

SR. Informatica Developer

Responsibilities:

• Involved in full life cycle development including Design, ETL strategy, troubleshooting, reporting, and Identifying facts and dimensions.
• Interacted with Lead Developers, System Analysts, Business Users, Architects, Test Analysts, Project Managers and peer developers to analyze system requirements, design and develop software applications.
• Prepared the required application design documents based on the functionality required.
• Designed the ETL processes using Informatica to load data from Oracle, Flat Files (Fixed Width), and Excel files to staging database and from staging to the target Teradata Warehouse database.
• 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.
• Involved in writing procedures, functions in PL/SQL.
• Created mappings using transformations like Source Qualifier, Joiner, Aggregator, Expression, Filter, Router, Lookup, Update Strategy, and Sequence Generator.
• Involved in Dimensional modeling (Star/Snowflake Schema) of the Data Warehouse and used Erwin to design the business process, dimensions, and measured facts.
• Designed and developed the logic for handling slowly changing dimension table’s load by flagging the record using update strategy for populating the desired.
• Used the Data Transformation Studio (DT Studio) 4.0 to create scripts that convert complex data formats, into standard ones and then integrate them to Informatica Power Center platform, using the UDO transformation.
• Involved in cleansing and extraction of data and defined quality process for the warehouse.
• Involved in performance tuning and optimization of Informatica mappings and sessions using features like partitions and data/index cache to manage a very large volume of data.
• Involved in migration of mappings and sessions from a development repository to a production repository.
• Created Flat files for external vendors using Informatica ETLs and moved them to MFT (Go Anywhere), for the vendors to pick up files.
• Unit test code before handing over code to QA Team along with documents.
• Provided Tier l support duties for Informatica Production Support, including off-hours and weekends. Keep the Production Support team management informed of any issues or concerns.
• Used GIT Hub to maintain data consistency across all environments.
• Created test cases using Quality Center and fixed the issues for defects.
• Troubleshoot database, workflows, mappings, source, and target to find out the bottlenecks and improved the performance.
• Provided 24/7 On-call Production Support for various applications and provided resolution for night-time production job failures, attend conference calls with business operations, system managers for resolution of issues

Environment: Informatica Power Center9.6, Teradata, Repository Manager, Designer, Workflow Manager, Business Objects 4. x, Oracle 11g/10g, UNIX, LINUX, SQL Server 2008/2005, DB2, Flat Files, CSV files, Toad, Netezza, Erwin, Autosys job scheduler, HP Quality Center.

Confidential, Chicago, IL

ETL Informatica Developer

Responsibilities:

• Involved in understanding the Requirements of the End Users/Business Analysts and developed strategies for ETL processes.
• Responsible for requirements gathering for an enhancement requested by the client. Involved in analysis and implementation for an Intranet Based Information Management Information System.
• Provided maintenance and support of Online and Batch’s Programs using COBOL, DB2.
• Wrote several DB2 Stored Procedure scripts to implement the business logic.
• Created data models for information systems by applying formal data modeling techniques.
• Strong expertise in physical modeling with the knowledge to use Primary, Secondary, and Join Indexes.
• Designed Fact tables and Dimension tables for star schemas and snowflake schemas using ERWIN tool and used them for building reports.
• Performed reverse engineering of physical data models from databases and SQL scripts.
• Provided database implementation and database administrative support for custom application development efforts.
• Developed OLAP reports and Dashboards using the Business intelligence tool - OBIEE.
• Synchronizing all regions PCR, Unit, and System while migration changes from lower region to acceptance.
• Reviewing programs for QA and Testing.
• Responsible for Coding, Unit Test Plans, Unit Test Results, Functional Testing, and Regression Testing.
• Involved in comprehensive end-to-end testing- Unit Testing, System Integration Testing, User Acceptance Testing, and Regression.
• Developed a standard ETL framework to enable the reusability of similar logic across the board. Involved in System Documentation of Dataflow and methodology.

Environment: Oracle 11g, SQL * Plus, Informatica Power Center9.1.6, TOAD, SQL*Loader, SQL Developer, Shell Scripts, UNIX, Windows XP, SQL*Plus, PL/SQL, Oracle Designer 2000,Windows 2000, Toad, Erwin.

Confidential

ETL Engineer

Responsibilities:

• Utilized extensive analytical skills to perform due diligence analysis on asset management companies.
• Written complex SQLs using joins, sub queries, and correlated subqueries. Expertise in SQL Queries for cross verification of data.
• Developed administrative tasks of SQL server of performing daily backups and recovery procedures.
• Diligently maintained and updated the information on the platform, including monthly net return and assets under management data.
• Interpreted data analyzed results using statistical techniques and provided ongoing reports.
• Created packages that implement tasks like Execute SQL, Task, and Data Flow Task.
• Analyze reports and fix bugs in stored procedures.
• Created Triggers, Functions, Indexes, Tables and SQL joins for applications.
• Create joins and sub-queries for complex queries involving multiple tables.
• Handled data from SQL plus extracts to load the data into the Teradata tables using SQL loader
• Developed and implemented data collection systems and other strategies that optimized statistical efficiency and data quality.
• Responsible forPerformance Tuningof High CPU consuming queries and tables with high skew for daily batch jobs.
• Provided database implementation and database administrative support for custom application development efforts.
• Involved in all levels of Application Life Cycle Development (SDLC), provided value-added services with development teams and clients throughout the life span of the project, strategic consulting, code writing, and managing complex development and tasks.
• Acquired data from primary or secondary data sources and maintained databases/ data systems.
• Developed analysis and reporting capabilities to increase skill levels and efficiency.
• Continuously monitored performance and quality control plans to identify improvements and prepared daily reports and worked along with the team members.
• Bug fix and release including changes in coding, technical support of system testing, writing implementation plans, assisting and debugging deployment issues, creating/updating technical documentation.
• Developed reporting capabilities to increase skill levels and efficiency.
• Documented business specifications and followed them during the process of development and testing.
• Continuously monitored performance and quality control plans to identify improvements

Environment: SQL Server 2005, SQL Server 2000, XML, MS Excel, MS Word, MS Access, Business Objects 5.x/6.x, SQL Query Analyzer, SQL Developer edition.