SUMMARY

• 8+ years of experience in software applications analysis, design and development, Testing, Maintenance and Enhancement in data warehousing, Data Integration.
• 8 years of strong Data Warehousing experience in Business Requirement Analysis, Design, Development, Testing, Implementations, Loading, Maintenance and Enhancements of Data warehouse and ODS systems using Informatica PowerCenter 9.x/8.x/7.x, Oracle 11g/10g/9i, DB2, SQL, PL/SQL, SSIS, SSMS, SSRS and well versed with Data Warehousing Architecture, Technology and Dimensional Data Modeling.
• 2+years of experience in designing and implementation of real - time Data warehouse using Informatica PowerExchange 9.1/8.6.
• Extensive knowledge with Dimensional Data modeling, Star Schema/Snowflakes Schema, Fact and Dimension tables.
• Heavily interacted with the Source System owners and business users to gather requirements, design tables, standardize interfaces for receiving data from multiple operational sources, coming up with load strategies of loading staging area and data warehouse.
• Worked extensively with Flat Files, COBOL Files, DB2 Relational source data, and Workflow and Scheduling Job design, resolving production issues.
• Used features like pre-session/post-session commands/SQL, fine-tuned databases, mappings, and sessions to get optimal performance.
• Implemented slowly changing dimensions (Type1, Type2 and Type3), Merge Queries for Updates, slowly growing targets, and simple pass through mapping’s using Power Center.
• Experience in UNIX shell scripting, Application Monitoring using UNIX Shell Scripting.
• Extensive experience with relational databases (Oracle 10g/11g, DB2, SQL Server, Teradata.
• Worked in Agile methodology, have experience on Rally, Basecamp.
• Experience in developing Test Strategy, Test plan, Test cases, Use Case, Test scripts.
• Possess excellent interaction, communication and problem solving abilities.
• Strong experience in offshore and onsite coordination.

TECHNICAL SKILLS

ETL TECHNOLOGY: Informatica Power Center 9.x/8.x/7.x, Informatica Power Exchange 9.x/8.6

DATA WAREHOUSE: Multidimensional Model Design, Star Schema Development

DATA MODELLING: Star-Schema Modeling, Snowflake Modeling, MS Visio, Erwin 8/7.5

DATABASES: Oracle 11g/10g/9i, DB2 mainframe 9, Teradata 12/V2R5/14/15,MySQL, MS Access, Sybase

PROGRAMMING: SQL, PL/SQL, Shell Scripting, PERL

REPORTING TOOLS: Business Objects XI, Cognos

OPERATING SYSTEMS: Windows 7, IBM AIX 5.1, Red Hat Linux V6

APPLICATIONS: Toad 9.2/8.6,DB Visualizer 9.2,FileZilla,Winscp,JIRA,Service Desk

MANAGEMENT TOOLS: MS-Office 2007

PROFESSIONAL EXPERIENCE

Confidential, Woodland Hills, CA

ETL DEVELOPER

Responsibilities:

• Worked on building a number of complex Informatica mappings, mapplets, reusable transformations to implement the business logic and load the data incrementally by using aggregator, Update Strategy for Backfills, SQL overrides in lookups, source filter in source qualifier and data flow management into multiple targets using router transformations.
• Extracted data from the application to staging area thru flat files, Tables, COBOL files from Mainframe and populated onto Data Warehouse.
• Created Informatica PowerExchange registration, data map, configuring connection, recovery and tokens.
• Extensively involved in performance tuning of the ETL process by applying business logic in Source Qualifier as a query and using less transformations, using TPT (Teradata Parallel Transporter) for fast load and also determining the bottlenecks at various points like targets, sources, mappings, sessions or systems. This led to a better session performance.
• Involved in creating the run book and migration document (from Development to Production).
• High level Documentation of most of the processes for further maintenance and support.
• Worked on test cases and use cases creating Unit Test Plans and unit Testing on the ETL Packages and Workflows.
• Worked on Reviewing, analyzing, fixing Production issues and handling abends.
• Job Monitoring
• To produce artifacts (technical specifications, architectural specifications, data models, Installation and release notes) for the software development process.
• To design Profile, Endpoints, Partners, Accounts, Workflows using Informatica Data Exchange.
• Working on agile Project development and task management.
• Involved in Monthly Process Production support. Using SSMS to query the data.
• Created Reports on monthly process using SSRS.

Environment: SQL Server 2008 R2, PL/SQL, UNIX, Informatica PowerCenter 9.6.1, PowerExchange 9.6.1, Mainframe DB2, Teradata Studio15.10, BMC Remedy, JIRA, Control M.

Confidential, New York, NY

INFORMATICA DEVELOPER

Responsibilities:

• Gathered Business requirements by interacting with Business Analyst team and analyzed the requirements to translate into Technical Specifications.
• Identified the bottlenecks in the sources, targets, mappings, sessions and resolved the problems.
• Performed complex defect fixes in various environments like UAT, SIT etc. to ensure the proper delivery of the developed jobs into the production environment.
• Responsible to write complex SQL queries and PL/SQL procedures to perform database operations according to business requirements.
• Worked with the testers closely in determining both medium and high severity defects, that would potentially affect the downstream systems before the release of the project, and also fixed the defects before moving the jobs into production.
• Document all ETL related work per company's methodology.
• Attended production implementation calls and co-ordinated with the build engineers during migration of the code and was highly acknowledged.
• Prepared estimates and tracked each and every tasks and strictly adhered to the estimated deadlines.
• Extensive knowledge in promoting packages (code) across development, test, preproduction and production environment using tools like Computer Associate Harvest package.
• Co-ordinated with Off-Shore team in INDIA.
• Extensive knowledge in promoting packages (code) across development, test, preproduction and production
• Preparation of Test Data/Unit Testing /Integrated testing and generated various test cases.
• Involved in different Team review meetings.
• Worked along with UNIX team for writing UNIX shell scripts to customize the server scheduling jobs.
• Communication with the client for weekly status report.

Environment: Informatica Power Center 8.6, SQL Server 2008, Oracle 11g, Toad,Autosys, UNIX Shell Scripting, Flat Files, Mercury Quality Center, DB2 Mainframe, CVS.

Confidential 

INFORMATICA DEVELOPER

Responsibilities:

• Source system evaluation, standardizing received data format, understanding business/data transformation rules, business structure and hierarchy, relationships, data transformation through mapping development, validation and testing of mappings.
• Developed logical & physical modeling as per business requirements using ERWIN 4.0
• Performed requirement analysis and developed designing technical specifications for data migration according to the business requirement.
• Used Information Power Exchange for loading/retrieving data from mainframe systems.
• Developed complex ETL structures to extract, transform and load data from multiple data sources into data warehouse bases on business requirements.
• Extensively worked with SCD Type-I, Type-II and Type-III dimensions and data warehousing Change Data Capture(CDC).
• Created mapplets in place of mappings which were repeatedly used like formatting date or data type conversion.
• Ensured accurate, appropriate and effective use of data; including data definition, structure, documentation, long - range requirements, and operational guidelines.
• Monitored ETL process activity and utilization, with particular strengths in performance tuning highly transactional data integration package in both the development and production environments.
• Responsible for troubleshooting and resolving issues related to system performance, Informatica applications, and data integrity
• Extensively worked with SQL queries, created stored procedures, packages, triggers, views using PL/SQL Programming.
• Involved in optimization and performance tuning of Informatica objects and database objects to achieve better performance.
• Sourced data from Teradata to Oracle using Fast Export and Oracle SQL Loader.
• Created load scripts using Teradata Fast Load and Mload utilities and procedures in SQL Assistant.
• Offered production support for daily jobs
• Worked with Unix commands and used Unix shell scripting to automate jobs.
• Performed Unit and Integration testing and wrote test cases
• Worked extensively in defect remediation and supported the QA testing.
• Involved in periodic maintenance of environments by applying patches and content upgrades.
• Involved in code migration for versioned repositories
• Involved in taking repository backup and restoring it, starting and stopping Informatica services and worked with pmcmd commands.
• Created Drill through Reports & Master Detail Reports for Sales Department
• Extensively used prompts, filters, cascading prompts, calculations, conditional variables, multiple queries for data extraction in reports.

Environment: Informatica Power center 8.1, PL/SQL, Oracle 10g, Autosys, Toad, Flat file, SQL Server, UNIX Shell Scripting.