SUMMARY

• He is a programmer/Developer Lead with over 13 years of IT experience in data warehousing specialized in Informatica Power Center.
• He is currently working as an ETL Lead and has worked on various modules involving data warehousing platforms like Structured Querying, Extract Transform and Loading(ETL), Business Objects, Cognos Reporting, DB2 database, Postgre SQL, UNIX etc.He has worked extensively on Informatica Power center Client tools like Designer, Workflow Manager and Workflow Monitor and has good exposure in Data warehousing concepts, and also worked with BMC Control M scheduling tool for monitoring the Informatica jobs.
• He is well known in the team for his ability to learn new technologies and easily adapt to new environments.
• He demonstrated excellent technical and leadership skills in end - to-end project execution in ETL/ Data Movement space at the client side and displayed a strong motivational and empowerment skills well supported by strong communication and relationship management skills for effective Onshore/ Offshore team management.

TECHNICAL SKILLS

Programming Languages: UNIX Shell programming, Pig, Hive, Informatica, Business Objects, Core Java, SQL, PL/SQL, knowledge on Mainframes

Environment: Business Intelligence, Mainframes, Hadoop

Database: IBM DB2, Oracle, MS Access, Postgre SQL, Hive, NoSQL

Internet Tools: HTML, TRAC, TestLink, Lotus Notes, Rational Software Architecture, WinSQL, IBM Optim, Data Flux Data Management Studio, Informatica

Operating Systems: IBM Mainframes, zOS, DOS, UNIX, LINUX, Windows

Other: Agile/SAFe Methodology, SAFe 4 Certified Agilist, PMP Certified

PROFESSIONAL EXPERIENCE

Confidential

Informatica Developer/Lead

Responsibilities:

• Studying the existing environment and gathering business requirements with the help of the Business Analysts.
• Developing ETL Mappings in Informatica as per the Business Logic.
• Self-Review and Peer to Peer review of the Mappings, Workflows, Scripts, and other code developed by the developers.
• Mentoring and Monitoring day-to-day work of the subordinates, providing leadership and mentoring to create and maintain a collaborative, motivated and positive team atmosphere.
• Monitor and report on progress towards achievement of plans and strategies and also, regularly review work processes for areas of improvement.
• To create high level technical design documents for all hierarchies with all the components involved.
• Review of Design, Test Cases and source code.
• Unit Test Report (UTR’s) preparation.
• Provide support to the customer for migrating, executing and unit testing developed objects to successive environments till production.

Confidential

Sr. Developer/Lead

Responsibilities:

• Reporting to the Manager and manage a large team of on-shore resources to perform the coding and development of the workflows and job applications.
• Manage personnel, tools, processes and schedules to deliver ten releases per year across all the applications.
• Inherited two cross-functional teams and through team-building, cross-training and skills building, created a single team of professional coders and developers
• Working close with the vendor test leads and monitoring the deliverables.
• Collecting the Business Requirements from the business people and analyzing them.
• Reviewing business requirements document and technical specifications.
• Involved in Database/Unit Testing.
• Responsible for mining the data required for the test execution.
• Used TRAC tool for defect tracking, reporting and resolving the bugs.
• Interacted with Business Analyst, Database Administrators, development team and End Users.
• Daily review meetings are organized to review the testing status.
• Created Re-usable queries so that these can be shared with the vendor teams for their execution.
• Used PostgreSQL extensively for on-platform execution.

Confidential

Informatica Developer

Responsibilities:

• Collecting the Business Requirements from the business people and analyzing them.
• Reviewing business requirements document and technical specifications.
• Prepare high level and low-level design documents and develop Informatica code for complex scenarios.
• Onsite/Offshore coordination/requirements clarification
• Attending Architecture and Design review sessions
• Create Unit test cases, Integration test cases and fix defects
• Planning and tracking the development tasks.
• Conduct Defect Prevention meeting in a periodic basis and note down the minutes and action items.
• Providing industry best practices to improve performance and data cleansing techniques where ever necessary across the data warehouse.
• Repeating the Individual modules and Integration testing cycles after bug fixes.
• Schedule mappings using Control M Automation tool

Confidential

Informatica Developer

Responsibilities:

• Understanding the Conceptual design.
• Involved in ETL designing in terms of best approaches to be followed considering underlying databases and business requirements.
• Analyzed Oracle and DB2 data using SQL scripts.
• Support the Business team to resolve the data issues and business clarifications about any defects.
• Converting business requirements into technical specifications, and detailed mapping documents.
• Created complex mappings using different transformations like Source, Target, Expression, Normalizer, Aggregator, Lookup, Router, Update strategy, Filter and Stored Procedure transformations.
• Created various tasks like Assignment, E-mail, Control and Decision etc…
• Used debugger to test mappings and fixed the bugs.
• Optimized/Tuned mappings for better performance and efficiency.
• Implemented persistent cache to reuse caches and to improve the performance.
• Interacting with the client on various forums to discuss the status of the project, clarify any queries regarding the functionality etc.

Confidential

Informatica Developer

Responsibilities:

• Understanding the Conceptual design.
• Involved in ETL designing in terms of best approaches to be followed considering underlying databases and business requirements.
• Analyzed Oracle and DB2 data using SQL scripts.
• Support the Business team to resolve the data issues and business clarifications.
• Converting business requirements into technical specifications, and detailed mapping documents.
• Created mappings using different transformations like Expression, Aggregator, Lookup, Router, Update strategy, Filter and Stored Procedure transformations. Also created reusable transformations like Lookup, Expression and Stored-Procedures.
• Created various tasks like Assignment, E-mail, Control and Decision etc…
• Used debugger to test mappings and fixed the bugs.
• Optimized/Tuned mappings for better performance and efficiency.
• Implemented persistent cache to reuse caches and to improve the performance.
• Involved in creating of test plans and migration plans for moving the application from development, Test and then into production environment.
• Interacting with the client on various forums to discuss the status of the project, clarify any queries regarding the functionality etc.

Confidential

Informatica Developer

Responsibilities:

• Extensively involved in Data Extraction, Transformation and Loading (ETL process) from source to target systems using Power Center of Informatica.
• Develop an understanding of business functions supported by the applications, analyze data from source systems and design complete ETL processes.
• Creation and Modification of Reusable Transformations and Mapplets.
• Extensively used the transformations such as Update Strategy, Aggregator, Stored Procedure, connected Lookup, unconnected lookup, Expression, and Filter during mapping in the Designer tool of Informatica.
• High performance tuning of cache management done to control millions of record’s cardinalities. Optimization is done on different level like source, target, mapping, session cache & by partitioning data as well as flow.
• Developed complex Informatica mappings based on the requirements.
• Performed extensive debugging.
• Created workflows using session, event wait, and event raise and worklet task.
• Worked with the testing team to validate the business logic and to move into production.
• Worked on production support