Over 6.0 years of combined IT experience in analysis, design, development, coding, testing, implementation and support of various projects using Data Warehousing tools, Informatica,SSIS and Databases like Oracle, MS SQL Server,DB2. Very Strong experience in Extraction, Transformation, Loading (ETL) data from various sources into Data Warehouses and Data Marts using Informatica Power Center (Repository Manager, Designer, Workflow Manager, and Workflow Monitor). Extensive experience in developing PL/SQL procedures, SQL Procedures and queries along with knowledge of Batch Scripting. Ability to work through the entire development life (SDLC) cycle from gathering requirements through implementation, development, production, support and documentation of the complete project. Delivery of Agile Projects with Complex and rapidly changing requirements. Experience in writing complex SQL queries to build Dashboards for Application Owners. Experience of processing Metadata, to generate useful analytical and audit related information. Expertise in migration process across different environments [Dev/QA/STAGE/Prod] and reviewing coding standards. Experience of automating the ETL jobs using windows batch scripts and Workload Automation tools. Very good Experience in Troubleshooting, Application Bottlenecks and performance tuning of ETL jobs and SQL Queries. Worked with ODS (Operational Data Source), Data validation and cleansing process. Complete ownership of enterprise reporting Database build with Dimensional modeling :- SCD-1 and SCD-2 concepts. Experience in Extracting data from various data sources like DB2, SQL Server, Oracle, Fixed Width and Delimited Flat Files, Salesforce, XML , MQ, MS EXCEL into Staging and ODS. Experience in production support - involved in data analysis,batch load implementation, troubleshooting breakdowns and application maintenance along with Disaster recovery activities. Working knowledge of Informatica Cloud and Informatica DQ with visibility to Salesforce. Excellent analytical and logical skills with sole aim of delivering above expectation. Strong team leader and motivator aimed at continuous success of entire team.
Utilities Service Now, Tree-Size, DBCM ,Audit Control Engine,MS -Office.
Operating System Windows 2000/XP, Windows Server 2003/2008,Red Hat Linux ,MAC OS.
Programming PL/SQL, T- SQL, Windows Batch Scripts, JAVA Scripts, Shell Scripting,Java.
Resumes, and other information uploaded or provided by the user, are considered User Content governed by our Terms & Conditions. As such, it is not owned by us, and it is the user who retains ownership over such content.
Companies Worked For:
Job Titles Held: