PROFESSIONAL SUMMARY:

• Certified informatica9x:informatica Data integration Developer Specialist
• Certified in oracle Developer (OCA)
• Having 11 years of IT experience in Analysis, Design, Development and Implementation, support of various EAI (Enterprise Application Integration), EDW (Enterprise Data warehouse) projects where BI tools like cognos,BOETL informatica tools are used extensively.
• Extensive experience in BI Data Warehousing projects in Collecting Client requirements, Data modeling and Development and architect experience in ETL tool informatica7.x,8x,9.x power center and power exchange, BOXI, Cognos, oracle and netezza.
• Proficient in understanding business processes, requirements and translating them into technical requirements and test strategies. Extensive experience working with business users, SMEs, App DBAs, Bi developers, Prod support team as well as senior management.
• Have experience in relational and dimensional data modeling for creating Logical and Physical Design of Database and ER Diagrams. Worked in security implementation based on roles.
• Strong in Data warehousing concepts Fact table, dimension table, star and snowflakes schema methodologies.
• Have experience with scheduling tool like Control - M and Autosys for creating, scheduling and ordering jobs.
• Experienced in writing oracle Sql queries and Pl/Sql procedures, functions packages, Materialized Views and performance tuning.
• Worked for a while on BOXI webi, crystal reports and universe (Dimensional modeling) to present data to end users.
• Good Knowledge on UNIX Shell Scripting and scheduling using crontab & Control-M
• Experience in IBM info sphere Change data capture(CDC) tool and Power exchange CDC, mapping tables from different sources like DB2,SQL server to oracle ODS of large volumes greater than 50 TB.
• Experience in SQL analysis services (SSAS) cubes. Prepared DB naming standard documents for tables, columns, indexes, views, access information, data mapping sheets with cardinalities and coordination with DBAs to get DB changes done and had created physical model.
• Had performed informatica admin activities like installation, configuration of repository, integration services, back up of repositories, creating folders, migration of code and granting role access to users/groups to appropriate data maps by using admin console and repository manager.
• Had experience of production support procedures and change management process.
• Diverse background with fast Learning and creative Analytical abilities with good Technical, Problem Solving, Communication and Interpersonal skills.
• Have both Onsite(USA,Sweden) and offshore(India) experience
• Trained in cognos10 from IBM official instructor as part of project cross training program

TECHNICAL SKILLS:

ETL Tools: Informatica Power Center 9.5.1 Big Data edition(BDE), 8.x, 7.x (Designer, Workflow Manager, Workflow Monitor, Repository Manager, Administration Console), Power Exchange, Syncsort DMExpress

RDBMS: Oracle11g / 10g / 9i, SQL Server 2000/2005, DB2, Green plum, Teradata

Operating System: UNIX, Windows NT/2000/XP/7

Job Scheduling Tools: Control: M

Languages: SQL, PL/SQL, Unix, Perl scripting

Tools: IBM CDC, MS Office, TOAD, Winscp, Putty, Squirrel, File zilla, BMC

Products: IBM CDC(Change Data capture), Power Exchange CDC,SVN Subversion, IBM Cognos, SAP BOXI

PROFESSIONAL EXPERIENCE:

Confidential, Chicago, IL

Sr. ETL Developer

Responsibilities:

• worked on claims connect and Canada to Confidential projects which are implemented in agile methodology.
• Gathering requirements through scheduled meetings and scrum meetings
• Preparation of Architecture road maps. HLD, Detailed Design docs
• Worked on informatica big data edition source as IBM DB2
• Contributed to POC on Big data, Hive.
• Used in different Data sources like sales force,db2 and netezza in Zurich
• Working on Development along with offshore team.
• Worked with power exchange navigator CDC on DB2 z/os files using asynchronous change data capture using Batch process
• By using power exchange navigator defined and managing data maps, capture registration
• And extraction maps for CDC and loading data into target in conjunction with power center
• Preparation unit test cases, Unit testing, integration testing and UAT testing after code development.
• Raising prod change requests
• As per company standards, making sure of meta data entries in DB2 for new mappings/work flows/parameter files.
• Fine tuning PDO queries keep track of CI list for migrations and all related development and process related activities .

Environment: Informatica 9.5.1, Netezza, DB2, Aginity,AQT 7.0,autosys

Confidential, Washington, DC

ETL Sr Developer

Responsibilities:

• Identifying data discrepancies, errors, delays and analysing root causes and fixing, developing informatica and DMExpress routines
• Analysis of the specifications provided by the clients.
• Preparation of HLD, project plan based on the business functional spec.
• Review of ETL Detailed design documents for Mapping and DDL specification.
• By using power exchange navigator defined and managing data maps,capture registration
• And extraction maps for CDC and loading data into target in conjunction with power center
• Worked with VSAM files using power exchange for Synchronous Real time CDC
• Loading flat files into Teradata tables using fast load and familiar with other utilities like mload, tpump, fast export.
• Extracting data from DB2,loading Flat Files using Power center designer transforming the data as per business logic and loading the data to the target Data marts like State, Annual person, Clinical service and InPatient.
• Dealing with the shell, Perl scripts associated with ETL jobs and production support.
• Fixing Data issues after raising change request in prod, writing complex sql .
• Preparation unit test cases, Unit testing, integration testing and UAT testing after code development.
• Raising prod change requests
• Making sure the all the mentioned data marts data is available for cognos reporting and dash board.

Environment: Informatica 9.5.1,Dmexpress5.4, Oracle11g,DB2,Teradata,Squirell,cognos10

Confidential, Chicago, IL

Sr.ETL Developer

Responsibilities:

• Team Developer and interacting with Business Analyst to understand the business requirements. Involved in analysing requirements to refine transformations
• Enterprise Application Integration (EAI) is an integration framework composed of a collection of technologies and services which form amiddlewareto enable integration of systems and applications across the enterprise. EAI group is responsible for exchange of data among internal departments
• Worked with VSAM files using power exchange for Synchronous Real time CDC using Batch processing.
• Informatica acts as EAI Hub that performs the business logic to transform the data into a common business language. Transformation applies in layers from incoming specific, to shared, to outgoing specific
• Analysis of the specifications provided by the clients.
• Preparation of HLD, project plan based on the business functional spec.
• Review of ETL Detailed design documents for Mapping and DDL specification document for creation of tables, defining keys/constraints on tables and data types.
• Extracting data from sources like Oracle and Flat Files using Power center designer transforming them using the business logic and loading the data to the target Data mart.
• Designing mappings as per the business requirements using Transformations such as Source Qualifier, Aggregator, Expression, Lookup, Filter, Sequence generator, Router, Union, Update strategy etc.
• Fine tuning mappings, partitioning sessions, Push down optimization to improve performance
• Preparation unit test cases, Unit testing, integration testing and UAT testing after code development.
• Raising prod change requests
• Coordinating with business and development teams for closure of UAT defects and enhancing BO universe for end user reporting.
• Refreshing Materialized views

Environment: Informatica9.5.1, SAP BOXIR3, Oracle11g,SQL server 2008,SSIS,BMC remedy,EURC,control-m8

Confidential, Chicago, IL

Sr ETL Developer

Responsibilities:

• Team Lead and interacting with Business Analyst to understand the business requirements. Involved in analysing requirements to refine transformations.
• Analysis of the specifications provided by the clients.
• Preparation of HLD, project plan based on the business functional spec.
• Review of ETL Detailed design documents for Mapping and DDL specification document for creation of tables, defining keys/constraints on tables and data types.
• Analysis of Data model to check table constraints and columns in Data mart
• Extracting data from sources like Oracle, Mainframe Db2 and Flat Files using Power center designer and power exchange and transforming them using the business logic and loading the data to the target warehouse.
• Designing mappings as per the business requirements Using Transformations such as Source Qualifier, Aggregator, Expression, Lookup, Filter, Sequence generator, Router, Union, Update strategy etc.
• Coordination of system/Integration/UAT testing with other teams involved in project and review of test strategy
• Used complex data transformations with more than 50 transformations for each mapping.
• Fine tuning mappings, partitioning sessions, Push down optimization to improve performance
• Coordinating with business and development teams for closure of UAT defects and creating adhoc reports for end users.
• Involved in Universes design& development discussing joins, cardinality between tables, creation of conditions with prompts, derived tables, applying contexts and alias tables to resolve cyclic dependencies like Loops, Fan Traps and Chasm Traps
• Analyze and validate reported data on ad-hoc basis.
• Monitoring and adding tables in CDC for RCT and TAP ODS systems using Data mirroring and refresh methods.
• Helping the team in fixing the technical issues if any and Tuning of Database queries for better performance.
• Developed OLAP cubes usingSSAS
• Keep tracking of all CI list, maintaining versions and Change requests.

Environment: Informatica 8.6,Oracle 10g,SQL server 2008,IBM CDC,SAP BOXIR3,BMC remedy, control-m

Confidential, Cupertino, CA

ETL Developer

Responsibilities:

• Tech Lead and interacting with Business Analyst to understand the business requirements. Involved in analysing requirements to refine transformations.
• Designing and developing exception handling and Preparation of technical specification documentation
• Designed various mappings for extracting data from various sources involving flat files and relational tables.
• Using designer to create source definitions, design targets, create mappings and develop transformations.
• Involved in Data profiling and data quality team work.
• Used Fast load scripts to load data into Teradata tables and familiar with other utilities like Tpump, mload, fast export.
• Created different transformations for loading the data into Teradata database using transformations like. Source Qualifier, Joiner transformations, Update Strategy, Lookup transformations, Filter, Rank transformations, Expression, Aggregator, and Sequence Generator.
• Responsible for monitoring all the sessions that are scheduled for run, investigation of failed session and debugging the corresponding mappings
• Created sessions using Informatica power centre workflow manager.
• Involved in Unit Testing, SIT testing, UAT testing and prepared Test Cases
• Worked on SQL performance tuning to fix slow running BO reports

Environment: Informatica 8.6, TeradataV2R5

Confidential

Data Analyst & Developer

Responsibilities:

• Developed various mappings for extracting data from various sources involving flat files and relational tables.
• Using designer to create source definitions, design targets, create mappings, sessions and developing transformations.
• Created different transformations for loading the data into stage and main schemas of oracle database using Source Qualifier, Joiner transformations, Update Strategy, Lookup transformations, Filter, Rank transformations, Expression, Aggregator, and Sequence Generator.
• Responsible for monitoring all the sessions that are scheduled and re running the failed sessions after debug the Mapping.
• Used Mapplets, Parameters and Variables to0 implement Object Orientation techniques and facilitate the reusability of code.
• Preparation of Unit Test Case and unit testing
• Keep track of status of ETL jobs responsible for cognos/BO report data.
• Preparation of low level design document

Environment: Informatica 7.x,ERWIN4.0,cognos8,BO5.x,oracle 10g,control-M

Confidential

ETL Data Analyst & Developer

Responsibilities:

• Analysis of the specifications provided by the clients
• Designed various mappings for extracting data from various sources involving flat files and relational tables.
• Using designer to create source definitions, design targets, create mappings, sessions and developing transformations and created data maps in power exchange navigator
• Created different transformations for loading the data into oracle database e.g. Source Qualifier, Joiner transformations, Update Strategy, Lookup transformations, Filter, Rank transformations, Expression, Aggregator, and Sequence Generator.
• Implemented SCD type 2.
• Responsible for monitoring all the sessions that are scheduled and re running the failed sessions after debug the Mapping
• Developed and executed UNIX scripts as pre/post-session commands to schedule loads, through SQL-loader utility
• Involved in Unit Testing and prepared Test Case
• Involved in Performance tuning and testing at mapping level.
• Configured and ran the Debugger from within the Mapping Designer to troubleshoot predefined mapping.
• Extensively involved in Fine-tuning of Informatica Code (mapping and sessions), Stored Procedures, SQL to obtain optimal performance and throughput
• Preparation of Unit Test Case and unit testing and Preparation of low level design document