We provide IT Staff Augmentation Services!

Informatica Developer Resume

Whippany, NJ

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.

Hire Now