Sql Server, Data Warehouse,SnowFlake,IICS,Power Center, Mantas
Resume:
**********.******@*****.***
Professional Summary:
Over 15 years of Data Warehousing experience in the Design, Development and Testing of ETL methodologies in all the phases of the Data Warehousing and Data Migration life cycle using Informatica PowerCenter 10.1/9.5/9.1/8.6/ 8.1/7.1/6.2/6.1/5.1.
Data Processing experience in designing and implementing Data Mart applications, mainly transformation processes using ETL tool Informatica Power Center.
Proficient in understanding business processes / requirements and translating them into technical requirements.
Excellent experience in data architecture, coordinating with data users, key stakeholders and external vendors to develop and achieve various long-term objectives for data architecture.
Strong in Data warehousing concepts, dimensional Star Schema and Snowflakes Schema methodologies.
Excellent experience in creating and managing Conceptual, Logical and Physical Data Models.
Significant experience in dimensional and relational database design.
Experienced in analyzing the data generated by the business process, defining the granularity, source to target mapping of the data elements, creating Indexes and Aggregate tables for the data warehouse design and development.
Good Knowledge working with Financial Industry and Stock Brokerage industry terms.
Lead the team of IICS- Data Integration, CAI and CIH for API integrations.
Experience working with AML solutions like Mantas and Risk Canvas.
Excellent experience in implementing ETL solutions as per business requirements.
Good Understanding of AWS Cloud concepts like EC2, S3, IAM, EBS.
Experienced in UNIX Shell Scripting and Perl Scripting.
Excellent knowledge of operating systems and databases including Windows, UNIX, AIX, Oracle, SQL Server, Intersystem Cache.
Detail oriented with good problem solving, organizational, analysis and requirement gathering skills.
Worked as an onsite-offshore coordinator for managing offshore team and get the deliverables achieved as per the SOW agreed.
Worked during the project conversation phase from Waterfall to Agile and completed the needed trainings required by an efficient Agile team.
Worked in Kanban Lean tool designed to reduce the idle time in a production deployment process. Our Kanban system is to deliver the required with sprint timelines which can be viewed by external teams.
Efficiently handled the Internal and External compliance Audit for all financial years.
Knowledge on Hadoop hive.
Worked in Backlog refinement processes.
Working knowledge on APIGEE Edge.
Education: B Tech Electronics and Communications Engineering.
Certifications:
AWS Certified Sysops Engineer
Dale Carnegie certified in Public Speaking Mastery
Informatica Cloud Datawarehouse
Skillset:
Informatica IICS DI, CAI, CIH, APIGEE, AWS, PowerCenter 10.1/9.5/9.1/8.6/8.1/7.1/7.0/6.2/6.1/5.1, Oracle 11g/10g/9i/8i, MS SQL Server 2000/2005/2008/2014/2016, UNIX, Windows NT/2000, SQL Navigator, SAP ERP, UNIX shell scripting, SQL, Tidal Automation, CSV and XML files, Oracle Exp/Imp, SQL*Loader utility, SQL Developer, AWS and Python (Basic), Jenkins, ART, GITLAB.
Projects Summary:
TD Ameritrade/Schwab, Jersey City, NJ Working -Till Date
Sr. Informatica Developer-Risk and Compliance Team
Compliance Data Repository is a staging warehouse for the Risk and Legal Team platform of Td Ameritrade which acts a bridge between multiple Risk and Legal Applications. CDR gets data feeds from various application of Back office, FIX and external legal applications. Compliance needs to be maintained for this data as it contains PII and SII information. All the data feeds are cleansed and transformed in CDR as per the downstream application requirement.
Responsibilities:
Worked as a Senior Informatica Developer and was involved in business analysis, requirements gathering, transforming business requirements and creating source to target mapping and transformation documents.
Designed Complex mappings using various transformations like Expression, Lookup (Connected and Unconnected), Filter, Router, Aggregator, Update Strategy, Joiner, Sorter, Normalizer to attain the required business logic in the mappings.
Implemented Slowly Changing Dimensions - Type I & II in different mappings as per the requirements.
Used Session parameters, Mapping variable/parameters and created Parameter files for imparting flexible runs of workflows based on changing variable values.
Worked with Connected, Unconnected lookup and Stored Procedure transformations and pre & post load SQLs and commands.
Used Informatica Developer and Informatica Analyst for analyzing, profiling, validating and cleansing data.
Used workflow monitor to monitor the jobs, reviewed session/workflow logs that were generated for each session to resolve issues, used Informatica debugger to identify issues in mapping execution.
Made performance improvements to the database by building Partitioned tables, Index Organized Tables and Bitmap Indexes.
Worked with PL/SQL Procedures, Functions, Packages, SQL scripts, Materialized views, Sequences and Triggers.
Extensively worked in SQL, PL/SQL, Query performance tuning, created DDL scripts, created database objects like Tables, Indexes, Synonyms, and Sequences etc., closely worked with DBAs to create Physical Databases.
Created application objects like metrics, filters, prompts, templates and reports.
Played key role in creating Advanced Prompts, Conditional, Transformation metrics and Level Metrics for creating complex reports.
Created base formulas for all the metrics to make the metrics reusable for future use.
Created Report Services Documents out of existing reports and customized them.
Worked in DVO tool for data comparison between environment during the Informatica upgrades.
Worked in Data Archiving strategies to archive the data by portioning as per the compliance requirements.
Used IICS Data Integration for mapping development for extraction data from PDF files.
Worked on Informatica developer tool to transform WI transactions which come in as PDF files from external banks.
Working knowledge on Informatica MDM 10.3 Hot fix 3.
Worked with external vendors to create new cashflow compliance strategies.
Handled Deployment process with CI/CD tools.
Environment: Informatica PowerCenter 10.1, IICS, IICS Data Integration and Application Integration (CAI), Oracle 12c, MS SQL Server, Jenkins, ART, Gitlab, SharePoint, Winssql, Flat Files, UNIX Shell Programming, Red hat Linux, Mantas (Oracle Financial Services Behavior Detection Platform), Risk Canvas, Informatica MDM 10.3.
Honeywell Automation Control Systems (ACS), Phoenix, AZ 02/2013 â 12/2015
Informatica Developer
The project is about Honey well ACS and Intermec integration. The purpose of the project is to scope, size, define and produce Order to Cash reporting across the combined Honey well and Intermec merger.
Responsibilities:
Worked closely with Business Analyst and Domain Experts in order to establish and document business needs for data.
Involved in transforming business requirements in to Conceptual, Logical data models.
Conceptualized and Designed Logical and Physical Data Models for the reporting requirements which integrated both Thomson and Reuters using Erwin 7.2.
Created super type and sub type entities and Category entities.
Defined various facts and Dimensions in the data mart including Fact less Facts, Aggregate and Summary facts.
Assisted in the Design and Development of Data Warehouse and Operational Data Stores utilizing Dimensional Data Modeling, OLAP and ETL concepts.
Involved in installing and configuring of Informatica on Unix. Also involved in backup, recovery, tuning of application, stopping and restarting the services.
Performed major role in understanding the business requirements and designing and loading the data into data warehouse (ETL).
Identified/documented data sources and transformation rules required populating and maintaining data warehouse content.
Extracted data from different sources like Oracle, SQL Server and Flat files, implemented business logic and loaded into the target Warehouse (Oracle).
Extensively used almost all the transformations of Informatica including lookups, Stored Procedures, Update Strategy and others.
Implemented Slowly Changing Dimensions - Type I & II in different mappings as per the requirements.
Defined Target Load Order Plan for loading data into Target Tables.
Provided Knowledge Transfer to the end users and created extensive documentation on the design, development, implementation, daily loads and process flow of the mappings.
Tuned Informatica Mappings and Sessions for optimum performance.
Involved in designing and developing Reporting System using Business Objects XI R2/R3.
Created and maintained several custom reports for the client using Business Objects.
Worked on database connections, SQL joins, cardinalities, loops, aliases, views, aggregate conditions, parsing of objects and hierarchies.
Environment: Informatica PowerCenter 8.1/8.6, Flat files, Oracle9i, MS SQL Server 2005, Erwin 7.2, PL/SQL, Business Objects XI R2/R3, SQL * Loader, UNIX Shell Programming, UNIX (Solaris), Windows NT.
Delasoft Inc 01/2007 â 03/2012
Informatica Developer/Support Engineer.
The aim of the project was to create a Reporting Data warehouse that is used to generate reports using MicroStrategy as the reporting tool. The Data warehouse is populated using Informatica Power Center 8.1 as the ETL tool.
Responsibilities:
Involved in business analysis and technical design sessions with business and technical staff to develop requirements document and ETL specifications.
Designed and developed the Logical and Physical data models using Erwin 7.2 based on the reporting requirements given.
Defined aggregations required and granularity available and required in DW.
Developed entity and attribute descriptions and definitions for the models and ensured that conflicts in descriptions and definitions are resolved.
Defined the PKâs and FKs for the Entities.
Involved in the upgradation of Informatica PowerCenter 7.1 to 8.1.
Designed and developed the ETL Mappings for the source systems data extractions, data transformations and aggregation.
Worked on Informatica Power Center 8.1 â Used Source Analyzer and Target designer to import the source and target database schemas and the Mapping Designer to map the sources to the target, Mapplets and Transformation Developer.
Developed standard and re-usable mappings and mapplets using various transformations like expression, aggregator, joiner, source qualifier, router, lookup, and filter.
Configured the mappings to handle the updates to preserve the existing records using Update Strategy Transformation.
Made performance improvements to the database by building Partitioned tables, Index Organized Tables and Bitmap Indexes.
Used SQL tools like TOAD to run SQL queries and validate the data in warehouse and mart.
Involved in error checking and testing of ETL procedures and programs using Informatica session log.
Tuned performance of Informatica sessions for large data files by implementing Pipeline partitioning and increasing block size, data cache size, sequence buffer length, target-based commit interval.
Involved in designing and developing Reporting System using MicroStrategy 8.1.1.
Created prompts, metrics, facts and hierarchies at the MicroStrategy level in order to create the ad-hoc reports.
Environment: Informatica PowerCenter 7.1/8.1, Flat files, Oracle10g, MS SQL Server 2000, Erwin 7.2, PL/SQL, TOAD, UNIX (Solaris), Windows NT.
Contact this candidate