SUMMARY

• Over 6+ years of experience as Data Warehousing Analyst, ETL developer in Investment banking and Insurance sectors.
• Designed and developed different slowly changing dimension procedures for various data loading based on the business requirements.
• Experienced in all phases of ETL such as extraction, Transformation and loading using informatica.
• Strong in data ware housing concepts, dimensional tables, fact tables, Dimensional data modelling, Star Schema and Snowflakes Schema methodologies.
• Proficient in the integration of various data sources with multiple relational databases like Oracle 10g, MS SQL Server, Flat files and Mainframe into staging area, Data Mart, ODS, DATAWAREHOUSE
• Strong knowledge on data structures and Data Modelling
• Hands on experience in tuning mappings, identifying and resolving performance bottlenecks in various levels like sources, targets, mappings and sessions.
• Experience in creating Mappings and Mapplets using various Connected and Unconnected transformations like Source Qualifier, Aggregator, Expression, Lookup, Filter, Joiner, Union, Router, Rank, Sequence Generator and Update strategy transformations.
• Extensively created and used various Teradata Set Tables, Multi - Set table, global tables, volatile tables, temp tables.
• Have RDBMS concepts experience in Oracle 11i/10g/9i/8i/7.x, WinSQL, SQL*Loader, Netezza.
• Have Experience in designing and developing UNIX shell scripts as part of the ETL process to compare control totals, automate the process of loading, pulling and pushing data from & to different servers.
• Created complex UNIX Wrapper scripts to trigger Workflows from UNIX to executeInformaticamappings.
• Worked with UNIX shell scripts extensively for job execution and automation.
• Experienced in working for the post development cycle and applications in Production Support.
• Extensive experience in developing Stored Procedures, Functions, Triggers, Views, Cursors, Packages, Exceptions, Joins, Sub Queries and Set Operators.
• Pleasant experience in coordinating with different teams to speed up the development process.
• Experienced in Performing Unit testing, system testing and system integration testing.
• Experience in working with job schedulers and monitoring tools.
• A well-organized, goal-oriented, highly motivated effective team member with excellent analytical, trouble shooting, and problem-solving skills. Ability to work individually and meet tight deadlines.
• Experience in agile, waterfall and other methodologies.

TECHNICAL SKILLS

ETL Tools: Informatica Power Center 10/9.5.1/9.1/ 8. x

DATABASES: Oracle 11g/10g/9i and SQLServer2014

Scheduling Tools: Autosys,Control-M

Oracle Tools: SQL PLUS, SQL Developer and TOAD

Business Intelligence: BO 3.1

Languages: PL/SQL, SQL, TOAD, UNIX Shell Scripting and Batch scripting

Operating Systems: UNIX/LINUX and Windows NT/XP

PROFESSIONAL EXPERIENCE

Confidential, Rockville,MD

Informatica Devoloper

Responsibilities:

• Worked with SME’s (Subject Matter Experts) to understand the business and technical requirements to be implemented for ETL
• Data Quality Analysis to be determined for cleansing requirements
• Worked on data modelling for the business objects
• Developed several complex mappings in Informatica a variety of Power Center transformations, Mapping Parameters, Mapping Variables, Mapplets& Parameter files in Mapping Designer using Informatica Power Center.
• Developed standard and reusable mappings and Mapplets using various transformations like expression, aggregator, joiner, source qualifier, router, lookup, and filter.
• Assign work and provide technical oversight to onshore and offshore developers
• Responsible for regression testing ETL jobs before test to production migration
• Extensive experience on Deadlock issues
• Extensively worked on Viewpoint for Teradata to look at performance Monitoring and performance tuning.
• Performance tuning through SQL tuning, indexes and INFA mapping and session level
• Worked with DBA to create schema instances and tables in DEV, TEST & PROD
• Involved in performance tuning with Informatica and database
• Created Connected, Unconnected and Dynamic lookup transformation for better performance
• Created multiple partitions in sessions to allow the data to be loaded concurrently.
• Responsible for creating complete test cases, test plans, test data, and reporting status ensuring accurate coverage of requirements and business processes. Involving in Functional Testing & Regression Testing
• Implemented partitioning and bulk loads for loading large volumes of data.

Environment: Informatica Power Center 9.5.1/8.6.1 Oracle 10g, Teradata, SQL Server 2008, Toad, SQL PlusSQL Query Analyzer, SQL Developer, MS Access, Windows NT, Shell Scripting, Clear Quest, Tivoli Job Scheduler

Confidential

Informatica Devoloper

Responsibilities:

• Worked closely with the Business Analysts to understand the Data requirements, definitions, and business rules to be implemented for accurate ETL programs
• Working in IDQ to create mapping & workflows
• Created dynamic script to execute tables in Database
• Worked on JSON format data converting into database tables
• Worked on XML files in IDQ by using hierarchal to relational transformation to populate data into tables
• Defined parameters and variables to increase their usability in mappings
• Analyze the Existing code and do the impact analysis.
• Developed the Teradata Macros, Stored Procedures to load data into Incremental/Staging tables and then move data from staging into Base tables
• Extensively worked with Source Qualifier Transformation to join the homogeneous sources and heterogeneous sources
• Extensively used Informatica debugger to figure out the problems in mappings. Also, involved in troubleshooting existing ETL bugs.
• Involved in developing the SQLs, which are used to apply all business rules on the data before load into the target tables.
• Analyze and fix defects raised during testing and tracking it to closure. Also involved in production support and fixing the production issues.
• Implemented optimization techniques for performance tuning and wrote necessary Pre-& Post session shell scripts.
• Extensive involvement with the Quality Assurance team for building exhaustive set of test cases.
• Created mappings using Reusable Transformations and mapplets.
• Created and maintained Technical specification documents.
• Working experience using Push Down Optimization.
• Implemented audit process to ensure Data warehouse is matching with the source systems in all reporting perspectives.

Environment: Informatica Power Center 9.6.1, Oracle 11g, SQL, PL/SQL, TOAD, Microsoft Visio, Autosys Scheduler Tool, SQL Server 2008

Confidential

Support engineer

Responsibilities:

• Handling outages in the applications CMDW, Valuations, Margins.
• Handling escalations from clients on business requirements.
• Acting as shift lead and taking up the responsibility of support activities
• Cracking business logics in informatica upon client queries.
• Working with client service managers to understand the impact on the outages.
• Working with different upstream and downstream teams in case of issues.
• To act on SLA and OLA and escalate when needed.
• Working with development team in planning and Executing production releases / software upgrades on weekdays and on weekends for Cash Equities and Derivatives production environment.
• Worked with business analysts to identify appropriate sources for Data warehouse and to document business needs for decision support data.
• Resolving intraday trading issues for Front Office traders. Trader support.
• Building and automation of complex queries to generate reports client analysis.
• Daily BAU activities received via email and various chat channels (Office Communicator/Microsoft Group Chat/Reuters Messenger) and to make sure it’s taken care of without delay.
• Provides the consistent communication on the tickets to the end user and IT groups along with Estimated Time to Resolve(ETTR)Raising a respective CRQ ticket drafted with all details required.
• Identify if any potential risk and impact due to a change.

Environment: Informatica Power Center 9.1, Oracle 10g/9i, SQL, TOAD, Putty, Control-M, Geneos