SUMMARY

• A data ware house Sr Informatica developer with more than 7 years of professional experience in Information Technology with extensive experience in the field of Enterprise Data Warehousing (EDW).
• Over 7+ years of IT experience with a strong background in SDLC, Data Integration tools including Informatica PowerCenter.
• Expertise in Informatica Power Center 9.x/8.x/7.x extracting data from Oracle, SQL Server, Sybase and DB2 databases.
• Developed and maintained complex Informatica mapping. Worked on almost all kind of Informatica mapping and transformation.
• Extensive experience in Extraction, Transformation and Loading of data using Informatica from heterogeneous sources.
• Used Informatica Power Center to create mappings, sessions and work flows for populating the data into dimension, fact, and lookup tables simultaneously from different source systems ( Oracle, Flat files).
• Excellent knowledge and experience in configuring connections to various sources and creating source to target mapping (CDC techniques like SCD mappings), edit rules and validation, transformations, and business rules in Informatica Power Center.
• Deployed reusable transformation objects such as mapplets to avoid duplication of metadata, reducing the development time.
• Experience with Informatica Advanced Techniques - Dynamic Caching, Memory Management, Parallel Processing to increase Performance throughput.
• Excellent knowledge of end to end performance tuning. Extensively involved in Optimization and Tuning of mappings and sessions in Informatica by identifying and eliminating bottlenecks, memory management and parallel threading.
• Experience in creating and using Stored Procedures, Functions, Triggers,Indexes, materialized views, Views, Synonyms, and Packages.
• Used SQL Loader to load the data from Flat files to Oracle databases.
• Strong experience in SQL performance tuning, Generation and interpretation of explain plans and tuning SQL.
• Experience in scheduling of ETL jobs using Crontab, Autosys and Control-M.
• Skilled in Unix Shell Scripting and experience on different UNIX platforms.
• Hands-on experience with Power Center command-line utilities (PMCMD)
• Excellent knowledge of the design and implementation of the Data Warehouse life cycle.
• Monitoring the loads (workflows) whether the loads are scheduled to respective timings. Recovery or Re-start in loads in case of any failures.
• Familiarity with entity-relationship/multidimensional modeling (star schema, snowflake schema).
• Knowledge of Data Warehouse/Data Mart design concepts.
• Experience with business requirements gathering, business analysis and documentation.
• Good experience in Financial and Telecoms domain.
• Ability to design and develop ETL solutions to fit business needs.
• Excellent knowledge in data warehousing / dimensional modeling.
• Develops Extraction, Transformation and Loading (ETL) processes to acquire and load data from internal and external sources.
• Strong ability to analyze source systems and business requirements, identify and document business rules, design data architecture for cohesive decision support and prepare dimensional data models.
• Experience in troubleshooting and handling production support duties on a 24x7 basis.
• Interacting with business user to gather the requirement and based on that estimate the project.
• Good Communication, analytical, interpersonal skills and ability to learn new concepts.

TECHNICAL SKILLS

Languages: SQL, PL/SQL, C, C++

Databases: Oracle 9i, 10g, 11g, DB2 v9.7, MS Sql server,DB2,Teradata, Sybase

Scripting: UNIX Shell script (Korn, Bourne, Bash)

ETL Tools: Informatica Power Center/PowerMart 9.x/8.x/7.x

Reporting Tools: Cognos 8.x/10.x

DB utilities: Export/import, expdp/impdp, SQL*Loader, Sqlplus, TOAD, SQL*PLUS, iSQL*Plus, SQL Developer, AQT

Scheduling Tools: Autosys R4, Control M, Unix Cron

Methodologies: ER/Multidimensional Modeling (Star Snowflake), Data Warehouse Lifecycle

Environment: (0S)/Protocol SUN Solaris 5.8, 5.9, IBM AIX 4.3, 5.3, 6.1, RH Linux 4.3,5.x, Windows 2000/2003/XP/NT, SAN, TCP/IP, IPV4, IPV6, FTP, SSH, DNS

PROFESSIONAL EXPERIENCE

Confidential, Wood cliff Lake NJ

Sr. Informatica developer

Responsibilities:

• Responsible for Business Analysis and Requirements Collection, Design Development, unit testing of Informatica solutions.
• Created mappings using various Transformations like Source Qualifier, Aggregator, Expression, Filter, Router, Joiner, Stored Procedure, Lookup, Update Strategy, Sequence Generator and Normalizer.
• Developed various Mappings with the collection of all Sources, Targets from legacy data sources and Transformations. Worked with almost all the Informatica transformations.
• Experience in Business Intelligence.
• Develop, test and maintain ETL procedures employing both ETL tools and custom PL/SQL.
• Used SQL Loader to load the data from Flat files to Oracle databases.
• Created sessions, configured work flows to extract data from various sources, transformed data, and loading into data warehouse.
• Deployed reusable transformation objects such as mapplets to avoid duplication of metadata, reducing the development time.
• Developed mappings to load into staging tables and then to Dimensions and Facts.
• Maintained stored definitions, transformation rules and targets definitions using Informatica repository Manager.
• Parsed high-level design specification to simple ETL coding and mapping standards.
• Involved in Performance tuning Confidential source, target, mappings, sessions, and system levels.
• Scheduling, automating and monitoring the loads (work flows) whether the loads are scheduled to respective timings. Recovery or Re-start in loads in case of any failures.
• Performing pre-load activities like dropping indexes and post load activities like creating indexes, refreshing materialized views and collecting statistic.
• Experience in creating and using Stored Procedures, Functions, Triggers,Indexes, materialized views, Views, Synonyms, and Packages.
• Strong experience in SQL performance tuning. Involved in Performance/Query tuning. Generation/interpretation of explain plans and tuning SQL to improve performance.
• Worked with DBA for partitioning and creating indexes on tables used in source qualifier queries.
• Used Debugger to test the mappings and fixed the bugs.
• Familiar with Stored Procedures and implementing them in the ETL jobs of Informatica.
• Wrote UNIX shell Scripts & PMCMD commands for FTP of files from remote server and backup of repository and folder.
• Assigned project responsibilities under limited supervision and aggressive deadlines.
• Performance tuning for Informatica mappings and sessions.
• Conducted code reviews for peers to verify program logic and identify design flaws.
• Performed production support duties on a 24/7 basis.
• Provided support to Quality Assurance team with troubleshooting of issues.
• Interact with client on a daily basis and Detailed Requirements Study.
• A Highly motivated and energetic Professional, dedicated to understanding and meeting the client needs. Knowledgeable in project management tools, processes and techniques.

Environment: Windows XP, Sun Solaris 5.10, RH Linux 4.3,5.x, Informatica Power Center 9.0.1, Oracle 10g/11g, Toad 8.0, Unix Shell scripting

Confidential, Middletown NJ

Sr Informatica developer/On site Coordinator

Responsibilities:

• Involved in gathering business requirements and attended technical review meetings to understand the data warehouse model.
• Gather requirements, Analyze, Design, Code, Test highly efficient and highly scalable integration solutions using Informatica, Oracle, SQL, Source systems viz. Oracle10g, Main frame (DB2) systems, MS SQL server databases, flat files, Unix Shell Scripting. Responsible for Functional design, technical design, coding, testing, debugging, and documentation.
• Involved in creation of mappings, sessions, command task and work flows.
• Extensively used ETL to load data from Flat files, DB2, Sybase and Oracle into Oracle.
• Developed various Mappings with the collection of all Sources, Targets from legacy data sources and Transformations.
• Worked with almost all the Informatica transformations.
• Created mappings using different transformations like Aggregator, Expression, Stored Procedure, Filter, Joiner, Lookup, Router and Update Strategy
• Develop, test and maintain ETL procedures employing both ETL tools and custom PL/SQL
• Created sessions, configured work flows to extract data from various sources, transformed data, and loading into data warehouse.
• Deployed reusable transformation objects such as mapplets to avoid duplication of metadata, reducing the development time.
• Developed mappings to load into staging tables and then to Dimensions and Facts.
• Maintained stored definitions, transformation rules and targets definitions using Informatica repository Manager.
• Involved in Performance tuning Confidential source, target, mappings, sessions, and system levels.
• Performing pre-load activities like dropping indexes and post load activities like creating indexes, refreshing materialized views and collecting statistic.
• Experience in creating and using Stored Procedures, Functions, Triggers,Indexes, materialized views, Views, Synonyms, and Packages.
• Strong experience in SQL performance tuning. Involved in Performance/Query tuning. Generation/interpretation of explain plans and tuning SQL to improve performance.
• Worked with DBA for partitioning and creating indexes on tables used in source qualifier queries.
• Used Debugger to test the mappings and fix the bugs.
• Familiar with Stored Procedures and implementing them in the ETL jobs of Informatica.
• Scheduling and automate the process of Work flows.
• Coordinated offshore and on site team ETL Team.
• Assigned project responsibilities under limited supervision and aggressive deadlines.
• Conducted code reviews for peers to verify program logic and identify design flaws.
• Performed production support duties on a 24/7 basis.
• Provided support to Quality Assurance team with troubleshooting of issues.
• Developed shell scripts for job automation, which will generate the log file for every job
• Developed UNIX shell scripts ftp files from source server, connect to database and perform pre data load activities and invoke work flow using pmcmd to do data load, connect to data to perform post data load operations.
• Interact with client on a daily basis and Detailed Requirements Study.

Environment: Windows XP, Sun Solaris 5.9/5.10, RH Linux 4.3,5.x, Informatica Power Center 9.0.1, 8.6., Oracle 10/11g, DB2, TOAD, Unix Shell scripting

Confidential

Sr Informatica developer

Responsibilities:

• Prepared program specifications and diagrams, developing logical flowcharts for coding.
• Developed Complex Cognos reports by using Conditional formatting and Conditional blocking.
• Translated business specifications and designs into maps using various transformations, packages, procedures or automated batch scripts
• Created Informatica maps using various transformations like Source Qualifier, Expression, Look up, Stored procedure, Aggregate, Update Strategy, Joiner, Filter and Router.
• Worked with almost all the Informatica transformations.
• Tested the ETL mapping codes and validated data. Created daily and weekly ETL batches and scheduled them through Control-M schedule according to the client requirement.
• Familiar with Stored Procedures and implementing them in the ETL jobs of Informatica.
• Scheduling and automate the process of Workflows.
• Extracted large volumes of data form Mainframes systems to target Oracle database.
• Extensively worked on Performance tuning of queries. Complex SQL queries are used for data retrieval.
• Performing pre-load activities like dropping indexes and post load activities like creating indexes, refreshing materialized views and collecting statistic.
• Experience in creating and using Stored Procedures, Functions, Triggers,Indexes, materialized views, Views, Synonyms, and Packages.
• Strong experience in SQL performance tuning. Involved in Performance/Query tuning. Generation/interpretation of explain plans and tuning SQL to improve performance.
• Conducted code reviews for peers to verify program logic and identify design flaws.
• Troubleshoot the reasons for load failures, analyze, identify the missing data and their dependencies.
• Develop, document, manage, and coordinate all user test plans, user validation/acceptance testing
• Performed production support duties on a 24/7 basis.
• Provided support to Quality Assurance team with troubleshooting of issues.

Environment: Windows XP, Sun Solaris 5.9/5.10, RH Linux 4.3,5.x, Informatica Power Center 9.0.1, 8.6., Oracle 10/11g, DB2, TOAD, Unix Shell scripting

Confidential

Informatica developer

Responsibilities:

• Involved in creation of mappings, sessions, command task and workflows in Informatica.
• Created Informatica maps using various transformations like Web services consumer, XML, HTTP transformation, Source Qualifier, Expression, Look up, Stored procedure, Aggregate, Update Strategy, Joiner, Filter and Router.
• Expertise in development and designing of ETL methodology for supporting data transformations using Informatica Power Center.
• Designed and developed utility for Power Center folder-level migration and rollback.
• Used most of the transformations such as the Connected & Unconnected lookups, Filters, Routers, Joiners, Stored Procedure transformations & Sequence Generators.
• Developed ETL sessions for initial full loading and incremental loading.
• Unit and Integration testing of Informatica mappings.
• Scheduling the Informatica workflows using Control-M scheduling tool & trouble shooting the Informatica workflows.
• Used SQL * Loader to load the data from Flat files to Oracle.
• Strong skills in Data Analysis, Data Requirement Analysis and Data Mapping for ETL processes.
• Scripting in ksh with extensive use of awk, sed and grep to improve efficiency.
• Configured test sessions to get performance details to identify and eliminate source/target bottlenecks.
• Performance tuning for Informatica mappings and sessions.

Environment: Windows XP, Sun Solaris 5.8, Informatica Power Center 7, Oracle 10g/9i, SQL*Plus