PROFESSIONAL SUMMARY:

• Extensive work experience with a strong background in Data Warehouse, Data Mart, Data Integration and Operational Data source using ETL tools.
• Established and implemented ETL best practices and guidelines by creating high performance and highly scalable ETL designs.
• Excellent experience on Data migration, Data Extraction, Data cleansing and Data staging of operational sources using ETL processes.
• Actively participated in Performance Tuning, Backup and Recovery strategy, worked on the entire development life - cycle.
• Worked extensively on several complex mappings involving Slowly Changing Dimensions (Type I, Type II and Type III) to maintain current, previous and full history.
• Designed and worked in various Transformations of ETL Informatica, Look-Up, Update Strategy, Stored Procedure, Transactional Control, Data Transformations, XML Transformation and Java Transformation.
• Involved and developed ETL Architecture/Processes against high volume and complex data with various sources and targets like COBOL, Oracle, Flat files, XML files and MS SQL Server.
• Extensive experience working with Informatica, Oracle, SQL and UNIX.
• Proficient in performing and supporting Unit testing, System Integration testing and production support for issues raised by application users.
• Actively worked in the full software development life cycle (SDLC) of the data warehouse building process including Dimensional modeling, ETL and Migration, primarily using Informatica Power Center.
• Skillful in developing code using SQL and PL/SQL to implement the business logics.
• Ability to co-ordinate with off shore team and able to delegate work to offshore team and plan/track tasks/activities.
• Highly motivated, result oriented professional with a short learning curve and phenomenal communication skills.

TECHNICAL SKILLS:

ETL Tools: Informatica Power Center (10.x/9.x/8.x). (Repository Manager, Mapping Designer, Workflow Manager and Workflow Monitor).

Data warehouse Concepts: Star & Snowflake Schema, Dimensional Modeling, Metadata Management, Data Staging and Data Mart.

Operating System: Windows Family and UNIX(Sun Solaris and HP)

Languages: SQL, PL/SQL, HTML, Unix Shell scripts.

Databases: Oracle 10g/11g/12c, MS SQL server 2008/ and MS Office/Access.

Scheduler: Autosys

PROFESSIONAL EXPERIENCE:

Confidential, CA

ETL developer

Responsibilities:

• Gather requirements, analyze, design, and implement data warehouse solution to meet the business and project’s requirements
• Model physical, logical, business and dimensional models using ER Studio to support Data warehouses, Data marts and Reporting systems
• Analyze data from source systems and implement the transformations to build Data warehouse and Data marts using various ETL tools
• Participate in planning, and Agile project delivery of processes
• Work closely with Product owners to gather functional specifications and turn them into technical specifications.
• Design and implement data auditing to find the bad data and reprocessing mechanism
• Coordinating with DBA team to plan the disk, file & table space allocations and keep track of database growth and performance.
• Review performance of various components in the Data Warehouse, and improve performance of ETL Components
• Perform code review and co-ordinate with all teams involved in the project
• Prepare test plans for unit, integration, system, and regression tests and perform testing at various stages of project life cycle. Help users with User Acceptance Testing.
• Involve in production deployment and conduct post-implementation reviews.
• Provide user training, documentation and transition to support team.
• Collaborate with Functional analysts for requirements gathering, analysis of functional requirements to help in designing the data warehouse
• Investigate and correct production issues encountered during and after implementation like adding command tasks.
• Ensure all applications have been loaded successfully on a daily basis meeting SLA’s.
• Provide daily and weekly status reports on the failures, issues and bug fixes
• Plan and execute the enhancements to the Production Code
• Use various tools and technologies for successful project deliverables.
• Co-ordinate the effort between Offshore and Onshore team
• Tune the various applications to improve the performance

Environment: Informatica Power Center 9.5.1/8.6.1 (Source Analyzer, Warehouse designer, Mapping Designer, Transformation Developer, Mapplet Designer, Repository Manager, Work Flow Manager), Oracle 11g/12c, Denodo, SSIS, Sql Server and Unix.

Confidential, CT

ETL Developer

Responsibilities:

• Designed mappings using the transformations Joiner, Aggregator, Expression, Lookup, Router, Filter, and Update Strategy transformations and Mapplets to load data into the target.
• Extensively used Informatica 9.1 in loading data from Flat Files, sources and Oracle.
• Used Normalizer transformation while loading the data from the COBOL copy books to the staging area.
• Responsible for creating shared and reusable transformations in Informatica shared folder and update the objects with the new requirements and changes.
• Documented user requirements, translated requirements into system solutions and develop implementation plan and schedule.
• Created packages and stored procedures for balancing and error handling by working on oracle Exadata.
• Extensively worked on developing the Unix scripts and JIL scripts for Autosys jobs.
• Created shell scripts for atomization of job such as to move the file from one server to another, to start informatica work flow using pmcmd command.
• Responsible for various testing which involves unit testing and integration testing.
• Worked on various applications like Ultra Edit, Telnet, putty, Autosys and Toad.
• Fine-tuned the logic in Procedures, Functions and Triggers for optimum performance.
• Involved in coordinating with the release teams at the time of deploying/promoting the code to QA/Production.
• Actively involved from the end to end cycle and have been part of every aspect of the project, development - QA- Production - Maintenance.
• Highly involved in closely monitoring the production jobs while in production support.
• Written PL/SQL Procedures and Functions for Procedure Transformations.
• Responsible for meeting the deliverables as per the schedule.
• Actively Co- Ordinate with the off-shore team to track the assigned tasks and updates.

Environment: Informatica Power Center 9.1/8.6.1 (Source Analyzer, Warehouse designer, Mapping Designer, Transformation Developer, Mapplet Designer, Repository Manager, Work Flow Manager), Ultra Edit, Telnet, Toad, Autosys, Oracle 10g, PL/SQL,SQL Server2008.