SUMMARY:

• Have 10+ years of experience in Information Technology industry
• Experience in development and maintenance of Enterprise Data Warehouse Applications for about 10 years.
• Have good technical proficiency in Data warehousing technologies viz., ETL (Informatica), Teradata, OLTP DB (Oracle)
• Have experience as Informatica developer and administrator.
• Worked and engaged Informatica Product support to work on product specific issues
• Have experience in implementing ETL Process using Informatica PowerCenter, Power Exchange
• Worked extensively on Informatica PowerCenter client tools in different versions
• Experienced in Installation, Configuration, and Administration of Informatica PowerCenter 9.x and Power Exchange
• Experienced in integration and transforming of various data sources from Databases like Teradata, Oracle, DB2, SQL Server and formats like flat - files, COBOL files, XML, etc.
• Proficient in developing mappings using different transformations in Informatica PowerCenter to implement ETL process
• Well-versed with the concepts of dimensional modelling for Data Warehouses
• Ability to work well in team environment and also independently.
• An effective team leader and communicator with strong interpersonal, leadership andRelationship management skills.
• Excellent communication (oral and written), client interaction and inter-personal skills.

TECHNICAL SKILLS:

ETL Tools: Informatica PowerCenter, Power Exchange

Operating Systems: AIX, HP UNIX, Windows NT/2000/XP

Languages: SQL, Oracle PL/SQL, C, C++

Scripts: UNIX Shell Scripting

Database: Teradata, Oracle 10g/11g

OtherTools: Control-M, Toad, Maestro (Job Scheduling), JIRA, Share Point and Cognos

PROFESSIONAL EXPERIENCE:

Confidential, Columbus, Ohio

Sr. Lead Informatica developer/Admin

Responsibilities:

• Interacted with Data Analysts and reviewed the profiling results in the Informatica analyst and worked closely with the BA’s and DA’s to define Functional and Informatica mapping Specifications. Participated in the Design team meetings and prepared technical and mapping documentation.
• Created/modified and consolidated various type-I, type-II dimensional mappings and workflows for the successful migration of the data from various source systems to IDW which meets the business requirements for reporting and analysis.
• Extensively used various Teradata features like TPT Export, TPT reader, TPT load, Teradata Query Banding, etc.
• Worked on Teradata Fastload, Multiload and Bteq scripts
• Extensively used Pushdown Optimization in Informatica for doing superfast loads.
• Parameterized various key variables to provide configurability and re-usability for the Informatica workflows developed.
• Optimized the performance of the mappings by various tests on sources, targets and transformations. Identified the Bottlenecks, Removed the Bottlenecks and implemented performance tuning logic on targets, sources, mappings, sessions to provide maximum efficiency and performance.
• Implemented error handling routines in the Informatica mappings to capture anomalies in the source data and send notifications as needed.
• Actively coordinated with testing team in the testing phase and helped the team to understand the dependency chain of the whole project.
• Responsible for authoring project deliverables like mapping specifications, knowledge transfer documents, Run Books and helped production support team get up to speed.
• Installation, Configuration& Administration of Informatica Power Center 9.x and Power Exchange
• Setup and configure PowerCenter domain, grid and services
• Identify root cause and implement resolution for production processing issues
• Perform object deployments on versioned repositories from lower to higher environments
• Setup and administer PowerCenter security
• Coordinate PowerCenter technical review/approval before on-boarding new projects to shared platform
• Work with Informatica product support to resolve critical issues identified by developers and get EBFs for product bugs.
• Apply EBFs received from Informatica in all environments
• Involved in POCs as part of Informatica COE and suggest best practices for developer community
• Worked on health check jobs to keep the environment clean and efficient
• Upgrade PowerCenter from version 9.1.0 to 9.6.1

Environment: Informatica PowerCenter 9.x, Oracle 11g, AIX, Control-M,Teradata

Confidential

Senior Application Developer

Environment: Informatica PowerCenter 9.1, Teradata 13.0, AIX, Control-M

Responsibilities:

• Communicating with BA team for gathering the requirement and preparing business rules
• Integration and transforming of various data sources from Databases like MS Access, Oracle, DB2, SQL Server and formats like flat-files, COBOL files, XML, etc.
• Involved in design discussions and creating design documents
• Created Informatica mappings as per business rules and to load data.
• Designed and developed complex mappings by using Lookup, Expression, Update, Sequence generator, Aggregator, Router, Stored Procedure, etc., transformations to implement complex logics while coding a mapping.
• Worked with Informatica power center Designer, Workflow Manager, Workflow Monitor and Repository Manager.
• Development of reusable Mapplets using Informatica Power Center Designer.
• Prepared SQL queries to reconcile data between existing EDW (legacy) system and ICDW environment.
• Developed Unit Test cases for semantic mappings and tested.
• Closed defects during system testing.
• Created the Implementation plans and schedules (Run book document) to move the code to higher environments.
• Created Control-M drafts as per the requirement specification for all environments
• Documenting project specific documents.

Confidential

Sr. ETL developer

Environment: Informatica PowerCenter 7.1.1, Oracle9i, UNIX

Responsibilities:

• Analyze the impact of source side changes on the ETL code
• Understand the ETL requirements
• Develop new mappings as required or change the existing ones
• Unit test the ETL code developed/changed
• Perform System Integration Testing once all the development part is done

Confidential, Irvine, CA

ETL developer

Environment: Informatica PowerCenter 8.6, Oracle10g, UNIX

Responsibilities:

• Coordinate with the onsite team to get the ETL requirements and understanding the ETL specifications
• Designed and created mappings/sessions/workflows to move data from source to staging and then from staging to the Data Warehouse
• Worked extensively on Informatica Client tools: Designer, Workflow Manager, Workflow Monitor extensively
• Worked on different transformations like Expression, Filter, Joiner, Lookup, Sorter, Router, Update Strategy, Stored Procedure, etc. provided by Informatica to build mapping with embedded business logic
• Configuring Sessions in Workflow Manager
• Debug the sessions by utilizing the logs of the sessions and monitor the workflows
• Wrote SQL queries on the source databases to validate target data
• Perform unit testing at various levels of the ETL
• Created test case documents, mapping specification documents, etc.
• Created documentation on the design and development of the mappings
• Involved in peer review of mappings created by the off-shore team
• Timely and error-free delivery of ETL mappings

Confidential

PL/SQL Developer

Environment: Oracle9i, UNIX, PL/SQL, Toad

Responsibilities:

• Understand the Technical specification document
• Involved in writing packages, procedures, functions and triggers in PL/SQL while developing application program modules
• Worked extensively on cursors, PL/SQL tables and other user defined data types
• Created test case documents and defect logs
• Involved in writing shell scripts
• Involved in peer review of the code developed by the team
• Ensured timely and error-free delivery of the code

Confidential

ETL Developer

Environment: Informatica PowerCenter 7.1.1, Oracle9i, UNIX

Responsibilities:

• Understanding the ETL specifications
• Designed and created mappings/sessions/workflows to move data from source to the Data Warehouse
• Worked on Informatica Client tools: Designer, Workflow Manager and Workflow Monitor extensively
• Worked on different transformations like Expression, Filter, Joiner, Lookup, Sorter, Router, Update Strategy, Stored Procedure, etc. provided by Informatica to build mapping with embedded business logic
• Configuring Sessions in Workflow Manager
• Debug the sessions by utilizing the logs of the sessions and monitor the workflow