Professional Summary
Over 8 years of ETL and data integration experience using DataStage and Informatica Power Center 10.x/9.x/8.x/7.x/6.x, AWS Glue, Talend, SSIS, Matillion, Snaplogic, SAP business objects, crystal reports, PowerBI and Tableau. Certified AWS Solutions Architect Associate 2+ years of implementation experience with AWS Services and tools. Expertise in implementing and maintaining system applications in AWS Cloud in Windows and Linux. Experienced in all phases of Data warehouse life cycle involving Requirement Analysis, Design, Coding, Testing, and Deployment. Extensive experience in creating high level design documents, logical design documents, process flow diagrams and data flow diagrams. Extensive experience in developing ETL mappings, data integration, data profiling, and master data management using ETL tools. Expertise in Business Model development with Dimensions, Hierarchies, Measures, Partitioning, Aggregation Rules, Time Series, Cache Management. Expertise in handling various aspects of Business Intelligence viz. Data Warehouse Design, Development, Administration and Architecture, ETL Administration, Development and Production Support, Informatica PowerCenter / Data Quality / B2B / Master Data Management, Talend Data Integration / Data Quality/MDM, Abinitio, Oracle PL/SQL, Teradata PL/SQL, Netezza PL/SQL/ DataStage/ BI-Crystal Reports/Control-M/MobaXterm/SQL Developer and UNIX Shell Scripting. Strong knowledge of Entity-Relationship concept, Facts, and dimensions tables, slowly changing dimensions and Dimensional Modeling (Star Schema and Snowflake Schema). Experience in integration of various data sources like Oracle, DB2, Sybase, SQL server and MS access and non-relational sources like flat files into staging area. Experience in development, creation of tickets and support to different vendor applications like; Charles River Investment Application, Eagle Investment, PAM, Fiserv APL, NFS, Bloomberg, State Street, Northern Trust, Golden Source and Factset. Experience in writing, testing and implementation of the PL/SQL triggers, stored procedures, functions, packages. Experience in Performance tuning of Power Center mappings, and SQL scripts for maximum efficiency and performance. Expertise with IDQ/IDE tools for data profiling, data enrichment and standardization. Experienced in UNIX work environment, file transfers, job scheduling and error handling. Experience in support and knowledge transfer to the production team. Proficient in interaction with the business users by conducting meetings with the clients in Requirements Analysis phase. Multi-tasking Manager well-known for creating positive workplace culture and high- performing teams. Demonstrated [Product or Service] expertise, including competitive offerings, pricing and market positioning.