SUMMARY:

• 9+ years of experience in IT industry. He has been exposed to Informatica, Oracle, Netezza and UNIX shell scripting.
• Strong IT experience in Data warehousing and Business intelligence with emphasis on Business Requirements Analysis, Application Design, Development, testing, implementation and maintenance of Data Warehouse and Data Mart systems in the Life science, Telecom and Insurance industries.
• Having good exposure to MDM Remediation to ETL project and having sound knowledge in the MDM concepts like Match/Merge rules.
• Involved in Development and design of ETL (Extract, Transform and Loading data) methodology for supporting data transformations and processing, in a corporate wide ETL Solution using Informatica Power Center (9.x/8.x)
• Extensively Worked on Informatica Designer Components - Source Analyzer, Target Designer, Transformations Developer, Mapplet and Mapping Designer.
• Strong experience on Workflow Manager Tools - Task Developer, Workflow & Worklet Designer.
• Extensively worked on Informatica Advance Techniques - Dynamic Caching, Pushdown Optimization, Parallel Threading to increase Performance throughput.
• Having good exposure in root cause analysis for complex logics by using SQL query.
• Having good exposure to create a procedure to implement the logic used by MDM for Match/Merge rules and Having good understanding about the Delta file feed from MDM.
• Involved in complete Software Delivery Life Cycle (SDLC) in large data warehouse environment.
• Experience in identify, research and resolve ETL production root cause issues. Experience in maintenance, enhancements, performance tuning of ETL code.

TECHNICAL SKILLS:

Operating System: Windows 98/XP/2000/Vista/7/ 8/10, UNIX

Technology: Datawarehousing

Programming Languages: C, HTML, UNIX Shell Scripting

Databases: Oracle 9i, 10g, 11g, Netezza 4.6.5, Teradata

Tools: Informatica Power Center 8.6.0, 9.0.1, 9.6.1

Other Utilities: WinSCP, Putty, Oracle SQL Developer, TOAD

PROFESSIONAL EXPERIENCE:

Confidential, Phoenix, AZ

ETL Lead developer

Operating System Windows 7 & UNIX

Tools: / DB / Script Informatica, Oracle & UNIX Shell Scripting

Role and Responsibilities

• User Requirement gathering and converting the same into Functional and Technical Specifications.
• Actively involved with BSAs and SMEs and Analyst to resolve the ambiguities in the requirements and participate in gathering of business requirements and carry out a suitable data Model for DataMart.
• Follow good security coding practices to ensure the application is free from most common coding vulnerabilities. Provided architectural design for Informatica.
• Involved in System analysis, Estimations and design enhancements.
• Participated in High Level design discussion and worked throughout the design cycle.
• Lead offshore development team of 4 members and interaction with client on daily basis.
• Develop the XML generation using Informatica and able to interpret the XSD definition and modify the XSD in order to work in Informatica.
• Able to understand and generate the XSD definition.
• Participate in code reviews.
• Identifying performance bottlenecks and fine-tuning ETL mappings and workflows for performance. Created scripts for automating dropping-recreation of warehouse table indexes for bulk loads.
• Participate in transitions of the application or technical architecture components to the testers. Provide a fix for any defects and performance issues discovered in testing.

ETL Lead developer

Operating System Windows 7

Tools: / DB / Script Informatica, Oracle & UNIX Shell Scripting

Role and Responsibilities

• Perform the detailed design of application and technical architecture components.
• Presented all of the Informatica tools to the Client, its usage, advantages and disadvantages for them to make up their mind to proceed with specific tools of Informatica.
• Actively involved with BSAs and SMEs and Analyst to resolve the ambiguities in the requirements and participate in gathering of business requirements and carry out a suitable data Model for DataMart.
• Work with the business architect and other planners to assess current capabilities and identify high-level business requirements.
• Confirm the design with the stakeholders to ensure that the design satisfies the requirements. Work with other developers, designers, and architects to make sure that the configuration and Custom components meet application requirements and performance goals.
• Follow good security coding practices to ensure the application is free from most common coding vulnerabilities. Provided architectural design for Informatica.
• Documented ETL requirements and translate the Business logic into ETL language.
• Participate in code reviews.

ETL / DI Lead developer

Operating System Windows Vista

Tools: Informatica, Oracle & Netezza

Role and Responsibilities

• Created Integration Requirements and Design Specification Document.
• Provided architectural design for Informatica.
• Defined and designed flow and standards for Informatica.
• Worked closely with data population developers, multiple business units and a data solutions engineer to identify key information that enhance business decision-making.
• Documented ETL requirements translation of Business logic into ETL language.
• Lead the offshore team of ETL Developers for Customer Master Module and providing them with in depth understanding of the Architecture, ETL system design and requirements.
• Involved in designing the Data warehouse based on the requirement document using Informatica Power Center 9.0.1.
• Extensively worked with flat files and excel sheet data sources. Wrote batch scripts to automate flat file transportation local to Informatica server.
• Utilized worklets to trigger job execution based on flat file availability for file sourced mappings. Scheduling and automating jobs to be run in a batch process.
• Used Deployment group migration.
• Trouble shooting and resolving issues in workflow objects.

ETL Architect / Senior DI developer

Operating System Windows Vista

Tools: Informatica, Oracle, UNIX

Role and Responsibilities

• Gathered requirements from users and document the sessions during the inception/Analysis phase of the project.
• Followed best practices of the waterfall model / spiral model of SDLC practices.
• Actively involved with BSAs and SMEs and Analyst to resolve the ambiguities in the requirements and participate in gathering of business requirements and carry out a suitable data Model for DataMart.
• Analysed the requirement and provide the inputs to Offshore Team.
• Having good understanding on the Data model and able to create a flow for Data Model as target based on existing source system
• Understanding how MDM works and how to remediate Customer Master, Product Master, Territory Master and Employee Master.
• Understand/Develop the logic of Xref tables and Master table used in MDM and how can be able to integrate with ETL.
• Understand/Develop the logic of Match/Unmerge rule works and how it will impact the flow of business.
• How to get rid of the records which is really needs to be Merged or Unmerged by discussing with Data Steward team
• How to handle the delta change in the files and understand the logic behind the record IND.
• Have very good understanding of Informatica 9 version including new features.
• Having good
• Studied the current OLTP system to understand the existing data structures.
• Used Deployment group migration.
• Trouble shooting and resolving issues workflow objects.
• Workflow errors that require service request to Informatica for problem resolution.

Senior ETL developer

Operating System Windows Vista

Tools: Informatica, Oracle, UNIX

Role and Responsibilities

• ns and database connection management and workflow monitoring.
• Informatica environment administration. Creating users and groups, configuring profiles and privileges. Configured folders and folder security. Configured shared folders for re-usable objects.
• Fixing invalid Mappings, modifying and testing coded procedures and functions, Unit and Integration Testing of Informatica sessions, batches and target Data. Created PL/SQL packages for iterative costing calculations
• Developed Mappings for loading data from Multiple Sources into Oracle tables.
• Perform daily operations of the EDW and related systems, user admin, interface processing and release management, disaster recovery.
• Automating all the loads with the scheduling tool AutoSys
• Provide Production incident and Production monitoring services
• Resolving production incidents in the ETL as per the agreed SLA.