SUMMARY:

• Certified Data Stage consultant around 8 years of experience as a Technical analyst, safety lead, Developer and administrator having solid experience in Banking, Finance, Health Care, Automobile and Manufacturing domains
• Experience on Talend ETL Enterprise Edition for Big data & Data integration v5.5/6
• Extensive experience in IBM Info Sphere Data Stage v 8.1/11.3/11.5 - ETL integration with SAP bank analyzer functional module performing data extract, loading and transformation process for financial general ledger accounts data.
• Experience in Hadoop Big Data Integration with Data stage ETL on performing data extract, loading and transformation process for automobile ERP data.
• Experience on Balance optimization for Data stage jobs and HQL conversion’s. Experience on writing Hive queries to load the data into HDFS.
• Knowledge on IBM Info sphere MDM Member model configuration and MDM data model
• Experience in UNIX file/dataset management to keep the load ready data for all financial transactional data.
• Experience in Oracle to perform the product hierarchy with master data & Active based costing reference validations for vertical financial modules. Experience in Teradata to perform the profit analytical model (PAM) data validations.
• Experience on Agile process implementation as a scrum team member. Experience in functional document & HLD preparation, business & data analysis on financial system road map for banking products.
• Process improvement by performing the Quality Champion role for quality code deployment in every month production cycle.
• Data processing for emphasizing on analysis, development, design, testing and implementation of various projects for Pharmaceutical, Material Management, Banking & financial industries.
• Involved in complete Software Delivery Life Cycle (SDLC) in large data warehouse environment for financial data system.
• Thorough knowledge in data warehousing, dimensional modeling, data integration, data virtualization, data synchronization, star schema, snowflake schema.
• ETL development & performance tuning, BI data analysis, SAP integrating, DFS & HDFS cluster segregation.
• Thorough domain knowledge in Banking & financial system and involved in profitability financial structure for varies banking products like Loans, Cards, Investments & Deposits for all instruments. Key role performance on Credit & small business cards to load the defaulting accounts into the financial module.
• Functional analysis on commercial loans and consumer loans for MDM hierarchy data validations and loads into financial system functional modules
• Global template hierarchy checks with financial products for master data like fund transfer pricing (FTP), Business partners & Active based costing and Risk data analysis system on capital funding.
• Thorough domain knowledge in pharma and involved in all four Phases of Clinical trials.
• Worked with senior Bio-statisticians and clinical data managers to provide ETL programs in analyzing the data, generating safety and efficacy loads, summary tables.
• Excellent oral and written communication skills. A quick learner with an eye for detail and excellent analytical and quantitative skills.
• Ability to work independently and adept at managing multiple competing tasks.

TECHNICAL SKILLS:

ETL Tools: Talend ETL data integration & Talend for Big data, IBM Data stage, Quality Stage, Info sphere Master data management (MDM)

Databases: Oracle 11g/10g/9i/8i, DB2 and Teradata

Languages: SQL, PL/SQL, Bourne shell (sh), Korn Shell Scripting (KSH)

OS: Windows NT& 2000/2003/XP/7, IBM AIX 6.1, Sun Solaris, HP-UX and Linux

Database Tools: Toad, SQL * Loader, SQL Developer and Aqua Data Studio

Version Tools: VSS, Subversion

Others: Autosys, MS Visio, TOAD, NDM, WinSCP, FTP, SFTP, Telnet, Putty, SH Tectia

PROFESSIONAL EXPERIENCE:

Confidential, Jerseycity, NJ

Sr. Talend ETL Developer

Responsibilities:

• Analyze the Data stage jobs for Hadoop balance optimization. Understand the functionality of GM EDW processing and data loads in IBM Big Data Integration sites.
• Understand the functionality of JAQL scripts for BDFS Balance Optimization Data stage jobs.
• Remediate the JAQL scripts by converting the Data stage jobs with HQL scripts. Working on HIVE tables to load the data into GM EDW HADOOP cluster environment.
• Involved in the Project planning, Resource allocation and role segregations. Working with Data analyst team during the preparation of HQL conversion documents
• Prepare the low-level design documents and HQL script files. Create the Hadoop connections for HDFS & HIVE in Talend enterprise repository.
• Develop the Talend ETL jobs to process the data in HIVE tables. Prepare the unit test scripts and make sure to get approved the test results by QA team
• Make sure the peer review QC validations before the deployment. Working on Talend integrated server packaging to move the Data stage code into QA/Production. Working on Autosys scheduler to run the Data stage jobs

Environment: Talend for Data integration & Big Data Enterprise edition v6.0, IBM Info Sphere Data Stage 9.1, HADOOP, HDFS, HIVE, JAQL, HQL, DB2, Oracle 11g, Linux, Autosys

Confidential, Saddle River, NJ

Talend ETL Developer

Responsibilities:

• Understand the requirement for FIG system. Working on design documents for data integration for FIG system flow.
• Working with Teradata team to understand the target model. Working with Data analyst team during the preparation of BRD & SLD
• Create the Hadoop connection for hdfs cluster in Talend ETL repository. Configure the hive tables to load the FIG profitability system in Talend ETL Repository
• Design the Talend ETL flow to load the data into hive tables. Create the Talend jobs to load the data into teradata and Hive tables.
• Experience on different connectors like tMap, Lkp, Sort, Join, CDC, Hive, hdfs, Oracle etc.
• Prepare the Talend job level LLD documents and working with the modeling team to understand the Big Data Hive table structure and physical design.
• Develop the Talend jobs and make sure to load the data into HIVE tables & HDFS files
• Develop the Talend jobs to integrate with Teradata sytem from HIVE tables
• Working with high volume of data and tracking the performance analysis on Talend job runs and session.
• Prepare the UTP for the design. Managing as Quality Champion for the process to make sure the quality migration in every month production cycle.

Environment: Talend Enterprise edition v6 for Big data & data integration, Hadoop HDFS, Hive, Sqoop, Flume, Hbase, Map/Reduce, Data Stage U NIX, SAP ECC, Oracle

Confidential, Parrispanny, NJ

Talend ETL Developer

Responsibilities:

• Understand the requirement document for Deposits product in FSR profitability system
• Analyze the data stage jobs with large volume for deposits on SAP integration. Working with Data analyst team during the preparation of BRD & SLD
• Design the Talend ETL flow to load the data into hive tables. Create the Talend jobs to load the data into Oracle and Hive tables.
• Experience on different connectors like tMap, Lkp, Sort, Join, CDC, Hive, hdfs, Oracle etc.
• Prepare the Talend job level LLD documents and working with the modeling team to understand the Big Data Hive table structure and physical design.
• Develop the Talend jobs and make sure to load the data into HIVE tables & HDFS files. Develop the Talend jobs to integrate with SAP functional modules from HIVE tables
• Working with high volume of data and tracking the performance analysis on Talend job runs and session.
• Prepare the UTP for the design. Managing as Quality Champion for the process to make sure the quality migration in every month production cycle.

Environment: Talend Enterprise edition v3.0/5.5 for Big data & data integration, Hadoop HDFS, Hive, Sqoop, Flume, Hbase, Map/Reduce, Data Stage U NIX, SAP ECC, Oracle

Confidential, Princeton, NJ

Sr. Data stage Developer

Responsibilities:

• Providing technology support to the team for SAP migration profitability system in Bank.
• Involved in the Project planning, Resource allocation and onsite-offshore coordination.
• Working with Data analyst team during the preparation of BRD & SLD. Prepare the ELLD documents
• Develop the Data stage jobs based on mapping sheet and SLD. Conducting the Peer reviews and documenting the best practices.
• Responsible for version controlling through VSS for source code. Prepare the unit test scripts and make sure to get approved the test results by DA's
• Make sure the peer review QC validations before the deployment. Monitoring the production box for every month cycle.
• Working on incident management for CT production deployments for emergency fixes.
• Tracking the production issues and update the status tracker & issue log. Upgrade the jobs from DataStage 8.1 to DataStage 11.3 for the financial product Cards.
• Create the Quality stage jobs to identifying components of data for the company code & cost center key attributes or free format, standardizing the values and formats of those data using the standardized results. Prepare the UTP for the design

Environment: IBM InfoSphere DataStage 8.1/11.3, Oracle 11g, UNIX, SAP-Bank Analyzer,

Confidential, NewJersey, NJ

ETL DatStage Developer

Responsibilities:

• Analysis the Conversion Design document/Interface Design Document and understand the conversion rules and requirements
• Prepare the Technical Design document. Develop the Data stage jobs based on mapping sheet and TDD.
• Prepare the UTP for the design. Profiled legacy systems using column analysis, table analysis and baseline analysis.
• Created Rulesets for data quality index reports. Generated reports with cardinality, null ability and uniqueness indicators.
• Used Business Glossary to create terms and catalogs for organization dictionary. Used metadata workbench to establish lineage between source Oracle systems, Data Stage jobs, Staging DB2 and target DB2 database.
• Working with SAP pack stages Idoc, BAPI-RFC to read and write the data. Working with MQ connector stages to pass the source data as a messages into the Message queue
• Working with FTP stage to transfer the target files into third party application server. Leading the review team and responsible for validating the code
• Attending the meetings weekly basis with onshore business partners to understand the business process for a specific product. Involved in creating error logs and increase the performance of the jobs

Environment: IBM Data Stage 7.5, Information Analyzer 8.1, Metadata Workbench 8.1, Business Glossary 8.1, AIX, SAP R/3 Plugin 5.0, SAP ECC 6.0, Oracle 9i, DB2 UDB.

Confidential, Murray Hill, New Jersey

ETL DataStage Developer

Responsibilities:

• Understanding the business requirements for various utilities provided by the customer.
• Preparing Unit specification documents. Develop Data Stage jobs and internal review of Data Stage jobs
• Provide the Technical support to the team in ETL part. Involved in creating error logs and increase the performance of the jobs.

Environment: Data stage, Oracle, UNIX

Confidential, Princeton, NJ

ETL DataStage Developer

Responsibilities:

• Understanding the business requirements for various utilities provided by the customer.
• Preparing Unit specification documents. Provide the technical support to the team and make sure to finish the work within the time. Involved in creating error logs and increase the performance of the jobs.

Environment: Data stage, Oracle, UNIX