SUMMARY

• More than 10 years of experience in data warehousing architectural design which includes Requirement Analyzing, designing, data analysis, developing, implementing, testing and supporting Business Intelligence applications
• Strong experience in designing and implementing Data Mart / Data Warehouse applications using ETL tools Informatica Power Center 10/9.x/8.x/7. x.
• Over 2 years of experience in Informatica IDR 9.5, IDQ and IBM DataStage 8.1/8.5.
• Expert in writing SQL queries and optimizing the queries in Oracle and MS SQL Server.
• Hands on experience in implementing Slowly Changing dimension types (I, II &III) methodologies, Incremental Loads and Change Data Capture (CDC) and MD5.
• Excellent experience with Normalization (1NF, 2NF, 3NF), and De - normalization techniques for improved database performance in OLTP, OLAP, Data warehouse and DataMart environments.
• Experience in Star schema, Snowflake schema, Fact tables, and Dimension tables.
• Strong technical development and design experience, especially with systems integration and interface development
• Well versed in Shell scripting and fine tuning of the SQL.
• Extensively involved in migrating various Informatica sessions and mappings from one version to another
• Experience working in data modelling to translate business rules/requirements into conceptual/logical dimensional model and worked with complex de-normalized and normalized data models.
• Worked with Oracle PL/SQL and SQL Server Stored Procedures, Functions, Triggers, Index, SQL*Loader.
• Over 3 years of experience as a Lead ETL engineer leading team of developers, authoring technical specifications and diagrams, updating and discussing the status of the project with managers
• Experience in multiple business domains (Institutional, Health care, Retail, Energy Utilities, Banking)
• As a Lead/Sr.ETL Engineer, involved in implementing the best practices and standards to Project Management, Process improvement and Change Management
• Good experience in performing Unit testing, System Integration testing (SIT), User acceptance testing (UAT) and experience production support for issues raised by application users.
• Involved in the installation, configuration and administration of Informatica 9.1, 8.6.1 and upgrading the repository from 7.1 to 8.1.1 and from 8.1 to 9.1
• Involved in leading a team of onsite and offshore developers.

TECHNICAL SKILLS

Programming Languages: SQL, PL/SQL, Shell Scripting

ETL Tools: Informatica Power center 10/9.6.1/8.6.1/8.1/7. X, IDQ, IDR, Datastage 8.5/8.1

RDBMS: Oracle 10g/9i/8i/8.0, SQL Server 2000

Data Modeling: Erwin

BI & Reporting Tools: COGNOS

Operating Systems: UNIX, AIX, HP-UX, Red Hat Linux, Windows XP, Windows 2003 server

Other Tools: Toad, SQL Navigator, SQL Developer, Autosys, Mercury Quality Center, SVN, WorkloadManager, Agile Scrum Methodology, DB Visualizer, SQL Server Management Studio,SQL Developer, Putty, WINSCP, FileZilla, JIRA, HP ALM, SPSS

PROFESSIONAL EXPERIENCE

Confidential

Application Developer

Responsibilities:

• Involved in meetings with Business Analysts/Users, Architects, and Data Modeler to understand the current processing methodology to develop and test the Informatica jobs.
• Effectively used Informatica parameter files for defining mapping variables, workflow variables and relational connections.
• Used debugger in identifying bugs in existing mappings by analyzing data flow, evaluating transformations.
• Designed workflows with many sessions with decision, assignment task, event wait, and event raise tasks, used informatica scheduler to schedule jobs.
• Created balancing reports and test scenarios to ensure the accurate coverage of requirements and business rules.
• Involved in determining the severity and priority for various defects based on the complexity of the defects and the business needs.
• Involved in performing Functional, Integration, System, Regression Testing and Negative Testing.
• Wrote PL/SQL Queries to test and validate the Data warehouse test results.

Environment: Informatica 10.1, SQL Server, TFS

Confidential

ETL Developer/Tester

Responsibilities:

• Involved in meetings with Business Analysts/Users, Architects, Data Modeler, Other Tech Leads and Managers to understand the current processing methodology and plan for ETL planning, designing, developing, loading and testing and for decommissioning the interfaces in the legacy system
• Involved creation of extended dimension modeling tables like snowflake
• Responsible for development, support and maintenance of the ETL (Extract, Transform and Load) processes using Informatica Power Center.
• Created complete test cases of varying complexity, executing tests, measuring expected and actual results, and reporting status ensuring accurate coverage of requirements and business rules.
• Involved in determining the severity and priority for various defects based on the complexity of the defects and the business needs.
• Created SPSS scripts to perform end to end data validation.

Environment: Datastage, Informatica, Oracle, SPSS, JIRA

Confidential, CT

DWH Consultant

Responsibilities:

• Involved in meetings with Business Analysts/Users, Architects, Data Modeler, Other Tech Leads and Managers to understand the current processing methodology and plan for ETL planning, designing, developing, loading and testing and for decommissioning the interfaces in the legacy system
• Involved in creating new jobs, testing and running them using the job scheduler Autosys
• Involved creation of extended dimension modeling tables like snowflake
• Coordinated and worked with cross functional business teams, development and testing teams to plan and execute the releases per the timelines
• Leading the status meetings with the project management and business sponsors and providing status reports every day
• Created complete test cases of varying complexity, executing tests, measuring expected and actual results, and reporting status ensuring accurate coverage of requirements and business rules.
• Involved in determining the severity and priority for various defects based on the complexity of the defects and the business needs.
• Logged defects into HP ALM found during execution of test cases, assigned the defects to the related test cases.
• Responsible for creating complete test cases, test plans, test data, and reporting status ensuring accurate coverage of requirements and business processes.

Environment: Informatica Power Center 9.6, Oracle, SQL Server, HP ALM