SUMMARY

• Over 6+ years of IT experience in all phases of software development life cycle with successful project implementation - Analyzing process and systems, understanding requirements, development and technical reviews
• Strong experience in different stages of Software Development Life Cycle (SDLC) which includes Analysis, design, development, testing and implementation of Business intelligence solutions using Data Warehouse/Data Mart Design.
• Worked on ETL using lnformatica PowerCenter Client tools - Mapping Designer, Repository manager, Workflow Manager/Monitor
• Created High level Design documents and shared with development team
• Good understanding of Dimensional Modeling concepts such as Star and Snow Flake Schema, identifying Facts and Dimensions, Physical and logical data modeling.
• Actively teamed with Project scope, Analysis, requirements gathering, Effort Estimation, ETL Design, development, System testing, implementation and production support.
• Strong experience in Extraction, Transformation and Loading (ETL) data from various sources into DataWarehouse and Data Marts using lnformatica PowenCenter as ETL tool
• Worked on creating Tables, Views, SQL queries using Oracle PL/SQL
• Good understanding of UNIX shell scripts and automation of the ETL processes
• Developed test plans, test cases, test scripts, and executed in development and QA environments to validate the output as per the business requirements
• Experience in resolving on-going maintenance issues and bug fixes, monitoring lnformatica sessions and preparing documentation.
• Worked on creating Change requests, coordinating with various teams for deploying packages and application turnover to production support teams.
• Actively taken part in projects requiring the Integration of various data sources with multiple relational databases like Oracle, MS SQL Server, Teradata, VSAM files and Flat Files into the staging area, ODS, Data Warehouse and Data Mart.
• Experience in using Automation Scheduling tools like Autosys and CA7.
• Actively participated in performance tuning of lnformatica mappings and sessions to improve performance of time taking mappings.
• Have good communication and interpersonal skills, coordinating with cross-functional teams, project management and developers across multiple disciplines.
• Created status reports for management as part of weekly meetings and need-basis to share the progress of the project and issues/road blocks if any.
• Good analytical, problem solving skills with strong technical background and interpersonal skills.
• Positive attitude and strong inclination towards learning new things.
• Good team player taking ownership of tasks and responsibilities and ability to work independently.
• Excellent Organizational skills, ability to Multi-task, prioritize and manage day to day workload with minimal supervision

TECHNICAL SKILLS

ETL Tool: Informatica Power Center 10.2//9.5/9.6/8 Power Exchange 10.2/9.5/9.6/8

Databases: Teradata 15.10/14.10 , Oracle 11g/10g/9i

Operating Systems: Linux, Windows 2000/NT, Mainframe

Database GUI Tools: Toad 12.0, Teradata Studio, Sqlpus, sFTP

Scheduling Tools: Informatica Scheduler, Autosys, CA7

Version Control Tools: Serena, Harvest 12.0

Ticketing: ServiceNow

PROFESSIONAL EXPERIENCE

Confidential, NJ

Infomatica Developer and Support

Responsibilities:

• Understanding the Business requirements based on Functional specification to design the ETL methodology.
• Extensively used Informatica Designer to create and manipulate source and target definitions, mappings, mapplets, transformations, re-usable transformations..
• Followed Star Schema approach for loading through ETL mappings into the data warehouse
• Created different transformations such as Joiner Transformations, Look-up Transformations, Rank Transformations, Expressions, Aggregators and Sequence Generator.
• Created tables, views, synonyms, stored procedures and test data.
• Extracted source data from Mainframes, Oracle and Flat files using Informatica, and loaded into target Database.
• Developed mappings involving SCD Type-I, Type-II mapping in Informatica to load the data from various sources.
• Validate the data in warehouse and data marts after loading process as per requirements.
• Worked closely with the business analysts team for adhoc changes and during testing and validations
• Involved in monitoring jobs in production environment
• Involved in Incident, Problem and Change management process
• Participated in internal application audits on annual basis and learnt to maintain application and documentation in secured and audited manner.
• Handled knowledge transition sessions during application migrations and reviewing documentation and changes being implemented.
• Worked with team and helped in resolving the issues on need basis.
• Participated in Disaster recovery operations and application testing according to planned schedule
• Involved in impact analysis for any changes coming into production for existing workflows and ensured end to end testing in appropriate environments
• Participated in SIT and Regression test cycles of the application on half yearly basis.
• Gathered batch statistics, database space consumption metrics on monthly basis to analyze the time taking jobs and space requirements as per the consumption
• Keep updated share point with up to date documentation and issue log inventory with fixes.

Confidential, California

ETL Developer

Responsibilities:

• Closely worked with the clients to understand the business use of the requirements.
• Estimated efforts, converted requirements into design documents, technical specification documents, helpful for the team in code development.
• Conducted data analysis, handled ongoing requests by client. lnvolved in release schedule discussions, parallel development and implementations
• Developed SQL, UNIX scripts to be used in ETL processes to full fill the requirements
• Migrated code into QA environment and supported QA and User acceptance testing and validation
• Created detailed Unit Test Document with possible Test cases/Scripts and reviewed with business
• Responsible for coordinating code deployment to production, supported post production issues for the initial few weeks of execution in production
• Worked on scheduling workflows, review, documentation and deployment
• Attended orientation sessions with application architect on project Architecture

Confidential, California

Software Developer

Responsibilities:

• Responsible for developing, support and maintenance for the ETL (Extract, Transform and Load) processes using lnformatica Power Center.
• Wrote SQL- Overrides and used filter conditions in source qualifier thereby improving the performance of the mapping.
• Used various transformations like Filter, Router, Expression, Lookup (connected and unconnected), Aggregator, Sequence Generator, Update Strategy, Joiner, Normalizer, Sorter and Union to develop robust mappings in the lnformatica Designer.
• Attended meetings involving Data modelers and Business Analysts to understand the requirements and the changes if any to existing processes
• Worked on ETL design/specification documents for the project
• As part of the ETL process, extracted data from Flat files, Mainframe files, SQL and Oracle source to build the operational data staging layer, implemented business logic to load the data further into Data store lnvolved in working with complex source qualifier queries, pre and post SQL queries at mapping and session level.
• Created reusable objects like mapplets, involved in creating complex and robust mappings and Mapplets using mapping designer. lmplemented technical lead and/or architect recommendations, methodologies and best practices.
• Created documentation to describe ongoing program development, business to technical logic, coding, testing and fixing
• Migrated the code into QA environment and supported QA and UAT testing and validation
• Created detailed Unit Test Document with possible Test cases/Scripts and reviewed with business.
• Involved in reviewing and identifying mappings that require performance enhancement and participated in performance tuning process lnvolved in Production support turnover and warranty support to resolve initial production issues and failures
• Worked as an active team member, under broad guidance with independent planning & execution responsibilities