SUMMARY

• Around 9+ years of experience in analysis, design, development and implementation of Client/Server and Data warehouse applications using Oracle, MS SQL server on Windows and UNIX platforms.
• Strong experience in designing and developing Business Intelligence solutions in Data Warehouse/Decision Support Systems using ETL tools, Informatica PowerCenter 10.2/9.5.1/9.1/8.6.1/8.5/8.1 , OLTP, OLAP.
• Data Modeling experience using Star Schema/Snowflake modeling, OLAP/ROLAP tools, Fact and Dimensions tables, Physical and logical data modeling, and Oracle Designer.
• Experience in documenting Design specs, Unit test plan and deployment plan.
• Experience in Installation, Configuration, and Administration of Informatica Power Center 10.2/9.1/8.x/7.x/6.x and Power Mart 5.x/6.x Client, Server.
• Experience in Repository Configuration, creating Transformations and Mappings using Informatica Designer and processing tasks using Workflow Manager to move data from multiple sources into targets.
• Created data stores, project, jobs, and data flows using Data Integrator.
• Experience in data integration of various data sources from Databases like MS Access, Oracle, SQL Server and formats like flat - files, CSV files, COBOL and XML files.
• Experience in Oracle as Pl/SQL Developer.
• Extensively worked on both Windows (Batch and Power shell) and Unix Scripting.
• Extensively worked on Data Services proactively and iteratively collaborate in the profiling and cleansing of data across the heterogeneous sources.
• Experience in creation and customization of ETL extracts and load process using Informatica.
• Experience in Performance tuning of Informatica (sources, mappings, targets and sessions) and tuning the SQL queries.
• Worked on data migration of Informatica Mappings, Sessions, and Workflows to Data Integrator.
• Experience in design and implementation using ETL tools like Informatica (Power Center) Designer, Repository Manager and Workflow / Server Manager.
• Developed effective working relationships with client team to understand support requirements, develop tactical and strategic plans to implement technology solutions, and effectively manage client expectations.
• Excellent interpersonal and communication skills, technically competent and result-oriented with problem solving skills and ability to work independently and use sound judgment.
• Developed excellent professional skills by working independently and also as a team member to analyze the Functional/ Business requirements and to prepare test plans, test scripts.
• Excellent written and verbal communication skills.

TECHNICAL SKILLS

ETL Tool: Informatica 10.2/9.1/8.6.1/8.1/7.1/6.2/6.1

Scheduler Tool: Autosys, One Automation, Control-M

Data Modeling: Toad, Star-Schema, Snowflake-Schema, Erwin.

DBMS: Oracle 8i/9i/10g/11g, MS Access

SQL Server: 2003/2005/2008/2012/2014/2016

Teradata: 14/14.10/15, IBM DB2, Siebel.

Languages & Scripting: SQL, PL/SQL, Java, XML, HTML, Perl, Batch Scripting, Power Shell, Korn Scripting, C, C++.

Operating Systems: Windows 95/98/00/NT/XP/7/8/10, Sun Solaris, Red Hat, UNIX.

PROFESSIONAL EXPERIENCE

Confidential, ST. LOUIS, MO

Lead ETL Developer

Responsibilities:

• Responsible for Requirement Gathering Analysis and End user Meetings
• Responsible for Business Requirement Documents BRD's and converting Functional Requirements into Technical Specifications.
• Responsible for mentoring Developers and Code Review of Mappings developed by other developers.
• Responsible for providing guidance and coordinate the business requirements with offshore developers and assigning appropriate amount of workload.
• Installed/configured Teradata Power Connect for Fast Export for Informatica.
• Used Informatica MDM (Siperion) tool to manage Master data of EDW.
• Extensively used Teradata utilities like Fast load, Multiload to load data into target database.
• Installed/configured SAP adaptor and JD Edwards (Power Exchange) for Informatica.
• Did change data capture (CDC) by using the MD5 function of Informatica.
• Installed/configured Teradata Utilities and Teradata Studio.
• Created custom IDQ plans and incorporated it into Power Center as mapplet.
• Extracted data from various heterogeneous sources like Oracle, SQL Server, and Flat Files and loaded into Datamarts using Informatica.
• Resolved Skewness in Teradata.
• Optimized MicroStrategy Cube queries.
• Used Informatica Data Quality (IDQ) to format data from sources and load it into target databases according to business requirements.
• Created jobs for Informatica data replication fast clone to get data from oracle and load it into Teradata.
• Created the visio diagram to show the job dependencies for One Automation jobs.
• Scheduled Informatica jobs and Teradata procedures in One Automation.
• Wrote BTEQ scripts and Stored Procedures in Teradata extensively.
• Created custom plans for product name discrepancy check using IDQ and incorporated the plan as a mapplet into Power Center.
• Extensively used Teradata utilities like Fast load, Multiload to load data into target database.
• Loaded data from flat files to Big Data (1010 data).
• Did bulk loading of Teradata table using TPump utility.
• Used IDQ’s standardized plans for addresses and names clean ups.
• Extensively used various active and passive transformations like Filter Transformation, Router Transformation, Expression Transformation, Source Qualifier Transformation, Joiner Transformation, and Look up Transformation, Update Strategy Transformation, Sequence Generator Transformation, Rank Transformation, and Aggregator Transformation.
• Created jobs for Informatica data replication fast clone to get data from oracle and load it into Teradata.
• Created jobs for Informatica data replication fast clone to get data from oracle and load it into Teradata.
• Responsible for best practices like naming Conventions, Performance tuning, and Error Handling
• Responsible for maintain data quality and data consistency before loading into ODS.
• Responsible for Performance Tuning at the Source level, Target level, Mapping Level and Session Level.
• Responsible for tweaking underperforming Stored Procedures in Teradata.
• Solid Expertise in using both Connected and Un connected Lookup transformations
• Extensively worked with various lookup caches like Static Cache, Dynamic Cache, and Persistent Cache
• Configured Informatica for the SAP Connector.
• Retrieved data from SAP using Informatica Power Exchange.
• Developed Re usable Transformations, and Re-Usable Mapplets.
• Worked with Shortcuts across Shared and Non Shared Folders
• Developed Slowly Changing Dimension Mappings for Type 1 SCD and Type 2 SCD
• Responsible for implementing Incremental Loading mappings using Mapping Variables and Parameter Files
• Responsible for determining the bottlenecks and fixing the bottlenecks with performance tuning.
• Used Update Strategy DD INSERT, DD DELETE, DD UPDATE, AND DD REJECT to insert, delete, update and reject the items based on the requirement
• Worked with Session Logs, and Workflow Logs for Error handling and Troubleshooting in all environment
• Responsible for Unit Testing and Integration testing of mappings and workflows.

Environment: Informatica Power Center 10.2/ 9.5.1/9.1.0 , Informatica MDM, Teradata 14/15, Teradata Studio, Big Data 1010 data., Oracle 10g/11g, MS SQL Server, One Automation, TOAD, SQL, PL/SQL, MicroStrategy, Windows 7/10, UNIX

Confidential, TAMPA, FL

Sr. Informatica Developer/OBIEE Developer

Responsibilities:

• Effectively analyze large amounts of data from data modelling perspective.
• Identify, analyze the source system data for data quality, data profiling and data governance.
• Responsible for BI/Data Warehouse data modeling with involvement in design, dimensional modeling and architecture.
• Responsible for developing ETL data mapping documents for source to target column mapping and business rules.
• Involved in all phases of SDLC from requirement gathering, design, development, testing, Production, user training and support for production environment.
• Extensively used Teradata utilities like Fast load, Multiload to load data into target database.
• Pulled data from Epic Clarity, EDI and HIPAA compliance files (X12 files).
• Loaded data to EDI system and clinical documentation.
• Created the RPD for OBIEE.
• Created custom IDQ plans and incorporated it into Power Center as mapplet.
• Worked on creating physical layer, business model, mapping and presentation layer in OBIEE.
• Created source system containers for OBIEE.
• Created subject areas in containers for OBIEE.
• Created narrative reports in OBIEE.
• Involved in extracting the data from the Flat Files and Relational databases into staging area.
• Optimized OBIEE dashboard queries.
• Prepared Technical Design documents and Test cases.
• Worked with UNIX shell scripts extensively for job execution and automation.
• Created the visio diagram to show the job dependencies for Control-M jobs.
• Inserted/updated the Informatica jobs in Control-M by invoking the pmcmd utility of Informatica.
• Worked on mappings, Mapplets and workflow to meet the business needs ensured they are reusable transformation to avoid duplications.
• Responsible for Performance Tuning at the Mapping Level, Session Level, Source Level and the Target Level for Slowly Changing Dimensions Type1, Type2 for data Loads.
• Worked on various kinds of transformations like Expression, Aggregator, Stored Procedure, Java, Lookup, Filter, Joiner, Rank, Router and Update Strategy.
• Used Change Data Capture (CDC) to simplify ETL in data warehouse applications.
• Utilized PuTTY to shut down and restart the Admin Server / Hub server to speed up the MDM process.
• Utilized Informatica IDQ to complete initial data profiling and matching/removing duplicate data.
• Created business objects universes.
• Created denormalized BO reporting layer for BO reports.
• Developed Slowly Changing Dimension Mappings for Type 1 SCD and Type 2 SCD
• Worked on performance tuning of workflows and mapping so that runtime and extraction time are improved.

Environment: Informatica Power Center 9.5.1/9.1.0 HF1,Informatica MDM, SAP BW, Oracle 10g, MS SQL Server, SAP BW/IDoc, Autosys, TOAD, SQL, PL/SQL, BO XI, OBIEE, Windows 7, UNIX

Confidential, CHARLOTTE, NC

Sr. Informatica Developer/OBIEE Developer

Responsibilities:

• Extracted data as flat file from DB2 database, applied business logic to load them in the Standardization area, Central Repository and all the way to data marts and flat files.
• Interview the Business users Data architects in gathering the requirements and finding the data needs.
• Retrieved data from the Oracle CDC Staging tables.
• Participate in the discussions with the business solutions team in creating and implementing the plans for the designs like Flow Chart diagrams, Conceptual and Logical Diagrams, and defining the terms on the needs of the project.
• Lead the Informatica developer’s team offshore.
• Reviewed the Offshore team’s code for performance.
• Helps in getting the potential data sources.
• Create the data results through techniques and tools such as basic SQL queries, data mining, and multidimensional analysis.
• Installed and configured Informatica Power Center Server and client 9.1.
• Designed the mappings and workflows and implemented the logic using the transformations.
• Extracted data from complex XML hierarchical schemas for transformation and load into teradata and vice versa.
• Wrote pearl script extensively.
• Extensively written Shell scripting to take repository backup and archiving the logs.
• Used Informatica power center for (ETL) extraction, transformation and loading data from heterogeneous source systems.
• Developed complex mappings using transformations such as the Source qualifier, Aggregator, Expression, Lookups, Filter, Router, Sequence Generator, Update Strategy, and Joiner
• Integrated Informatica workflows into OBIEE
• Recreated connections for OBIEE
• Acquired Working knowledge of Repository (RPD) and Datawarehouse Application Console (DAC).
• Designed logical and physical folders of OBIEE.
• Created subject area containers in OBIEE.
• Designed and Developed Oracle PL/SQL and Shell Scripts, Data Import/Export, Data Conversions and Data Cleansing.
• Maintained Sequential load through ROBOT job scheduler.
• Tuning the SQL queries as required. Created the PL/SQL Stored procedures, Indexes, Views.
• Performed unit testing and documented the results.
• Worked closely with QA team during the testing phase and fixed bugs that were reported
• Designed the Build Docs of the entire release/ project for the production support.

Environment: Informatica PowerCenter 9.1/8.6.1, DB2 4 (iSeries Navigator, TOAD for DB2), Oracle 11g, Teradata 13, Oracle CDC, Oracle Business Intelligence Enterprise Edition (OBIEE 11g), AS400, Cognos, UNIX, MS ACCESS, MS EXCEL 2007, Robot.

Confidential, HOUSTON, TX

Sr. Informatica Developer

Responsibilities:

• Extracted data as flat file from Sales Connect, SFDC and oracle database, applied business logic to load them in the Standardization area, Central Repository and all the way to data marts.
• Developed mappings/Reusable Objects/Transformation/mapplets by using mapping designer, transformation developer and mapplet designer in Informatica Power Center 8.6.1.
• Knowledge in upgrading from Informatica version 8.6.1 to 9.1.
• Created reusable transformations and mapplets and used them in mappings.
• Used Informatica Power Center 8.6.1 for extraction, loading and transformation (ETL) of data in the data warehouse.
• Implemented Informatica recommendations, methodologies and best practices.
• Implemented populate slowly changing dimension to maintain current information and history information in dimension tables.
• Used Informatica Power Center Workflow manager to create sessions, batches to run with the logic embedded in the mappings
• Involved in creation of Folders, Users, Deployment Group using Repository Manager.
• Worked on different data sources such as Oracle, SQL Server, Flat files etc.
• Created complex mappings in Power Center Designer using Aggregate, Expression, Filter, and Sequence Generator, Update Strategy, Union, Lookup, Joiner, XML Source Qualifier and Stored procedure transformations.
• Developed PL/SQL and UNIX Shell Scripts for scheduling the sessions in Informatica.
• Built Autosys boxes which schedules the Informatica jobs at very frequent.
• Created E-mail notifications tasks using post-session scripts.
• Worked with command line program pmcmd to interact with the server to start and stop sessions and batches, to stop the Informatica server and recover the sessions.
• Wrote SQL, PL/SQL, stored procedures & triggers for implementing business rules and transformations.
• Created procedures to drop and recreate the indexes in the target Data warehouse before and after the sessions.
• Retrieved data from SAP BW, SAP Idocs.
• Transformed data from unstructured data sources (XML, Mainframe etc), Applications (SAP Idocs, PS, Sales Vision, Sales Force etc)
• Maintained Full and Incremental loads through Autosys on different environments like Development, Stage, Production and Test environment.
• Created deployment groups, migrated the code into different environments.
• Written ETL Specs and documentation to describe program development, logic, coding, testing, changes and corrections.
• Involved in managing the UNIX servers and defining the file systems/directory structures on the UNIX box for various parameters and deciding the disk space and memory requirements.
• Provided support to develop the entire warehouse architecture and plan the ETL process.
• Documented technical design documents and error logics.

Environment: Informatica PowerCenter 8.6.1, Informatica PowerExchange, Oracle 11g (TOAD and SQL Developer), PL/SQL, Teradata, Cognos & Tableau, UNIX, MS ACCESS, MS EXCEL 2007, Autosys SAP BW.