PROFESSIONAL SUMMARY:

• Over 5 years of IT experience in various phases of Software Development Life Cycle (SDLC) which includes Requirement gathering, analysis, design, development, testing and implementation of data warehouses as ETL Developer using Informatica.
• Extensive experience in Database Modeling/Designing using Erwin to design Conceptual/Logical/Physical Modeling, Forward/Reverse engineering for both OLTP and OLAP systems.
• Experienced working with business analysts in understanding, translating the business requirements into functional requirements and documenting High Level Design’s (HLD) and Low Level Design’s (LLD).
• Experienced working on Entity - Relationship concepts, Dimensional Modeling (Star Schema and Snow Flake Schema), Normalization and De normalization Concepts.
• Extensive ETL experience using Informatica Power Center Client tools.
• Experienced in designing and developing Reports/Dashboards with different Analytics Views using Reporting tools such as Business Objects, OBIEE and Qlikview.
• Experience on Informatica Administration tasks and providing On Call Support for Production Problem Resolution.
• Excellent communication, interpersonal and problem solving skills with the ability to work in a team or independently.

TECHNICAL SKILLS:

ETL Tools: Informatica Power Center 9.x/8.x, Power Exchange, Data Analyzer, Oracle Warehouse builder.

Reporting Tools: Business Objects, OBIEE, Qlikview

Databases: Oracle 9i/10g/11g, SQL-ServerDB2 and MS Access, My SQL.

Tools: and Utilities: Erwin 4.0/3.5.2, MS-Visio, TOAD, SQL Developer, SQL Server Management Studio, SQL* plus, Autosy’s.

Languages and Web Technologies: HTML, XML, JavaScript, SQL, PL/SQL, C, UNIX Shell Script, Perl Script

Operating Systems: Windows 7 /vista /XP/98/2000, UNIX, LINUX, AIX.

PROFESSIONAL EXPERIENCE:

Confidential

Sr.ETL Developer/Analyst.

Responsibilities:

• Responsible for gathering requirements from business analysts and documenting them into detailed functional and technical specifications.
• Worked on day-to-day warehouse development and support tasks in agile model.
• Extract, Transform and Load the data from multiple sources.
• Worked on tuning the mappings to optimize the load and query performance.
• Defined parameters and variables to increase their usability in mappings.
• Created multiple partitions to allow the data to be loaded concurrently.
• Responsible for migrating the mappings, workflows and dependencies from staging to production.
• Worked with QA engineers to define test cases, test strategy, entry and exit criteria on ETL/data testing.
• Tracked issues that occurred during integration testing, which were then fixed and deployed to concerned environment.
• Hands-on experience designing/developing reports using QlikView.
• Prepared Complete documentation using both business and technical knowledge (e.g. requirements, technical and user documents).
• Developed Unix Shell scripts to schedule the jobs using Autosy’s.

Environment: Informatica 9x, DB2, TOAD, IBM DT Studio, SQL, XML, Autosy’s, Qlikview, Unix, and Windows.

Confidential

ETL Developer/Tester.

Responsibilities:

• Involved in coordinating with business users, business analysts, for requirement gathering.
• Communicated with clients and management to understand clear scope & status of the project.
• Responsible for creating the ETL mappings for all the dimensions and facts in the data mart.
• Implemented slowly changing dimensions - Type I & II as per the requirements.
• Extract and transform the data from multiple sources (Oracle, SQL Server, Flat File, XML) and load into Oracle tables.
• Developed reusable transformations, mapplets to reduce the development time and manipulating the data using various transformations ad per the requirements.
• Involved in migration of the entire Data Warehouse by implementing performance-tuning techniques.
• Implemented various loads like Daily loads, Weekly loads, Quarterly Loads using incremental load strategy.
• Responsible for troubleshooting the failure loads and to debug the data flow and fixing it.
• Build and maintained SQL scripts, indexes, and complex queries for data analysis and extraction.
• Involved in coding UNIX scripts to automate multiples ETL jobs and performed Informatica Administrative jobs when required.
• Worked with end users to develop and collect feedbacks in the User Acceptance Testing (UAT).
• Involved in production deployment, and was part of production support team.
• Created detailed design documentation, configuration documentation, and unit test plans.
• Experience in generating various reports using business Intelligence tool OBIEE and worked on end user s.

Environment: Informatica 9.x/8.x, UNIX, OBIEE, Oracle 11g/10g, SQL Server, PL/SQL, Flat files, XML, Toad

Confidential

Informatica Developer.

Responsibilities:

• Worked with data modelers in preparing logical and physical data models using Erwin.
• Responsible for creating User Folders and grant privileges to user to access the objects in the repository.
• Developed mappings to extract data from various sources like Oracle, Excel Spread sheets, Flat files, SQL Server and load into staging area.
• Worked on ETL to populate Fact and Dimension tables in the data warehouse.
• Developed complex mappings from scratch and were responsible in tuning the coded mappings that were previously implemented.
• Worked on PL/SQL scripts to handle different scenarios.
• Performed data manipulations using various transformations.
• Responsible in handling the Unix scripts to schedule informatica jobs.
• Responsible for assigning work and scheduling meetings for coordinating with offshore team on the development activities.
• Created and developed reports using Business Objects and Implemented the security levels.

Environment: Informatica8.x, UNIX, Business Objects, Oracle 11g, SQL Server, PL/SQL, Toad.