- Participate in all phases of the software development lifecycle, from inception through post-implementation support, for all types of applications consistent with established specifications and business requirements to deliver business value.- Understanding of data warehousing, reporting and data integration design concepts/skills to contribute to the design, development, testing, and implementation of end-to-end integrated systems and support production issues after deployment. - Responsible for serving as a data expert by translating business problems into the design and to create the required aggregation and transformations. - Work with architects/leads to design solutions that drive enterprise marketing projects from design, development, and demonstrate full implementation of the solution. - Collaborate with business partners to identify and scope new opportunities for analytics applications to evaluate business performance and to support business decisions.- Work with a team of developers responsible for integrating data into the enterprise data warehouse by leveraging the Extract-Transform-Load (ETL) tool and business intelligence framework.- Design technical deliverable artifacts, such as source-to-target mappings, low-level design, high-level design and implementation run books needed for project implementation.- Support new and existing efforts to support the ongoing delivery of services and/or operations such as proof of concept development, sub-system design, key module development, maintenance support, and enhancement development, debugging, problem solution and up-to-date with significant developments within the industry.- Develop ETL code that meets technical specifications and business requirements according to the established designs and framework.- Perform coding, development of analytical models to support business partner objectives and business needs and implementation.

Roles & Responsibilities:- Understand the customer requirements and translate it into appropriate technical solution.- Research, analyze, evaluate, identify alternative design and test approaches.- Analysis and understanding of data modeling and/or diagramming techniques, with the ability to create the process flow diagrams and understand the entity-relationship models.- Design the technical deliverable artifacts such as source-to-target mappings, implementation run books etc. needed for project implementation.- Involve and guide the team in preparing the low-level design, coding and unit testing of the Data warehouse application based on high-level design solution.- Develop the ETL code that meets technical specifications and business requirements according to the established designs and framework.- Troubleshoot development, operational problems and provide timely solutions.- Prepare master test plan and test strategy for the project and assist in defining test data criteria for testing.- Participates in system, integration and regression testing, identifies and remedies solution defects.- Collaborate with technical teams to develop solutions that are reusable.- Proactive and diligent in identifying and communicating development issues and recommending potential solutions.- Be the point of contact for all technical issues or design issues, initiatives on the project and provide solutions.- Involve in production implementation activities and validate the production system after implementation till system stabilizes.Environment: InfoSphere Data stage 11.5, Teradata 15.x/16.x, Oracle 11g/12c, Unix Shell script, Oracle SQL Developer, IBM Tivoli Scheduler, MOVEit Managed File Transfer System, Project planning & implementation, Maintenance, Github, Urban Code Deployment (UCD), Rally, Cherwell, Service now, Linux Unix

Roles & Responsibilities:- Partnering with the business users to understand the requirements and converting them into the project level functional specification.- Worked with business analysts to identify the appropriate sources and data elements.- Conducted requirements gathering with various business teams to understand the data needs for the new chip cards.- Co-ordinated with different source system teams to understand the changes in process required for processing chip cards. - Analyze the existing data present in data marts and EDW to understand the impacts of process changes to the existing system.- Involved in data profiling of the new chip information for data modeling and data quality monitors in EDW.- Provided the High level and low-level design solution using Datastage and Shell scripts.- Designed new process for data reprocessing and reconciliation to ensure no data loss in ETL layer.- Involved in designing the data model for the new chip data.- Test data preparation to ensure the test data available for coverage of all test case scenarios.- Worked with business teams to get sign off on the productions changes went well.- Single point of contact for all technical issues to the offshore and other development teams related to the project.- Gained extensive knowledge of existing systems and was a single point of contact for all the data related question to the business team.Environment: InfoSphere Data stage 11.5/8.5, Teradata 14.x, UDB DB2 9.5/10.5, Unix Shell script, SQL Developer, Control-M, Visio, Project planning & implementation, Maintenance, MSTFS, TAD, Quality center 11.58, Service now, Erwin v9, Hadoop, Sqoop, Hive, HBase and Pig, InfoSphere QualityStage 11.5, InfoSphere Information Analyzer 11.5, InfoSphere Information Governance Catalog 11.5, IBM Curam, IIB, Mainframe, IBM Tivoli Scheduler, E/R Studio Data Architect, AIX Unix

Roles & Responsibilities:- Designed Mappings between sources to operational staging targets, using Star Schema, Implemented logic for Slowly Changing Dimension (SCD).- Created ETL jobs to invoke SOAP web services with using WSDL for change the order status once payment is approved or rejected from XML file data. - Extensively worked with Join, Look up (Normal and Sparse) and Merge stages to improve the performance based on the volume of source and reference links.- Several hours running jobs are improved performance by reducing overall runtime in few minutes using different partitioning techniques.- Experienced the Agile Methodology approach in the project greatly increases the likelihood of successful implementation of a data warehouse on time and within budget.- Involved in testing, debugging, bugs fixing and documentation of the system.- Worked in analyzing the issue, trace the problem area, suggest a solution, discuss with business.- Unit and integration testing of various ETL components to verify the Data Warehouse functionalities and requirements.- Have identified tuning opportunities in the application Level, database level and administrator level implemented to reduce the ETL Server resource consumption.- Efficiency displayed Team-coordination and ensuring customer satisfaction by providing extensive support.- Designed the archival logic, Error handling & Reprocessing of the data.- Co-ordinate with the QA team in various testing phases by resolving the defects and ensuring smooth execution of the test plans.- Extensively worked on BAU requirement in timely manner.Environment: InfoSphere DataStage version 8.7(Designer, Director, Administrator), IBM DB2 9.7.6, Oracle 11g, PL/SQL, Toad for Oracle 10.5, SQLDeveloper 1.5.4, Toad for DB2 4.6, IBM-AIX (korn shell) V6, Windows 7, Tortoise CVS, UNIX scripting, Mercury Quality Center 9.0, soapUI 3.6.1, Autosys

Roles & Responsibilities:- Partnered with business users in identifying, prioritizing & resolving numerous data issues create ETL Project Plans, design and development of the tables.- Extracted the data from heterogeneous sources like SAP BW using openhub connection, Mainframe tables, Flat files and IBM DB2.- Designed and developed the parallel jobs for slowly changing dimensions (SCD Type1, Type 2 and Type 3) and fact tables loading and Type 2 to handling the historical data. - Designed Data Stage parallel jobs to process more than 40 million records in the weekly basis.- Involved in monitoring history data migration in general ledger.- Involved in monitoring the workflows and in optimizing the load times.- Designed, developed & tested the fact table partition strategy to minimize performance impact due to additional history data in the fact tables.- Analyzed data with discrepancies through Error files and Log files for further data processing and cleansing.- Used DataStage Manager for importing metadata into repository, creating new job categories, exporting and importing the jobs between the production and the development servers.- Involved in analyzing the daily defects of the production support and finding the root cause.- Raising a CR (Change Request) for bringing in the changes in the production environment. This also involves coordinating with other groups like DBA to make the changes successfully.- Receiving Client problems using Service now and analyzing code and solving the issues to provide a persistent resolution to the recurring problems.- Created Job flow document for each process and Unit Testing.- Participated in meetings with Business users and Subject Matter Experts (SMEs) to understand the business requirements.Environment: InfoSphere Data stage 8.5, Teradata 13.x, Shell script, SQL Developer, Control-M, Visio, Project planning & implementation, Maintenance, MSTFS, TAD, Quality center, Service now

Roles & Responsibilities:- Designed the jobs to maintaining the data warehouse from different sources such as CIS, CAARUS and FACTS applications.- Developed in ETL jobs using Datastage, supporting all ETL process such as implementing Source to target mapping.- Design the application to support the restartability and recovery approach to ease application maintenance.- Identified/documented data sources and transformation rules required populating and maintaining data warehouse content.- Design of pre & post processing which includes generating files for the system health tables, unzipping, archiving files, creation of load report file etc.- Used Datastage Parallel Extender for splitting the data into subsets and to load data, utilized the available processors to achieve job performance, configuration management of system resources.  - Tested the DataStage jobs to fix the issues in Migration environment before moving the Jobs to Production.- Worked on the Unix scripts for file transfers, file concatenations and e-mail notifications to advise key recovery associates of critical events are sent to the vendor clients.- Implemented enhancements to the current ETL programs based on the new requirements.- Monitor daily ETL cycle and providing on call production support for DW environment.- UNIX scripts which involves purging of tables after a stipulated time period, calling of merge scripts & other job specific requirements.- Designed the job templates and created new jobs from existing templates.- Production support and maintenance for 3 months.Environment : Ascential Datastage 7.5.3, Oracle 10g, PL/SQL, SQL Server 2005, Shell script, Web FOCUS, Performance Tuning, Control-M, Visio, Project planning & implementation, Maintenance.