SUMMARY

• Solid understanding of ETL design principles and good practical knowledge of performing ETL design processes using Informatica Powercenter 8x - 9x.
• Expertise in ETL design, development and Testing.
• Experience in Data Analysis and providing solutions.
• Experience in ETL tool Informatica Data Transformation 9.1 and UNIX scripting.
• Experience in Informatica Cloud and ETL tool SSIS.
• Experience in working with databases such as Oracle, Greenplum, DB2 and Mainframe JCL’s
• Thorough understanding and involvement in Software Development Life Cycle(SDLC) which includes requirement gathering, designing, implementing, warranty support and testing.
• Experience in preparing Blueprints, High Level Designs, Low Level Designs.
• Performed Proof of Concepts for IDT (Informatica Data Transformation) and Po wercenter webservices and provided recommendations.
• Solid working experience in Insurance, Finance, Banking and Retail domains.
• Supported Sales teams by providing power point presentations on Informatica DT, Informatica Webservices and data masking transformation.
• Resourceful, creative problem-solver with proven aptitude to analyze and translate complex customer requirements and business problems and design/implement innovative custom solutions.
• Excellent team management, leadership, communication and interpersonal skills. Managed small to medium size teams and have delivered many complex projects successfully.
• Good knowledge on Scheduling tools like Autosys, control M and TWS
• Developing Glue based projects utilizing AWS Cloud

TECHNICAL SKILLS

ETL Tools: Informatica Power Center 9.6/9.1/8.6/8.5 , Informatica Data transformation 9.1, Informatica Cloud

Operating Environment: Windows 7/95/98/NT/2000/XP/Server 2008/2010

Tools: & Utilities: Oracle Clients (TOAD, etc.), Putty, ClearCase, IBM Clear Case, WinSQL, SQL Developer, harvest

Databases: Oracle, DB2, SQL Server, Mainframes, Green Plum

Languages: SQL, Unix shell scripting, Mainframe JCLs

Graphics: MS-Visio, MS PowerPoint.

PROFESSIONAL EXPERIENCE

Confidential

Technology Lead

Responsibilities:

• Gather and understand requirements from business partners and business analysts and convert them into low level design and technical specifications.
• Responsible for partnering with requirements team to understand expected functional and non-functional behavior, and to verify that proposed solution design meets those requirements
• Provide Estimation to baseline the size and schedule of the development work
• Gather data to analyze, design, develop, troubleshoot and implement business intelligence Applications
• Create unit test plans, system test plans and integrated test plans and conduct testing in different environments for various business intelligence based applications.
• Facilitate/lead reviews (walkthroughs) of technical specifications and program code with other members of the technical team.
• Team coordination to manage the expectations with MFT (Managed File Transfer) and EDI (Electronic Data Interchange) teams.
• Implementation of ETL solutions and provide warranty support to the existing active applications in production.
• Manage offshore team - Analyze and share the work with developers at offshore. Review their deliverables and provide updates to the project team daily.
• Working closely with release management team, DBAs, Data modelers, Data Architects and testing team during design, development, testing, production implementation and support for the project.
• Proactively identify the risks involved in the project if any and communicate those to the management along with other major project updates on a timely manner during the entire life cycle of a project.
• Reporting of the status of assigned tasks to project manager

Tools: Informatica Powercenter 9.6/10.2, Informatica Cloud, Oracle, Greenplum, DB2, Mainframe

Confidential

Technology Lead

Responsibilities:

• Gather and understand requirements from business partners and convert them into low level design and technical specifications.
• Provide Estimation to baseline the size and schedule of the development work
• Create unit test plans and system test plans and conduct testing in different environments.
• Manage offshore team - Analyze and share the work with developers at offshore. Review their deliverables and provide updates to the project team on day to day basis.
• Implementation of ETL solutions and provide warranty support to the existing active applications in production.
• Reporting of the status of assigned tasks to project manager

Tools: /DBs: Informatica Powercenter 9.1, Oracle, Unix, DB2

Confidential

Lead ETL Developer

Responsibilities:

• Gather and understand requirements from business partners and convert them into low level design and technical specifications.
• Provide Estimation to baseline the size and schedule of the development work
• Create unit test plans and system test plans and conduct testing in different environments.
• Design, code, test, debug and document programs and ETL processes.
• Implementation of ETL solutions and provide warranty support.

Tools: /DBs: Informatica Powercenter 8.6, Oracle, Unix