SUMMARY

• Six Years (6) of Total IT Experience in Analysis, Design, Development, Implementation, Testing and maintenance of Business Intelligence solutions using Data Warehousing/Data mart design, ETL, OLAP,OLTP client /server applications.
• Strong Data warehousing and ETL experience using Informatica Power Center and IDQ 9.5/9.1.x/9.0.x/8.6.x Meta data Manager, IDQ Developer/Analyst 9.5.1, Warehouse Designer, Source Analyzer, mapping Designer, Transformation Developer, Mapplet Designer, Mapping Designer,Shell Scripts creations.
• Good knowledge upon RDBMS, OLAP, OLTP, Data Marts, ODS Systems.
• Create Mappings, work flows in both Power Center and IDQ.
• Anal yze the data by query db tables and schemas.
• Create stage tables and identify the discrepancies by profiling, Score Cards generations.
• Standardize the data by applying the DQ Rules.
• Work closely with software developers/project owners and BA's to develop and execute thorough test suites in all phases of the software development cycle
• Develop Test strategy, test plan/design, execute test cases and defect management for the ETL & BI systems
• Develop and execute detailed ETL related functional, performance, integration and regression test cases, and documentation
• Analyze and understand the ETL work flows developed
• Quality Management - Knowledge of quality management methods, tools and techniques
• Create UNIX shell scripts to access and move data from production to development environment
• Communicate- and manage expectations of the senior management team and affected stakeholders during the planning and roll out of project releases.
• Good working knowledge on Agile and Waterfall models.
• Determine the correctness by looking at different dimensions.
• Support the Dev and test teams for smooth project migrations.
• Mapping experiences with SCD TYPES, Master, Transactional Subject areas & other dimensional models with respect to ETL Data warehouses.
• Maintained warehouse meta data, naming standards and warehouse standards for future application development.
• Performing Profiles, Standardization, Identifying Anomalies, creating/Applying rules and created mappings/mapplets.
• Performed gap analysis between the current state and future data warehouse environment identifying data gaps and quality issues plus recommending potential solutions.
• Used MDM/IDQ effectivel y to identif y the golden records.
• Data modeling experience using Star Schema/Snowflake modeling, FACT & Dimensions tables, Relational & Dimensional tables in perspective of Master and Transactional data.
• Good knowledge upon databases using Oracle 11g/10g/9.x/8.x/7.x, MS SQL Server 2000/2005, SQL, PL/SQL, SQL * Plus, SQL*Loader, Toad 8.x . 0/ 9.1/ 10.3.3.0/ 11.5 , Teradata mload.
• Good hands on Cyber Ark.

TECHNICAL SKILLS

• Informatica PowerCenter 9.5/9.1.x/9.0.x/8.6.x/8.1.x(Repository Manager, Source Analyzer, IDQ Developer/Analyst 9.5.1,Designer, Server manager, Work Flow Monitor,Talend Studio, TAC, Warehouse Designer, Mapplet Designer, Mapping Designer, Work Flow Manager), Metadata Manager 8.x, OLAP, OLTP, IDQ/IDE,SQL * Plus, SQL * Loader, Informatica Data Quality, Informatica Data Profiler
• Business Objects 6.5/6.0/5.1/5.0 ,SQL Server Reporting 2005, Siebel Analytics 7.8, OBIEE 10.x/11.x,Cognos 8.1/8.2/8.3/8.4
• Physical Modeling, Logical Modeling, Relational Modeling, Dimensional Modeling (Star Schema, Snow-Flake, FACT, Dimensions), Entities, Attributes, ER Diagrams, ERWIN, ERStudio 7.1/6.1
• Other Tools HP Service Manager, IBM Rational Clear Quest 7.1.1.3.
• SQL, UNIX
• IBM Tivoli Manager 5.0, Crontab.
• UNIX , RedHat Linux 5.x/4.x/3.x, Linux 2.6.32 Solaris, Windows 2008/2003/2000/ XP
• TOAD, RapidSQL, SQL Plus, CYGWIN (X-Windows Server), Winscp, Core FTP LE 2.2, Putty, AIX Servers,SONAS,EDGE Servers.
• Jenkins, GITHUB

PROFESSIONAL EXPERIENCE

Confidential, Whippany, NJ

Informatica Developer

Responsibilities:

• Work closely with software developers/project owners and BAs to develop and execute thorough test suites in all phases of the software development cycle
• Develop Test strategy, test plan/design, execute test cases and defect management for the ETL & BI systems
• Develop and execute detailed ETL related functional, performance, integration and regression test cases, and documentation
• Analyze and understand the ETL work flows developed, Also Developed workflows/Mappings.
• Quality Management - Knowledge of quality management methods, tools and techniques
• Create UNIX shell scripts to access and move data from production to development environment.
• Communicate- and manage expectations of the senior management team and affected stakeholders during the planning and roll out of project releases

Environment: Informatica PowerCenter 9.6. 1/10.1 (Repository Manager, PowerCenter Designer, Talend Studio, TAC Admin Console, Workflow Manager, Workflow Monitor), IDQ 9.5.1, Informatica Data Analyst,IDQ,Oracle 11g/10g, AWS, S3, Snowflake, Flat files, Unix, Linux, Window 10, Red shift SQL, Aginity

Confidential

Informatica Developer

Responsibilities:

• Work closely with software developers/project owners and BAs to develop and execute thorough test suites in all phases of the software development cycle
• Develop Test strategy, test plan/design, execute test cases and defect management for the ETL & BI systems
• Develop and execute detailed ETL related functional, performance, integration and regression test cases, and documentation
• Analyze and understand the ETL work flows developed, Also Developed workflows/Mappings.
• Quality Management - Knowledge of quality management methods, tools and techniques
• Create UNIX shell scripts to access and move data from production to development environment
• Communicate- and manage expectations of the senior management team and affected stakeholders during the planning and roll out of project releases

Environment: Informatica PowerCenter 9.6. 1/10.1 (Repository Manager, PowerCenter Designer, Workflow Manager, Workflow Monitor), IDQ 9.5.1, Informatica Data Analyst,IDQ,Oracle 11g/10g,Flat files, Unix, Linux, Window 10, Autos y s, Bitbucket, Mongo DB, SQL Developer 3.0,QC, TQM.

Confidential

Informatica Developer

Responsibilities:

• End to end support have provided from a project stand point.
• Provided the solutions to the data design team for modelling.
• Worked effectively with the DBA’s for the table creations
• Prepared the DBCR’s
• Worked on Jira for creating the User stories and providing necessary updates on the work assigned for the assessment of higher management.
• Worked on Jenkins deployment of codes across environments.
• Good working knowledge on GITHUB.
• Comfortable working on the shell scripts.
• As a normal work activity comfortable on working with Informatica and other related job activities.
• Good hands on Cyber Ark.
• Worked on service now request and Incident Management tickets.
• Worked on mango data files testing and also QA Support activities.

Environment: Informatica PowerCenter 9.6. 1/10.1 (Repository Manager, PowerCenter Designer, Workflow Manager, Workflow Monitor), IDQ 9.5.1, Informatica Data Analyst,IDQ,Oracle 11g/10g,Flat files, Unix, Linux, Window 10, Crontab, Tivoli, SQL Developer 3.0, Teradata 16.20, Cyber Ark.