SUMMARY

• 8 years of experience in ETL tools - Datastage,Informatica, Data Analysis, Datawarehouse Implemention, Data migration, Data Conversion, SQL, PL/SQL
• IBM Certified Solution Developer Infosphere Datastage v8.0
• IBM Certified Designer Cognos 8 BI Reports.
• Extensive experience in Ascential Datastage 9.1/8.7/8.5/8.0.1/7.5. x using Components like Datastage Designer, Datastage Manager, Datastage Director, Datastage Administrator, Information server and Parallel Extender. Designed Mapping documents ETL architecture documents and specifications.
• Strong experience in working with Business Analyst to understand business requirements from business owners in order to transform business requirements into effective technology solutions.
• Extensive experience in ETL tool Informatice 8.6/9.1
• Strong experience in Data conversion from legacy source systems to new target system.
• Analyzed the Source Data and designed the source system documentation.
• Created the data mappings and conversion logic to cleanse the data.
• Experience in handling bulk volume of data to cleanse and load into target.
• RDBMS experience with Oracle 10g/9i/8i, PL/SQL.
• Implementation of ETL functionality of Data warehouse and Data migration applications.
• Extensive experience in loading high volume data, and performance tuning
• Used Datastage 7.5.x 2/ 8.0.1/8.5/8.7/9.1 (Parallel Extender) as an ETL tool to extract data from source to Target system.
• Good knowledge in data warehouse concepts like Star Schema, Snow Flake, Dimension and Fact tables.
• Excellent data analysis skills
• Experience in Converting the Business Logic into Technical Specifications.
• Ability to quickly grasp new concepts, both technical and business related and utilize as needed.
• Strong knowledge in Datastage transformations and to enhance performance both in job and environment level.
• Good knowledge in SQL, PL/SQL, RDBMS.
• Good communication skills and having project management skills
• Having good understanding of oil and gas domain and financial domain.

TECHNICAL SKILLS

ETL Tools: Datastage 7.5.x/ 8.0.1/8.5/8.7/9.1 (Administrator, Designer, Director, Manager)Informatica 8.6/9.1:

Operating System: Windows NT/XP, Unix

Database: Oracle 9i/10g, 11g, SQL Server 2008/2012

Language: C, C++, SQL, PL/SQL, Unix

Modelling Tools: Visio, Erwin 7.1.2

PROFESSIONAL EXPERIENCE

Confidential - Fairfield,CT

Sr. Informatica ETL Developer

Responsibilities:

• Maintain and monitor all the related applications in all the environments that is, development, staging and production,
• Fixing all the bugs that may arise in production.
• Deployment of the enhanced modules.
• Modified various existing reports and PlSqlcode. Involved in Database Testing, loaded the test data into SQL database by writingSQLqueries and PLSQLprocedures.
• Unit Testing and integration testing of the enhanced modules
• Associated with physical and Logical Data Modeling . Created models based on the dimensions, levels and measures requires for analysis.
• Analyze and interpret all complex data on all target systems and analyze and provide resolutions to all data issues and coordinate with data analyst to validate all requirements.
• Develop Informatica ETL jobs and perform tests on all ETL codes for system data and analyze all data
• Work with the Business Analysts to prepare functional specification during the project requirements stage. Direct the offshore team for documentation of functional requirements for client submission and approvals.
• Document application from a technical maintenance point of view and host a knowledge transfer session.
• Work with the client in proposing solutions for the overall stability of the applications.

Confidential - Houston TX

Sr. Datastage Developer

Responsibilities:

• Responsible for all technical and system specifications documents for all ETL processes and perform unit tests on all processes and prepare required programs and scripts.
• Analyze and interpret all complex data on all target systems and analyze and provide resolutions to all data issues and coordinate with data analyst to validate all requirements.
• Develop ETL and perform tests on all ETL codes for system data and analyze all data
• Provide support to all ETL schedule and maintain compliance to same and develop and maintain various standards to perform ETL codes and maintain an effective project life cycle on all ETL processes.
• Monitor all business requirements and validate all designs and schedule all ETL processes and prepare documents for all data flow diagrams.
• Perform root cause analysis on all processes and resolve all production issues and validate all data and perform routine tests on databases and provide support to all ETL applications.
• Oversees basic and advanced transformation activities such as normalization, cleansing, aggregation, summarizing, and integration in complex ETL
• Shell Scripting in UNIX to schedule the jobs using Crontab.
• Worked on agile methodology to develop, test and deploy ETL.

Confidential

Datastage Developer

Responsibilities:

• Migration of jobs from Datastage 7.5 version to Datastage 8.7
• Resolved the compatibility problems while megrating jobs from 7.5 to 8.7
• Replaced all DRS and ODBC stages with ODBC and DRS connectors.
• Converted the few server datastage jobs of version 7.5 to parallel jobs in Datastage 8.7
• Performed multi job compilation in datastage 8.7 from 7.5
• Used Administrator to administer the locks on the jobs and other Administration activities for data stage server.
• Involved in performance tuning of Jobs.
• Extensively worked with Job sequences using Job Activity, Email Notification, Sequencer, Wait for File activities to control and execute the Datastage Parallel jobs.
• Regularly did the Data Quality Checks on the source system.
• Worked closely with Development and QA to clarify the requirement issues.
• Have addressed production, UAT issues, proper action was taken accordingly based on priority and requirement

Confidential

Datastage Developer

Responsibilities:

• Worked with business owner to understand business requirements in order to transform business requirements into effective technology solutions.
• Work closely with Architects and Developers to develop jobs in such a way it can be re used for different regions.
• Involved in Analysis, Development, Testing and Implementation of complex ETL jobs .
• Co-ordinating and allocating the team for Development of jobs.
• Designing of Datastage Jobs and alerts to handle the discrepancy alongwith automating the processes
• Involved in performance tuning of Jobs and Data Analysis to resolve defects with migrated data
• Extensively worked with Job sequences using Job Activity, Email Notification, Sequencer, Wait for File activities to control and execute the Datastage Parallel jobs.
• Have addressed production, UAT issues and production issues, proper action was taken accordingly based on priority and requirement
• Approval of DMR requests after validating the scripts successfully in appropriate databases so that it can be forther executed and implemented in Data Model.

Confidential

Datastage Developer

Responsibilities:

• Developed the Complex ETL Jobs independently for Applications.
• Involved in Analysis, Development, Testing and ETL jobs
• Create, update and maintain ETL technical documentations and facilitate in migration efforts. Troubleshoot and resolve application issues.
• Understanding requirements as per the Client
• Data Analysis of source data
• Responsible for UNIT, System and Integration testing.
• Involved in performance tuning of Jobs.
• Involved in tuning the jobs to improve the performance to meet the SLA time.
• Tuned the queries and ETL jobs effectively to improve the performace.
• Used Various Standard and created Custom Routines to use in DataStage jobs.
• Extensively wrote user-defined SQL coding for overriding for Auto generated SQL query in DataStage.
• Defined Stage variables for data validations and data filtering process.

Confidential

Datastage Developer

Responsibilities:

• To monitor the datastage jobs designed in various integrated layers.
• Designed and developed parallel ETL Datastage jobs to perform Extract/Transform& loading operations using various databases, flat files etc
• Developed Sequencing mechanism ie, Wait-For-Files to sequence the jobs.
• Understanding requirements as per the Client
• Data Analysis of source data
• Monitor CPU Utilizations consumed by jobs and maintaining health-checks of database.
• Involved in performance tuning of Jobs.
• Involved in tuning the jobs to improve the performance to meet the SLA time.
• Tuned the queries and ETL jobs effectively to improve the performace.
• Ensuring the databases are up and running and users are able to access various applications.