SUMMARY:

• Having 7+ years of Experience in AscentialDatastage Parallel Extender/PX.
• Having strong knowledge on extracting data to stage and then to Cleanse, Process and Loading into Data Warehouse and then Data Marts.
• Having Knowledge on Cognos Planning.
• Extensively worked on Agile and Waterfall methodologies.
• Implemented various ETL solutions as per the business requirement using Datastage 11.x/8.x.
• Involved in all aspects of the product development lifecycle (business requirements, functional specifications, architectural specifications, development, test plans, and documentation).
• Experience in developing strategies for Extraction, Transformation and Loading (ETL) data from various sources into Data Warehouse and Data Marts using Datastage.
• Experienced in integration of various data sources like Oracle 11g/10g/9i/8i, MS SQL Server 2008/2005, Teradata, XML files, DB2, Mainframe COBOL sources into staging area and different target databases.
• Experienced in defining data quality, data warehouse, Data Migration and Data Integration, Star/Snowflake Schema Designs with requirements analysis - definition, database design, testing and implementation, and Quality process.
• Extensive Knowledge in creating SCD Type I, Type II, Type III. Successfully managed operations on Datastage Enterprise Data Warehouse (EDW) including creation, designing, development, implementation, and testing.
• Proficient in shell scripting.
• Experience in Autosys scripting and Job scheduling.
• Experience in working with both DB2 and Oracle databases.
• Leading ETL applications for Disaster recovery planning and exercise.
• Co-ordinate with vendor and BAs to support and maintenance of various applications.
• Managing and allocating the tasks among the team members and tracking them to closure.
• Facilitates project team meetings, manages agendas and meeting recaps to ensure all project tasks and goals are being accomplished as expected.
• Managed Onsite-offshore model.
• Excellent communication and interpersonal skills, ability to learn quickly, good analytical reasoning and high adaptability to new technologies and tools.
• Strong Team working spirit and relationship management skills.

TECHNICAL SKILLS:

ETL Tools: Datastage v7.5, 8.1,8.5, 11.3

Languages: C, C++, C#.Net,SQL,Java, SQL, Shell Scripting and PL/SQL Basics.

Databases: Teradata 6.x/14.x, Oracle 11g/10g/9i, DB2, SQL Server 2005/2008

Quality Assurance: Manual Testing

OS: Windows 2000/XP, Unix

Scheduling Tool: Autosys

Miscellaneous: Hadoop Concepts,DAC, Star Team, Autosys, TD Viewpoint, Sharepoint,Serena Tool, ACCE Tool, Service Now, Git Lab

PROFESSIONAL EXPERIENCE:

Confidential

Application Programmer

Environment: Data stage 8.1,8.5,11.3Informatica 8.6.1/9.5.1, Teradata,Oracle,Unix,CA7 & Autosys.

Responsibilities:

• Define the scope of business requirement and effectively mapping those into Requirement Specification Documents.
• Create Logical Data Model for the required application using the Data warehousing concepts.
• Create and review Application Design Document and Application Technical Specification. Understanding the high level design and create an efficient low level design using the technical knowledge of Datastage tool. Review the technical specifications prepared by peers.
• Create and Review Application Mapping document to do a source system analysis and hence prepare a source to target mapping document applying the business rules and logics.
• Database query tuning & performance tuning. To tune the queries used in Datastage jobs so as to improve the performance of the application.
• Coordinate with the Client Technical team to identify issues and risks and work proactively to eliminate them.
• Provide advanced consulting to the offshore development team helping them implement the ptimized application.
• Conduct the proof of concept for the business and helping them conduct the 'User Acceptance Test' of the delivered application.
• Review system test cases, Codes prepared by offshore development team to ensure a quality delivery.
• Assist Project Manager on status report. Prepare weekly/monthly & quarterly status reports on the development of the project. Lead the team to deliver Interfaces on time. Adhere to the project plans and work to complete the project within stipulated timelines.
• Document the lessons learnt for each project, understanding of the legacy system, application architecture, flow and best practices to mentor / train the new team members.

Confidential

E.T.L Developer

Environment: Data Stage v8.1, Mainframe, Unix, Windows XP, Java

Responsibilities:

• Design and develop the ETL jobs for transforming, integrating, and loading data using Data Stage Designer.
• As per file changes, model changes/mapping document design and develop the jobs using Datastage tool and develop the scripts using UNIX.
• Prepare test cases, according to the business logic provided by the client and test all the jobs to fulfill the requirements.
• Responsible to perform the analysis for various enhancements, perform impact analysis to find ut the systems/programs that could be potentially affected by proposed change(s), coding, and testing and implementation activities.
• Working on defects raised by testing team and identifying the route cause and giving the final solution to resolve the issue and made them to close the defects.
• Understanding the business rules completely and implementing the data transformation methodology.
• Extensively used different Stages like Transformer, Filter, Look-up, Join, Aggregator, Pivot, Funnel, Sort, Data Set, and CFF Files.
• Prepared unit test cases, Integrated test cases and executed them during CIT & SIT runs in code migration phase. Also a part of UAT by ensuring defects are identified as part of lower environment: testing and delivered Zero Defect code. Supporting SIT, UAT runs and giving the solution if any process/jobs failed.
• Co-ordinated with the upstream and downstream team members to establish a good flow during dependencies.
• Involved in Code reviews like Internal and External reviews, Peer reviews before migrating the code to higher environments.
• Supported testing team during the code walk through and presentations.
• Handled SIT & TT runs during delivery of Code Change.
• Responsible of delivering high quality solutions to client.
• Extensively used the advanced properties of the Datastage stages and also the scripts.
• Analyzed the traditional/manual process followed and developed scripts to automate the existing process.
• Utilized HTML and Mail functionality in order to send reports directly to the consumers in mail without any manual intervention.
• Conduct the meetings with Business analysts and Data analysts.
• Working with other dependent teams to resolve the ongoing issues.
• Develop the Autosys JIL’s and scripts for scheduling the jobs.
• Implementing the Performance tuning techniques to reduce the execution time.
• Participate in development of best practices that contribute to higher quality release
• Imparting technical knowledge to new entrants and fellow team members.
• Developed Job sequences to control Job flow and also call the scripts to run in between the ETL

Confidential

E.T.L Developer

Environment: Data Stage 7.5PX, Oracle 9i, DB2UDB 8.1, Unix, Windows XP, Cognos Planning

Responsibilities:

• Involved in analyzing the business user requirements.
• Worked on Data stage designer for extracting source transactional database and transforming and then load into target database.
• Used Sequential file, Oracle Enterprise,DB2 UDB API, Joins, Look Up, Transformer, Dataset, Change Capture, Aggregator, Remove Duplicate,Merge and Filter Stage for designing the Jobs.
• Developing routines (server) and Created master controlling sequencer jobs using the DataStage Job Sequencer.
• Developed UNIX shell scripts for run the jobs.
• Performed Import and Export of DataStage components and table definitions using DataStage Manager.
• Created Tables, indexes in DB2 Database to Load Data.
• Performed Unit Testing and code review.
• Maintenance & bug fixing, resolving defects.
• Provided support including off-hour on DataStage issues.