SUMMARY

• Over 5+ years of experience in Information Technology with emphasis on Data Warehouse/Data Mart development using developing strategies for extraction, transformation, and loading (ETL) in Informatica Power Center from various database sources.
• Experienced with full life cycle of Software Development (Planning, Analysis Design, Deployment, Testing, Integration and Support).
• Extensive involvement in composing UNIX shell scripts and computerization of the ETL forms utilizing UNIX shell scripting.
• Strong work experience in Data Warehouse life cycle development, performed ETL procedure to load data from different sources like SQL Server, Oracle, Mainframe, Teradata and flat files into data marts and data warehouse using Informatic Power Center - Designer, Workflow Manager, and Workflow Monitor.
• Excellent in designing ETL procedures and strategies to extract data from different heterogeneous source systems like Oracle, SQL Server, DB2 10, Flat files, XML, SAP R/3 etc.
• Created mappings in mapping Designer to load data from various sources using transformations like Transaction Control, Lookup (Connected and Un-connected), Router, Filter, Expression, Aggregator, Joiner and Update Strategy, SQL, Stored Procedure and more.
• Have experience with IDQ, MDM with knowledge on Big Data Edition Integration with Hadoop and HDFS.
• Experience in Managing and perform data cleansing, de-duplication and harmonization of data received from On-Prem and Cloud sources.
• Developing Oracle PL/SQL stored procedures, Functions, Packages, SQL scripts to facilitate the functionality for various modules.
• Extensive knowledge of various Performance Tuning Techniques on Sources, Targets, Mappings and Workflows using Partitions/Parallelization and eliminating Cache Intensive Transformations.
• Strong RDBMS concepts and experience in creating, maintaining and tuning Views, Stored Procedures User Defined Functions and System Functions using SQL Server, T-SQL.
• Involved in the Analysis, Design, Development, Testing and Implementation of business application systems for Health care, Pharmaceutical, Financial, Telecom and Manufacturing Sectors.
• Hands on experience working in LINUX, UNIX and Windows environments.
• Good knowledge on data quality measurement using IDQ and IDE
• Strong experience in Dimensional Modeling using Star and Snowflake Schema, Identifying Facts and Dimensions, Physical and logical data modeling using Erwin and ER-Studio.
• Proficient with Informatica Data Quality (IDQ) for cleanup and massaging at staging area.
• Designed and Developed IDQ mappings for address validation / cleansing, doctor master data matching, data conversion, exception handling, and report exception data.
• Hands-on experience across all stages of Software Development Life Cycle (SDLC) including business requirement analysis, data mapping, build, unit testing, systems integration and user acceptance testing.
• Experience in handling initial/full and incremental loads.
• Expertise in scheduling workflows Windows scheduler, Unix and scheduling tools like CRTL-M &Autosys
• Designed, Installed, Configured core Informatica/Siperian Hub components such as Informatica Hub Console, Hub Store, Hub Server, Cleanse Match Server, Cleanse Adapter, IDD & Data Modeling.
• Experience in support and knowledge transfer to the production team.
• Worked with Business Managers, Analysts, Development, and end users to correlate Business Logic and Specifications for ETL Development.
• Experienced in Quality Assurance, Manual and Automated Testing Procedures with active involvement in Database/ Session/ Mapping Level Performance Tuning and Debugging.
• Excellent communication, presentation, project management skills, a very good team player and self-starter with ability to work independently and as part of a team.

TECHNICAL SKILLS

ETL Tools: Informatica PowerCenter 10.x/9.x/8.x, Informatica DataQuality, Power Exchange

RDBMS: Oracle11g/10g/9i, SQL Server 2000/2005/2008 , Teradata

Operating System: Windows NT/2000/XP/7

Job Scheduling Tools: AutoSys, Control M,Zena, Cron Tab

Languages: SQL, PL/SQL, Unix Shell Scripting

Database frontend tools: Oracle PLSQL Developer, Oracle TOAD.

PROFESSIONAL EXPERIENCE

Confidential, Charlotte, NC

ETL Informatica Developer

Responsibilities:

• Requirements gathering, analyse, design, code, test highly efficient and highly scalableintegration solutions usingInformatica, Oracle, SQL, Source systems viz.
• Involved in the technical analysis ofdata profiling, mappings, formats, data types, and developmentof data movement programs usingPower ExchangeandInformatica.
• DevelopedETLmappingdocumentwhich includes implementing the data model, implementing the incremental/full load logic and theETLmethodology.
• Involved in writingTeradataSQLbulk programs and in Performance tuning activities forTeradata SQLstatements usingTeradataEXPLAINand usingTeradata Explain, PMONto analyze and improve query performance.
• Developed variousETLprocess for complete end to endData Integration anddoneData IntegrationbetweenDB2andOracleusingETLProcess
• Design, development ofmappings, transformations,sessions, workflows andETLbatch jobsto load data into Source/s to Stage usingInformatica, T/SQL,UNIXShell scripts, Control - M scheduling.
• Developed various mappings for extracting the data from different source systems usingInformatica,PL/SQLstored procedures.
• Developed mappings for extracting data from different types of source systems (flat files, XML files, relational files, etc.)into our data warehouse usingPower Center.
• UsedInformaticapower center10.1.0to Extract, Transform and Loaddata intoNetezzaData Warehouse from various sources likeOracle and flat filesandresponsible for creatingshell scriptsto invoke theinformaticaworkflows through command line.
• DevelopedUNIX Shell scriptsfor data extraction, running thepre/post processes andPL/SQLprocedures.
• UsedTeradata SQL Assistant, Teradata Administrator and PMONand data load/export utilities likeBTEQ,Fast Load, Multi Load, Fast Export, Tpump, and TPT on UNIX/Windowsenvironments and running thebatch processforTeradata.
• Developed standard mappings using various transformations likeexpression, aggregator, joiner, source qualifier, router, lookup, and filter.
• Involved in business analysis and technical design sessions with business and technical staff todevelopEntityRelationship/data models, requirements document, andETLspecificationsand Dig deep into complexT-SQLQuery and Stored Procedure to identify items that could be converted toInformaticaCloud ISD.
• Involved in gathering and documenting business requirements from end clients and translating them into report specifications for theTableauplatform.
• CreatedInformaticamappings withPL/SQLstored procedures/functions to in corporate critical business functionality to load data.

Environment: Informatica Power Centre 10.2.0, Power exchange, Oracle 12c, Netezza, UNIX, Netezza Aginity, Teradata, SQL & PLSQL, SQL Server, Korn Shell Scripting, XML, T-SQL, TOAD, UNIX, Win, LINUX, Excel,, tableau, Flat Files, Tivoli.

Confidential, Los Angeles, CA

Informatica ETL Developer

Responsibilities:

• Perform requirement analysis through coordination with business analysts and define business and functional specifications.
• As a team conducted gap analysis and Discussions with subject matter experts to gather requirements, emphasize on problem areas and define deliverables.
• Logical and Physical data modeling was done using Erwin for data warehouse database in STAR SCHEMA.
• Using Informatica Power Center Designer analyzed the source data to Extract & Transform from various source systems (oracle 10g, DB2, SQL server and flat files) by incorporating business rules using different objects and functions that the tool supports.
• Using Informatica Power Center created mappings and Mapplets to transform the data according to the business rules.
• Designed the ETL mappings between sources to operational staging targets, then to the data warehouse using Power center Designer.
• Involved in Design, analysis, Implementation, Testing and support of ETL processes for Stage, ODS and Mart.
• Documented Informatica mappings in Excel spread sheet.
• Developed mappings/Reusable Objects/Transformation/Mapplets by using mapping designer, transformation developer and Mapplets designer in Informatica Power Center.
• Worked with Informatica power center Designer, Workflow Manager, Workflow Monitor and Repository Manager.
• Used Informatica Power Center to migrate the data from different source systems.
• Extensively used Autosys for Scheduling and monitoring.
• Responsible for developing, support and maintenance for the ETL (Extract, Transform and Load) processes using Informatica Power Center 9.1 by using various transformations like Expression, Source Qualifier, Filter, Router, Sorter, Aggregator, Update Strategy, Connected and unconnected look up etc.
• Extensively used various Performance tuning Techniques to improve the session performance.
• Developed and maintained ETL (Extract, Transformation and Loading) mappings to extract the data from multiple source systems like Oracle, SQL server and Flat files and loaded into Oracle.
• Created business rules in Informatica Developer and imported them to Informatica Power center to load the standardized and good format of data to staging tables.
• Involved in creating new table structures and modifying existing tables and fit into the existing Data Model.
• Worked with offshore team to Develop and deliver the ETL tasks.
• Monitored workflows and session using Power Center workflows monitor
• Used Informatica Scheduler for scheduling the workflows
• Developed the ETL jobs to automate the Data validation process across the systems (Web trends and In house) using Informatica and notifying the variances to stakeholders.
• Created workflows and worklets for designed mappings.
• Provide documentation of ETL design and technical specifications, high level and low level design specifications.

Environment: Informatica PowerCenter 9.6.1/9.x Informatica Power Exchange 9.1, Oracle 11g, SQL, PL/SQL, DB2 8.0, MS SQL Server 2008, T-SQL, Flat Files, Teradata 14, Windows XP, UNIX, SAP BODS, PL/SQL.

Confidential, Mayfield Heights, OH

ETL/Informatica Developer

Responsibilities:

• Interacted with Business Analysts to understand the business requirements.
• Involved in Understanding the logical and physical data models with Modellers & Data Architects.
• Involved in staging the data from external sources and was responsible for moving the data into the Warehouse using ETL Informatica.
• Involved in building the ETL architecture using Informatica 9.1.1/ 8.6.1 and Source to Target mapping to load data into Data warehouse.
• Used Informatica as an ETL tool to create source/target definitions, mappings and sessions to extract, transform and load data into staging tables from various sources.
• Responsible for mapping and transforming existing feeds into the new data structures and standards utilizing Router, Lookups (Connected, Unconnected), Expression, Aggregator, Update strategy & stored procedure transformation.
• Used SCD Type 2 to populate the data in a generic way. Single mapping is used to load multiple tables.
• The scope of this design includes a generic design for implementing tables whose content will be managed in part by end-users of the Data Warehouse. The content changes can be made via the standard production change request process.
• Created mappings using flat files and relational databases as sources to build update Mappings.
• Created reusable transformations and mapplets and used them in mappings.
• Written SQL override queries in source analyzer to customize mappings.
• Debug mappings to gain troubleshooting information about data and error conditions using Informatica Debugger.
• As the requirement is to maintain the history of every change for all columns, have implemented the slowly changing dimension type 2 with effective start and end date of the record.
• Providing periodic updates to customers on the coding, unit testing, release and act as Coordinator between development and business team.
• Handled UNIX system tasks by generating Pre and Post-Session UNIX Shell Scripts.
• Analyzed source data and formulated the transformations to achieve the customer requested reports.
• Performed Unit testing and moved the data into QA.
• Handled UNIX system tasks by generating Pre and Post-Session UNIX Shell Scripts.
• Analyzed source data and formulated the transformations to achieve the customer requested reports.
• Performed Unit testing and moved the data into QA.
• Participated in scheduling workflows, error checking, production support, maintenance as well as in testing of ETL procedures using Informatica session logs.
• Involved in Performance tuning on sources, targets mappings and SQL (Optimization) tuning.
• Documentation of the project activity all along the course of the project along with Failure Recovery plans.

Environment: Informatica Power Center 9.5.1/9.1.1/8.6.1 , MS SQL server 2005/2008, My Sql, Oracle 11g, PL/SQL, TOAD, Flat Files, Windows, Unix.