PROFESSIONAL SUMMARY:

• Around 13 years of experience in designing, developing and maintaining large business applications such as data migration, integration, conversion, data warehouse and testing.
• Strong database experience in DB2,Teradata, Oracle and SQL Server.
• Experience in data warehousing and data processing based applications using Informatica Power Center 9.x/8.x/7.x, and Teradata.
• Extensively worked with Teradata utilities like BTEQ, TPT, Fast Export, Fast Load, Multi Load to export and load data to/from different source systems including Flat Files.
• Expertise in creating databases, users, tables, triggers, views, stored procedures, functions, packages, joins and hash indexes
• Hands on experience using query tools like TOAD, SQL Developer, PLSQL developer, Teradata SQL Assistant and Query Man.
• Experience in integration of various data sources like Oracle, SQL Server, Fixed Width and Delimited Flat Files, DB2, Excel, COBOL Files and XML Files.
• Used Informatica IDQ services to profile and document the structure and quality of data.
• Developed complex Informatica mappings from varied transformation logic like unconnected / connected lookups, router, filter, expression, aggregator, joiner, update strategy and experience in identifying bottlenecks in ETL processes, improving the performance of the production loads and data access using database tuning, index usage.
• Experience in creating reusable tasks (sessions, commands, worklets and email) and non - reusable tasks (decision, timer, assignment, and control) /or handling.
• Worked extensively on Informatica partitioning and bulk loading options when dealing with huge volumes of data.
• Experience in creating, modification and testing of Informatica mappings (type 1, type 2 and type 3) and session and workflows (sequence and concurrent) and Developed slowly changing dimension mappings for type 1 SCD and type 2 SCD.
• Hands on experience on Informatica Web Services and understanding and working knowledge of Informatica Confidential (Change Data Capture).
• Worked on UNIX-Shell Scripting for file validations, pre-session, post-sessions tasks and also automated the scripts using a scheduling tool.
• Knowledge of different Schemas (Star and Snow Flake Schemas) for query and business analysis requirements.
• Experience in working on implementation of data warehouse and strong understanding of data warehouse concepts, data modeling experience using star schema/snowflake modeling for OLAP systems, ER diagrams, dimensional data modeling(Kimball), fact and dimensions tables, physical and logical data modeling using Erwin.
• In-depth insight of CMMI, SDLC and various software and architecture methodologies and process improvement approaches.
• Effectively made use of table functions, indexes, table partitioning, collections, analytical functions, materialized views.
• Developed complex database objects like stored procedures, functions, triggers using SQL and PL/SQL.

TECHNICAL PROFICIENCIES:

DWH Tools: Informatica Power Center 9.x/8.x/7.x, Power Exchange, IDQ,IDE, Informatica B2B DT,MS SSIS, MS DTS, Informatica Address Doctor

Data Modeling: Star Schema Modelling, Snow Flake Modelling, FACT and Dimensions

Databases: DB2, Teradata 13x/14x, Oracle 11g/10g/9i, MS SQL Server 2005,knowledge of Big Data/Hadoop and Amazon Web Services.

Languages: SQL, PL/SQL, UNIX Shell Script. knowledge of Core JAVA

Database Utilities: Toad, SQL editor, SQL Assistance, SQL Plus

Job Scheduling Tools: Redwood Chronicle, Control M, IBM Tivoli Workload Scheduler - TWS

Version Controls: Harvest

Others: HPQC, JIRA, BUGZILLA and HP Service Desk, People Soft, Microsoft Project Planning MPP, SharePoint, Documentum, Track+, Project Management Tool, Service Now, IDM Tool

PROFESSIONAL EXPERIENCE:

Confidential

SQL Developer

Responsibilities:

• Experience in integration of various data sources like Oracle, SQL Server, Fixed Width and Delimited Flat Files, DB2, Excel, COBOL Files and XML Files.
• Used Informatica IDQ services to profile and document the structure and quality of data.
• Developed complex Informatica mappings from varied transformation logic like unconnected / connected lookups, router, filter, expression, aggregator, joiner, update strategy and experience in identifying bottlenecks in ETL processes, improving the performance of the production loads and data access using database tuning, index usage.
• Experience in creating reusable tasks (sessions, commands, worklets and email) and non - reusable tasks (decision, timer, assignment, and control) /or handling.
• Worked extensively on Informatica partitioning and bulk loading options when dealing with huge volumes of data.
• Experience in creating, modification and testing of Informatica mappings (type 1, type 2 and type 3) and session and workflows (sequence and concurrent) and Developed slowly changing dimension mappings for type 1 SCD and type 2 SCD.
• Hands on experience on Informatica Web Services and understanding and working knowledge of Informatica Confidential (Change Data Capture).
• Worked on UNIX-Shell Scripting for file validations, pre-session, post-sessions tasks and also automated the scripts using a scheduling tool.
• Knowledge of different Schemas (Star and Snow Flake Schemas) for query and business analysis requirements.
• Experience in working on implementation of data warehouse and strong understanding of data warehouse concepts, data modeling experience using star schema/snowflake modeling for OLAP systems, ER diagrams, dimensional data modeling(Kimball), fact and dimensions tables, physical and logical data modeling using Erwin.