SUMMARY

• Over 6 years of experience as Informatica Developer and database technologies such as MS - SQL Server, Confidential, MySQL.
• Hands on experience in development and debugging using ETL tools such as Informatica.
• Extensive working experience in Database … SQL, PL/SQL, Stored Procedures, Functions, Ref Cursors, Constraints, Triggers, Indexes, Views, Materialized Views, and SQL Loader.
• Hands on experience in designing the Database … objects in 3NF.
• Expert in TSQL DDL/DML, perform most of the SQL Server Enterprise Manager and Management Studio functionality using T-SQL Scripts.
• Strong object oriented programming skills.
• Hands on experience of developing Mappings, Sessions, and Workflows using ETL tool (Informatica).
• Hands on experience in debugging Informatica mappings to identify the data load issues.
• Experience in Batch processes, Import, Export, Backup, Database Monitoring tools and Application support.
• Extensive experience in Database query and Performance tuning.
• Good knowledge in using data modelling tools like ER diagrams. Normalization Techniques for designing database with Relational technology on N-Tier Architecture.
• Good knowledge in STAR Schema, Snow Flake Schema, FACT Tables and Dimension Tables.
• Hands on Experience in Mainframes technologies such as DB2, JCL.
• Proficient in application development and enhancements using Confidential SQL, PL/SQL.
• Providing Data and code fixes for the incidents raised by the business users as part of application support activity.
• Extensive knowledge in Unemployment Insurance.
• Ability to independently handle L1 and L2, P1 and P2 level support issues.
• Creation and maintenance of database objects like Ad hoc SQL Queries, tables, views, index, synonyms and sequence etc.
• Regularly monitoring Production servers.
• Regularly attending client calls to discuss various issues & development tasks and have good communication and interpersonal skills with experience of functioning as morale owner of the team and a good team player.
• Superior communication, presentation, analytical and problem solving skill. Work well with all levels of business.
• Highly analytical thinking with demonstrated talent for identifying, scrutinizing, improving, and streamlining complex work processes.

TECHNICAL SKILLS

Operating System: Windows, Linux

RDBMS: Confidential 9i /10g/ 11g, MS SQL Server 2005/ 2008/ 2012MySQL, DB2, PostgreSQL

Scripting Languages: UNIX Shell Scripts

ETL & Data Warehouse: Informatica, Confidential

Tools/ Utilities: Toad, PL/SQL developer, SQL* Plus, Putty, WinSCP

Programming Languages: C, C++

Domain Skill: Insurance, Retail

PROFESSIONAL EXPERIENCE

Confidential

Sr. ETL Developer

Software Used: MS-SQL Server, Confidential, DB2, VSAM Informatica Power, Center 10.0, Power Center 10.2, Power Exchange 10.0.

Responsibilities:

• Requirements gathering through table level and column level mappings and knowing client’s data element fields and their data structures.
• Writing the transformation rules based on the column level mapping discussions.
• Installation and configuration of Informatica Power Exchange and Power Center on the Conversion/mainframe servers.
• Created the staging Database with Legacy tables and structures in MS SQL Server.
• Extracted the Client’s VSAM, DB2, Confidential and SQL server data to our SQL server staging Database by creating data maps in Power Exchange.
• Experience in extracting the VSAM binary files, VSAM data directly from the main frame server by establishing the site to site connection, DB2 data using DB2 connect in Informatica power center.
• Development of transformation rules as per the column level mapping document using various transformation techniques in Informatica.
• Good experience in writing various complex SQL queries using joins at the Informatica Source qualifier level to increase the performance of huge data set mappings.
• Expert in using various transformations like Joiner, Aggregator, Expression, Router, Look upUnion in Informatica.
• Experience in performance tuning of Informatica mappings at both session and workflow level.
• Experience in creating the incremental load mappings to capture the change data in the target tables.
• Experience in designing SCD type 1, type 2 and type 3 mappings.
• Involved in data cleansing to see that accurate data is being loaded in the target.
• Data validation by wring the SQL queries after the data has been converted into target tables.
• Data scrambling and encryption of identified PII columns in the data base to ensure the data security.
• Identifying and resolving the defects raised by the clients during UAT.

Confidential

Software Used: SQL Server, Confidential, Informatica Power Center 9.0, 9.1, 9.5

Responsibilities:

• Gathering the requirements and developing the Informatica mappings using custom transformations available in Informatica to load the data into the target environment for various clients.
• Understanding the data structure and load the data into each client’s region every week after the application build releases.
• Data cleansing of any unstructured data.
• Writing several complex sql queries which will be used for validation purposes which helps in client’s UAT testing.
• Performance tuning of Informatica mappings at mapping, session and workflow level.
• Experienced in using several re-usable mapplets.
• Scheduling the weekly jobs and monitoring of the jobs at the session and workflow level.
• Fixing the defects/bugs raised by client’s UAT testers.
• Experience in production support and Front end application support to the users.