SUMMARY

• 9+ years of experience in Data Warehousing specialized in INFORMATICA.
• Responsible handling end to end data warehousing application in Informatica for the Extraction Transformation and Loading (ETL).Exposure to designing Dimensional models for OLAP and OLTP. Working primarily on Informatica and responsible for Analysis, Design, Development, Implementation, Testing and Support of Data Warehousing and Data Integration Solutions using Power center.
• Strong architectural expertise in databases like Oracle, SQL Server and extensive query language programming experience working on business applications, data migrations, custom Interfaces across various applications.
• Hands on experience working on UNIX, creating and debugging shell scripts.
• Agile trained and transitioned to Agile Methodology - operating in Sprints. Strong business understanding of verticals like Retail and Energy domain.
• Ability to work on multiple small projects simultaneously, multi-tasking and balancing work based on priority. Project management and prioritization skills, ability to communicate well with people at all levels.
• Possess excellent problem solving, inter-personal and communication skills, ability to work as a team member, resourceful and self-starter with minimal hand holding required.

TECHNICAL SKILLS

Database: SQLServer 2017, Oracle 12c.

Operating System: Windows, Unix,Linux

Reportingand AnalysisTools: Informatica, SSIS 2005, SSRS 2005, MSTR basics.

PROFESSIONAL EXPERIENCE

Confidential

Senior ETL Developer

Responsibilities:

• ETL scoping of the upgrade- Data analysis using existing design.
• Leading the ETL team and guiding the offshore team through project understanding and work allocation.
• Dimensional modelling of existing system to a better hierarchical structure bringing in snow flaking modelling and building relationship within entity structure.
• Development of informatica objects to enable initialize and incremental activities of CRM entities.
• UNIX Scripting - for file delta capture and file handling from CIS- Mainframe.
• Reviewed and analyzed functional requirements, mapping documents, problem solving and trouble shooting.
• Performed unit testing at various levels of the ETL and actively involved in team code reviews.
• Identified problems in existing production data and developed jobs to correct them.
• Agile functionality - following and enabling sprint activities.

Software: Informatica9.5, Unix, SQL Server 2017, JIRA.

Confidential

Senior Developer / Administrator

Responsibilities:

• Sole responsible leading the data warehouse design enhancements, development, implementation and maintenance of development, test and production environments.
• Organized meetings and interacted with various Business users, functional, technical teams and system experts as part of Business analysis, requirements gathering, development, testing and final releases.
• Worked in different roles from designing the data models, configuring the data warehouse environments, administrating the data warehouse repositories, creating the ETL mappings, releasing the product to the end users, supporting various clients during the installation and post installation issues and other product related questions.
• Created technical documents, mapping documents, end user documentation.
• Worked on Informatica Power Center tools- Designer, Workflow Manager, and Workflow Monitor.
• Worked on Dimensional modeling (Star Schema) of the Data warehouse to design the business process, dimensions and measured facts.
• Used various transformations like Filter, Expression, Sequence Generator, Joiner, Stored Procedure, look up, and Union to develop mappings and mapplets in the Informatica Designer.
• Worked on different tasks in Workflows like sessions, events raise, event wait, decision, e-mail, command, worklets, Assignment, Timer and scheduling of the workflow.
• Created sessions, configured workflows to extract data from various sources, transformed data, and loading into data warehouse.
• Used Debugger to test the mappings and fixed the bugs.
• Wrote UNIX shell Scripts.
• Involved in Performance tuning at source, target, mappings, trasformations, sessions, and system levels.
• Admin activities like migration, user profile creation.
• Support of all applications.
• Remedy monitoring.

Software: Informatica9.5 / 9.0, UNIX, Oracle, SQL Server, Control-M.

Confidential

ETL Developer

Responsibilities:

• Involved in the Feasibility Study, Requirement Analysis
• Involved in the Development of ETL Module
• Designing and Developing mappings, sessions and workflows.
• Keeping track of Quality processes.
• Ensuring coordinated Onsite Offshore activities.
• UNIX Scripting and Testing.
• Unit Testing.
• UAT Support.
• Performance tuning of the developed workflows.
• Creating FSD, HLD and Technical specification documents.
• Involved in Coordinating activities between Onsite and Offshore.

Software: Informatica9.1, UNIX, SQL Server, SAMS.

Confidential

System Support

Responsibilities:

• Data warehouse maintenance.
• Worked on critical business enhancements, by gathering requirements, coordinating with the functional team members and coding the business rules.
• Involved in performance tuning of SQL Queries. Worked with RDBMS concepts for creating database objects such as Tables, Stored Procedures, Indexes, Views and Joins.
• Re-engineering and creating UNIX scripts and housekeeping of existing Scripts.
• Warehouse quality check and bug fixes raised by the business, taking care of downtimes both to application and informatica and ensuring data integrity in the warehouse.

Software: Informatica 9, UNIX, Oracle.

Confidential

ETL Developer

Responsibilities:

• Involved in direct communication with Client and Business users to understand the problems/fixes and requirements at large.
• Designed and developed ETL packages to validate, extract, transform and load data from OLTP system, Staging Database to data warehouse.
• Designed and created complex source to target mappings using various transformations inclusive of but not limited to Aggregator, Look Up, Joiner, Source Qualifier, Expression, Sequence Generator, and Router Transformations.
• Writing UNIX script for Dynamic parameter file generation and Housekeeping of old files
• Involved in SIT, OAT, and LIVE code implementations.
• Tuned the performance of mappings by following Informatica best practices and also applied several methods to get best performance by decreasing the run time of workflows.
• Designed workflows with many sessions with decision, assignment task, event wait, and event raise tasks, used Informatica scheduler to schedule jobs.

Software: Informatica8, UNIX, Oracle.

Confidential

Senior Systems Engineer

Responsibilities:

• Offshore lead of 4 developers bridging between onsite and gathering requirements, designing and development of ETL packages and guiding the team members and help resolve issue/show stoppers of any.
• Worked in different roles from designing the data models, configuring the data warehouse environments, administrating the data warehouse repositories, creating the ETL mappings, releasing the product to the end users
• Used various transformations like Filter, Expression, Sequence Generator, Joiner, Stored Procedure, look up, and Union to develop mappings and mapplets in the Informatica Designer.
• Worked on different tasks in Workflows like sessions, events raise, event wait, decision, e-mail, command, worklets, Assignment, Timer and scheduling of the workflow.
• Created sessions, configured workflows to extract data from various sources, transformed data, and loading into data warehouse.
• Used Debugger to test the mappings and fixed the bugs.
• Wrote UNIX shell Scripts & PMCMD commands for backup of repository.
• Involved in Performance tuning at source, target, mappings, trasformations, sessions, and system levels.

Software: Informatica8, UNIX, DB2.

Confidential

Offshore Development Resource

Responsibilities:

• Gathered business requirements, definition and design of the data sourcing and data flows, data quality analysis, working in conjunction with the data warehouse architect.
• Created logical and physical data models using Erwin for new requirements after discussion with technical team and application users.
• Created Informatica Mappings to build business rules to load data using transformations like Source Qualifier, Aggregator, Expression, Joiner, Connected and Unconnected lookups, Filters and Sequence, External Procedure, Router and Update strategy..
• Extensively worked on Mapping Variables, Mapping Parameters and Session Parameters.
• Extensively used Joins, Stored Procedures and Functions in Interaction with backend database using PL/SQL.
• Performance tuning by optimizing the sources targets mappings and sessions.
• Creating UNIX scripts and various batch Scripts for scheduling and loading process.

Software: Informatica8.6

Confidential

Offshore Development Resource

Responsibilities:

• Developed packages to pull data from heterogeneous sources, transform the data per the business requirement and load into the destination tables.
• Transformed the data using different SSIS transformations like Aggregate, split, join, merge, derived column, Multicast, Term extraction and data conversion of SQL Server Integration Services (SSIS).
• Worked with configuration process for dynamic connection string.
• Worked with Job scheduling for Execution of Package in development and Production Environment.
• Responsible for creating and deploying reports in SSRS.
• Documentation and UAT with End User.

Software: SQL Server Integration Services 2005, SQL Server Reporting Services 2005.