• Having 5 plus years of extensive hands-on experience in IT industry that includes Data warehousing, Data analysis and good exposure to banking domains like consumer card and small business services. • 5 years of experience in BI projects and complete Data Warehousing lifecycle. • 5 years of experience in IBM DataStage 9.1/8.7/8.5, IBM DB2, Teradata, and Oracle SQL. • Strong in Data warehousing, and Data Modeling concepts. • Involved in Data Management, Product enhancement, Technical and team management activities. • Involved in several successful critical projects in Banking domain. • Experience in Unix/Linux shell scripting. • Experience in Development, Enhancement & Maintenance in DWH projects. • Good experience with CA Autosys and Maestro Scheduling Tools. • Good experience with ITSM (IT Services Management) tool for Change management, Incident management and Problem management activities. • Good at troubleshooting/debugging issues. • Extensively worked on Information Analyzer to perform Column Analysis, Table Analysis, Primary Key Analysis and developed rules to identify overlapping data across domains. • Experience in working with Shared and Local Containers. • Expertise in SQL, performance tuning and optimization. • Good Knowledge of IBM Cognos, SAP BO and Tableau. • Thorough knowledge in Logical and Physical Data Modeling and Design. • Excellent technical and analytical skills with clear understanding of design goals of ER modeling for OLTP and dimension modeling for OLAP. • Expertise in identifying Fact & Dimension tables and working with Star and Snowflake Schema’s. • Thorough understanding of ETL and Data warehouse architectures. • Strong experience in creating source systems analysis, Data mapping, functional and technical design documents. • Good experience in Data management - Cleansing, profiling, integrity & master data. • Set up development, QA & Production environments. • Worked with XML input, XML output and XML transformer. • Excellent problem-solving skills with a strong technical background and good interpersonal skills. • Quick learner and excellent team player with ability to work in any phase of project life cycle. • Data Processing experience in design and implement Data Mart applications, mainly transformation processes using ETL tools IBM DataStage and Informatica Power Center. • Data Warehousing ETL experience of using DataStage 9.1 Client tools - Designer and Director. • Data Warehousing ETL experience of using Informatica 9.1 Power Center Client tools - Mapping Designer, Repository manager, Workflow Manager/Monitor. • Strong in SCD (Slowly Changing Dimension) methodologies. • Proficient in working Unix/Linux environment and have good knowledge in Shell scripting. • Proficient in SQL Queries and performance tuning of SQL Queries. • Efficient in incorporation of various data sources such as Oracle, MS SQL Server, DB2, Teradata, XML, Text files, CSV files and Binary files into the staging area. • Hands-on experience across all stages of Software Development Life Cycle (SDLC) including business requirement analysis, data mapping, build, unit testing, systems integration testing and user acceptance testing. • Handled onshore-offshore coordination seamlessly. • Hands on experience in ETL Development and Testing. • Involved in creation of Test scripts and execution of Test Case using HP ALM Quality Center. • Have good knowledge of SAS and Perl scripting. • Experience on Network Data Mover (NDM) for data transfer. • Experience with file version using Subversion (SVN) and Source Code Control System (SCCS). • Experience with prism portal to upload and update project management activities.

Highlights:

• AutoSys
• ETL
• Extract Transform Load Tools
• Data Warehouse
• IBM AIX
• IBM DB2 Database
• Linux
• Services
• Coding
• Management
• sql
• linux
• agile
• datastage
• informatica
• waterfall
• devops
• ITSM
• oracle
• TERADATA
• HP vertica
• SVN
• SCCS
• Version control
• HP ALM