SUMMARY

• Around 6 + years of IT experience in Data warehousing with emphasis on Business Requirements Analysis, Application Design, Development, testing, implementation and maintenance of client/server Data Warehouse and Data Mart systems
• Involvement in all phases of SDLC (Systems Development Life Cycle) from analysis and planning to development and deployment
• Good proficiency in Informatica Data Quality 10.2.1/10.1.1 /9.6.1 and Informatica Power Center 10.2.1/10.1.1 /9.6.1
• Experience in dealing with the different source systems analysis and data extraction from various sources like Flat files, Oracle, DB2, Teradata files and extensively used ETL to load data using Power Center and Data Analysis using IDQ tool
• Strong experience working in data migration and conversion projects
• Establishes, enhances, implements, enforces, and maintains ETL, Data Quality and data integration best practices
• Experience in Data Extraction, creating Column Profiling, Rule Profiling, Mid - stream Profiling, Join analysis profiling, Data Domain, Domain discovery, Scorecards, Data lineage, Data Cleansing, Data Standardization, Match & Merge process and Data Deduplication using Informatica Data Quality 10.2 HF2.
• Good experience on rule specification, Mapping specifications, Virtual data objects (VDO), Custom Data Objects (CDO), Logical Data Objects (LDO), Physical Data Objects (PDO), Mapplets, Rules and Reference data management.
• Experience with deploying the mapplets as service and using them in downstream process.
• Extensively worked with complex mappings using various transformations like Expression, Lookup, Filter, Router, Union, Aggregator, Joiner, Update Strategy, Sequence generator, Labeler, Match, Merge, Decision, Exception, Key Generator, Standardizer, Case Converter, Consolidation, Parser, Address validator and Reusable Transformations, User Defined Functions etc.
• Expertise in building the mapplets for data Standardization, Address Validation, De-duplication Integrating the IDQ mapplets with Power Center.
• Involved in production support, resolving the production job failures, interacting with the operations support group for resuming the failed jobs.
• Involved in writing various UNIX shell scripts for writing automated scripts for scheduled queue process and pmcmd/infacmd command utilities
• Experience In working with various job scheduling tools like Autosys, Control-M, Informatica Scheduler
• Good working experience on onshore and offshore model
• Have Experience on Production on call support for the complex High Available databases, checking logs, debugging, provided work around to support the entire system for daily/Weekly/Monthly loads
• Identified and fixed bottlenecks and tuned the complex Informatica mappings for better Performance.
• Analytical, problem solving, technical, project management, training, and presentation skills.

TECHNICAL SKILLS

ETL/DQ Tools: Informatica PowerCenter 10.2.1/10.1.1 /9.6.1 , Informatica Data Quality (IDQ) 10.2.1/10.1.1 /9.6.1

Databases: Oracle 11g/10g/9i/8i, Teradata 15.1,16, SQL Server 2013, DB2

Languages: UNIX Shell Scripts, XML and SQL

SQL Tools: SQL plus, TOAD, Oracle SQL developer, PLSQL developer, IBM Data Studio, DBeaver

UNIX Tools: Putty, WinSCP, Jump Server secured access

Other Tools: SoapUI,MS Office, Service Now, HP QC, JIRA, Remedy

Operating Systems: Windows (NT,2000/03/XP/Vista/7), Linux (Red Hat), Unix AIX 5.0/5.2/6.0

Scheduler Tools: Autosys, Control-M and Informatica Scheduler

PROFESSIONAL EXPERIENCE

Confidential, Dallas, TX

ETL Informatica /IDQ Developer

Responsibilities:

• Interacted with the Business users to identify the process metrics and various key dimensions and measures. Involved in the complete life cycle of the project.
• Good proficiency in Informatica Data Quality 10.2.1/10.1.1 .
• Created profiles, rules, scorecards and mappings with Informatica Developer and Analyst Tool.
• Strong in implementation of data profiling, creating scorecards, Creating reference tables and documenting Data Quality metrics/dimensions like Completeness, Conformity, Accuracy, Consistency.
• Worked with Informatica Data Quality 10.2.1/10.1.1 . (Informatica Developer and Analyst Tool) to create Column profiles, DQ Rules, Mapplets, Scorecards.
• Design, Development and implementation of Informatica Developer Mappings for data cleansing using Address validator, Labeler, Parser, Expression, Filter, Router, Lookup transformations etc.
• Using IDQ, performing data quality operations such as data profiling, developing scorecards, column profiling, join analysis, creating reference tables etc.
• Expertise in building the mapplets for data Standardization, Address Validation, De-duplication Integrating the IDQ mapplets with Power Center.
• Good experience on rule specification, Mapping specifications, Virtual data objects (VDO), Custom Data Objects (CDO), Logical Data Objects (LDO), Physical Data Objects (PDO), mapplets, rules and reference data management.
• Creating command tasks, Email tasks to control sequence of Informatica workflows and configure failure notifications
• Worked on Migration of Data Objects, Profiles, Mapplets and Scorecards from one environment to other environment using Export and Import options in Informatica Developer Tool.

Environment: Informatica Developer 10.2.1/10.1.1 , Informatica Analyst Tool 10.2.1/10.1.1 , Agile, TOAD, Putty, PL/SQL, UNIX Shell Scripting, Flat Files

Confidential, NJ

Informatica Developer

Responsibilities:

• Work closely with team of business users to gather business requirements and translate into technical specifications.
• Created profile, rules and mappings with Informatica Developer and Analyst Tool.
• Strong in implementation of data profiling, creating scorecards, Creating reference tables and documenting Data Quality metrics/dimensions like Accuracy, completeness, duplication, validity, consistency.
• Worked with Informatica Data Quality 9.6.1 (IDQ) toolkit, Analysis, data cleansing, data matching, data conversion, exception handling, and reporting and monitoring capabilities using IDQ 9.6.1.
• Performed the data profiling and analysis making use of Informatica Data Quality (IDQ).
• Worked on different transformations like case converter, standardizer, labeler etc. for cleansing and standardize the data.
• Performing Informatica Admin tasks such as Migrating Informatica code between different environments.
• Using IDQ to perform data profiling, data cleansing, creating reference tables, scorecards etc.
• Wrote and ran different type of SQL queries, including create/insert/update on given databases
• Wrote complex SQL override scripts at source qualifier level to avoid Informatica joiners and Look-ups to improve the performance as the volume of the data was heavy.
• Performance tuning of Informatica mappings for large data files by managing the block sizes, data cache sizes, sequence buffer lengths and commit interval
• Developing mappings based on Change Data Capture (CDC) techniques.
• Using TOAD, IBM Data Studio, DBeaver etc. to analyze the existing data and to design SQL queries for mappings
• Involved in Unit, System integration, User Acceptance Testing of Mapping.
• Supported the process steps under development, test and production environment.

Environment: Informatica Data Quality 9.6.1, Informatica Power Center 9.6.1/9.5.1 SQL, Oracle 11g/10g, Autosys, QL Server, SQL* Loader, SQL developer, PLSQL developer, TOAD, Putty, PL/SQL, UNIX Shell Scripting, Flat Files, Control-M

Confidential, Atlanta, GA

Responsibilities:

• Documented user requirements, translate requirements into system solutions and developed an implementation plan and schedule.
• Extracted data from relational databases DB2, Oracle and Flat Files
• Developed Complex transformations, Mapplets using Informatica to Extract, Transform and load data into DataMart, Enterprise Data warehouse (EDW)
• Developed data Mappings, Transformations between source systems and warehouse
• Worked on OLAP, OLTP, Reporting and Analytics, Data Cleansing, Data Scrubbing, Data Migration and writing PL/SQL.
• Well Versed in building test strategy on IDQ Mappings, Profiles.
• Experience in profiling the data and performed Proof of Concept for Informatica Data Quality (IDQ)
• Created Profiles using IDQ rules and filters.

  Applying cleansing rules using IDQ.

• Tuned performance of Informatica session for large data files by increasing block size, data cache size, sequence buffer length and target-based commit interval.
• Performing Unit testing and tuned the mappings for the better performance
• Responsible to design, develop and test the software (Informatica, PL SQL, UNIX shell scripts) to maintain the data marts (Extract data, Transform data, Load data).
• Organized data in the report Inserting Filters, Sorting, Ranking and highlighting data

Environment: Informatica Power Center 9.6.1/9.5.1 , IDQ 9.5.1/9.6.1 , SQL

Confidential, Danbury, CT

Informatica Developer

Responsibilities:

• Wrote Informatica ETL design documents, establish ETL coding standards and perform Informatica mapping reviews
• Worked on Power Center 8.6 Client Tools like Power center Designer, Workflow Manager, and Workflow Monitor
• Worked on Power Center 8.6 Designer client tools like Source Analyzer, Target Designer, Mapping Designer, Mapplet Designer and Transformation Developer.
• Analyzed the source data coming from different sources (Oracle and SAP Flat files) and worked on developing ETL mappings
• Developed various Oracle sub functions like Stored Procedures, Functions, and Packages using PL/SQL in order to ensure the data integrity and security
• Created Process Control and Metadata for informatica jobs
• Created reusable Sessions, command tasks, worklets and workflows in Workflow Manager
• Utilized Informatica toolset (Informatica Data Explorer, and Informatica Data Quality) to analyze legacy data for data profiling
• Responsible for the Performance tuning at the Source Level, Target Level, Mapping Level and Session Level
• Performed Unit testing and Data validation testing using Validation scripts.
• Proven Accountability including professional documentation and weekly status report

Environment: Informatica Power Center 8.6, Oracle 10g, Flat Files,UNIX, Win XP, SQL * Plus.