Sandip P.

Sandip P.

Techno-Functional Analyst/ETL Designer

Pune , India

Experience: 10 Years

Sandip

Pune , India

Techno-Functional Analyst/ETL Designer

37367.7 USD / Year

  • Notice Period: Days

10 Years

Now you can Instantly Chat with Sandip!

About Me

Experienced ETL Designer cum Data Analyst with a demonstrated history of working in the information technology and services industry. 9 years of experience in ETL software development covering assignments in Scope & Strategy, ETL software design, Sof...

Show More

Portfolio Projects

Description

Responsible to understand the legacy cleared derivatives products like Clearvision, GMI and target product – FIS Cleared Derivatives. Responsible to interact with the stakeholders to understand the requirements. Responsible for designing and developing solutions around the data migration. Responsible for defining and implementing coding standards and checklists. Responsible for end-to-end delivery.

Show More Show Less

Corporate ODS and data lake creation along with data migration.

Description

·Involvement and contribution to scope and strategy discussions with customer during design.

·Responsible for interacting with the stakeholders to understand the requirements.

·Responsible for designing and developing ODS and data lake frameworks using ETL tools as per business requirements.

·Responsible for end to end code management and delivery.

Show More Show Less

Description

Responsible to interact with the stakeholders to understand the requirements. Responsible for designing and developing ETL frameworks Responsible for defining and implementing coding standards and checklists. Responsible for end to end code management and delivery. Responsible for performance tuning of the ETL code.

Show More Show Less

Data warehouse creation with generation of multiple reports out of it

Contribute

Requirement gathering, designing and developing ETL code as per business requirements. End to end code management and delivery. Performance tuning of the ETL code.

Description

Involvement and contribution to scope and strategy discussions with customer during design.
Responsible for interacting with the stakeholders to understand the requirements.
Responsible for designing and developing ETL code as per business requirements.
Responsible for end to end code management and delivery.
Responsible for performance tuning of the ETL code.

Show More Show Less

Description

Involvement and contribution to scope and strategy discussions with customer during design. Responsible for interacting with the stakeholders to understand the requirements. Responsible for designing and developing Abinitio graphs and Informatica mappings as per business requirements. Responsible for end to end code management and delivery. Responsible for performance tuning of the ETL code.

Show More Show Less

Vodafone romania data migration project

Contribute

Requirement gathering, documentation, implementation, review and execution processes. Designing and developing Informatica mappings for Billing and CRM modules as per business requirement.

Description

Led the requirement gathering, documentation, implementation, review and execution processes.
Responsible for designing and developing Informatica mappings for Billing and CRM module as per business requirements.
Informatica aministration system architecture, installation, managing users/groups/permissions, code migration, maintaining backups etc.

Show More Show Less

BSS/OSS- CRM, Ordering, Billing data migration

Contribute

Designing and developing ETL code. Documenting all the processes. Delivery of each module.

Description

Responsible for designing and developing Informatica mappings for Billing and CRM module as per business requirements.
Responsible for code management and migration and basic administrator functions.
Involvement and contribution to scope and strategy discussions with customer during design.

Show More Show Less

Description

Worked on gathering/understanding the business requirements and make them documented. Design and Development of ETL workflows and graphs. Developed various BO universes and reports in business intelligence using business objects. Done the performance tuning for the informatica workflows. Done the deployment of code into SIT and UAT. Done the documentation for project like release notes, post release checks etc. Done the Unit Testing, SIT Testing and data validation.

Show More Show Less

Description

Worked on understanding the Business Requirements. Design and Development of Informatica mappings and workflows. Done the documentation for project like release notes, post release checks etc. Development of several UNIX scripts for the different processes. Done the deployment of code into SIT and UAT. Testing and data validation.

Show More Show Less