SUMMARY

• ETL Developer with over 5+ years of IT experience in the Analysis, Design, Development, Testing and Implementation of business application system.
• Hands - on experience across all stages of Software Development Life Cycle (SDLC) including business requirement analysis, data mapping, build, unit testing, systems integration and user acceptance testing.
• Strong Data Warehousing ETL experience of using Informatica PowerCenter Client tools - Mapping Designer, Repository manager, Workflow Manager/Monitor and Server tools - Informatica Server, Repository Server manager.
• Experienced in using ETL tools including Informatica PowerCenter 10.x/9.x/8.x, Power Mart, Power Exchange, Workflow Manager, Repository Manager, Administration console and Informatica Data Quality (IDQ).
• Experience in all phases of Data warehouse development from requirements gathering for the data warehouse to develop the code, Unit Testing and Documenting.
• Experience with dimensional modeling using star schema and snowflake models.
• Vast experience in Designing and developing complex mappings from varied transformation logic like Unconnected and Connected lookups, Source Qualifier, Router, Filter, Expression, Aggregator, Joiner, Update Strategy etc.
• 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 Manger), Power Connect as ETL tool on Confidential, DB2 and SQL Server Databases.
• Experience in Data Extraction, Transforming and Loading (ETL) from multiple sources like Excel, MS Access, XML, Confidential and DB2 to MS SQL Server using SQL Server Integration Services (SSIS), DTS, Bulk Insert and BCP.
• Good experience in using Multidimensional Expressions (MDX) for querying and manipulating the multidimensional data stored in OLAP.
• Experience in Erwin Database programming for Data Warehouses (Schemas), proficient in dimensional modeling, Star Schema, Snowflake and Hierarchy modeling.
• Experience in creating UNIX shell scripts to run the Informatica workflows and controlling the ETL flow.
• Experienced in writing SQL, PL/SQL programming, Stored Procedures, Functions, Triggers, Views and Materialized Views.
• Highly motivated team player with analytical, organizational and technical skills, unique ability to adapt quickly to challenges and changing environment.
• Excellent communication and presentation skills, works well as an integral part of a team, as well as independently, intellectually flexible and adaptive to change.

TECHNICAL SKILLS

Packages & ETL Tools: Informatica Power Center 10.x/9.x/8.x/7.x, IDQ, TOAD, OLAP, OLTP, Erwin

Data Bases: Confidential 11c/10g/9i/8i/8.0, DB2, Sybase, SQL*Plus, Confidential

Languages: SQL, PL/SQL, TSQL, UNIX Shell Scripting.

Data Modeling: Erwin 7.3, Star-Schema Modeling, Snowflakes Modeling

Methodologies: Agile, Waterfall

Operating Systems: Unix, Win NT, MS-DOS, Solaris

PROFESSIONAL EXPERIENCE

Confidential, Walla Walla, WA

ETL Developer

Responsibilities:

• Participate in design and analysis sessions with business analysts, source-system technical teams, and end users.
• Responsible for developing and maintaining ETL jobs, including ETL implementation and enhancements, testing and quality assurance, troubleshooting issues and ETL/Query performance tuning
• Designing, developing, maintaining and supporting Data Warehouse or OLTP processes via Extract, Transform and Load (ETL) software using Informatica.
• Manage and expand current ETL framework for enhanced functionality and expanded sourcing.
• Translate business requirements into ETL and report specifications. Performed error handing using session logs.
• Worked on Power Center Tools like designer, workflow manager, workflow monitor and repository manager.
• Involved in creating database objects like tables, views, procedures, triggers, and functions using T-SQL to provide definition, structure and to maintain data efficiently.
• Done Code reviews of ETL and SQL processes. Worked on upgrading Informatica from version 9.x to 10.x.
• Created complex mappings in Power Center Designer using Aggregate, Expression, Filter, and Sequence
• Identifying performance issues in the code and tuning it to complete the jobs within the given SLA time.
• Performance tuning at Informatica and database levels depending on the bottlenecks identified with the jobs.
• Developed mappings using Informatica Power Center Transformations - Lookup (Unconnected, Connected), Filter, Expression, Router, Joiner, Update Strategy, Aggregator, Stored Procedure, Sorter, and Sequence Generator.
• Effectively used Informatica parameter files for defining mapping variables, workflow variables, FTP connections and relational connections.
• Worked with Informatica Data Quality 9.x (IDQ) toolkit, analysis, data cleansing, data matching, data conversion, exception handling, and reporting and monitoring capabilities of IDQ.
• Performed Relational Data Modeling, ER Diagrams (forward & reverse engineering), dimensional modeling, OLAP multidimensional Cube design & analysis, define slowly changing dimensions and surrogate key management.
• Worked with the testing team to resolve bugs related to day one ETL mappings before production.
• Maintained ETL release document for every release and migrated the code into higher environments through deployment groups.
• Created change request before code deployment into production to get required approvals from business.
• Created weekly project status reports, tracking the progress of tasks according to schedule and reported any risks and contingency plan to management and business users.

Environment: Informatica Power Center 10.x/9.x, IDQ, OLAP, Confidential, MS SQL Server, PL/SQL, SSIS, SSRS, SSAS, SQL*Plus, SQL*Loader, Windows, UNIX.

Confidential, Bridgeport, CT

ETL Developer

Responsibilities:

• Extensively Working on Informatica tools such as Source Analyzer, Warehouse Designer, Transformation Designer, Mapplet Designer and Mapping Designer
• Using Informatica Power center 10.1 to make the changes to the existing ETL Wrote PL/SQL procedures which are called from Stored Procedure transformation to perform database actions such as truncate the target before load delete records based on a condition and re-name the tables .
• Create ETL mappings with complex business logic for high volume data loads using various transformations such as Aggregator, Sorter, Filter, Normalizer, SQL Transformation, Lookup, Joiner, Router, Update Strategy, Union, Sequence Generator, transformation language likes transformation expression, constants, system variables, data format strings etc.
• Developed Mapplets, Reusable Transformations, Source and Target definitions, mappings using Informatica 10.x.
• Extensively worked on building workflows, worklets, sessions, command tasks etc.
• Designed and developed Informatica mappings including Type-I, Type-II and Type-IIIslowly changing dimensions (SCD).
• Created mappings using different IDQ transformations like Parser, Standardizer, Match, Labeler and Address Validator.
• Extensively worked on ETL performance tuning for tune the data load, worked with DBAs for SQL query tuning etc.
• Supported monthly data load activity using SSIS for Account Assignment System.
• Involved in writing SQL Stored procedures and Shell Scripts to access data from various sources.
• Assisted other ETL developers in solving complex scenarios and coordinated with source systems owners with day-to-day ETL progress monitoring.
• Performed System, Integration testing and supported User Acceptance Testing.
• Managed stakeholder communication and validated the fixed issues in order to ensure support availability as per agreed SLAs.

Environment: Informatica Power Center 10.x/9.x, IDQ, Confidential, MS SQL Server 2014, Business Objects, MS Access, Windows.

Confidential, Dania Beach, FL

ETL Developer

Responsibilities:

• Interacted with business analysts, data architects, application developers to develop a data model.
• Involved in the warehouse design using a Star Schema.
• Joined relational tables existing in separate database using Joiner Transformation.
• Used the Router Transformation to load user-defined groups for the business units based on group filter conditions.
• Involved in Performance Tuning of sources, targets, mappings and sessions.
• Performed unit testing to validate mappings and populate the database.
• Documentation of Technical specification, business requirements, functional specifications for the development of Informatica Extraction, Transformation and Loading (ETL) mappings to load data into various tables.
• Performed data analysis based on the source systems and existing OLTP database systems.
• Involved in production support working with various mitigation tickets created while the users working to retrieve the database.
• Created Stored Procedures to transform the Data and worked extensively in PL/SQL for various needs of the transformations while loading the data.
• Tested data and data integrity among various sources and targets.

Environnent: Informatica Power Center, Confidential, DB2, SQL, PL/SQL, UNIX, TOAD, SQL Server, Windows 2000.

Confidential

ETL Developer

Responsibilities:

• Extracted Data from Different Sources by using Informatica.
• Extensively used Informatica client tools Source Analyzer, Warehouse designer, Mapping designer and Mapplets Designer.
• Extracted data from different sources of databases. Created staging area to cleanse the data and validated the data.
• Designed and developed complex Aggregate, expression, filter, join, Router, Lookup and Update Transformation rules.
• Developed schedules to automate the update processes and Informatica sessions and batches.
• Analyze, design, construct and implement the ETL jobs using Informatica.
• Developed mappings/Transformations/mapplets by using mapping designer, transformation developer and mapplets designer in Informatica Power Center 6.1.
• Developed Shell scripts to setup runtime environment, and to run stored procedures, packages to populate the data in staging tables.
• Created Users, user groups, database connections and managed user privileges using supervisor.

Environment: Informatica Power Center, Confidential, MS SQL SERVER, SQL, PL/SQL, SQL*Loader, UNIX Shell Script.