SUMMARY

• Seven Plus (7+) years of total IT experience which includes Business Requirements Analysis, Development, Implementations and Testing of Data Warehousing in various industries.
• All 7+ yrs. experience extensively in the complete Software Development Life Cycle (SDLC) covering Requirements Management.
• 7+ years of Data Warehousing experience using Informatica Power Center 9.6.1/9.5.0/8.6 , Informatica Power Exchange 9.5, Warehouse Designer, OLAP, OLTP
• Experience in Master Data management (MDM)
• Have Sound knowledge in Healthcare and Insurance, Finance domains.
• Data Processing experience in designing and implementing Data Mart applications, mainly transformation processes using Informatica.
• Proficiency in using Informatica Power Center tool to design data conversions from wide variety of sources.
• Strong in Data warehousing concepts, Star Schema and Snowflakes Schema methodologies
• Extensively worked with large Databases in Development.
• Proficient in using Informatica workflow manager, Workflow monitor to create, schedule and control workflows, tasks, and sessions.
• Performance tuning of the Informatica and Databases.
• Extensive work in ETL process consisting of data transformation, data sourcing, mapping, conversion, and loading.
• Proficient in understanding business processes / requirements and translating them into technical requirements.
• Experience in resolving on - going maintenance issues and bug fixes; monitoring Informatica sessions as well as performance tuning of mappings and sessions
• Seven Plus (7+) years of database experience using Oracle 11g/10g/9i, MS SQL Server 2010
• Experience in complete life- cycle of Test case design, Test plans, Test execution, Defect Management
• Extensively used SQL and write Stored Procedures, Functions and Triggers.
• Extensively worked with SQL Loader for bulk loading into the Oracle database.
• Experience in UNIX Operating System.
• Outstanding skills in analyzing business process and end-user needs, detail oriented and committed to delivering superior quality work.
• Excellent problem solving, communication, analytical and interpersonal skills working independently or as part of a team
• Able to quickly adapt to new environments and learn new technologies.

TECHNICAL SKILLS

Data Warehousing: Informatica Power Center 9.6.1/9.0/8.6/8.1 , Warehouse Designer, Informatica Power Exchange 9.5, ETL OLTP, OLAP, Control-M

Dimensional Data Modeling: Dimensional Data Modeling, Data Modeling, Star Schema Modeling, Snow-Flake Modeling, FACT and Dimensions Tables, Physical and Logical Data Modeling, Erwin 7.2/6.1

Databases: Oracle 11g/10g/9i, MS SQL Server, SQL Plus

Programming: TOAD, SQL, PL/SQL, Unix.

Environment: Unix HP, WinSCP

PROFESSIONAL EXPERIENCE

Confidential

Sr. Informatica developer

Responsibilities:

• Participating in HCDM integration meetings for Business requirement, data-mapping from source systems into Oracle database.
• Interacting with workday team in case there is any source related data issue.
• Working with flat files, Relation database tables, views, materialized views as source system to load data in HCDM database.
• Created UNIX scripts to automate the activities like Decrypting files, creating indirect files, and archiving files.
• Working on encrypted PGP files to decrypt files, loading indirect files in database.
• Worked with staging area to perform data cleansing, data scrubbing, data filtering and data standardization process.
• Working closely with DBA team to tune the performance of the Database.
• Working with various look-up caches.
• Working with connected and unconnected look-up for implementing complex logic.
• Working on the performance tuning of databases (dropping & re-building indexes, analyze tables. creating indexes in database level. using bulk load in session.
• Write SQL Queries to test and analyze the data.
• Designing, Developing, and implemented ETL mappings using Informatica power center 9.5.0 and 10.2
• Implementing Slowly Changing Dimensions Type 1, Type2. Creating Type 2 history tables as well as snapshot tables for ease in reporting requirements.
• Working on workflow manager, sessions, command task, session task, email task, decision task etc.
• Monitoring Prod job using flink and workflow monitor.
• Unit testing for encrypting and decrypting batch scripts.
• UAT defects analysis and fixation.
• Working in Dev, SIT, UAT and PROD environments.
• Working with OBIEE team and Essbase team which are downstream applications for the data populated in HCDM.
• Working with Data Governance team to gather metadata requirements and populate metadata and hierarchies from their inputs.
• Jobs are scheduled based out of flink (Finance Link --an internal scheduling tool) which can run jobs end to end starting from Data Governance to Essbase irrespective of application. Provided inputs for ETL job scheduling in flink with the corresponding team and created job schedules based out of flink.
• Responsible for assign the access to users for MARC Prod database access for all hub and non-hub ledger access and as per tickets assign.
• Worked on Shortcuts as sources and targets in power center designer
• Created workflow packaging in workflow manager.
• Migrated the folders or mappings and sessions from development to test environment and Created Migration Documents to move the code from one Environment to another Environment for PROD and UAT.

Environment: Informatica PowerCenter10.2, Informatica PowerCenter 9.5.0, Oracle 11g, TOAD, SQL Developer, SQL server, SharePoint, JIRA

Confidential

Informatica developer

Responsibilities:

• Gather business requirement documents.
• Designed, Developed, and implemented ETL mappings using Informatica.
• Worked with Informatica Power Center -Source Analyzer, Warehousing designer, Mapping Designer & Mapplet and Transformation Developer for creating Mappings.
• Used various transformations like Filter, Expression, Sequence Generator, Update Strategy, Lookup, Joiner, Stored Procedure, and Union to develop the mappings in the Informatica Designer.
• Build test scripts (SQL queries) using SQL server database and SQL Developer for integration testing and end to end system testing of the project requirements.
• Working on SQL queries, stored procedure for integration, regression testing to validate data according to all baseline projects.
• Working on source target mapping document.
• Coordinate with Business End-User to obtain user acceptance test (UAT) approval.
• Execute the test cases and log defects when appropriate. Included test case execution results on the HP ALM tool.
• Data validation, report mismatch data count and load mismatch count
• Catch defect using HP ALM (Application cycle management) defect tracking tool.
• Upload test cases to HP ALM.
• Provide weekly status on ABC Validation progress, including test case execution status, defect summary report, and defect detail report.
• Prepare Final ABC Validation Cycle Report.
• Worked as a member of the team of QA testers, involved in designing test cases, writing test cases, execution of test cases and documenting the findings.
• Used Informatica Workflow Manager for creating, running the Workflows and Sessions, and scheduling them to run at specified time.

Environment: SQL server 2008 management studio, HPALM tool 12, Oracle 11g, ALM Add in Excel, SQL Developer, Informatica Power Center 9.6.1, Unix, Flat Files, CSV files.