Description :

1. Loading of all sales data from various sources into the database.
2. Actively participating in decision making and QA meetings and regularly interacting with the Business Analysts and development team to gain a better understanding of the business process, requirements & design.
3. Using DataStage as an ETL tool to extract data from sources systems, loaded the data into the IBM DB2.
4. Creating jobs to read and write data into complex flat files, Cobol files, sequential files.
5. Designing and developing a data stage jobs to extract data from heterogeneous sources applied to transform logic.
6. Creating Datastage 8.5 jobs using different stages like the transformer, aggregator, sort, join, merge, lookup, data set, funnel, remove duplicates, copy, modify, filter, change data capture, change apply, column.
7. Extensively using the Datastage for extracting, transforming and loading databases from sources including flat files.

Experience

5-7 Years

Level

Executive

Education

BS

Description :

1. Working with Business Analyst to identify, develop business requirements, transforming it into technical requirements and responsible for deliverables.
2. Implementing join, lookup, aggregates, filters, rank and update strategy transformations.
3. Working towards optimal performance when using stages like lookup, join, and merge.
4. Extensively working with Datastage Designer and Director to load data from source extract files to the warehouse.
5. Providing the staging solutions for data validation and cleansing with PL/SQL and Datastage ETL jobs.
6. Developing various jobs using database connectors, aggregator, and sequential file stages.
7. Designing and developing DataStage jobs for loading staging data from different sources like files, Oracle, SQL server DB into data warehouse applying business rules which consist data loads, data cleansing, and data massaging.
8. Creating a shared container to simplify the DataStage design, and used it as a common job component throughout the project.
9. Tuning DataStage jobs for better performance by creating DataStage lookup files for staging the data and lookups.

Experience

2-5 Years

Level

Junior

Education

MS

Description :

1. Involved with application and database support teams to maintain system and database which supports current data scenarios and easily adapts to changing business needs.
2. Used parallel extender extensively by using processing, development/debug, file and real-time stages.
3. Involved in all phases including requirement analysis, design, coding, testing, support, and documentation.
4. Extensively used DataStage designer to develop processes for extracting, transforming, integrating and loading data from various sources into the data warehouse database.
5. Extensively used quality stage stages like standardize, match frequency, duplicate & unduplicated match and survive stages.
6. Widely used different types of DataStage stages like modify, sequential file, copy, aggregator, surrogate key, transformer, dataset, look up, join, remove duplicates, cff, sorter, column generators, cdc, and funnel.
7. Used database stage like db2/udb enterprise, db2 bulk load, Drs, Sybase, odbc connector.
8. Designed and developed the process for real-time data movement of reference data from Sybase to db2 using a mix of DataStage jobs.
9. Developed information service stages (wisd) for real-time data movement between db2 and Sybase.
10. Involved in generating an SOA service of DataStage quality stage job and deploy/manage the services using IBM console to receive service requests.
11. Worked with data modelers, technical architects, customer/end user, business analysts, and data analysts to design technical specification documents/mapping documents.

Experience

7-10 Years

Level

Management

Education

BS

Description :

1. Participating in all stages of the development lifecycle including reverse engineering, requirement analysis, preparing mapping documents, design and developing ETL jobs and sequences.
2. Working on reverse engineering between an existing source and target layers using Oracle SQL.
3. Developing jobs using various stages like Oracle connector, copy, pivot, funnel, lookup, join, merge, sort, transformer, dataset, row generator, column generator, datasets, and aggregator stages.
4. Using checksum and Change Data Capture (CDC) stages for doing incremental loads.
5. Sitting with QA people helping them understanding the requirements, analyzing and fixing the bugs raised by them.
6. Working on the testing of code and fixed defects during the conversion.
7. Involving in design and code reviews and extensive documentation of standards, best practices, and ETL procedures.
8. Taking the responsibility of code back up and checking it in TFS and maintain the versions of the code changes.
9. Responsible for adopting the company standards for stage & link naming conventions.

Experience

10+ Years

Level

Management

Education

Bachelor Of Technology

Description :

1. Working closely with the data modeler and database administrator to understand the business processes and participated in the analysis of business requirements to build the data warehouse model.
2. Extensively using DataStage designer to develop the parallel jobs and server jobs.
3. Designing several DataStage jobs using join, merge, lookup, change apply, change capture, funnel, filter, odbc, column generator, transformer, modify, surrogate key, aggregator, dcode, row generator and XML stages.
4. Developing parameter-driven ETL processes to map source systems to target data systems with DataStage complete source system profiling.
5. Implementing various partition methods like hash, entire, auto, and Oracle.
6. Tuning DataStage jobs for better performance by creating DataStage lookup files for staging the data and lookups.
7. Developing complex transformations, surrogate keys, dimension tables, and fact tables.
8. Utilizing the environment variables and stage variables for developing parameter-driven jobs and debugging them.
9. Identifying the facts and dimensions for developing a logical design of the data marts.
10. Extracting and transforming the source data from Oracle database and XML sources to load into the data warehouse in Oracle and Teradata.
11. Performing data extractions and loads using Teradata database utilities like multiload, fast load and fast export for large warehouse and for datamarts in Teradata.

Experience

5-7 Years

Level

Executive

Education

BS

Description :

1. Creating low level design documents by understanding the requirements and there by developing jobs.
2. Worked in data acquisition project, where we need to extract data from different sources, process the data and generate the files and transfer these files to target systems.
3. Working on several change requests, which were created because of production incidents and requirement changes to the code in production environment.
4. Responsible for using different types of stages such as ODBC Connector, Oracle Connector, DB2 Connector, Teradata Connector, Transformer, Join, Sequential File to develop different jobs.
5. Developing common jobs, shared containers and server routines, which are used across the project in most of the interfaces.
6. Using Data Stage director and its run-time engine for job monitoring, testing and debugging its components, and monitoring the resulting executable versions on ad hoc or scheduled basis.
7. Working on Hadoop Hive tool for application database uses customer ID to index into the customer table.
8. Converting the complex job designs to different job segments and executed through job sequencer for better performance and easy maintenance.
9. Using the Datastage as an ETL tool to extract data from sources systems, loaded the data into the IBM DB2 database.

Experience

5-7 Years

Level

Senior

Education

BS

Description :

1. Gathering all the information from existing ETL team and source providers.
2. Participating in business meetings and understanding the current job flow and their dependencies.
3. Working closely with the source system owners in getting the source files, and discussing the data related issues.
4. Extensively using IBM info sphere datastage designer and director for creating and implementing jobs. Designing complex data stage mappings (parallel extender and server) between sources (external files and databases) to the target-using oracle as the target database.
5. Using the datastage director and its run-time engine to schedule the jobs, testing and debugging its components, and monitoring the resulting executable versions.
6. Using datastage to transform the data to multiple stages, and prepared documentation.
7. Modifying old jobs which had hashed files, replacing them with datasets to improve performance.
8. Working with multiple sources which included ingres, oracle, flat files, teradata, sybase.
9. Changing slow performing jobs to high efficient jobs by analyzing and making necessary manipulations.

Experience

5-7 Years

Level

Senior

Education

BS

Description :

1. Worked on all phases of software development life cycle from planning to deployment.
2. Performed requirement gathering, analysis and designing decisions based on business analysis and technical design discussions with the stakeholders.
3. Coordinated with the Business Analyst to understand and design the explanation of benefits and monthly bill reporting to ease the report generation process from the enterprise data warehouse.
4. Coordinated with different team members to resolve and design the effective solution concerning accuracy of the data in the data mart environment maintaining the hipaa compliance rules.
5. Implemented complex etl jobs depending on the requirements like member claims, copay, deductible and access to the appropriate benefits available according to the plans and groups.
6. Developed parallel jobs using cc and scd stages to achieve complex change capture process to maintain history of customers.
7. Used parameters and parameter sets to aide code consistency of modules across environments.
8. Prepared and performed unit test cases to validate the data generated.
9. Extensively used sql queries for retrieving and processing data in databases and datastage.
10. Performed code reviews to validate the deliverables like ETL code, design documents, test cases.
11. Developed Unix shell scripts for scheduling, supplying parameter values and performing business requirements, ftp and audit activities.

Experience

7-10 Years

Level

Management

Education

Bachelors Of Engineering

Description :

1. Participating in gathering the business requirements through interviews, surveys, prototyping, and observing.
2. Preparing conceptual model, business process diagrams, process and data flow diagrams and converting the business requirements into logical models.
3. Converting logical models into physical models and creating database script for implementing physical model into target database using erwin.
4. Identifying/documenting the data sources and transformation rules required to populate and maintain data warehouse content. Also, creating mapping documents for ETL and architecture purpose.
5. Involving in preparing data volume estimates, defining data definitions and creating target tables in the database.
6. Mapping the source and target databases by studying the specifications and analyzing the required transforms.
7. Extensively using the datastage designer to develop various jobs to extract, transform, integrate and load data into data warehouse database.
8. Designing and developing Change Data Capture (CDC) process to extract delta data from ODs.
9. Designing datastage parallel jobs involving complex business logic, update strategies, transformations, filters, lookups and necessary source-to-target data mappings to load the target.
10. Extensively working on job sequences to control the execution of the job flow using various activities & triggers (conditional and unconditional) like job activity, wait for file, email notification, sequencer, exception handler activity, routines (threshold) and execute command activity.
11. Extensively using the sequential file, modify, dataset, filter, funnel, join, lookup, copy, aggregator, transformer, remove duplicate and sort during etl development.

Experience

10+ Years

Level

Consultant

Education

MS

Description :

1. Working with Business Analysts to identify and develop business requirements and also transform it into technical documentation and responsible for deliverables.
2. Designing the ETL processes using Datastage to load data from Oracle, DB2 UDB to flat files (fixed width) and flat files to staging Teradata database and from staging to the target Teradata data warehouse database.
3. Extensively working with Datastage 9.1V - designer and director to load data from source extract files to the warehouse.
4. Using the Datastage designer to develop processes for extracting, cleansing, transforming, integrating and loading data into staging tables.
5. Working with Data Modeler and Business Analyst in gathering business rules.
6. Developing complex jobs using various stages like lookup, join, transformer, dataset, row generator, column generator, datasets, sequential file, aggregator and modify stages.
7. Creating Datastage jobs to load data from Sequential files, CSV, Flat files, SQL server and Oracle.
8. Developing various jobs using ORA OCI, ODBC, Aggregator, Sequential File Stages.

Experience

2-5 Years

Level

Junior

Education

BS

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. 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. 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