SUMMARY:

• Analysis, design, development and implementation of Client/Server and Data warehouse applications.
• Strong experience in designing and developing Business Intelligence solutions in Data Warehouse/Decision Support Systems using ETL tools, Informatica PowerCenter 8.x, 9.x.
• Experience in Repository Configuration, creating Transformations and Mappings using Informatica Designer and processing tasks using Workflow Manager.
• Knowledge in designing Dimensional models for Data Mart and Staging Database.
• Experience in Installation, Configuration, and Administration of Informatica Power Center 7.x, 8.x, 9.x,10.x Client/Server.
• Responsible for interacting wif different Business Partners, Vendors & Customers to identify information needs and business requirements for reports.
• Experience in documenting Design specs, Unit test plan and deployment plan.
• Experience in Oracle as Pl/SQL Developer.
• Experience in data integration of various data sources from Databases like MS Access, Oracle, SQL Server and formats like flat - files, CSV files and XML files.
• Experience in Performance tuning of Informatica (sources, mappings, targets and sessions) and tuning teh SQL queries.
• Working noledge of a variety of Relational DBMS products, wif experience in designing and programming for relational databases, including Oracle, SQL Server, Teradata, DB2.
• Experience in design and implementation using ETL tools like Informatica (Power Center) Designer, Repository Manager and Workflow / Server Manager.
• Experience in creating various transformations using Aggregator, Look Up, Update Strategy, Joiner, Filter, Normalizer, Sorter, Router, XML, Stored procedure in Informatica Power Center.
• Extensive noledge in handling Slowly Changing Dimensions (SCD) Type 1/2/3.
• Developed excellent professional skills by working independently and also as a team member to analyze teh Functional/ Business requirements and to prepare test plans, test scripts.
• Experience working wif SDLC, SCRUM, RUP, Waterfall and Agile methodologies.
• Reliable, responsible, hardworking and good team player.

TECHNICAL SKILLS:

ETL Tools: Informatica 10.x/9.x/8.x/7.x, SQL Server Integration Services (SSIS).

Relational DBMS: Oracle 8i/9i/10g/11g, SQL Server 2000/2005/2008, Teradata v2R4/R6, DB2.

Data Modelling Tools: Rational Rose, ERWin, Visio.

Reporting Tools: Business Objects 6.x/XI, Cognos 8.4/10.2, MicroStrategy 7.1.5.

Scheduling Tools: Tivoli Work Scheduler (TWS) 8.3, Autosys, Crontab.

Operating Systems: Windows 95/98/00/NT/XP, HP-UNIX, SUN-OS, MS-DOS, MVS, z-OS.

Languages: C/C++, Java, JavaScript, HTML, XML, VB, SQL, PL/SQL, T-SQL.

Tools: TOAD 9.x/10.x/11.x/12.x, SQL Query Analyzer 8.0, Oracle SQL Developer 1.1.2Teradata SQL Assistant 7.1.0, SQL * Plus, Eclipse, NetBeans, PVCS, SCM.

PROFESSIONAL EXPERIENCE:

Confidential, MA

Sr. ETL Developer

Responsibilities:

• Responsible for ETL technical design discussions and prepared ETL high level technical design document.
• Translate requirements and high-level design into detailed functional design specifications.
• Involved in Data Validating, Data integrity, Performance related to DB, Field Size Validations, Check Constraints and Data Manipulation.
• Coordinated wif Business Users to understand business needs and implement teh same into a functional Data warehouse design.
• Coordinate requirements wif team and guide teh team during development and testing phases.
• Interacting wif onsite and offshore team and scheduling weekly status calls wif offshore team on status of deliverables.
• Designed and developed ETL strategies and mappings from source systems to target systems.
• Developed and tested ETL strategies were designed to cater initial and incremental load.
• Developed Informatica mappings to load new, modified and deleted data wif history.
• Setting up ODBC, Relational, Native and FTP connections for Oracle, DB2, SQL server, Teradata, VSAM and flat file.
• Implemented teh concept of slowly changing dimensions to maintain current and historical data in teh dimension.
• Implemented various loads like Daily Loads, Weekly Loads, and Quarterly Loads using Incremental Loading Strategy.
• Created several Repository Mappings and Queries facilitating rapid analysis, trouble shooting, code verification and deployment
• Responsible for determining and fixing teh bottlenecks and performance tuning.
• Responsible to tune ETL procedures and schemas to optimize load and query Performance.
• Involved in migration of Informatica ETL Code, Database objects and flat files through from development to different environments.

Environment: Informatica PowerCenter 9.6/9.5/9.1,Oracle 12g/11g, TOAD, SQL Developer, Teradata 14, Winscp, XML SPY, Putty, Tidal, SQL* Loader, HP ALM, Windows Enterprise 2012

Confidential, DC

Sr. ETL Developer

Responsibilities:

• Designed and developed ETL strategies and mappings from source systems to target systems. ETL strategies were designed to cater initial and incremental load.
• Worked wif production support team to fixes and enhancements on teh problems identified in teh existing system.
• Worked on multiple defects from different projects at teh same time.
• Developed and tested Informatica mappings to load new, modified and deleted data wif history.
• Worked wif source teams to resolve data quality issues raised by end users.
• Participated in Code Review sessions.
• Applied scripts in production for correcting teh incorrect data on teh tables.
• Created Test Case/Test Log documents and SQL queries for Unit and System Testing.
• Created, maintained and comminuted all teh data refresh request by creating mappings to load data from production environments to lower environments.
• Successfully identified and removed teh erroneous data from teh core tables and intermediate tables using SQL scripts.
• Implemented performance-tuning techniques by identifying and resolving teh bottlenecks in source, target, transformations, mappings and sessions.
• Used debugger to validate teh mappings and gain troubleshooting information about data and error conditions.
• Analyzed Session Log files in case teh session failed to resolve errors in mapping or session configurations.
• Extensively used PL/SQL Procedures/Functions to build business rule.
• Developed post and pre session shell scripts and scheduled Event based sessions at teh Informatica workflow manager.
• Transferred Knowledge on teh System to new team members.

Environment: Informatica PowerCenter 9.6/9.5/9.1, Informatica Data Quality 9.1,Oracle 12g/11g, TOAD, SQL Developer, Winscp, XML SPY, Putty, Tidal, SQL* Loader, HP ALM, Sun Solaris Unix and Windows Enterprise 2008

Confidential, OH

Sr. ETL Developer

Responsibilities:

• Participated in teh business analysis process and teh development of ETL requirements specifications.
• Involved in Source Data Analysis & Data Profiling and prepared Mapping Specification document based on Data Analysis & Profiling results.
• Prepared Technical Design Document based on Mapping Specification and HLD.
• Developed various mappings for Billing, Claims, Payment process, Lockbox process, Pharmacy, Medicare, Med claim and Decommissioned mappings.
• Utilized Lookup, Aggregator, Joiner, Union, Expression, Filter, Update strategy, Sql and Normalizer, Router, Transaction Control, Sequence Generator, Source Qualifier transformations to model various standardized business processes and implemented business logics.
• Implemented slowly changing dimensions (SCD) - type I & II in different mappings as per teh requirements and performed target load order in multiple target instances.
• Increased code reusability using shortcuts, mapplets, reusable transformations, re-used mappings, reusable sessions and worklets to reduce redundancy in code.
• Handled versioning and dependencies in Informatica.
• Created and maintained teh shell scripts and parameter files in UNIX for teh proper execution of Informatica workflows in different environments.
• Involved in extensive performance tuning by determining bottlenecks at various points like targets, sources, mappings, sessions or system.
• Extensively used Debugger to validate teh mappings and gained troubleshooting information about data and error conditions.
• Prepared teh error handling document to maintain teh error handling process.
• Used PL/SQL procedures/functions in mappings to build business rules to load data.
• Used Pushdown Optimization to push teh transformation logic on to teh Database both on teh Source and teh Target sides where ever possible to improve performance of teh mapping.
• Monitoring teh ETL jobs, generating tickets and fixing teh bugs in HP ALM.
• Extensively used Tidal Enterprise Scheduler for running teh shell scripts, performing actions, event tasks, scheduling teh workflows and dynamically updating teh parameter file.
• Participated in daily sprint scrum meetings, monthly retro meetings, IT Staff team meetings and training sessions.

Environment: Informatica PowerCenter 9.6/9.5/9.1, DB2 UDB, Informatica Data Quality 9.1, Teradata 14/13, Oracle 12g/11g, TOAD, SQL Developer, Surveyor, Winscp, XML SPY, Putty, Tidal, SQL* Loader, HP ALM, QVCS, Sun Solaris Unix and Windows Enterprise 2000