SUMMARY

• Around 8+ years of experience in development of various projects using Data Warehousing tools like Informatica and Databases like Oracle, SqlServer, Teradata and DB2 UDB.
• Over 8 years used Informatica Client Tools - Designer, Source Analyzer, Warehouse Designer, Transformation Developer, Mapplet Designer, Mapping Designer, Workflow Manager and Workflow Monitor.
• me have installed and upgraded multiple PowerCenter and administered them.
• Created many informatica folders and services that are required to facilitate teh development work.
• Creating ETL mappings using Informatica Power Center to move data from multiple sources such as XML, DB2, Teradata, MS SQL Server, flat files, and Oracle into a common target area such as data marts and data warehouse.
• Worked on resolving multiple issues due to performance on PowerCenter and handled multiple outages.
• Having experience in Big data .
• Applied hot fixes for teh existing versions to resolve issues internally.
• Worked wif Informatica Support team directly during issues related to teh PowerCenter itself and requested multiple fixes on teh software.
• Over 4+ years worked wif Teradata utilities like BTEQ, Fast Export, Fast Load, Multi Load to export and load data to/from different source systems including flat files.
• Expertise in building Enterprise Data Warehouses (EDW), Operational Data Store (ODS), Data Marts, and Decision Support Systems (DSS) using Data modeling tool ERWIN and Dimensional modeling techniques (Kimball and Inmon), Star and Snowflake schema addressing Slowly Changing Dimensions (SCDs).
• Creating complex mappings in PowerCenter Designer using Aggregate, Expression, Filter, Sequence Generator, Update Strategy, Union, Lookup, Joiner, XML Source Qualifier, and stored procedure transformations.
• Highly motivated and goal-oriented individual wif a strong background in SDLC Project Management and Resource Planning using AGILE methodologies.
• Exported teh data into from UNIX to Mainframe for backup.
• Extensive Knowledge on teh development life cycle process from requirements gathering to deployment of code to production and good knowledge on teh Dimensional modeling.
• Implementing performance tuning methods to optimize developed mappings.
• Extensive experience in Production support management involving Informatica, Oracle, UNIX and Mainframes.
• Have significant experience in reporting using MS Excel, Easytrieve and Business objects.
• Hands on Experience wif teh scheduling tools like Control M, Autosys scheduler.
• Good Understanding and Knowledge on teh Business Intelligence Tools like Cognos.
• Extensive knowledge in DPI programming.
• Experienced in Erwin data modeling, Star-Schema design, Logical data modeling, Normalization, Physical design, Data Analysis, Data Modeling, Reports and Report Design.
• Involved in all phases of data warehouse project life cycle. Designed and developed ETL Architecture to load data from various sources like Oracle, Flat files, Db2 UDB, XML files and MS SQL Server into Oracle, XML and SQL server targets.
• Experienced in leading and managing onsite/off shore team.
• Excellent Analytical, problem solving, communication and interpersonal skills.
• Experience in Health, Banking, and Manufacturing domains.

TECHNICAL SKILLS

Platform: IBM OS/390, Windows, UNIX.

Languages: PL/SQL, SQL, COBOL, UNIX Scripting, Excel VB Scripting, JCL, CICS, XML, WSDL, EasyTrieve.

Database: DB2 UDB, Oracle 10g, Teradata, SQL server, VSAM.

ETL tool: Informatica Powercenter 10.x, 9.x, 9.5.1/8.x/7.x/6.x.

Database Access Tools: TOAD, Teradata SQL Assistant, T-SQL, Quality Center.

Database Utilities: Oracle PL/SQL developer, FTP client, Business Objects Supervisor, MQ Series, BTEQ, fastload, Multiload, FastExport, TPump, SQLPlus, CA-7, Business Objects.

PROFESSIONAL EXPERIENCE

Confidential, VA

Sr. Informatica Developer/Admin

Responsibilities:

• Interacted wif business users, analysts to gather, understand, analyze, program and document teh requirements of Data Warehouse.
• Focused on new system and tools wif minimal supervision and trained Project Architecture to team members.
• Involved in generating and applying rules to profile data for flat files and relational data by creating rules in IDE and case cleanse, parse, standardize data through mappings in IDQ and generated as Mapplets in PC.
• Worked on identifying Mapping Bottlenecks and improved session performance through error handling.
• Worked on Mapplets and created parameter files wherever necessary to facilitate reusability.
• Used Error Handling to capture error data in tables for handling nulls, analysis and error remediation Process.
• Extensively used Informatica Functions LTRIM, RTRIM, DECODE, ISNULL, IIF, INSTR and date functions in Transformations.
• Effectively worked on Mapping Designer, Workflow Manager, and Workflow Monitor.
• Extensively used Sequence Generator in all mappings and fixed bugs / tickets raised in production for existing mappings in common folder for new files through versioning (Check in and Check out) on an urgency through support for QA in component unit testing and validation.
• Used shortcuts for sources, targets, transformations, Mapplets, and sessions to reuse objects wifout creating multiple objects in teh repository and inherit changes made to teh source automatically.
• Created Tidal jobs to schedule Informatica Workflows. Executed workflows using Tidal schedule.
• Involved in checking Data accuracy standards for NULLS, Comparison, key generator and labeler using reference table manager in PWH and rolled based on statistics through Threshold value and Score Cards applied teh Data cleansing process in Model Repository on same domain and merged to Power center.
• Used teh PL/SQL procedures for Informatica mappings for truncating teh data in target tables at run time.
• Performed teh data profiling and analysis making use of Informatica Data Explorer (IDE) and Informatica Data Quality (IDQ).
• Worked on writing and executing BTEQ scripts for checking teh data integrity between S&T. databases and to generate reports.
• Used BTEQ scripts to load data from files such as .csv, .txt and .dat to teh database tables and also merging teh data which is already existing.
• Developed teh Teradata Macros, Stored Procedures to load data into Incremental/Staging tables and move teh data from landing to Base tables.
• Uploaded data from operational source system (Oracle 8i) to Teradata.
• Used utilities of FLOAD, MLOAD, FEXP of Teradata and created batch jobs using BTEQ.
• Imported Metadata from Teradata tables.
• Extensively worked on performance tuning and in isolating header and footer in single file.
• me have installed and upgraded multiple PowerCenter and administered them.
• Created many informatica folders and services that are required to facilitate teh development work.
• Applied hot fixes for teh existing versions to resolve issues internally.
• Worked wif Informatica Support team directly during issues related to teh PowerCenter itself and requested multiple fixes on teh software.
• Prepared teh Standard Operating Procedure (Knowledge Transfer) document, which provides necessary information, required for teh Maintenance and Operation of teh application.
• Performed code migration of mappings and workflows from Development to Test and Production Servers through deployment groups for DEV, TEST and PROD repositories in retaining shortcuts, dependencies wif versioning.
• Worked wif UNIX commands and used UNIX shell scripting to automate jobs. Wrote UNIX scripts to back up teh log files in QA and production.
• Effectively understood session error logs and used debugger to test mapping and fixed bugs in DEV in following change procedures and validation.
• Used pmcmd command to run workflows though shell scripts.
• Tuned and optimized mappings to reduce ETL run time and ensuring they ran wifin designated load window.

Environment: Informatica Power Center 9.5.1, 9.6.1, 10.1, 10.2, Oracle 11g, Oracle SQL* LOADER, Flat Files, UNIX Shell Scripting, TOAD, Crontab, SQL, VSS, IDE, IDQ, Putty, WinSCP.

Confidential

Informatica developer

Responsibilities:

• Gatheird teh required information from teh users.
• Interacted wif different system groups for analysis of systems.
• Working wif business units to identify mapping specifications.
• Created teh ETL test plans and implemented teh Code Review, Formal Testing, and Specification Testing using teh Test Director.
• Implementing teh standardized process to archive flat files and for loading indicator files.
• Also used teh Informatica Data Exchange to connect to teh Main frames source and extract teh data.
• Utilizing teh MS Access database for teh conversions that are (one time data conversions) for translations that are in Excel or CSV format.
• Created proper PI taking into consideration of both planned access of data and even distribution of data across all teh available AMPS.
• Implemented slowly changing dimensions methodology to keep track of historical data.
• Expertise in performance tuning teh user queries, execution of frequently used SQL operations and improves teh performance.
• Interacted wif people from various teams in teh Project like Oracle/Teradata DBA’s, Maestro Schedulers, Spec. Creators, Reporting and UNIX etc. to aid in teh smooth functioning of teh Project flow.
• Developed data marts using Cognos Powerplay and Transformer OLAP tools.
• Exported teh data into from UNIX to Mainframe for backup.
• Knowledge transfer to teh PS team.
• Developed teh triggers to handle history and audit data for production environment.
• Created users, roles, profiles and Objects and system rights.
• Performance changes to allow fast handling of transaction processing related request (plan caching).
• Created Understanding documentation and Release Testing documentation on teh tickets handled, and documented teh issues found in a central repository.
• Involved in Performance testing of all teh workflows/Mapping, which halped in analyzing its performance before moving into production.
• Extracted, Transformed and Loaded OLTP data into teh Staging area and Data Warehouse using Informatica mapping and complex transformations (Aggregator, Joiner, Lookup, Normalizer, Filter).
• Involved in teh code reviews prepared by teh teams.
• Analyzing production support documents and finding teh feasible time to run their jobs.

Environment: Informatica 6.2, SQL Tools, Teradata, BTEQ PL/SQL, Big data Business Objects, UNIX, Windows XP.