Summary

• Over 8 years of IT experience as an ETL Developer/Program analyst, which includes Data Warehouse/Database Developer experience using Informatica PowerCenter 9.5.1/8.x/7.x, Power Exchange 9.5.1/8.6/8.1 as ETL tool.
• 8.5 years of database experience on Oracle Exadata/11g/10g/9i, Teradata 13/12/V2R5, SQL Server 2012/2008, DB2, Sybase and MS access.
• Experience in all the phases of Data warehouse life cycle involving Requirement Analysis, Design, Coding, Testing, and Deployment.
• Extensively worked on the ETL mappings, analysis and documentation of OLAP reports requirements. Solid understanding of OLAP concepts and challenges, especially with large data sets.
• Strong knowledge of Entity-Relationship concept, Facts and dimensions tables, slowly changing dimensions and Dimensional Modeling Star Schema and Snow Flake Schema .
• Proficient in Optimizing Database querying, data manipulation and population using SQL PL/SQL and Utilities in Oracle 11g/10g/9i, Teradata 13/12/V2R6, DB2 UDB and SQL Server 2008/2000, Sybase databases.
• Experience in integration of various data sources like Oracle, DB2, Sybase, SQL server and MS access and non-relational sources like flat files into staging area and DWH DB.
• Experience in creating Reusable components like transformation, mapplets and tasks.
• Loading data from various data sources and legacy systems into Teradata production warehouse using utilities BTEQ, FASTEXPORT, MULTI LOAD, FASTLOAD.
• Experience in writing, testing and implementation of the PL/SQL triggers, stored procedures, functions, packages.
• Excellent working knowledge of UNIX shell scripting, job scheduling on multiple platforms, experience with UNIX command line and LINUX.
• Worked on CDC using Informatica PowerExchange to load data in Real-time mode.
• Proficient in interaction with the business users by conducting meetings with the clients in Requirements Analysis phase.
• Assign work and provide technical oversight to onshore and offshore developers
• Excellent analytical/communication skills and good team player.

Technical Skills:

Professional Experience

Confidential

Sr. Informatica/ETL Developer

Roles Responsibilities:

• Converted business requirements into technical documents BRD, explained business requirements in terms of technology to the developers.
• Developed Data Flow diagrams to create Mappings and Test plans. The Data flow diagrams ranged from OLTP systems to staging to Data warehouse.
• Developed Test plan to verify the logic of every Mapping in a Session. The test plans included counts verification, look up hits, transformation of each element of data, filters, and aggregation and target counts.
• Developed complex Informatica mappings using various transformations- Source Qualifier, Normalizer, Filter, Connected Lookup, Unconnected Lookup, Update strategy, Router, Aggregator, Sequence Generator, Reusable sequence generator transformation.
• Extensively used SCD's Slowly Changing Dimension to handle the Incremental Loading for Dimension tables, Fact tables.
• Designed various mappings for extracting data from various sources involving Flat files, Oracle, Sybase and SQL Server, IBM DB2.
• Created power exchange registration, data map and restart token for CDC real time process.
• Worked on Debugging and Troubleshooting of the Informatica application. For debugging utilized Informatica debugger.
• Worked on Performance Tuning to optimize the Session performance by utilizing, Partitioning, Push down optimization, pre and post stored procedures to drop and build constraints.
• Experience in building of the Repository RPD using the OBIEE toolset.
• Developed OBIEE technology such as Answers, Dashboards, and BI Publisher.
• Identify users and see what level of familiarity do they have with this data. Segment these users based on criteria like influence, authority and participation levels.
• Identifying automated decision-making possibilities.
• Worked on Teradata utilities BTEQ, MLOAD, FLAOD and TPUMP to load staging area.
• Worked on Audit login, Error login and Reference check while loading data to Data warehouse.
• Created Unix Script for ETL jobs, session log cleanup and dynamic parameter.

Environment: Informatica Power Center 9.5.1/8.6, Power Exchange 9.5.1/8.6, AS-400 DB2 , Oracle 11g,Teradata 13,OBIEE 10g, SQL Server 2005/2K, AIX, Windows XP, Sun Solaris, Putty, SCM, Rally.

Confidential

Sr. Informatica/ETL Developer

Roles Responsibilities:

• Participated in the business analysis process and the development of ETL requirements specifications.
• Involved in the design, development and implementation of the Enterprise Data Warehousing EDW process and Data Mart.
• Designed mapping document, which is a guideline for ETL coding following standards for naming conventions and best practices were followed in mapping development.
• Extracted the data from the Flat files, Excel files, Operational systems, Oracle databases into staging area and populated onto data warehouse.
• Developed number of complex Informatica mappings, mapplets, and reusable transformations to implement the business logic and load the data incrementally.
• Worked with Connected, Unconnected Lookups, Aggregator, Router, Update strategy, Sorter, Normalizer, SQL and SQ transformations.
• Designed CDC Real-time Informatica recovery process,
• Created job for start and stop real-time workflows, wrapper to generate restart token for failed workflows.
• Created static and dynamic deployment groups to move code to higher region.
• Extracted data from Flat files, SQL Server and Oracle and loaded them into Teradata.
• Involved in Data Profiling Data Analysis on Database sources like Oracle and flat files.
• Used Debugger extensively to validate the mappings and gained troubleshooting information about data and error conditions.
• Used Teradata for running the SQL Queries to check the data loaded to the Target Tables.
• Worked with Teradata loading utilities like Multi Load, Fast Load and TPump.
• Involved in creation of BTEQ Script for validating the data quality like referential integrity, not null check.
• Utilized UNIX shell scripts for adding the header to the Flat file targets.
• Scheduled the workflow using CRONTAB command and PMCMD in UNIX.
• Worked with production support systems that required immediate support.
• Participated in weekly meetings to discuss the status, issues and defects detected during the different stages of testing of the application.
• Tested all the mappings and sessions in Development, UAT environments and also migrated into Production environment after everything went successful.

Environment: Informatica Power Center 9.1, Power Exchange 9.1, DB2 UDB, Oracle11g, Teradata 12,TOAD, Autosys, SQL Loader, QVCS, Flat file, Sun Solaris Unix, BTEQ, Windows Enterprise 2000.

Confidential

Sr. Informatica/ETL Developer

Roles Responsibilities:

• Designed ETL processes using Informatica to load data from Flat Files, and Excel files to target Oracle Data Warehouse database
• Prepare ETL Specifications based on the design and high level logical flow provided by BI Architect
• Develop code using Oracle SQL Loader / Informatica mappings, workflows and sessions as per ETL specifications and implemented CDC Change Data Capture scripts wherever required.
• Create Performance Metrics and Deployment documents.
• Perform Unit, Functional, Integration and Performance testing there by ensuring data quality.
• Create job chains to schedule data loads and trace bugs, close HII-logs if anyCo-ordinate with support teams to deploy code in stage and production environments.
• Provide transition to RTS team after project go-live.
• Used tuned SQL overrides in source Qualifier to meet business requirements
• Written pre session and post session scripts in mappings. Created sessions and workflows for designed mappings. Redesigned some of the existing mappings in the system to meet new functionality
• Created and used different reusable tasks like command and email tasks for session status
• Used Workflow Manager to create Sessions and scheduled them to run at specified time with required frequency
• Monitored and configured the sessions that are running, scheduled, completed and failed.
• Created test case, participate in System integration test, UAT and migrated code from Dev to Test to QA to Prod.
• Compiled report presentations using tools like Business Object reports.
• Involved in writing UNIX shell scripts for Informatica ETL tool to fire off services and sessions

Environment: Informatica 8.5, Oracle 10g/9i, Flat files, Excel, SQL Server, PL/SQL, Toad, UNIX Shell Scripting, Windows XP, Business Object XI R2.

Confidential

Informatica/ETL Developer

Roles Responsibilities:

• Designed ETL processes using Informatica to load data from Flat Files, and Excel files to target Oracle Data Warehouse database
• Performed data manipulations using various Transformations like Joiner, Expression, Lookup, Aggregate, Filter, Update Strategy, and Sequence Generator, Stored Procedure etc.,
• Used tuned SQL overrides in source Qualifier to meet business requirements
• Written pre session and post session scripts in mappings.
• Created sessions and workflows for designed mappings. Redesigned some of the existing mappings in the system to meet new functionality
• Created and used different reusable tasks like command and email tasks for session status
• Involved in the data analysis for source and target systems and good understanding of Data Warehousing concepts, staging tables, Dimensions, Facts and Star Schema, Snowflake Schema.
• Identify the flow of information, analyzing the existing systems, evaluating alternatives and choosing the most appropriate alternative
• Understand the components of a data quality plan. Make informed choices between sources data cleansing and target data cleansing.
• Prepare documentation on all aspects of ETL processes, definitions and mappings.
• Used features like email notifications, scripts and variables for ETL process using Informatica Power Center.
• Involved in Data Extraction from Oracle and Flat Files using SQL Loader Designed and developed mappings using Informatica Power Center
• Involved in Data Extraction from Oracle and Flat Files, XML Files using SQL Loader, Freehand SQL.
• Used Workflow Manager to create Sessions and scheduled them to run at specified time with required frequency
• Monitored and configured the sessions that are running, scheduled, completed and failed.
• Created test case, participate in System integration test, UAT and migrated code from Dev to Test to QA to Prod.
• Compiled report presentations using tools like Business Object reports.
• Involved in writing UNIX shell scripts for Informatica ETL tool to fire off services and sessions

Environment: Informatica Power Center 8.1, Oracle 10g, MS SQL server 2000, Unix, Shell scripting and Windows XP, Erwin 4.2, SQL/PL SQL, Putty, SCMS

Confidential

Informatica/ETL Developer

Roles Responsibilities:

• Interacted with business user groups through facilitated meetings understanding the business process.
• Extracted data from different sources like flat files, Oracle, DB2and loaded them into DB2 enterprise Data Warehouse.
• Extensively worked with Source Analyzer, Warehouse Designer, Transformation designer, mapping designer and Workflow Manager.
• Developed data Mappings between source systems and warehouse components
• Created various Transformations like Joiner, Aggregate, Expression, Lookup, Filter, Union, Update Strategy, Stored Procedures, and Router etc. and Fine-tuned the mappings for optimal performance.
• Developed and modified many scripts using Shell scripting in UNIX
• Made use of System variables SYSDATE , Mapping parameters and variables in the transformations within a mapping. Employed variable functions like SetMax Variable to manipulate mapping variables and parameter files to initialize mapping parameters.
• Coordinating with the DBA's for managing the databases in different environments for UAT and system testing, also involving with DBA's during the release nights and troubleshooting with any of the production problems.
• Worked with testing team in trouble shooting the defects in application.
• Used Informatica as a tool for the test data preparation in various environments
• Involved in performance tuning of SQL Queries adding indexes, mapping, having files locally avoiding network connections and avoiding/correcting transformation errors in a mapping.

Environment: Informatica Power Center 7.1.1, Oracle 10g, MS SQL server 2000, Unix, Shell scripting and Windows XP, Erwin 4.2, SQL, PL/SQL.