SUMMARY:

• Six years of experience in ETL/Informatica data warehousing and data integration in all phases of the SDLC (Software Development Life Cycle) including analysis, design, development, testing, implementation and maintenance with timely delivery against aggressive deadlines
• Proficient with Informatica Power Center designer tools (Source Analyzer, Warehouse Designer, Mapping Designer, Mapplet Designer, and Transformation Developer), Workflow Manager Tools (Task Developer, Worklet and Workflow Designer)
• Experience with RDBMS including Oracle 10g/9i, Oracle 12c, SQL Server and My SQL
• Experience with dimensional modeling using star schema and snowflake models
• Created UNIX shell scripts to run Informatica workflows and control the ETL flow
• Skilled in the development of Informatica mappings and mapplets and tuning them for optimum performance
• Experience working in an Agile development environment
• Hands on experience with tools like Toad and SQL Developer
• Well acquainted with session partitioning and performance tuning of sources, targets, mapping and sessions to overcome the bottlenecks in mappings
• Proficient in creating stored procedures, tables, cursors, views, indexes, SQL joins and performance based query writing
• Used advanced PL/SQL concepts for implementing complex ETL logic
• Strong knowledge of slowly changing dimensions
• Migrated objects in all phases (DEV, QA and PRD) of project and trained developers to maintain system when in production

TECHNICAL SKILLS:

Informatica: Informatica Power Center 10.x/9.x/8.6.1, Power Mart5.1.1/5.x, Warehouse Designer, Power Connect, Power Exchange, Informatica Designer, Workflow Manager, Workflow Monitor, OLAP, OLTP, Flat Files, RDBMS tables, legacy system files

Data Modeling: Dimensional Data Modeling, Erwin 7.1, Ralph Kimball Approach, Star/Snowflake Modeling, Data marts, OLAP, FACT & Dimensions tables, Physical/Logical data modeling and Oracle Designer

Methodologies: Ralph Kimball, Inmon, ODS, EDW and Metadata repository

Databases: Oracle 12g/11g/10g, DB2 8.0/7.0, MS SQL Server 2005/2000/, Netezza, Teradata V2R5/V2R4, Sybase 12.x/11.x

Dimensional Data Modeling: Dimensional Data Modeling, Star Join Schema Modeling, Snowflake Modeling, FACT and Dimensions Tables, Physical and Logical Data Modeling, Oracle Designer

Programming GUI: SQL, PL/SQL, SQL*Plus, SQL*Loader, Transact SQL, ANSI SQL, Synopsis, Visual Basic .Net/6.0/5.0, Java, HTML, DHTML, C, C++, UNIX Shell Scripting, PERL Programming

Other tools: Tidal Scheduler, Autosys, Tibco

PROFESSIONAL EXPERIENCE:

ETL/ Informatica Developer

Confidential, Buffalo, NY

Responsibilities:

• Interacted with business analysts to finalize the requirements and completed the technical design document for coding
• Managed the design, development and implementation of the MDM decommissioning project using Informatica Power Center, reducing development and implementation cost
• Successfully managed and implemented various ETL projects using Informatica Power Center that loaded data from DB2, flat files and other data sources to Oracle and other targets used for reporting
• Created mappings for both full and delta loads
• Designed and developed parallel jobs, sequences using Designer
• Designed POC mappings and helped the ETL team with data acquisition techniques and loading strategies during the development phase
• Documented the expected level of effort and resource requirements to configure required MDM processes to support the client onboarding and maintenance business processes
• Defined and designed the Data Acquisition, Transformation, and Data Cleansing approach for the MDM implementation
• Worked on the 10 MDM releases, implemented the business requirements for Claims, Member, and Provider data in Oracle MDM data warehouse
• Designed several parallel jobs using Sequential File, Dataset, Join, Merge, Lookup, Change Apply, Change Capture, Remove duplicates, Funnel, Filter, Copy, Column Generator, Peek, Modify, Compare, Oracle Enterprise, Surrogate Key, Aggregator, Transformer, Row Generator stages
• Worked with SCD stage for implementing slowly changing dimensions. Extracted data from Flat Files and Oracle databases and applied business logic to load them in the central Oracle database
• Developed map, reusable objects, transformation, and Mapplets using Mapping Designer, Transformation Developer and Mapplets Designer
• Created reusable transformations and mapplets and used them in mappings
• Used Informatica Power Center for extraction, loading and transformation (ETL) of data in the data warehouse
• Worked with data modelers to prepare logical and physical data models and added and deleted necessary fields using Erwin
• Tidal Scheduler was implemented for scheduling of Informatica workflows
• Interacted with the vendor and set up the SFTP connection to the vendor’s ftp site for transferring extracted files
• Set up SFTP connections to various vendors for receiving and sending of encrypted data as part of MFT Integration team support
• Implementations were populated slowly to change dimension to maintain current information and history information in dimension tables
• Used Informatica PowerCenter Workflow manager to create sessions and batches to run with logic embedded in the mappings
• Created folders, users, repositories, and deployment group using Repository Manager
• Created Shared Containers to increase Object Code Reusability and to increase throughput of the system
• Used environment variables, stage variables and routines for developing parameter driven jobs and debugged them
• Performed extraction, transformation and loading of data using different types of stages and by performing derivations over the links connecting these stages
• Designed the job templates and created new jobs from existing templates
• Enhanced job performance by using partitioning methods and analyzing the resources utilized using Job Monitor
• Created test plans for unit testing of designed jobs

Environment: Informatica Power Center 10.1/9.6 (Repository Manger, Designer, Workflow Monitor, Workflow Manager), Tidal Scheduler, Autosys, DB2, Oracle 12g, Siebel, TOAD, SQL*Plus, Windows, UNIX, Shell Scripting

ETL/ Informatica Developer

Confidential, Knoxville, TN

Responsibilities:

• Created high level design, technical design documents and mapping documents based on business requirements
• Configured, designed and developed ETL for Enterprise Data Infrastructure (EDI) DataMart which includes sourcing, vending the security data
• Optimized complex ETL processes using performance tuning methods
• Created program to implement Change Data Capture using Informatica to perform inserts, updates, and delete operations
• Monitored and executed production jobs whenever required
• Performed unit, system and integration testing to validate source and target data and performed internal quality auditing of the ETL code before delivery
• Created Informatica tasks and workflows to execute ETL processes
• Wrote complex SQL Query as per business requirement to fetch the data from relational tables
• Optimized complex SQL query to improve performance
• Created Slowly Changing Dimension SCD type1, type2, Slowly Growing Targets, and Simple Pass Through Informatica mappings to meet business requirements
• Worked on XML source/target and used XML Source Qualifier, XML Parser and XML Generator transformation
• Performed Unit testing, Integration testing/User Acceptance testing for ETL/SQL/Unix script codes
• Developed UNIX shell scripts to run the workflows and SFTP source/target files from various systems and Informatica process automation
• Executed Autosys command/box to run the Informatica workflows

Environment: Informatica Power Center 9.6 (Repository Manger, Designer, Workflow Monitor, Workflow Manager), Autosys, DB2, Oracle12g, Netezza, TOAD, SQL*Plus, Tibco, Windows, UNIX, Shell Scripting