Senior Datastage Developer Resume Samples

Description :

1. Involved in full development life cycle.
2. Participated in all stages of the development life cycle including reverse Engineering, requirement analysis, preparing mapping documents, design and developing ETL jobs and Sequences.
3. Worked on Reverse engineering between existing source and target layers using Oracle SQL.
4. Developed jobs using various stages like Oracle Connector, Copy, Pivot, Funnel, Lookup, Join, Merge, Sort, Transformer, Dataset, Row Generator, Column Generator, Datasets, and Aggregator Stages.
5. Used very extensively the Peek stage for debugging purposes.
6. Developed Multi-Instance jobs to generate Pick list values.
7. Used Checksum and Change Data Capture (CDC) stages for doing incremental loads.

Experience

2-5 Years

Level

Executive

Education

Bachelors

Description :

1. Developed UNIX shell Scripts that trigger DataStage jobs, transfer the output files, perform basic validations on file.
2. Implemented and hardcoded high performance DataStage routines Supporting the testing team, Integration Team and Reporting team after ETL data Load Performed the Integration and System testing on the ETL jobs Responsible for generation of DDL statements which are executed for database creation Deploy the developed code to SIT, Production environments and validate the code Fix the defects raised by testing team and maintain the status in HP Quality Center.
3. Implemented type 1, type 2 slowly change dimensions (SCD).
4. Sat with QA people helped them understanding the requirements, analysed and fixed the bugs raised by them.
5. Interacted with End user community to understand the business requirements and in identifying data sources.
6. Analyzed the existing informational sources and methods to identify problem areas and Make recommendations for improvement.
7. Effectively implemented partitioning and parallelism techniques to fully utilize the resources and enhance job performance.

Experience

2-5 Years

Level

Executive

Education

Bachelor In Computer Science

Description :

1. Designed and developed parallel jobs using DataStage Designer.
2. Worked on different partitioning methods and collection methods in processing sequential data.
3. Acted as production support person/administrator for the DataStage UNIX server.
4. Responsible for monitoring all the jobs that are running, scheduled, completed and failed.
5. Required a detailed understanding of the Data sources and researching possible solutions.
6. Implemented dimensional model (logical and physical) in the existing architecture using Erwin.
7. Developed and executed, in conjunction with the etl architect, quality and release, and process analyst system and integration test plans.

Experience

2-5 Years

Level

Executive

Education

Master In Science

Description :

1. Consisted of the legacy CISPlus+ application and the Vitria Integration application.
2. Interacted with End user community to understand the business requirements and in identifying data sources.
3. Analyzed the existing informational sources and methods to identify problem areas and make recommendations for improvement.
4. Required a detailed understanding of the data sources and researching possible solutions.
5. Implemented dimensional model (logical and physical) in the existing architecture using Erwin.
6. Studied the PL/SQL code developed to relate the source and target mappings.
7. Helped in preparing the mapping document for source to target.

Experience

2-5 Years

Level

Executive

Education

Bachelor In Computer Science

Description :

1. Documented requirements and created design deliverables.
2. Suggested Informatica Design and Development Best practices for the implementation.
3. Supported effective and efficient business processes in partnership with other software and reporting development teams.
4. Worked in a delivery environment, presales activities, including customer presentations, proposal development.
5. Addressed customer inquiries, applications and services issues, as they arise.
6. Responsible for providing feedback to Delivery Management.
7. Responsible for deliverable project quality.

Experience

5-7 Years

Level

Executive

Education

Bachelor In Computer

Description :

1. Ability to assess client environments, make recommendations, modeling, use of methodologies, roadmap plan.
2. Ability to work with all levels of team, business and technical.
3. Worked as a project lead to integrate various aspects of the project team.
4. Provided clear schedule and plans. Worked with client to clearly define scope.
5. Worked on mload, fastload, bteq, fastexport, tpt and tpump utilities.
6. Assisted in the collection of technical metadata supporting the implementation.
7. Analyzed source data/file structures, technical metadata, profile source data and develop data mapping and transformation rules and detail etl specifications based on business requirements.

Experience

2-5 Years

Level

Executive

Education

Bachelor Of Technology

Description :

1. Enterprised pharmacy Data Storage project is to load the ADW database to create an integrated data resource for pharmacy analytics, Enhance the extract of data from EDW for MedeAnalytics to include additional data on pharmacy claims.
2. Designed mappings using DataStage designer from source to staging and staging to data warehouse.
3. Created complex ETL jobs to implement the business logic based on requirements.
4. Implemented the CDC logic using change capture stage to maintain the history of customers.
5. Incorporated environment variables and parameter set in all DataStage PX jobs to maintain consistency across different environment (development, test and production).
6. Developed UNIX shell scripts to validate the source files.
7. Utilized DataStage director and job score to monitor, view log, handle unwanted warning messages, analyze performance of individual stages and run jobs.

Experience

7-10 Years

Level

Management

Education

B.Tech In Business

Description :

1. Involved in analyzing the system and gathering the requirements.
2. Worked with the project and business teams to understand the business processes involved.
3. Worked with the Solution Architect in designing the Data Model.
4. Responsible for developing the process & testing as it pertains to data flow for the interfaces.
5. Used Datastage Designer to develop multiple processing jobs to read data from CPF and load into Oracle.
6. Used Datastage Manager for import/export jobs, metadata from one project to another project.
7. Developed version control to maintain version and history of jobs and scripts using Serena migration tool.

Experience

10+ Years

Level

Senior

Education

Bachelors

Description :

1. Ability to evaluate, diagnose and solve problems
2. Ability to coordinate multiple tasks and activities
3. Ability to develop technical plans and customer proposals, as well as, conduct modeling and analysis.
4. Ability to travel to customer sites.
5. Ability to read, interpret and correctly operate from instructions and specifications
6. Ability to communicate clearly and appropriately with other employees, engineers, customers, vendors, management and executives
7. Ability to work trade shows
8. Ability to travel for business up to 75% of the time.

Experience

7-10 Years

Level

Management

Education

B.Tech In Business

Description :

1. Designed, coded, tested, etl application data flow plans to populated databases.
2. Assisted in the collection of technical metadata supporting the implementation.
3. Analyzed source data/file structures, technical metadata, profile source data and develop data mapping and transformation rules and detail etl specifications based on business requirements.
4. Involved in scrum call to update the customer on project status on daily basis.
5. Prepared high level design document and low level document for the project.
6. Identified the list of project to be moved and move them to datastage 11. 3 env,.
7. Used etl for executing, monitoring, analyzing logs and scheduling the jobs.
8. Used autosys as a scheduling tool to handle event based scheduling and time-based scheduling.
9. Developed etl jobs using various development / processing stages (transformer, aggregator, change capture, change apply, join, lookup, modify, filter, sort and merge, funnel, remove duplicate stage) debug stages (peek stage, head and tail stage, row generator stage, column generator stage, sample stage).

Experience

10+ Years

Level

Senior

Education

Bachelors