Now you can Instantly Chat with Suryakant!
About Me
Total 7 years of experience as ETL – INORMATICA Developer, ETL Tester, ETL Production Support in Telecommunication and Digital Media Domain. Strong knowledge on Oracle Database, Oracle SQL & Microsoft SQL concepts, Performance tuning, ETL (Extract,...
Show MoreSkills
Positions
Portfolio Projects
Description
- 2.5 years
- Developer & Tester
- Domain : Telecom
- DW STAGE BASECAMP is the temporal data stores with some persistence where source data is housed until integration has occurred. Some integration, standardization or cleansing could occur from ETL1 into Staging, but this is kept to a minimum. Staging lends itself to providing operational data for performance monitoring (i.e., Dashboards and Alerts) on a near real-time basis. In addition, Staging could be used as a data source for non-integrated data (i.e., Independent Data Marts (IDMs))
- Interacting with Business/Clients to gather the Requirement, understanding the requirements and preparation design documents.
- Understanding the requirement.
- Analyze Sources, targets, transform the data, map and load the data into Targets using Informatica Tool.
- Developed data Mappings between source systems and warehouse components using Mapping Designer to fulfill the business requirements.
- Develop the HLD, create mappings, Sessions, and workflows with the help Source to target Mapping Document.
- Code Development, Unit Test Case Preparation and Executions.
- Managing day-to-day client relationship and on-going service delivery.
- Maintenance of the application.
- Change Requests in mappings and workflows.
- Resolving issues in case of any simple to complex failures.
- On-call support for production system to resolve any issues.
- Fix the issues and work on to meet the specified SLA
Description
- 2.5 years
- Development and Testing
- Domain : Telecom
- The CenturyLink Company Data Warehouse (CCDW) is intended to serve as the single, official source for detailed billing and inventory information for the combined entities of Legacy Q and Legacy CTL. It is loaded nightly with information from the source billing and inventory systems.
- CCDW provides a combined company star schema Data mart (facts and dimensions) for three major subject areas; revenue, ending in service, and product activity. CCDW is full summarized data
- Interacting with Business/Clients to gather the Requirement, understanding the requirements and preparation design documents.
- Develop the HLD, create mapping, mapplets, sessions, worklets and workflows to fulfill the business requirements.
- Impact analysis for any change requirements or enhancements
- Unit testing the Informatica mappings with sample data to validate the code against the business requirements.
- Debugging the issues during the unit testing of the flows.
- Working on Change Requests in mappings and workflows as per client requirement.
- Resolving issues in case of any simple to complex failures.
- Collaborating with the onsite Manager/Team member to research into ways of improvement of the application which include new enhancements for the application optimization and greater usability acceptance.
- Interacting with clients for any source data issues and solving them up by digging into the Informatica codes.
- Creating deployment groups, Working with Production Support team during deployment and validating the production deployment.
- Being part of production quick fixes and outage managements to avoid the issues in production environment.
Description
- 1+ year
- Development, Testing and Support
- Domain : Digital Media
- Worked on a project where the company provides Leads and Inquiries to a financial institutions like Banks and insurance companies through advertisements from SEO, websites, Social Networking Sites and Call centers.
- Create Inquiries and Leads from the advertisements, make sure the Leads are valid by validating the details they have provided after filling the form on the web page from the advertisement link. Provide the Leads and Inquiries to the financial institutions and earn the revenue based on the number of clicks, Leads, Inquiries and number of closures.
- Whenever users clicks the advertisements they see on any websites like Google, Yahoo or any news websites or through social media like Facebook, tiktok, instagram, emails, or call centeres and convince them to buy Insurance, Home mortgage, Home Loan refinancing etc. As part of this projects we need to all the data related to the customers, advertising companies, financial institutions and track them till the closure and charge them accordingly.
- Interacting with Business/Clients to gather the Requirement, understanding the requirements and preparation design documents.
- Develop the HLD, create mapping, mapplets, sessions, worklets and workflows to fulfill the business requirements.
- Impact analysis for any change requirements or enhancements
- Unit testing the Informatica mappings with sample data to validate the code against the business requirements.
- Debugging the issues during the unit testing of the flows.
- Working on Change Requests in mappings and workflows as per client requirement.
- Resolving issues in case of any simple to complex failures.
- Collaborating with the onsite Manager/Team member to research into ways of improvement of the application which include new enhancements for the application optimization and greater usability acceptance.
- Interacting with clients for any source data issues and solving them up by digging into the Informatica codes.
- Creating deployment groups, Working with Production Support team during deployment and validating the production deployment.
- Being part of production quick fixes and outage managements to avoid the issues in production environment.