We provide IT Staff Augmentation Services!

Informatica / Teradata Consultant Resume

PROFESSIONAL SUMMARY:

I have done B.Tech and have 9+ years of professional experience in Data WareHousing and Telecom Domain working on ETL tools like Informatica, Telecom Billing tools like Kenan Arbor and Oracle BRM. I also have expertise in Databases like Oracle and Teradata. I have good knowledge of UNIX and PL/SQL and have been involved in all phases of Software Development i.e. analysis, designing, coding, testing, implementation in Development and Production Support & Maintenance projects.

TECHNICAL SKILLS:

Tools: Informatica PowerCenter 8.6, Dollar Universe (Orsyp), ControlM, TOAD, BTEQ, FLOAD, MLOAD, TPUMP

Programming Languages: PL/SQL

Operating Systems: UNIX AIX5.2, Windows

Databases: Oracle, Teradata

WORK EXPERIENCE:

Confidential

Informatica / Teradata Consultant

Responsibilities:

  • Understanding business requirements / major - minor enhancements (CRs) and simulating the same in terms of Informatica mapping logics.
  • Working extensively on all different and aggressive involvement in End-to-end design of several mappings.
  • Scheduling the workflows (along with extra business logics) through shell scripts.
  • Troubleshooting failures encountered during automated scheduling through Monitoring tools / Schedulers like Dollar Universe (Orsyp).
  • Intensive hands-on in Teradata SQL assistant and utilities like BTEQ, Fastload, and Multiload etc.
  • Involvement in of team members and new joiners in different subject areas.

Confidential

Informatica Consultant / Billing Functional Analyst

Responsibilities:

  • Understanding business requirements / major - minor enhancements (CRs) and simulating the same in terms of Informatica mapping logics.
  • Working extensively on all different transformations and interpreting the business logic used for mappings between two heterogeneous systems.
  • End-to-end design of several mappings and scheduling the workflows (along with extra business logics) through shell scripts.
  • Troubleshooting failures encountered during automated scheduling through Monitoring tools / Schedulers like Control M.
  • Understanding business req. by interacting with customer & on site teams and working on Functional Analysis of customer’s billing system
  • Responsible for RCA’s for all incidents logged due to errors during Rating/Billing and working towards resolution of defects / incidents raised
  • Helping team members in resolving Kenan issues efficiently and thereby providing timely resolution of issues.
  • Ensuring that deliverables are of high quality and that they meet the required deadline without compromising on quality.

Confidential

Informatica Consultant / Billing Functional Analyst / Onsite Co-ordinator

Responsibilities:

  • Understanding Client requirements and simulating the same in terms of Informatica mapping logics.
  • Working extensively on all different transformations.
  • Also, have end-to-end designing experience with workflows, sessions and mappings and exensive involvement in Performance tuning activities. Involvement in of new team members.
  • Providing solutions to Kenan issues in Confidential and troubleshooting Special Price Agreements and Help Desk Tickets
  • Provided Kenan to team members and new joiners Planning & executing Confidential Application Maintenance activities and ensuring high quality deliverables and meet deadlines and SLAs. Complete solution design and development of new configurations / functional enhancement projects Working with OSS/BSS team of Confidential in areas of Usage, Rating, Product Configuration, Discounts, Billing and Interfaces.
  • Working on the entire SDLC including requirement analysis, effort estimation, preparing Detailed
  • Design Documents, development, Unit Testing, Integration Testing, packaging & delivering to production and post-production support in the releases

Confidential

IT Architect

Responsibilities:

  • Considering both the business and the technical needs of the customers and stakeholders with the goal of providing quality solutions or products that meets user needs
  • Focusing on defining customer needs and translating those needs, expectations and constraints into a comprehensive technical solution baseline that provides the project framework.
  • Documenting requirements, and then proceeding with design synthesis and system validation
  • Co-coordinating with the development teams and making sure that the developed code is in sync with the Client needs/Business Requirement.
  • Managing end-to-end Project Life cycle

Confidential

Production Support Engineer

Responsibilities:

  • Working on integrating different systems like Billing, Provisioning, CRM etc, with ETL logics. Being responsive in resolving problems, providing feedback to the customer, pro-active in identifying and avoiding potential problems and risks Developing the required level of technical and business skills and ensuring complete and accurate documentation is obtained and maintained
  • Working extensively in areas such as Application Management, Application monitoring, Database management, Application Logical security, Configuration Management, Application Performance Management, Production scheduling and execution, Incident Management and Escalation and Problem Management
  • Responsible for overseeing the Quality procedures related to the project and meeting all committed Service Level Agreements (SLAs). Giving to the new members of the team.

Hire Now