SUMMARY:

• 10+ years of IT experience in Data warehouse/ Data Integration using Informatica power center 9.x/8.x & Informatica Data Quality.
• Strong experience in Data Warehousing, Data Analysis, ETL, testing methodologies, development and Documentation.
• Strong troubleshooting skills, strong experience of working with complex ETL in a data warehouse and Master data management environment.
• Extensively worked with Informatica Tools - Source Analyzer, Warehouse Designer, Mapping Designer, Mapplet Designer, Transformation Developer, Informatica Repository Manager and Informatica Developer 9.6.1.
• Strong working experience in Informatica Data Integration Tools- Repository Manger, Designer, Workflow manger and Workflow monitor.
• Worked extensively with complex mappings using Expressions, Joiners, Routers, Lookups Update strategy, Source Qualifiers, Aggregators to develop and load data into different target types
• Extensive experience in creating the Workflows, Worklets, Mappings, Mapplets, Reusable transformation and scheduling the Workflows and sessions using Informatica Power Center.
• Worked on integrating data from flat files - fixed width and delimited files.
• Highly skilled in creating unit test cases and testing of developed code.
• Involved in Performance tuning of Informatica mappings and sessions.
• Experiences in executing Unit testing, Regression testing, Performance Testing System Testing, Integration Testing.
• Experienced in Informatica Administrator tasks like upgrade/install of Informatica server, troubleshooting issues with Informatica Server & Repository
• Extensive knowledge on project management methodologies, software development life cycle methodologies.
• Involved in Life cycle of projects such as requirements analysis, Design, Testing and Implementation Phases.
• Strong technical skills in Oracle- SQL and PL/SQL.
• Good knowledge of Data Marts, Data warehousing, Operational Data Store (ODS), OLAP, Data Modeling like Dimensional Data Modeling, Star Schema Modeling, Snow-Flake Modeling, FACT and Dimensions Tables.
• Experience in UNIX shell scripting & PERL scripting.
• Involved in writing shell/Perl scripts in UNIX for Informatica ETL tool to run the workflows.
• An acknowledged Onsite coordinator from the development Team which included all the processes right from the User Requirements collection till the production support.
• Experience in SPARQL & Semantic MediaWiki.
• Experience in Business Objects XI R2/ 6.5
• Proven Project & People Management skills, proficient in managing widely-divergent, concurrently occurring projects within agreed cost / time lines, by using strong organizational skills, out-of-the-box thinking, and innovative problem solving abilities.
• Have strong communication, analytical, organizational and relationship management skills. Successful track record in accomplishing assigned projects within agreed cost & timelines.

PROFESSIONAL EXPERIENCE:

Confidential, New York, NY

Informatica Administrator, SPARQL and Semantic MediaWiki Developer

Responsibilities:

• Implementing IDQ rules for analyzing quality of data in the flat files.
• IDQ Coding (involves designing logical data models, mappings, workflows, profiles and scorecards).
• Writing SPARQL generators and queries in blazegraph on rdf triples to get inference results and displaying them on wiki using semantic MediaWiki forms & templates.
• Working with various teams to help them with IDQ and doing POCs to address their data quality needs. Example, POC on address validator for CDO.

Environment: Linux, Informatica Data Quality (IDQ) 9.6.1, SPARQL, and Blazegraph database, Semantic MediaWiki.

Confidential

Lead Informatica developer, Informatica Administrator

Responsibilities:

• Analyzing new requirements by talking to business users.
• Estimation.
• Creating design document.
• Coding (involves designing Informatica mappings, Perl/Unix scripts, oracle stored procedures)
• Unit testing, SIT & UAT of code.
• Managing Informatica administrative tasks & Informatica upgrade tasks.
• Providing UAT and Production Support.
• Providing support to operate team during production deployments.

Environment: & Tools - Linux, Oracle 10g/11g, Informatica 9.1, Unix Shell & PERL scripting.

Confidential

Lead Informatica developer, Informatica Administrator

Responsibilities:

• Analyzing new requirements by talking to business analysts.
• Estimation.
• Creating design document.
• Coding (involves designing Informatica mappings, Perl/Unix scripts, and oracle stored procedures).
• Unit testing, SIT & UAT of code.
• Regression testing for major changes in UAT.
• Managing Informatica administrative tasks & Informatica upgrade tasks.
• Providing UAT and Production Support.
• Providing support to operate team during production deployments.

Environment: & Tools - Solaris/Linux, Informatica 8.1.1/9.1.1, Oracle 10g/11g, Unix Shell & PERL scripting.

Confidential

Informatica, Business Objects reports Developer

Responsibilities:

• Handled DAC reconciliation independently and was responsible for all activities that come under the project scope.
• Analyzing new business requirements given by onsite coordinator.
• Design, Development and enhancement of given requirements.
• Testing of code developed.
• Developing shell scripts and making changes in the existing scripts if needed.
• Additional responsibilities were quality related documentation, quality assurance.

Environment: & Tools - UNIX, Informatica 7.1.4/8.1.1, Business Objects 6.5/ XI R2, Oracle 9i.