Total 13 Years of Experience in IT industry on which 8 years in Data warehousing with application development and Implementation of ETL tool Data Stage, Informatica and ODI. Have 7 years of experience in Data warehousing ETL tools (Data Stage), Informatica. Have 2 years of experience in Teradata. Have 1+ years of experience in Reporting Tools. Knowledge of Hadoop/Impala/Hive/Airflow. Knowledge of Azure data Lake, Azure Delta Lake, Azure SQL Database, Data bricks, Azure Data factory, Azure Data Lake storage. Solid organizational skills and focus on accuracy and attention to detail. Excellent analytical, problem solving and troubleshooting abilities. Self-motivated with the ability to work both independently and in a team environment. Providing accurate and timely estimates for tasks. Provide support and leadership in critical production support issue resolution. Conduct or facilitate root cause analysis on all in-scope incidents and recommend a corrective action plan. Worked with team to achieve timely resolution of all production issues meeting or exceeding Service Level Agreements. Conducted code review to ensure the work delivered by the team is of high-quality standards. Ability on technically managing the medium to large applications with complete technical ownership. Experienced in handle the design, architecture and implementation. Experienced in performance management of large and complex applications. Strong analytical and problem-solving abilities. Good interpersonal and communication skills and Experience working with all levels of business. Ability to handle complex large applications technically. Establish technical quality processes, templates, checklist for application and ensure delivery with respect to the same. Enhance the quality of deliverables. Experience in producing technical documentation. Provided technical support to the development team. Overall Infosphere DataStage (Developer) experience: 5 years. Experience in Installing, Configuring, Updating and Administering DataStage. End to End IBM InfoSphere Information server suite installation. Understanding the business functionality & Analysis of business requirements. Converted requirement specifications into detailed design and implementation. Design and developed ETL jobs using various stages in server and parallel mode. Extracting data from sources like oracle, Teradata and flat files and transforming them using business logic and loading the data to the Data warehouse. Worked on Slowly Changing Dimensions. Production support, implementation, defect fixing, enhancements activities and release. Worked extensively on different types of stages like CFF stage, Aggregator, Change capture, Copy, Funnel, Join, Lookup, Merge, Remove duplicates, sort, Transformer. Worked on several Development/ Debug stages. Involved in Unit Testing, performance Tuning, support and implementation. Installed IBM InfoSphere Information Server 9.1 on windows 2008 server. Efficient is using Work Load Management server (WLM) and its best practices. Resolved complicated code issues for development team. Granting appropriate privileges to users in DataStage. Established rsh setup by co-coordinating with UNIX admin. Resolved Ssh and rsh connectivity (secondary node for effective communication). Migrated of DataStage components from Development server to QA and Production servers. Creation of new projects and roles setup. Expertise architecting data integration solutions. Worked with development teams, DBA's, Unix admin, network, storage and other technology teams to resolve performance issues with ETL code or database loads.
To obtain a demanding and challenging opportunity that will allow me to leverage my technical skill set in conjunction with my proven leadership record to deliver successful Implementations of technology.