Please suggest what NOC to choose - 2171 or 2172 for each roles -
Company A - Current Project Job Duties - (Role - ETL Informatica Support and Administrator, Job Title Senior Consultant)
As an Informatica Administrator perform system administration of all Informatica Powercenter Client v10.1.1 environments including Production, Pre-Production (UAT) and QA (Testing), grant user access accounts, roles, privileges.
As a Support analyst provide Application and Environment Support with Research and Correct/Escalate the Data Issues in production
Handle Incident Management on Service Now, configuration management, operational change, problem determination and resolution on a 24x7 basis.
Change Management and work on listed scheduled tasks as per the release plan.
Handle all Service incidents and queries within the agreed service levels (SLA).
Perform Service Requests based on Standard Operating Procedures.
Experience with different connections like Relational connection, Native connections, and Application connections.
Handle issues independently and suggest/implement services improvements plans.
Identify and highlight scope of automation of manual activities.
Work on Manual and Automated Code Deployments and Release Management activities.
Coordinate with multiple teams to make sure environment is up to date and ready for testing before Production release.
Work with different stake holders on triage call, handling defects, Issue Analysis, communicate effectively, attend planning meetings, clearly articulate technical issues, define detailed tasks, represent on customer calls to make sure environment is stable and healthy
Experience in SDLC process, Change Data Capture on Power Exchange, agile methodology.
Experience in Windows and Linux environment, working knowledge on Linux Commands.
Communicate planned maintenance/outages to stakeholders and users.
Provide 24x7 rotational off hours on call support.
Create and maintain wiki documentation, technical writing and documentation
Company A Past Project Job Duties - (Role - ETL Informatica Developer, Job Title Technical Lead)
Informatica Developer using Informatica Power Centre v10.1.1 and v9.5.1
Attended business meetings and status calls with clients to understand requirements, database design and translated into technical specifications.
Extensively used ETL methodology for Extraction, Transformation, and Loading data into target tables using Informatica Power Center tools like Designer, Repository manager, Work flow manager, Workflow monitor.
Used various Transformations such as Source Qualifier, Lookup, Filter, Expression, Router, Joiner, Update Strategy, Rank, Aggregator, Stored Procedure, Sorter, Sequence Generator, Normalizer, Union, and XML Source Qualifier to develop Informatica Mappings, Sessions and Workflows.
Clear understanding and implementation of full Software Development life cycle (SDLC).
Worked with multiple sources such as Relational Databases, Flat files, Informatica power exchange(pwx) etc and also used Mapping Parameters and Variables.
Did thorough Unit Testing of source, target, sessions, and mappings and also did Integration Testing as part of data warehousing project.
Wrote basic Unix Shell Scripts required for the ETL processes.
Company B. Job Duties - (Role - BI Cognos Report Developer, Job Title Sales Reporting Professional)
✓ Responsible for development and implementation of various types of reports using IBM Cognos Business Intelligence Reporting tool applying Data Warehousing concepts.
✓ Handled various phases of projects that included requirement analysis, design, development, Implementation and testing for end-to-end IT solution offerings.
✓ Developed various types of reports like List, Cross tab, Chart, Dashboard and Active reports.
✓ Created Parameter map, filters, prompts, calculations, and published packages using Framework Manager.
✓ Created drill-through, Master-detail relationship and report views in Report studio.
✓ Involved in creating Burst report in report studio to distribute the report among multiple recipients.
✓ Applied Conditional formatting, Conditional style, Conditional block and Conditional variables on different kinds of prompt functionalities.
✓ Possessed extensive knowledge on different approaches to develop the reports for Data Warehousing concepts which were Managed/Complex reports.
✓ Worked on Master-detail relationships, Repeater table, Drill through between parent and child reports and self-drill through in a single report.
✓ Implemented Active reports functionality available in Cognos for the Sales Connect Execution Dashboard Project.
✓ Created dashboards with Crosstab, List, Chart, and maps with the available components in Active reports Deck, Data Deck, Tab Control, Button bar and data Button bar and provided interactive behavior between the components as per the business need.
✓ Provided the security features to protect the data and lead the project as and when required and suggested technical suggestion’s to improve the Active report performance.
✓ Worked on advanced features of Report Studio such as Conditional Variables, Conditional Blocks, Drill-through, Page Break, Master-Detail relationships and various kinds of prompts (Value prompt, Date prompt, Textbox prompt).
✓ Worked on user’s setup, also worked on Security part of Framework Manager.
✓ Created Query Prompts, Calculations, Conditions, and Filters in the Reports.
✓ Scheduled and distributed reports through TBS Manager.
✓ Worked extensively on MS Excel.
✓ Checked the output according to the specifications and improvised.
✓ Involved in the resolution of report performance issues.
✓ Involved in the Sanity Testing of the reports on weekly basis and updated the defect Tracking Tools.
