SUMMARY

• 8 years of experience in Analysis, Development, and Implementation of business applications including Development and Design of ETL methodologies using Informatica Power Center in various domains like Pharmaceutical, Financial, and Oil & gas sectors.
• As a ETL Developer in designing and implementing Data Mart / Data Warehouse applications using INFORMATICA Power Center 9.x /8.x / 7.x / 6.x (Designer, Workflow manager, Workflow monitor and Repository Manager).
• Designed and developed Complex mappings from various Transformations like re - usable transformations, and Mappings/Mapplets, Unconnected / Connected lookups, Router, Filter, Expression, Aggregator, Joiner, Update Strategy and more, mappings using Stored Procedure’s, Normalizer, XML, External Procedure.
• Good knowledge on SDLC (software development life cycle) and good experience with unit testing and integration testing.
• Preparing the High level Design Specifications for ETL Coding and mapping standards.
• Experience in Performance tuning of targets, sources, mappings and sessions.
• Experience in integration of various data sources like Oracle, SQL server and MS access, flat files, and XML files.
• Experience in Ralph Kimball Methodology, Logical Modeling, Physical Modeling, Dimensional Data Modeling, Star Schema, Snowflake Schema, FACT tables, Dimension tables
• Expertise in OLTP/OLAP System study, developing Database schemas like star schema, snow flake schema Dimensional Data Modeling used in relational, dimensional modeling and slowly changing dimensions (SCD’s).
• Performed ETL procedure to load data from different sources into data marts and Data Warehouse using Power Center.
• Strong expertise in Relational data base systems like Oracle 8i/9i/10g, SQL Server 2000/2005, MS Access, design and database development using SQL, PL/SQL, SQL PLUS, TOAD,SQL LOADER.
• Knowledge of reporting tool like OBIEE, and Business Objects.
• Experience inInformaticaDACTool for Customizing Data warehouses and Creating Task and Task Groups in it.
• ETL experience in development of mappings and tuned existing mappings for better performance using InformaticaPowerCenter as per the business rules.
• Expertise in writing Oracle PL/SQL Stored Procedures/Functions/Packages and cursors Triggers.
• SQL Tuning and creation of indexes for faster database access, better query performance in Informatica by creating Explain Plan, SQL hints for query and indexing the required columns.
• Develop, execute ETL test plans, Document ETL processing and generate required metadata.
• Develop a transformation by marking the relevant data directly on a sample of the data source, and mapping that data to a chosen XML schema
• Experience with UNIX commands, VI editor and writing Shell scripts.
• Experience in creating reports using Oracle Business Intelligence 10x
• Outstanding communication and interpersonal skills, ability to learn quickly, good analytical reasoning and high compliance to new technologies and tools.

TECHNICAL SKILLS

ETL Tools: Informatica 9.x/8.x/7.x/6.x (Power Center),Talend(TOSDI 5.2.3,5.3.1)

Databases: Oracle 8i/9i/10g/11g

Query Tools: SQL, PL/SQL, SQL*Plus, and TOAD

OLAP/Reporting Tools: Business Objects

Languages: UNIX/LINUX/DOS Scripting, PL/SQL

PROFESSIONAL EXPERIENCE

Confidential, UT

Sr ETL Developer

Responsibilities:

• Worked with customers, end-users, technical architects, and application designers to definethe data requirements and structure for Business Intelligence (BI) applications.
• Designed models for the data warehouse or data mart (data structure, storage, andintegration)
• Extensively worked on TALEND in Creating Complex Jobs Involving components like Tmap, Tfilter row, Tmysql Input, Tmysql output and many more.
• Had a good experience working with different kinds of data sources like Excel, Flat file, DB tables, Cloud Based Folders.
• Responsible for design, development and maintenance of ETL processes to populatewarehouse.
• Lead the database analysis, design, and build effort
• Worked with developers to design and improve complex SQL queries so they are optimized
• SQL development of queries, optimization, reporting & schema creation
• Designed maps of source system data to data warehouse models
• Developed strategies for data acquisitions and integration of the new data into Domo's Dataengine.
• Access Box Folders and pulling data directly from them at run time.
• Monitor performance and tune databases to optimize for different workloads
• Conducted Post deployment analysis on production server for the new changes.
• Present defect report to the higher management.
• Developing complex TALEND mappings to load the data from various sources using different components like look up, Tmap, Taggregaterow, Tjoin, Tfilter, Tnormalize, Tunite and Treplicate components.
• Developing TALEND mappings and also tuned for better performance.
• Developing Procedures and Functions in PL/SQL.
• Using Procedure Components to invoke Oracle PL/SQL Procedures.
• Optimizing and Tuning SQL queries and PL/SQL blocks to eliminate Full Table scans to reduce Disk I/O and Sorts.
• Working with TALEND in extracting the data from Cloud based folders.
• Using TALEND to load data from flat files, Oracle, MYSQL database.
• Performing Data Masking for preserving the referential integrity of the user data.
• Performing Data Encryption on user data and client data for maintaining consistency and security.
• Load balancing of ETL processes, database performance tuning and capacity monitoring.
• Involve in Unit testing and System testing of the individual.
• Analyze existing system and developed business documentation on changes required.

Environment: Talend Data Integration, MYSQL, QuickBooks

Confidential, TX

Sr. Informatica Developer

Responsibilities:

• Developed complex Informatica mappings to load the data from various sources using different transformations like source qualifier, connected and unconnected look up, expression, aggregator, joiner, filter, normalizer, rank and router transformations.
• Worked Informatica power center tools like source analyzer, mapping designer, mapplet and transformations.
• Developed Informatica mappings and also tuned for better performance.
• Developed Procedures and Functions in PL/SQL.
• Used Procedure Transformations to invoke Oracle PL/SQL Procedures.
• Optimized and Tuned SQL queries and PL/SQL blocks to eliminate Full Table scans to reduce Disk I/O and Sorts.
• Designed and Developed ETL logic for implementing CDC by tracking the changes in critical fields required by the user.
• Extensively used Informatica to load data from flat files, Oracle database.
• Performed Data Encryption on user data and client data for maintaining consistency and security.
• Responsible for Performance Tuning at the Mapping Level and Session level.
• Worked with SQL Override in the Source Qualifier and Lookup transformation.
• Extensively worked with both Connected and Unconnected Lookup Transformations.
• Load balancing of ETL processes, database performance tuning and capacity monitoring.
• Created standard and best practices for TALEND ETL components and jobs.
• Performed transforming and filtering data Implementation of ETL Process using TALEND Tool
• Worked with the onsite team to understand the ETL TALEND requirements and start working independently
• Involved in Unit testing and System testing of the individual.
• Analyzed existing system and developed business documentation on changes required. performed detail data analysis of both data elements requested by the business and data source and documenting data source definition, source-to-target mapping, and logical structures for the data warehouse/data mart was involved in design, development, and the administration of a Oracle data mart, the distribution of global data from the Data Warehouse
• Used UNIX to create Parameter files and for real time applications.
• Developed shell scripts.
• Extensively involved in testing the system from beginning to end to ensure the quality if the adjustments made to oblige the source system up-gradation.
• Worked with many existing Informatica mappings to produce correct output.
• Prepared Detail design documentation thoroughly for production support department to use as hand guide for future production runs before code gets migrated.
• Prepared Unit Test plan and efficient unit test documentation was created along with Unit test cases for the developed code.
• Detail system defects are created to inform the project team about the status throughout the process.
• Extensively worked with various lookup caches like Static Cache, Dynamic Cache and Persistent Cache.
• Used Update Strategy DD INSERT, DD UPDATE to insert and update data for implementing the Slowly Changing Dimension Logic.
• Developed Re-Usable Transformations and Re-Usable Mapplets.
• Developed Slowly Changing Dimensions Mapping for Type 1 SCD and Type 2 SCD.

Environment: Informatica Power Center 9.0/8.6, Windows NT, Oracle 9i/10g,DB2, SQL/PL-SQL, T SQL, TOAD, XML.

Confidential, FL

Sr. Informatica Developer

Responsibilities:

• Involved in gathering and reviewing business requirements. Involved in designing the specifications, Design Documents, Data modeling and design of data warehouse.
• Responsible for definition, development and testing of processes/programs necessary to extract data from operational databases, Transform and cleanse data, and Load it into data warehouse using Informatica Power center.
• Created the repository manager, users, user groups and their access profiles.
• Created complex mappings in Power Center Designer using Expression, Filter, Sequence Generator, Update Strategy, Joiner and Stored procedure transformations.
• Created connected and unconnected Lookup transformations to look up the data from the source and target tables.
• Modeling and populating the business rules using mappings into the Repository for Meta Data management.
• Demonstrated expertise utilizing ETL tools, including Informatica and ETL package design, and RDBMS systems like SQL Server, Oracle.
• Cleansed the source data, extracted and transformed data with business rules, and built reusable mappings, known as ‘Mapplets’ using Informatica Designer.
• Extensively performed Data Masking for preserving the referential integrity of the user data.
• Performed Data Encryption on user data and client data for maintaining consistency and security.
• Involved in the development of Informatica mappings and also performed tuning for better performance.
• Designed and Developed ETL logic for implementing CDC.
• Extensively worked on tuning (Both Database and Informatica side) and thereby improving the load time.
• Setting up sessions to schedule the loads at required frequency using Power Center, Workflow manager, PMCMD and also using scheduling tools
• Used parallel processing capabilities, Session-Partitioning and Target Table partitioning utilities.
• Automated the entire processes using UNIX shell scripts.
• Worked on UDB/ DB2, Tested the target data against source system tables by writing some QA Procedures.
• Conduct status meetings with project managers, escalate issues when necessary, conducts meetings for issues resolution
• 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. Technical solutions and supporting deliverables will be constructed to enable CIGNA IT clients to accomplish their business objectives.
• Created new extracts for external vendors and use Informatica ETLs for new workflows to move data out of multiple data sources.
• Unit test coding changes, fill out required documentation such as installation instructions, and follow standards and procedures.
• 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. New development and support task responsibilities.

Environment: Informatica Power Center 8.6.1/8.1.3 , Oracle 10g, SQL Assistant and Administrator, XML, UNIX Shell Scripting

Confidential, Lewistown, PA

Sr. Informatica Developer

Responsibilities:

• Interacted with business users and business analyst to understand reporting requirements and prepared system requirement specification document.
• Worked with Reporting team to get to an agreement on what level of complexity to be handled by ETL and reporting side.
• Experience in developing canned/ad-hoc reports, scheduling the processes using Broadcast Agent and administering the BO activities.
• Designed and developed complex mappings, from varied transformation logic like Unconnected and Connected lookups, Router, Filter, Expression, Aggregator, Joiner, Update Strategy and more.
• Identifying and Removing Bottlenecks in order to improve the performance of Mappings and Workflows.
• Used Procedure Transformations to invoke Oracle PL/SQL Procedures.
• Implemented slowly changing dimensions according to the requirements, Partitioned sessions, modified cache/buffers and tuned transformations for better performance.
• Used Workflow Manager for Creating, Validating, Testing and running the sequential and concurrent Batches and Sessions.
• Designed Incremental loading process to load data into staging tables.
• Actively contributed in framing the Data Warehouse SDLC standards, methodologies and best practices.
• I Developed shell scripts for Informatica pre-session, post-session scripts.
• Optimized the existing applications at the mapping level, session level and database level for a better performance.
• Wrote DB2 scripts for implementing in the production databases.
• Developed PL/SQL procedures, functions to facilitate specific requirement.
• Optimized and Tuned SQL queries and PL/SQL blocks to eliminate Full Table scans to reduce Disk I/O and Sorts.
• Configured the sessions using workflow manager to have multiple partitions on Source data and to improve performance.
• Carried out unit testing, systems testing and post-production verification.
• Designed and developed UNIX scripts for creating, dropping tables which are used for scheduling the jobs.
• Developed a UNIX Shell scripts which will send the reports to client over the network by using file transfer protocol (FTP) and generating the log file, which will keep the history for the FTP reports.
• Investigated and fixed problems encountered in the production environment on a day to day basis.

Environment: Informatica Power Center 8.5/8.1, Business Objects XI R2, Web intelligence Oracle 9i, SQL/PL-SQL, DB2 8.0, Flat Files, Windows XP, UNIX Shell Scripting, Sql*Loader, TOAD.

Confidential, CA

Informatica Developer

Responsibilities:

• Involved in gathering and reviewing business requirements. Involved in designing the specifications, Design Documents, Data modeling and design of data warehouse.
• Responsible for definition, development and testing of processes/programs necessary to extract data from operational databases, Transform and cleanse data, and Load it into data warehouse using Informatica Power center.
• Created the repository manager, users, user groups and their access profiles.
• Created complex mappings in Power Center Designer using Expression, Filter, Sequence Generator, Update Strategy, Joiner and Stored procedure transformations.
• Created connected and unconnected Lookup transformations to look up the data from the source and target tables.
• Modeling and populating the business rules using mappings into the Repository for Meta Data management.
• Demonstrated expertise utilizing ETL tools, including SQL Server Integration Services (SSIS), and Informatica and ETL package design, and RDBMS systems like SQL Server, Oracle.
• Implemented Slowly Changing Dimensions (SCDs, Both Type 1 & 2).
• Cleansed the source data, extracted and transformed data with business rules, and built reusable mappings, known as ‘Mapplets’ using Informatica Designer.
• Involved in the development of Informatica mappings and also performed tuning for better performance.
• Extensively worked on tuning (Both Database and Informatica side) and thereby improving the load time.
• Setting up sessions to schedule the loads at required frequency using Power Center, Workflow manager, PMCMD and also using scheduling tools
• Used parallel processing capabilities, Session-Partitioning and Target Table partitioning utilities.
• Automated the entire processes using UNIX shell scripts.
• Conduct status meetings with project managers, escalate issues when necessary, conducts meetings for issues resolution

Environment: Informatica Power Center 8.6/8.5, Windows-NT, Oracle 9i/10g, DB2, SQL, PL/SQL, SQL * Loader, T SQL, TOAD, XML.

Confidential, Waukegan, IL

Informatica Developer

Responsibilities:

• Responsible for gathering the user requirements and discuss with Business Analysts to acquire the functional and Technical specifications
• Analyzed the source data coming from Oracle ERP system to create the Source to Target Data Mapping.
• Interacted with the Data Architect in Creating and modifying Logical and Physical data model.
• Used Informatica Repository Manager to create Repositories and Users and to give permissions to users.
• Worked with DBA’s in optimizing the Major SQL Query’s in the process of performance tuning.
• Responsible for identifying the bottlenecks and tuning the performance of the Informatica mappings/sessions.
• Used parallel processing capabilities, Session-Partitioning and Target Table partitioning utilities.
• Designed and developed mapping using various transformations like Source Qualifier, Sequence Generator, Expression, Lookup, Aggregator, Router, Rank, Filter, Update Strategy and Stored Procedure.
• Worked extensively in creating Worklet’s and Mapplet’s and Reusable Sessions
• Worked with Tidal Enterprise Scheduler to schedule jobs and batch processes.
• Experience in using AppWorx software to schedule and run jobsfor custom writtenprograms.
• Developed Procedures and Functions in PL/SQL.
• Created Unit Test plans and involved in primary unit testing of mappings.
• Provided data loading, monitoring, system support and general trouble shooting necessary for all the workflows involved in the application during its production support phase.

Environment: Informatica Power Center 8.6/8.5, Oracle 10g, Flat files, TOAD 8.6, UNIX.