PROFESSIONAL SUMMARY:

• 10+ years of IT Experience in Data Warehousing, Database Design and ETL Processes in the Development, Test and Production environments of various business domains.
• Highly proficient in Design, Development, Enhancement, Implementation, Testing, Administration and Support of ETL processes for Large - scale Data warehouses using Informatica Power Center.
• Expertise in Data Warehouse, Data-mart, ODS, OLTP and OLAP implementations teamed with Project Scope, Analysis, Requirements Gathering, Data Modeling, Effort Estimation, ETL Design, Development, System Testing, Implementation and Production Support.
• Experienced in Database Administration and Technical Management.
• Good understanding in database and data warehousing concepts (OLTP & OLAP).
• Hands on Experience in Installing, Configuring, Managing, Monitoring and troubleshooting different RDBMS like SQL server and Oracle.
• Extensive Experience in Teradata Utilities like BTEQ, MLOAD, TPUMP and FAST LOAD
• Expertise in creating databases, users, tables, triggers , macros , views, stored procedures, functions, Packages, joins and hash indexes in Teradata database.
• Proficient in performance analysis, monitoring and SQL query tuning using EXPLAIN PLAN , Collect Statistics , Hints and SQL Trace both in Teradata and Oracle.
• Extensive experience with data modeling techniques, logical and physical database design.
• Hands on experience in tuning mappings, identifying and resolving performance bottlenecks in various levels like sources, targets, mappings, and sessions and at database.
• Proficient in the Integration involving various data sources like Oracle, MS SQL Server, DB2, Teradata, Salesforce, VSAM files and Flat Files.
• Experience in Creating and Updating Clustered and Non-Clustered Indexes
• Used Power Exchange to integrate the sources like Mainframe MVS, VSAM, GDG, DB2 and XML files.
• Experience in UNIX shell scripting, job scheduling and communicating with server using pmcmd and pmrep.
• Experience in Analyzing Execution Plan and managing indexes and troubleshooting deadlocks.
• Good knowledge in Normalizing and De-normalizing the tables and maintaining Referential Integrity by using Triggers and Primary and Foreign Keys.
• Designed and developed efficient Error handling methods and implemented throughout the mappings in various projects.
• Good knowledge of Master Data Management concepts.
• Hands on Experience in Informatica MDM, Informatica IDQ and Informatica B2B
• Good Knowledge of Kimball and Inmon data warehouse design approaches and considerations
• Good understanding of dimensional models, slowly changing dimensions, star & snowflake schemas.
• Experienced with Agile SDLC methodology.
• Hands-on experience across all stages of Software Development Life Cycle (SDLC) including gathering business requirement, analysis, data mapping, build, unit testing, systems integration and user acceptance testing.

TECHNICAL SKILLS:

Databases:  Oracle 10g/9i/11i, DB2, MS SQL server 7.0/2000/2005/2008 , MS Access 2000/2005, Teradata, MySQL

Operating Systems:  Windows, Linux, Unix, MS-DOS, Sun Solaris.

OLAP/Reporting Tools:  SQL Server Analysis Service(SSAS), SQL Server Reporting Service(SSRS), Business Objects 6.x, Cognos Framework Manager, OBIEE, Hyperion

ETL Tools:  SQL Server Integration Services (SSIS), SQL Server DTS, Informatica PowerCenter 10.x/9.x/8.x/7.x, Informatica Power Exchange, Informatica Data Quality Suite 8.5, Cognos Data Manager, Pentaho Kettle

Data Modeling Tools:  Microsoft Visio, Embarcadero ERStudio, Erwin

SQL Server Tools:  SQL server Management Studio, SQL server Query Analyzer, DBCC, BCP, SQL server profiler  

Web Technologies:  MS FrontPage, MS Outlook Express, FTP, TCP/IP

Other Tools:  Microsoft Office, Visual Basic 6, Oracle R12 EBS

Scheduling Tools:  Tidal, Autosys, Windows Scheduler

Data Quality Tools: Informatica Analyst, Informatica Data Quality, Informatica Developer

PROFESSIONAL EXPERIENCE:

Confidential, Lake Mary, FL

Senior Solution Engineer

Responsibilities:

• Coordinated with Business Users to understand business needs and implement the same into a functional Data Warehouse design.
• Lead design, development and implementation of the Enterprise Data Warehouse.
• Established ETL standards and created detail ETL Standards documents for Design, Development, Release Management and Production Support.
• Designed and developed various Informatica mappings using transformations like Expression, Aggregator, External Procedure, Stored Procedure, Normalizer, Lookup, Filter, Joiner, Rank, Router, Update Strategy and XML.
• Responsible for Requirement Gathering Analysis and End User Meetings
• Interpreted logical and physical data models for Business users to determine common data definitions.
• Coordinate requirements with team and guide the team during development and testing phases.
• Design and Develop Reusable Common objects shared across various Repositories.
• Responsible for projects estimates, design documents, resource utilization and allocations.
• Responsible for ETL technical design discussions and prepared ETL high level technical design document.
• Setting up ODBC, Relational, Native and FTP connections for Oracle, DB2, SQL server, VSAM and flat file.
• Involved in the analysis of source to target mapping provided by data analysts and prepared functional and technical design documents.
• Involved in designing of snowflake schema based data model with dimensions and facts.
• Responsible for Production Support and Issue Resolutions
• Responsible for mentoring Developers and Code Review
• Responsible for determining and fixing the bottlenecks and performance tuning.
• Involved in massive data profiling using IDQ prior to data staging.
• Created business rules in Informatica Developer and imported them to Informatica Powercenter to load the standardized and good format of data to staging tables
• Design and develop and Implement detail layout of ETL testing plan procedures
• Created several Repository Mappings and Queries facilitating rapid analysis, trouble shooting, code verification and deployment.
• Implemented various loads like Daily Loads, Weekly Loads, and Quarterly Loads using Incremental Loading Strategy.
• Designed and developed various complex Informatica mappings and mapplets.
• Used Informatica Developer to perform data quality tasks like data profiling, validation and cleansing.
• Designed and developed efficient Error handling methods and implemented them in the mappings.
• Expericed in utilizing JIRA and Bitbucket.
• Extracted and loaded data using the Quintiq Data Integrator from the Quintiq Warehouse to Oracle DB

Environment: Informatica Powercenter 9.6, Informatica Analyst, Informatica Data Quality 9.6, Quintiq Application, UNIX, Oracle 11g, Tidal, Putty, Visual Studio, TOAD, Erwin.

Confidential, Dayton,OH.

ETL Developer

Responsibilities:

• Implemented new functionalities and extracts as per the needs of the Users, after detailed analysis of the data and the business requirements.
• Extensive qualifications in all facets of information systems methodology from conceptual design through documentation, implementation, user training, quality review, and enhancement.
• Designed and developed various Informatica mappings using transformations like Expression, Aggregator, External Procedure, Stored Procedure, Normalizer, Lookup, Filter, Joiner, Rank, Router, Update Strategy and XML.
• Involved in interacting with business users for requirements.
• Analyzed data flow and business requirements to create High Level Design document.
• Developed various Ad-hoc mappings for various business needs.
• Acquired substantial knowledge with respect to the different source systems in healthcare - namely HEDIS, FACETS etc.
• Responsible to tune ETL procedures and schemas to optimize load and query Performance.
• Interpreted logical and physical data models for Business users to determine common data definitions.
• Created implementation plan and deployment groups to ensure successful migration of the code from the Development environment to the Integration, Certification and Production environments.
• Actively involved in successfully resolving high priority defects with very tight timelines.
• Involved in Data Validating, Data integrity, Performance related to DB, Field Size Validations, Check Constraints and Data Manipulation.
• Implemented pushdown optimization to load the CORE tables in the EDW.
• Developed mappings to load into staging tables and then to Dimensions and Facts.
• Used Informatica Analyst for Data Profiling.
• Created mapping documents to outline data flow from sources to targets.
• Used Tidal scheduler to schedule and run Informatica workflows.
• On-Call/Production Support provided during day-time and off-hours.
• Proficient in working with Teradata and using utilities like MultiLoad, FastLoad, FastExport, BTEQ, TPump and Teradata SQL
• Experienced in writing Teradata SQL and analytic functions
• Used Teradata native loaders to load the tables into Teradata using Informatica.
• Implemented partitioning on extracts reading data from large files.
• Implemented the concept of dynamic parameter file for certain incremental loads.
• Managed internal websites for ticketing system.
• Designed, developed, implemented and maintained Informatica PowerCenter and IDQ application for matching and merging process.
• Integrated Informatica applications as Maplets within PowerCenter Mappings.
• Utilized of Informatica IDQ to complete initial data profiling and matching/removing duplicate data.

Environment: Informatica Powercenter 9.6, Informatica Analyst, Informatica IDQ, MS SQL Server 2008, Tidal, Putty, Teradata 14.

Confidential, Danville, PA.

ETL Developer

Responsibilities:

• Delivered cost effective, high performance technology solutions to meet challenging business demands.
• Designed and developed various Informatica mappings using transformations like Expression, Aggregator, External Procedure, Stored Procedure, Normalizer, Lookup, Filter, Joiner, Rank, Router, Update Strategy and XML.
• Involved in interacting with business users for requirements.
• Analyzed data flow and business requirements to create High Level Design document.
• Developed various Ad-hoc mappings for various business needs.
• Acquired substantial knowledge with respect to the different source systems in healthcare - namely Amisys, Milliman etc.
• Experienced with loading into and reading from XML files in Informatica Powercenter.
• Responsible to tune ETL procedures and schemas to optimize load and query Performance.
• Interpreted logical and physical data models for Business users to determine common data definitions.
• Involved in Data Validating, Data integrity, Performance related to DB, Field Size Validations, Check Constraints and Data Manipulation.
• Involved in Data Validating, Data integrity, Performance related to DB, Field Size Validations, Check Constraints and Data Manipulation.
• Implemented the concept of slowly changing dimensions to maintain current and historical data in the dimension.
• Wrote UNIX shell Scripts to FTP of files from remote server.
• Developed mappings to load into staging tables and then to Dimensions and Facts.
• Used Informatica Analyst for Data Profiling.
• Created mapping documents to outline data flow from sources to targets.
• Involved in upgrading from Informatica 9.1 to Informatica 9.5.1.
• Used Tidal scheduler to schedule and run Informatica workflows.
• Involved in migration projects to migrate data from data warehouses on Oracle/DB2 and migrated those to Teradata.
• Used Fast Load to load the stage tables in Teradata.

Environment: Informatica Powercenter 9.1/9.5, Informatica Power Exchange, Informatica Analyst, UNIX, PL/SQL, MS SQL Server 2008, Oracle 11g, Tidal, Putty, Teradata 13.10.

Confidential, Framingham, MA

ETL Developer

Responsibilities:

• Implemented numerous business optimization projects and reporting tools that improved efficiency, reduced expenses, labor costs, and maximized profit by automating outdated manual processes.
• Designed and developed various Informatica mappings using transformations like Expression, Aggregator, External Procedure, Stored Procedure, Normalizer, Lookup, Filter, Joiner, Rank, Router, Update Strategy and XML.
• Developed various Ad-hoc mappings for various business needs.
• Supported the BI team by extracting operational data from multiple sources, merging and transforming the data to facilitate enterprise-wide reporting and analysis and delivering the transformed data to coordinated data marts.
• Responsible to tune ETL procedures and schemas to optimize load and query Performance.
• Perform Designs and Analysis on business systems applications, systems interfaces, databases, reporting, or business intelligence systems
• Deliver new systems functionality supporting corporate business objectives
• Implemented the concept of slowly changing dimensions to maintain current and historical data in the dimension.
• Translate requirements and high-level design into detailed functional design specifications.
• Responsible for design, development and maintenance of Data Marts including Sales, Inventory, Customer Reporting and Resource Management leveraging Informatica Power Center ETL tool, Oracle and SQL Server.
• Involved in Data Validating, Data integrity, Performance related to DB, Field Size Validations, Check Constraints and Data Manipulation.
• Coordinated with Business Users to understand business needs and implement the same into a functional Data warehouse design.
• Used ERStudio to analyze and optimize database and data warehouse structure.
• Used Tidal scheduler to schedule and run Informatica workflows.
• Accountable for documenting, designing and constructing the Extract, Translate and Load jobs that will move data for the Operational Data Store using Talend ETL Platform.
• Designed numerous ad-hoc ETL processes in Talend to load data from DB2 to MySQL for an in house data quality project.
• Used Pentaho Data Integration Designer to create ETL transformations.
• Used Informatica Analyst to profile the source systems

Environment: Informatica Powercenter 9.1, Informatica Power Exchange, Informatica Analyst, Oracle 11g, UNIX, PL/SQL, Embarcadero ERStudio Data Architect, TOAD, Tidal, Putty.

Confidential, Chelmsford, MA

ETL Developer

Responsibilities:

• Handling various activities of the project like information gathering, analyzing the information gathered, documenting the functional or business requirements.
• Designed and developed various Informatica mappings using transformations like Expression, Aggregator, External Procedure, Stored Procedure, Lookup, Filter, Joiner, Rank, Router, Update Strategy and XML.
• Developed various Ad-hoc mappings for various business needs.
• Supported the BI team by extracting operational data from multiple sources, merging and transforming the data to facilitate enterprise-wide reporting and analysis and delivering the transformed data to coordinated data marts.
• Perform Designs and Analysis on business systems applications, systems interfaces, databases, reporting, or business intelligence systems
• Responsible for design, development and maintenance of Data Marts including Sales, Shipment, Customer Reporting and Transportation leveraging Informatica Power Center ETL tool, Oracle and SQL Server.
• Deliver new systems functionality supporting corporate business objectives.
• Translate requirements and high-level design into detailed functional design specifications.
• Wrote stored procedures, functions, and database triggers in SQL Server 2008.
• Responsible to tune ETL procedures and schemas to optimize load and query Performance.
• Interpreted logical and physical data models for Business users to determine common data definitions.
• Involved in Data Validating, Data integrity, Performance related to DB, Field Size Validations, Check Constraints and Data Manipulation and Updates by using SQL Single Row Functions.
• Coordinated with Business Users to understand business needs and implement the same into a functional Data warehouse design.
• Used ERStudio to analyze and optimize database and data warehouse structure.
• Implemented the concept of slowly changing dimensions to maintain current and historical data in the dimension.
• Develop reports using complex formulas and to query the database to generate different types of ad-hoc reports using   SSRS .
• Experience in using Normalizer transformation for normalizing the XML source data.
• Extensively used XML transformation to generate target XML files.
• Developed UNIX shell scripts for scheduling sessions in Informatica.
• Provide SME level guidance to Development and Application support teams during development and deployment phases.
• Facilitate/lead design reviews of functional design with other members of the technical team, communicating design, requirements, feature set, functionality and limitations of systems/applications.
• Developed ETL technical specs, Visio for ETL process flow and ETL load plan, ETL execution plan, Test cases, Test scripts etc.
• Responsible for ETL development with successful design, development, and integration of components within the Talend ETL Platform.
• Created dashboards in Pentaho using Pentaho Dashboard Designer.
• Automated hourly and daily transaction reports using talend open studio.
• Extraction, transformation and loading of data from various file formats like .csv, .xls, .txt and various delimited formats using talend open studio and sql loader.
• Actively involved in building the system test environment
• Migrated mappings from Development to System Test environment and QA environment.
• Used Informatica Power center workflow manager to create sessions, workflows and Worklets to run with the logic embedded in the mappings.

Environment: Informatica Power Center 9.1/8.6, SQL Server 2005/2008, PL/SQL, Transact SQL, Oracle 10g/11g, Embarcadero ERStudio Data Architect, TOAD, UNIX

Confidential, Tewksbury, MA

ETL Developer

Responsibilities:

• Extensively used several transformations such as Source Qualifier, Router, Lookup (connected & unconnected), Update Strategy, Joiner, Expression, Aggregator and Sequence generator transformations.
• Involved in Dimensional modeling to Design and develop STAR Schemas, used ER-win 4.0, identifying Fact and Dimension Tables.
• Worked with different Sources such as Oracle, MS SQL Server and Flat file.
• Used Informatica to extract data into Data Warehouse.
• Identified and tracked the slowly changing dimensions, heterogeneous Sources and determined the hierarchies in dimensions.
• Created reusable transformations and Mapplets and used them in mappings.
• Used Informatica Repository Manager to maintain all the repositories of various applications.
• Developed number of Complex Informatica Mappings, Mapplets and Reusable Transformations for the Claim Profitability Systems to facilitate Daily, Monthly and yearly Loading of Data.
• Involved in fixing invalid Mappings, testing of Stored Procedures and Functions, Testing of Informatica Sessions, and the Target Data.
• Wrote UNIX scripts and PL/SQL scripts for implementing business rules.
• Worked on SQL tools like TOAD to run SQL queries to validate the data.
• Design and Development of pre-session, post-session and batch execution routines to run Informatica sessions using Informatica Server.
• Created and Scheduled sessions & Worklets using workflow Manager to load the data into the Target Database
• Wrote PL/SQL stored Procedures and Functions for Stored Procedure Transformations.
• Used Control - M scheduler to automate the process.
• Participated in Review of Test Plan, Test Cases and Test Scripts prepared by system integration testing team.
• Monitored the performance and identified performance bottlenecks in ETL code.

Environment: Informatica PowerCenter 7.1.3, Oracle9i, MS SQL Server 2000, MS Enterprise Manager, MS Query Analyzer, Flat file, XML, Control-M (scheduler), Linux, UNIX Korn scripting, TOAD, Erwin 4.0, Windows NT, Clear case.